| View previous topic :: View next topic |
| Author |
Message |
bauer
Intermediate
Joined: 10 Oct 2003
Posts: 317
Topics: 50
Location: Germany
|
 Posted: Fri Mar 11, 2005 7:39 am Post subject: DB2 RUNSTATS / Message DSNU623I |
 |
|
Hi,
DB2 runstats returns message
DSNU623I +DB2X DSNUSIDX - SYSIBM.SYSCOLDIST CATALOG NOT UPDATED WITH AGGREGATE STATISTICS FOR <creator>.<tablename>.<columnname>,
BECAUSE SOME PARTITIONS HAVE NO VALID STATISTICS,
for an specific index, returncode of job is zero. <columname> is part of other indexes, at 2. or 3. position.
Runstats is executed using then syntax
RUNSTATS TABLESPACE <dbname>.<spacename> INDEX(ALL).
For all other indexes the SYSCOLDIST is updated, the tablespace / indexspace is not segmented, table has 18 indexes (limit of runstats ???).
But executing runstats using the command
RUNSTATS TABLESPACE <dbname>.<spacename> INDEX(<indexname>)
the data in syscoldist is updated for the specific index.
I checked the IBM manual for the reason, but couldn't find anything.
Any idea ?
regards,
bauer |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Fri Mar 11, 2005 8:47 am Post subject: |
|
|
Bauer,
Did some alter a varchar column and ran a RUNSTATS with PART option?
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
bauer
Intermediate
Joined: 10 Oct 2003
Posts: 317
Topics: 50
Location: Germany
|
| Posted: Fri Mar 11, 2005 8:52 am Post subject: |
|
|
Kolusu,
this possible reason is known to me.
But the answer is NO (I'm responsible of this table, I'm sure).
Any other hint (Don't say ask DB Admin, we dicussed the problem, but no solution.)
regards,
bauer |
|
| Back to top |
|
|
bauer
Intermediate
Joined: 10 Oct 2003
Posts: 317
Topics: 50
Location: Germany
|
| Posted: Fri Mar 11, 2005 8:55 am Post subject: |
|
|
Kolusu,
we added some columns to this table.
Could this be a possible reason ?
regrads,
bauer |
|
| Back to top |
|
|
bauer
Intermediate
Joined: 10 Oct 2003
Posts: 317
Topics: 50
Location: Germany
|
| Posted: Wed Mar 16, 2005 5:19 am Post subject: |
|
|
Kolusu,
the problem is caused by an bug, see below.
PQ72652
APAR status
Closed as program error.
Error description
During Runstats of non-partitioned tablespace, MSGDSNU623I is
invalidly issued.
Local fix
| Code: |
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
|
|
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Wed Mar 16, 2005 8:37 am Post subject: |
|
|
Bauer,
Thanks for the update.
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
