|
Problem IT36825
|
Status: Closed |
SQLTEMPSPACE OR AGGSQLTEMPSPACE THRESHOLDS DO NOT WORK WITH ROWSTORE OLAP OPERATORS THAT SPILL TO DISK.
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
When running queries with rowStore OLAP operators (for example
SUM() OVER) that spill large amounts of rows to disk, wlm
SQLTEMPSPACE or AGGSQLTEMPSPACE thresholds may not be triggered
even if the amount of temporary tablespace used exceeds the
threshold limits.
db2trc.flw file looks like this:
592745 | | | | | | sqlricc1 entry [eduid 18 eduname
db2agent]
592746 | | | | | | sqlricc1 exit
592747 | | | | | | sqlri_scalag entry [eduid 18 eduname
db2agent]
592748 | | | | | | | sqlri_buffer_add entry [eduid 18
eduname db2agent]
592749 | | | | | | | sqlri_buffer_add exit
592750 | | | | | | | sqlri_scalag_partition_break entry
[eduid 18 eduname db2agent]
592751 | | | | | | | | sqlri_buffer_fix_page_N_ptrs
entry [eduid 18 eduname db2agent]
592752 | | | | | | | | sqlri_buffer_fix_page_N_ptrs
exit
592753 | | | | | | | | sqlri_buffer_fix_page_N_ptrs
entry [eduid 18 eduname db2agent]
592754 | | | | | | | | sqlri_buffer_fix_page_N_ptrs
exit
592755 | | | | | | | | sqlrxcp1 entry [eduid 18 eduname
db2agent]
592756 | | | | | | | | sqlrxcp1 exit [rc = 1]
592757 | | | | | | | sqlri_scalag_partition_break exit
592758 | | | | | | | sqlri_scalag_aggNfind_bot entry
[eduid 18 eduname db2agent] |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.5.7 or later *
**************************************************************** |
| Local Fix: |
N/A |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.5.7 or later *
**************************************************************** |
| Comment |
Upgrade to 11.5.7 or later |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.05.2021
02.12.2021
02.12.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
