A fix is available
APAR status
Closed as program error.
Error description
SQLCODE +331 may issue on table DSN_PREDICAT_TABLE for column LITERALS when using ADMIN_INFO_SQL to collect service sql SQLCODE -331 will be issued when query on DSN_PREDICAT_TABLE
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: * * All DB2 11 and DB2 12 for z/OS users of * * table spaces partitioned by range * * with column keys in a descending order * * may be affected. * **************************************************************** * PROBLEM DESCRIPTION: * * DB2 may incorrectly generate the page * * range predicate values when the * * column partitioning keys are ordered * * as descending. This problem can * * result in DB2 generating the * * incorrect filter factor values for * * the page range predicates and * * may lead to poor query performance. * * In addition, the EXPLAIN table * * DSN_PREDICAT_TABLE data may * * show non-formattable literal values * * for the TEXT and LITERALS columns * * on the generated predicates. Also, * * a query on the table * * DSN_PREDICAT_TABLE may fail with * * SQLCODE-331 because the literal * * values for the TEXT and LITERAL * * columns are not convertible to * * UNICODE CCSID format. * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** DB2 may incorrectly generate the page range predicate values when the column partitioning keys are ordered as descending. This problem can result in DB2 generating the incorrect filter factor values for the page range predicates and may lead to poor query performance. In addition, the EXPLAIN table DSN_PREDICAT_TABLE data may show non-formattable literal values for the TEXT and LITERALS columns on the generated predicates. Also, a query on the table DSN_PREDICAT_TABLE may fail with SQLCODE-331 because the literal values for the TEXT and LITERAL columns are not convertible to UNICODE CCSID format. Additional Keywords: PAGERANGE SQLEXPLAIN SQLPERFORMANCE SQLCODE331
Problem conclusion
DB2 code has been corrected to resolve the problem described as above.
Temporary fix
Comments
APAR Information
APAR number
PI61366
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-04-25
Closed date
2017-10-27
Last modified date
2017-11-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI51061 UI51062
Modules/Macros
DSNXODTX DSNXOPG
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
01 November 2017