A fix is available
APAR status
Closed as program error.
Error description
Rebuild Index with SHRLEVEL CHANGE resulted in a 1 byte overlay during log apply processing that caused the following dumps: WSAA ESTAE ENTERED. ABEND S0C4 MODULE DXRRL130+0138 APAR PI40903 2017/323 21:07:04. WSA ESTAE ENTERED. ABEND S0C4 MODULE DXRRL109+0224 APAR PI51090 2017/323 18:34:58 ssid,ABND=0C4-00000004,U=SYSOPR ,M=N ,C=111.DMC -DSNIPSFI,M=DSNTFRCV,PSW=477C100198D1B220,A=00E9 ssid,ABND=0C4-00000038,U=SYSOPR ,M=N ,C=111.ADMF-FUNCTION,M=DSNTFRCV,LOC=DSNTF .DSNTFRCV+01DA This can be followed by a Db2 crash. This happens under the following conditions: 1. rebuild index shrlevel change. 2. processing a roll back log record 3. The index row being processed was not at the current level The problem could potentially happen with REORG log apply processing. ABEND0C4 DXRRL109 OFFSET0224 ABEND0C4 DXRRL103 OFFSET0138 ABEND0C4 RC4 ABEND0C4 RC38 DSNTFRCV OFFSET01DA DB2OVRLAY/K
Local fix
Instead of REBUIILD INDEX SHRLEVEL CHANGE use Rebuild index with SHRELVEL REFERENCE
Problem summary
**************************************************************** * USERS AFFECTED: All users of Db2 zOS v11 and v12 users of * * REORG and REBUILD INDEX SHRLEVEL CHANGE. * **************************************************************** * PROBLEM DESCRIPTION: Db2 crash or unpredictable problems * * occurred during log apply phase of * * REORG SHRLEVEL CHANGE or REBUILD * * INDEX SHRLEVEL CHANGE. * **************************************************************** * RECOMMENDATION: * **************************************************************** During the log apply phase of either REORG or REBUILD INDEX, Db2 tries to process an insert or an update on a table that has been altered and the data on the base table for the record is down level. The data conversion code was using a work area that does not exist for REORG or REBUILD INDEX. The address for that work area would be garbage and that would cause various kinds of problems, including Db2 down.
Problem conclusion
Db2 code is modified to use the correct address for the data versioning data.
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PI92394
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-01-15
Closed date
2018-05-09
Last modified date
2018-06-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI55818 UI55824
Modules/Macros
DSNIETRV
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
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"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
04 June 2018