A fix is available
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 number
PH18977
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-11-07
Closed date
2020-05-14
Last modified date
2020-06-01
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 June 2020