PH66139: DSNISGSS ERQUAL 5003 ABEND WAS ISSUED WHEN THE MAXIMUM ALLOWED PARTITION REACHED ITS DSSIZE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When the last partition of a PBR member cluster table space was
  the maximum allowed partition and reached its DSSIZE, insert
  still tried to allocate a new segment. When calculating the next
  
  space map page for the new segment,  the boundary check didn't
  work properly and allowed the space map page number to overflow
  from 'FFFFFXXX' to '00000XXX', which led to RC00C90101 DSNISGSS
  ERQUAL5003 abend.
  
  
  You might also see below abends
  DSNISUPI 0CA4
  
  Additional symptoms: DSNIBMCL 5001 ERQUAL5001 00C90101
                       DSNISUPI ERQUAL0CA4
  

Local fix

• BYPASS/CIRCUMVENTION:
  If the last part contains some free space, REORG the part to
  reclaim them to avoid hitting DSSIZE.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of Db2 12 and 13 for z/OS using    *
  *                 Universal Table Space(UTS)                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND 04E-00C90101 in DSNISGSS          *
  *                      ERQUAL5003 occured when searching       *
  *                      for the free space during the insert    *
  *                      process.                                *
  *                                                              *
  *                      The following abends were also          *
  *                      issued along with the above abend:      *
  *                      1. ABEND 04E-00C90101 in DSNISUPI       *
  *                      ERQUAL0CA4                              *
  *                      2. ABEND 04E-00C90101 in DSNIBMCL       *
  *                      ERQUAL5001                              *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  An RC00C90101 DSNISGSS ERQUAL5003 abend occurred because an
  insert into a partition-by-range (PBR) member cluster table
  space, where the last partition had reached its DSSIZE and
  the maximum partition limit, erroneously tried to allocate
  a new segment. This was due to an improper boundary check
  in the space map page calculation, leading to an overflow.
  

Problem conclusion

• Db2 is modified to correct the space map page boundary check
  that prevents the overflow.
  

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:

  UO04049 UO04050

Modules/Macros

• DSNISGNS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UO04049

     UP25/07/19 P F507

• RD10 PSY UO04050

     UP25/07/19 P F507

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.