A fix is available
APAR status
Closed as program error.
Error description
ABEND04E RC00C90206 occurs at DSNIDIFS ERQUAL5007 due to incorrect serialization between parallel threads. ADDITIONAL SYMPTOMS: RC00C90101 DSNKINSL ERQUAL5004 RC00C90101 DSNGEDRP ERQUAL5017 MSGDSNB250E DSNB250E -DBN DSNKUNR2 A PAGE RANGE WAS ADDED TO THE LOGICAL PAGE LIST DATABASE NAME= DSNDB01 SPACE NAME= DSNDB01X INSTANCE=1 DATA SET NUMBER=1 PAGE RANGE X'00000000' TO X'FFFFFFFF' START LRSN=X'00D2F0A2C66F6AF40600' END LRSN=X'00D2F0A2C66F6AF40600' START RBA=X'00000000FF109C502EC2' LPL TRACE ID=00000006 LPL REASON TYPE=LOGAPPLY
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 V11 for z/OS users of workfile and * * parallelism. * **************************************************************** * PROBLEM DESCRIPTION: User received unexpected abend * * ABEND04E with RC00C90101 at * * DSNIDM.DSNIDIFS at location 5007 * * on DELETE. * **************************************************************** * RECOMMENDATION: * **************************************************************** DB2 did not handle serialization properly for child tasks during partition growth processing on a workfile. The scenario is as follow: - subsystem parameter PARAMDEG is set to > 1 allowing parallelism - the processing is on a workfile data sets (DGTT, CGTT) - DB2 is attempting to grow a new partition for the workfile TS If the above conditions are met, this might result in the corruption of DSNDB01 and lead to the reported abend. Please note that this can result in other unpredictable errors/abends as well. Some of the known problems: ABEND04E with RC00C90101 at DSNOLDEL 5005 ABEND04E with RC00C90101 at DSNGEDRP 501A ABEND04E with RC00C90101 at DSNGEDRP 501D ABEND04E with RC00C90101 at DSNGEDRP 5017 ABEND04E with RC00C90101 at DSNKINSL 5004 ABEND04E with RC00E70005 at DSNXISUB P003 ABEND04E with RC00C90206 at DSNIDIFS 5007 ABEND04E with RC00C90101 at DSNIWKFD 5002 ABEND04E with RC00C90110 at DSNIFPSC 53E7 ABEND04E with RC00C90101 at DSNIFPSC 5007 REBUILD INDEX reporting duplicate keys DISPLAY DATABASE showing inconsistent data on DSNDB01
Problem conclusion
DB2 has been corrected to handle the add-part lock serialization for child tasks during the add part processing on a workfile. Please note that applying the ptf will not fix existing corrupted DSNDB01. Please contact DB2 support for solution on fixing the corrupted DSNDB01. Temporary work around includes turning off parallelism. Additional Keywords: PBG SQLPBG ABEND04E RC00C90101 DSNIDIFS DSNOLDEL DSNGEDRP DSNKINSL DSNXISUB DSNIWKFD DSNIFPSC PARAMDEG
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PI81964
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
2017-05-22
Closed date
2017-08-21
Last modified date
2017-10-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI49709
Modules/Macros
DSNIOPNP DSNXIPGA
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RB10 PSY UI49709
UP17/09/06 P F709
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:
02 October 2017