A fix is available
APAR status
Closed as program error.
Error description
REORG fails with RC00E40304 on an NPI. This only occurs when 1. SHRLEVEL is NONE 2. There are disjoint parts in the same reorg 3. There are NPIs involved. 4. The NPIs are not in RBDP and no records are discarded with REORG DISCARD usage. Additional symptoms: RC00C202B2 - REORG with in-line statistics using LISTDEF PARTLEVEL of a single or contiguous partition range can leave unintended index partitions in format write mode. Statistics values are also invalid. A stop/start of the index will clear the 00C202B2, but RUNSTATS will need to be run to correct the statistics. This applies to any SHRLEVEL. RC00C90088 - Running multiple concurrent REORG jobs with in-line statistics processing different partitions of the same table space can result in deadlocks. This applies to any SHRLEVEL. DSNI014I DSNKTRAV REASON 00C90101 ERQUAL 2008 TYPE 00000303 Abend 04E 00C90101 LOC=DSNK2DM .DSNKNXT2:2006 DSNU017I DSNUGSAT - UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED, REASON=X'00E40322' CAUSE=X'00E40304' DSNU016I DSNUGBAC - UTILITY BATCH MEMORY EXECUTION ABENDED, REASON=X'00E40347'
Local fix
For RC00E40304 1) use SHRLEVEL other than NONE OR 2) reorg 1 part at a time OR 3) reorg a continguous range of parts OR 4) reorg the entire tablespace For RC00C202B2 or RC00C90088 remove in-line statistics as part of the REORG.
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 9 for z/OS utility users with * * PK87762/UK59095 applied. * **************************************************************** * PROBLEM DESCRIPTION: After user applied PK87762/UK59095, * * the following problems were encountered * * when running the REORG TABLESPACE * * utility: * * * * - REORG TABLESPACE PART SHRLEVEL NONE * * failed with ABEND04E RC00E40304 * * during the BUILD/SORTBLD phase on * * NPIs. * * * * - REORG TABLESPACE PART SHRLEVEL NONE * * with zero records unloaded caused * * Real Time Statistics to be * * incorrectly updated for all data and * * index partitions defined. * * * * - REORG TABLESPACE STATISTICS with * * LISTDEF PARTLEVEL left partitioned * * indexes in non-recoverable state * * resulting in subsequent application * * failure with RC00C202B2 * * * **************************************************************** * RECOMMENDATION: Apply corrective PTF when available. * **************************************************************** After user applied PK87762/UK59095, the following problems were encountered when running the REORG TABLESPACE utility: - REORG TABLESPACE SHRLEVEL NONE with a LISTDEF containing disjoint partition ranges could result in ABEND04E RC00E40304 in the BUILD/SORTBLD phase on the non-partitioned index(es) ( NPI ) processed. If the REORG utility completed, the NPI could also have missing index keys resulting in a broken index. The same problem can occur without using LISTDEF, when REORG is specified with the new disjoint partition range syntax. Example: LISTDEF L INCLUDE TABLESPACE dbb.tss PARTLEVEL 3 INCLUDE TABLESPACE dbb.tss PARTLEVEL 5 REORG TABLESPACE LIST L SHRLEVEL NONE or REORG TABLESPACE dbb.tss PART (3,5) - REORG TABLESPACE PART SHRLEVEL NONE with zero records unloaded (i.e. due to empty partition(s) reorganized, or by REORG DISCARD deleting all existing data) would cause Real Time Statistics (RTS) for all data and index partitions to be updated, effectively zeroing all RTS statistics relevant to the last REORG for those partitions not reorganized. - REORG TABLESPACE STATISTICS with a LISTDEF containing non-contiguous partition range specification would leave partitioned index(es) in a non-recoverable state, resulting in subsequent RC00C202B2 failure when these indexes were accessed. The DB2 catalog tables were also updated with incorrect, zeroed statistics for the index partitions not reorganized. RC00C202B1 failures can also happen. This problem applies to all SHRLEVEL of REORG TABLESPACE. Example: LISTDEF K INCLUDE TABLESPACE dbb.tss PARTLEVEL 3 REORG TABLESPACE LIST K STATISTICS Additional symptom: ABEND04E 00E40202 with RC00C90088 when running concurrent partlevel REORG on different parts of the same partitioned table space with partitioned index(s) defined, while collecting inline statistics.
Problem conclusion
Code is modified to correct the reported problems.
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PM22336
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
910
Status
CLOSED PER
PE
YesPE
HIPER
YesHIPER
Special Attention
NoSpecatt
Submitted date
2010-09-12
Closed date
2010-11-04
Last modified date
2011-04-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK61931
Modules/Macros
DSNUGULM DSNURBXA DSNUSIIX
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
R910 PSY UK61931
UP10/11/23 P F011 ®
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":"9.1","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":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
05 April 2011