PH66211: ABEND04E RC00E40213 WITH CAUSE 00C9004F DURING RUNSTATS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABND=04E-00E40214 in DSNUSUPT+014DE with CAUSE=X'00C9004F' may
  happen when RUNSTATS on a compressed PBG tablespace is executed.
  
  
  Execting the RUNSTATS utility with REPORT YES option shows a bad
  value for column PCTPAGES (of SYSIBM.SYSTABSTATS) as indicated
  by message DSNU624I (for the last partition of the TS):
  
  DSNU624I  DSNUSUPT - SYSTABSTATS CATALOG STATISTICS FOR
  abc.tablename PARTITION n
  CARD              = 10849324
  CARDF             = 1.0849324E+07
  NPAGES            = 895675
  PCTPAGES          = -31916          <-- bad !!!
  NACTIVE           = 130
  PCTROWCOMP        = 0
  
  Looking at the SDWAVRA, Key D7 of the DUMP we see
  DSNTST_PCTPAGES:
  Key: D7     Length: 0F
  C4E2D5E3    E2E36DD7    C3E3D7C1    C7C5E2
  |DSNTST_PCTPAGES |
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 12 for z/OS and Db2 13 for z/OS      *
  *                 utility users of RUNSTATS TABLESPACE         *
  *                 collecting table space partition             *
  *                 statistics during TABLESAMPLE SYSTEM         *
  *                 processing.                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND04E RC00E40214 in DSNUSUPT         *
  *                      OFFSET014DE with RC00C9004F during a    *
  *                      RUNSTATS utility catalog insert of a    *
  *                      bad PCTPAGES value into                 *
  *                      SYSIBM.SYSTABSTATS for a partitioned    *
  *                      table space.                            *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  When the user executed a RUNSTATS TABLESPACE TABLE COLUMN(ALL)
  with TABLESAMPLE SYSTEM active, the utility attempted to insert
  into the SYSIBM.SYSTABSTATS with a bad PCTPAGES value causing
  check constraint violation. The utility terminated with
  ABEND04E RC00E40214 and RC00C9004F in DSNUSUPT + '014DE'x.
  The utility showed incorrout for NPAGES in MSGDSNU624I.
  
  The bad PCTPAGES value was derived by using an incorrect
  NPAGES value which was obtained from the real-time statistics
  (RTS) catalog table SYSIBM.SYSTABLESPACESTATS. The NPAGES
  value was greater than the NACTIVE value in the
  SYSTABLESPACESTATS catalog table.
  
  Additional Keywords: DSNU624I
  

Problem conclusion

• Code was changed to check to ensure that the RTS values NPAGES
  and NACTIVE are consistent. If the values are not consistent,
  then page sampling is turned off and MSGDSNU3346I is issued
  with return code 4.
  
  Here is the modified text of message DSNU3346I:
  
  DSNU3346I REAL-TIME STATISTICS INFORMATION MISSING FOR
  object-type object-qualifier.object-name. SAMPLING RATE
  CHANGED TO 100.
  
  Explanation
  | The utility could not read the necessary information from
  | the real-time statistics tables for the object
  | or some statistics might be inconsistent for the object.
  
  object-type
  The type of object.
  
  object-qualifier.object-name
  The name of the object, as a qualified name.
  
  System action
  | The utility sets the sampling rate to 100 and continues to
  run.
  
  System programmer response
  | If a sampling rate of 100 is appropriate, no action is
  | required. Otherwise, take one of the following actions:
  
  | -Run the RUNSTATS TABLESPACE utility with SHRLEVEL REFERENCE
  |  TABLESAMPLE SYSTEM NONE on the specified object to
  |  set the base values in the real-time statistics tables
  
  | -Run REORG TABLESPACE on the specified object to set the
  |  base value in real-time statistics tables.
  
  | Then run RUNSTATS with TABLESAMPLE SYSTEM n again.
  
  Severity
  4 (warning)
  

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:

  UO04066 UO04067

Modules/Macros

• DSNUSITS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UO04066

     UP25/07/22 P F507

• RD10 PSY UO04067

     UP25/07/22 P F507

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.