|
Problem IT35833
|
Status: Closed |
SQL1585N is incorrectly returned for certain types of queries
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
Some queries may encounter the following error even though a
32K system temporary table space exists.
SQL1585N A temporary table could not be created because there
is no available system temporary table space that has a
compatible page size. SQLSTATE=54048
SQL1585N occurs in this situation when extended row size support
is enabled
(DB configuration parameter EXTENDED_ROW_SZ = ENABLE) and
the minimum width of a row in a system temporary table space
will not fit on a 32K page. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* 250 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Fixed in 11.5.5. Upgrade to 11.5.5 or above. *
**************************************************************** |
| Local Fix: |
Set DB2_REDUCED_OPTIMIZATION="EXT_ROWS_TEMP COST" to avoid the
problem. This registry variable can be set for individual
queries using optimization guidelines. |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* 250 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Fixed in 11.5.5. Upgrade to 11.5.5 or above. *
**************************************************************** |
| Comment |
Fixed in 11.5.5. Upgrade to 11.5.5 or above. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.02.2021
26.03.2021
26.03.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
