Forum

Hallo Herr Baur

es gibt einen APAR dazu vielleicht hilft das weiter

PQ72652

Viele Grüße
Thomas

APAR status
Closed as program error.

Error description

During Runstats of non-partitioned tablespace, MSGDSNU623I is
invalidly issued.

Local fix

Problem summary

****************************************************************
* USERS AFFECTED: All DB2 UDB for OS/390 or z/OS utility users *
****************************************************************
* PROBLEM DESCRIPTION: MSGDSNU623I issued erroneously during *
* RUNSTATS TABLESPACE DSNDB06.SYSOBJ *
* TABLE(ALL) INDEX(ALL) SHRLEVEL CHANGE. *
****************************************************************
* RECOMMENDATION: Apply corrective PTF when available *
****************************************************************
RUNSTATS TABLESPACE DSNDB06.SYSOBJ TABLE(ALL) INDEX(ALL)
SHRLEVEL CHANGE erroneously issued DSNU623I SYSIBM.SYSCOLDIST
CATALOG NOT UPDATED WITH AGGREGATE STATISTICS FOR
SYSIBM.SYSROUTINES.NAME BECAUSE SOME PARTITIONS HAVE NO VALID
STATISTICS. The tablespace is not partitioned.

Certain code paths are avoided during frequency statistics
collection for duplicate columns. However, this led duplicate
column processing to issue MSGDSNU623I in error.

Problem conclusion

Duplicate column processing has been corrected.

Temporary fix

Comments

APAR information
APAR number PQ72652
Reported component name 5740 IBM DATABA
Reported component ID 5740XYR00
Reported release 710
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Submitted date 2003-03-31
Closed date 2003-07-31
Last modified date 2003-09-04

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:
UQ79108