PM61736: ABEND0C4 DSNUGACC+12F8 DURING DGTT APPLICATION THAT USES WORKFILE PARTITION-BY-GROWTH TABLE SPACE (PBG)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The 0C4 abend happens due to a garbage xInsLPart value in
  DSNISRTI - OBDPSCMP(xInsLPart) is ON by mistake.
  
  In DSNISGPI, OBDPSET needs to be refreshed after FIND_NEXT_PART
  as is done in DSNISUPI.
  
                                                        (d153538)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 (NFM) for z/OS users of declared  *
  *                 global temporary tables (DGTT) who employ    *
  *                 partition-by-growth table spaces in Workfile *
  *                 database                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND0C4 DSNUGACC+12F8 during DGTT      *
  *                      application that uses a partition-by-   *
  *                      growth workfile table space (PBG)       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  During a partition-growing insert into a DGTT which was residing
  in a partition-by-growth workfile table space, the 0C4 abend
  occurred because the insert driver module was looking at the
  old (pre-growth) OBDPSET structure while thinking that it was
  looking at the new (post-growth) one.
  
  Specifically, in the old OBDPSET, the OBDPSP2L array slot did
  not exist for the newly grown partition and therefore the module
  was looking at a memory contents that is unaccounted for. This
  made the module go to a wrong code path, which resulted in the
  aforementioned abend.
  

Problem conclusion

• Code has been changed to make sure that the OBDPSET structure
  is refreshed after growing a new partition, so that the insert
  driver module will have the latest structure at its disposal.
  
  Additional keywords: SQLPBG SQLDGTT
  

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:

  UK80179

Modules/Macros

•    DSNISGPI DSNITLPE
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK80179

     UP12/07/25 P F207

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.