PK98505: MISSING MESSAGE DSNT501I AFTER EXTEND FAILS DURING INSERT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Resource Not Available message DSNT501I msgDSNT501I is not
  issued after dataset extend fails (message DSNP007I msgDSNP007I
  rc00D70014) during INSERT.
  
  The following messages were issued, then the job doing
  INSERT ended cc=8.
  
  DSNP011I  = DSNPXTN0 - MEDIA MANAGER SERVICES ERROR 927
  FOR
              DSNCTST.DSNDBC.DBTEST.TS01.I0001.A002
             MMRC=8 DSMRC=00D70014
             CONNECTION-ID=BATCH, CORRELATION-ID=PM21638B,
             LUW-ID=*
  DSNP031I  = DSNPXTN0 - CURRENT SPACE HAS 0251 EXTENTS 928
             FOR DSNCTST.DSNDBC.DBTEST.TS01.I0001.A002.
             THE MAXIMUM EXTENTS IS  251.
             CONNECTION-ID=BATCH, CORRELATION-ID=PM21638B,
             LUW-ID=*
  DSNP007I  = DSNPXTN0 - EXTEND FAILED FOR 929
             DSNCTST.DSNDBD.DBTEST.TS01.I0001.A002.
             RC=00D70014
             CONNECTION-ID=BATCH, CORRELATION-ID=PM21638B,
             LUW-ID=*
  
  This problem occurs only on non-segmented tablespace.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 users who have executed insert or    *
  *                 update operations on a non-segmented table   *
  *                 and run into data set extend failure.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: For applications that are executing     *
  *                      inserts into a table that reached the   *
  *                      maximum extent limit.  DB2 issues       *
  *                      MSGDSNP007I,MSGDSNP011I and MSGDSNP031I *
  *                      to indicate dataset extent failure.     *
  *                      But there is no MSGDSNT501I message     *
  *                      that follows with resource unavailable  *
  *                      error SQLCODE -904.  DSNP007I,          *
  *                      DSNP011I, DSNP031I, DSNT501I,           *
  *                      SQLCODE904                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 has been modified to issue a DSNT501I message with resource
  unavailable SQLCODE -904 when data set extend failure occurred
  on non-segmented table space.
  

Problem conclusion

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:

  UK53586 UK53587

Modules/Macros

• DSNISMPI
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK53586

     UP10/02/02 P F002

• R910 PSY UK53587

     UP10/02/02 P F002

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.