IBM Support

PM22336: REORG SHRLEVEL NONE FAILS WITH RC00E40304 10/09/16 PTF PECHANGE

A fix is available

Subscribe

You can track all active APARs for this component.

 

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