PH18977: ABEND04E DSNB5FOR RC00C200A4 DURING A FORMAT WRITE FOLLOWING AN ALTER INDEX DSSIZE FOR A PBR RPN TABLESPACE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SC10,ABND=04E-00C200A4,U=BOXWELL ,M=N  ,C=121.BMC
  -DSNB5FOR,M=DSNTFRCV,LOC=DSNIDM  .DSNB5FOR+01594
  --------------------------------------------------
  ABEND04E DSNB5FOR RC00C200A4 MSGDSNB225I I/O error during
  format write for an INSERT.  The error occurs when an
  ALTER INDEX DSSIZE is issued to increase the DSSIZE.  The ALTER
  closes the index dataset, without a DRAIN.  The INSERT suffers
  the I/O error because the dataset is unexpectedly closed.
  This occurs for a PBR RPN tablespace.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users of ALTER                           *
  * INDEX DSSIZE.                                                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When the user runs an ALTER INDEX                            *
  * DSSIZE, Db2 might issue any of the                           *
  * following ABENDs when an INSERT is                           *
  * running concurrently:                                        *
  * ABEND04E RC00C200B0 at DSNIDM.DSNB1REL                       *
  *                                                              *
  *                        OFFSET022AC                           *
  * ABEND0C4 RC0000003A at DSNIDM.DSNIEABR                       *
  *                                                              *
  *                        OFFSET00914                           *
  * ABEND04E RC00C90101 at DSNIDM.DSNKINSL                       *
  *                                                              *
  *                        ERQUAL5002                            *
  * ABEND04E RC00C200A4 at DSNIDM.DSNB5FOR                       *
  *                                                              *
  *                        OFFSET01594                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  Due to Db2 missing proper serialization on processing ALTER
  INDEX DSSIZE when the index is defined using relative page
  numbering (RPN), Db2 might issue various ABENDs when this index
  is being used.
  The possible ABENDs are listed below but not limited to:
  ABEND04E RC00C200B0 at LOC=DSNIDM.DSNB1REL OFFSET022AC
  ABEND0C4 RC0000003A at LOC=DSNIDM.DSNIEABR OFFSET00914
  ABEND04E RC00C90101 at LOC=DSNIDM.DSNKINSL ERQUAL5002
  ABEND04E RC00C200A4 at LOC=DSNIDM.DSNB5FOR OFFSET01594
  Depending on the timing window between the ALTER and other
  Db2 operation, there could be other ABENDs or unpredictable
  behaviors as a result of Db2 not draining the proper
  part(s) of the index when its DSSIZE is being altered.
  In addition, when a table space defined with relative page
  numbering is the target of an ALTER TABLESPACE with partition
  level DSSIZE alteration, Db2 incorrectly drains all the parts
  instead of only the part that is being altered. Customer
  might encounter resource unavailable conditions on the part(s)
  not being altered.
  

Problem conclusion

• When processing ALTER INDEX DSSIZE alteration, Db2 will drain
  the correct part(s) of the index for proper serialization.
  When processing ALTER TABLESPACE part level DSSIZE alteration,
  Db2 will only drain the part being altered to improve
  concurrency.
  ADDITIONAL KEYWORDS:
  SQLCODE904
  SQLALTER
  SQLINSERT
  

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:

  UI69510

Modules/Macros

• DSNGDADP DSNGDAIP
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI69510

     UP20/05/23 P F005

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.