PI61366: SQLCODE331 MAY ISSUE ON TABLE DSN_PREDICAT_TABLE FOR COLUMN LITERALS WHEN USING ADMIN_INFO_SQL TO COLLECT SERVICE SQL

Obtain the fix for this APAR.

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 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

• RC10 PSY UI51061

     UP17/10/30 P F710

• RB10 PSY UI51062

     UP17/10/30 P F710

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.