PH07783: REORG PBG TABLESPACE GETS S04E RC00E4D5D2 IN DSNURWIR.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Triggers:
  In both of V11 and V12, if REORG PBG tablespace needs to grow a
  new partition. And its inline statistic specifies one COLGROUP
  per TABLE keyword with many TABLE keywords.
  
  STATISTICS
  TABLE("AA"."BB") SAMPLE 25 COLGROUP(C1) FREQVAL
  TABLE("AA"."BB") SAMPLE 25 COLGROUP(C2) FREQVAL
  TABLE("AA"."BB") SAMPLE 25 COLGROUP(C2) FREQVAL
  TABLE("AA"."BB") SAMPLE 25 COLGROUP(C4) FREQVAL
  TABLE("AA"."BB") SAMPLE 25 COLGROUP(C5) FREQVAL
  TABLE("AA"."BB") SAMPLE 25 COLGROUP(C6) FREQVAL
  TABLE("AA"."BB") SAMPLE 25 COLGROUP(C7) FREQVAL
  
  Consequences:
  REORG abends S04E RC00E4D5D2 in DSNURWIR.
  

Local fix

• Use one TABLE keyword with many COLGROUP statements.
  
  STATISTICS
  TABLE("AA"."BB") SAMPLE 25
  COLGROUP(C1) FREQVAL
  COLGROUP(C2) FREQVAL
  COLGROUP(C3) FREQVAL
  COLGROUP(C4) FREQVAL
  COLGROUP(C5) FREQVAL
  COLGROUP(C6) FREQVAL
  COLGROUP(C7) FREQVAL
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 11 for z/OS and Db2 12 for z/OS      *
  *                 users of REORG TABLESPACE and LOAD REPLACE   *
  *                 utility with STATISTICS on PBG table space   *
  ****************************************************************
  * PROBLEM DESCRIPTION: REORG TABLESPACE STATISTICS COLGROUP    *
  *                      failed with ABEND04E RC00E4D5D2 in      *
  *                      DSNURWIR OFFSET37A4 during PBG growth   *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  User ran a REORG TABLESPACE with STATISTICS COLGROUP specified
  on a partitioned by growth (PBG) table space. The utility needed
  to grow a new PBG partition in the RELOAD phase, but during
  this growth operation it failed with an ABEND04E RC00E4D5D2 in
  DSNURWIR + x'37A4' when creating new control blocks for inline
  statistics processing.
  
  The reported problem is caused by incorrect program logic where
  statistics control block is not referenced correctly during PBG
  growth.  This can happen to either the REORG TABLESPACE or
  LOAD REPLACE utility with PBG growth during the RELOAD phase,
  and only when multiple TABLE clauses with COLGROUP are specified
  on the utility statement instead of a single TABLE clause with
  multiple COLGROUP keywords.
  
  Below is an example of a failing utility statement:
  
  REORG TABLESPACE dbname.tsname
  STATISTICS TABLE(T1) COLGROUP(C1) FREQVAL
             TABLE(T1) COLGROUP(C2) FREQVAL
             TABLE(T1) COLGROUP(C3) FREQVAL
             TABLE(T1) COLGROUP(C4) FREQVAL
  

Problem conclusion

• Code has been modified for the REORG/LOAD STATISTICS COLGROUP
  logic to reference the correct statistics control block during
  PBG growth and thus resolving the aforementioned problem.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

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

  UI62725 UI62726

Modules/Macros

•    DSNURWIR
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI62726

     UP19/05/15 P F905

• RC10 PSY UI62725

     UP19/05/15 P F905

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.