PI62796: ADD SERVICEABILITY FOR ABEND04E RC00C90110 DSNICTBU 5004 ERQUAL5004 WHEN RUNNING QUERY WITH A CONCURRENT DROP TABLE/INDEX

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Add serviceability for ABEND04E RC00C90110 DSNICTBU 5004
  ERQUAL5004 when running a query on a table which has a
  concurrent drop table/index running on it.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users of DB2 11 for z/OS who use                         *
  * dynamic queries, or REOPT(ALWAYS) for                        *
  * static queries                                               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Serviceability code is added for                             *
  * dynamic queries and static queries                           *
  * using REOPT(ALWAYS) when the DB2                             *
  * Optimizer does an RTS lookup for a                           *
  * table. Specifically, this could occur                        *
  * if one of the following is true for                          *
  * the query:                                                   *
  * a. Statistics indicate the table is                          *
  * empty, OR                                                    *
  * b. Table is defined as VOLATILE and                          *
  * missing statistics (CARDF=-1), OR                            *
  * c. Statistics indicate qualifying                            *
  * partitions of the table are                                  *
  * empty, OR                                                    *
  * d. Subsystem parameter NPGTHRSH is                           *
  * set to a non-zero value, and NPAGES                          *
  * for the table in SYSIBM.SYSTABLES                            *
  * is smaller than NPGTHRSH, and the                            *
  * table is missing statistics                                  *
  * (CARDF=-1).                                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  Serviceability code is added for dynamic queries and static
  queries using REOPT(ALWAYS) when the DB2 Optimizer does an RTS
  lookup for a table. Specifically, this could occur if one of
  the following is true for the query:
  a. Statistics indicate the table is empty, OR
  b. Table is defined as VOLATILE and missing statistics
  (CARDF=-1), OR
  c. Statistics indicate qualifying partitions of the table are
  empty, OR
  d. Subsystem parameter NPGTHRSH is set to a non-zero value,
  and NPAGES for the table in SYSIBM.SYSTABLES is smaller than
  NPGTHRSH, and the table is missing statistics (CARDF=-1).
  

Problem conclusion

• DB2 code is updated to add serviceability information in case
  a dump is generated. The dump would contain new diagnostic
  information that would be helpful for problem analysis.
  

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:

  UI53844 UI53845

Modules/Macros

• DSNXORTS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI53844

     UP18/02/28 P F802

• RB10 PSY UI53845

     UP18/02/28 P F802

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.