A fix is available
APAR status
Closed as program error.
Error description
REORG with INLINE STATS and COLGROUP does not collect index statistics when DATA SORT for single column COLGROUP is performed. Typically the job output will contain a message like the following one: DSNU1388I ... DSNUSITS - DATA SORT REQUIRED ESTIMATED SPACE REQUIRED TO AVOID DATA SORT = 23. SPACE SPECIFIED BY THE STATCLGSRT PARAMETER = 10. and there will not be any message DSNU610I for SYSINDEXES, SYSINDEXPART and SYSINDEXSTATS. The problem occurs with Inline Statistics only. RUNSTATS utility will collect the proper statistics.
Local fix
Run RUNSTATS, or increase the value of ZPARM STATCLGSRT so that message DSNU1388I will not be externalized during Inline Statistics processing and the data sort for single column colgroup will be avoided (DSNU1387I) .
Problem summary
**************************************************************** * USERS AFFECTED: All Db2 11 for z/OS with PI74408 / UI49484 * * applied and Db2 12 for z/OS with PI76730 / * * UI51754 applied, users of utilities with * * inline STATISTICS gathering COLGROUP and * * INDEX statistics. * **************************************************************** * PROBLEM DESCRIPTION: Missing INDEX STATISTICS when inline * * statistics is executed to collect * * COLGROUP and INDEX statistics with * * Db2 11 for z/OS with PI74408 / UI49484 * * applied or Db2 12 for z/OS with * * PI76730 / UI51754 applied. * **************************************************************** * RECOMMENDATION: Apply corrective PTF when available * **************************************************************** With Db2 V11 for z/OS with PI74408 / UI49484 applied or Db2 12 for z/OS with PI76730 / UI51754 applied, when a REORG TABLESPACE STATISTICS TABLE COLGROUP INDEX is executed, the inline STATISTICS fails to collect the INDEX statistics. The message DSNU610I was not issued for SYSINDEXPART, SYSINDEXSTATS, SYSCOLSTATS, SYSCOLDISTSTATS, SYSCOLUMNS, SYSINDEXES and SYSCOLDIST catalog tables as the catalog tables were not updated The REORG with inline STATISTICS failed to build the requisite control blocks for INDEX processing due to a warning return code issued along with MSGDSNU1388I during table processing. This error can also occur during LOAD with inline STATISTICS. ADDITIONAL KEYWORDS: MSGDSNU610I DSNU1388I
Problem conclusion
Code was modified to correctly check the return codes before index processing.
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PH06454
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
B10
Status
CLOSED PER
PE
YesPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-12-13
Closed date
2019-01-25
Last modified date
2019-03-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI60972 UI60973
Modules/Macros
DSNURDRT
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 March 2019