PI62002: REORG GOT 04E-00E40346 DUE TO ABEND B37-04 IN THE INLINE COPY WHEN CONVERTED FROM SEGMENTED TABLESPACE TO UTS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• REORG got 04E-00E40346 due to abend B37-04 in the INLINE COPY
  REORG was run to convert the segmented tablespace into UTS.
  The problem was caused by DB2 did not get NPAGES from RTS due
  to this conversion from segmented TS to UTS.  DB2 used the
  zero value to calculate the space allocation and only 1 cylinder
  was allocated as the primary quantity  for the inline
  copy dataset.  This caused the B37 in the inline copy dataset.
  

Local fix

• Customer can bypass the problem by specifying SPACE with
  proper primary space in the COPY template dataset definition.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 11 for z/OS users of REORG           *
  *                 TABLESPACE with part level inline copy       *
  ****************************************************************
  * PROBLEM DESCRIPTION: (1) ABENDSB37 for an inline copy data   *
  *                      set during a REORG TABLESPACE           *
  *                      materializing a pending definition      *
  *                      change to convert a segmented table     *
  *                      space to a partition-by-growth(PBG)     *
  *                      table space with part-level inline copy *
  *                      enabled;                                *
  *                                                              *
  *                      (2) ABENDSB37 for an inline copy data   *
  *                      set during a REORG TABLESPACE against   *
  *                      a PBG table space with part-level       *
  *                      inline copy enabled.                    *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  (1) User ran an online REORG TABLESPACE utility to materialize a
  pending definition change to convert a segmented table space to
  a PBG with part-level inline copy. The REORG job abended with
  ABENDB37 for the inline copy data set when the
  SPACE(primary, secondary) parameter is not specified on the
  template statement for the copy data set.
  
  This problem occurred because the REORG did not get the
  correct statistics for table space conversion cases.
  
  (2) User ran a REORG TABLESPACE utility against a PBG table
  space with part-level inline copy but without specifying the
  SPACE parameter on the template statement for the copy data set.
  Then REORG utility allocated a copy data set with a very small
  primary and secondary space quantity for one of the non-last
  partitions, as RTS information indicated that it was almost
  empty. During the reload phase, the data from the subsequent
  partitions was pushed up and consolidated into this part, which
  caused the copy data set to run out of the maximum extents and
  abending with B37.
  

Problem conclusion

• (1) REORG code has been modified to better utilize the RTS
  information when converting from a simple / segmented table
  space to a PBG table space.
  
  (2) REORG code has been modified to better estimate the
  primary and secondary space for the part level inline copy data
  sets for PBG table space.
  

Temporary fix

Comments

• ×**** PE17/11/17 FIX IN ERROR. SEE APAR PI89308  FOR DESCRIPTION
  

APAR Information

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

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

  PI69092 UI49322

Modules/Macros

• DSNURAIC DSNUREPG DSNURFUI DSNURORG DSNUULJA
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI49322

     UP17/08/21 P F708

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.