A fix is available
APAR status
Closed as program error.
Error description
With apar PM53155 , the following abend could occur during group restart: DSN ABND 04E 00C90101 U=SYSOPR M=(N) C=910 DMC DSNIDBLG M DSNTFRCV LOC DSNIDM DSNIDBHK 500C A portion of the DBET base SCA record(s) was accidentally deleted which resulted in the local DBET being built incorrectly. From the dump, for the dbet_db being processed, the lowest partition number was higher than the highest partition number , and that highest partition number ' dbedhpnc ' was zeroes .
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 10 for z/OS data sharing users with * * PM53155 / UK77362, DB2 9 for z/OS data * * sharing users with PM53155 / UK77364 and * * DB2 V8 for z/OS data sharing users with * * PM53155 / UK77363 applied * **************************************************************** * PROBLEM DESCRIPTION: ABEND04E RC00C90101 DSNIDBHK ERQUAL500C * * during several data sharing members' * * DB2 checkpoint after group restart, * * leading to their DB2 crash with * * MSGDSNV086E RC00D95001 * **************************************************************** * RECOMMENDATION: * **************************************************************** During group restart, while updating the group DBET in SCA, a subset of the DBET base SCA record(s) for an object was accidentally deleted, which resulted in local DBET entry for the object being built incorrectly. In this case, there were more than 200 partitions with diverse exception states such that the DBET entry for this object had multiple DBET blocks. During internal DBET rectify, at the beginning of forward log apply phase, the group DBET in SCA needed to be updated since local DBET had to reset an internal extend-in-progress state. However, when copying the local DBET blocks to the group DBET in SCA, by mistake not all the DBET blocks were copied. This resulted in an incomplete group DBET in SCA for this object. When other members of the data sharing group came up, their local DBET was built incorrectly, eventually leading to the aforementioned ABEND04E. The first member that performed the rectify was able to come up successfully because his local DBET was not corrupted. Any subsequent DBET updates that this member performed after the group restart automatically cleaned up the group DBET in SCA, which is why the originally failed members were able to restart on their second restart attempt.
Problem conclusion
DB2 code has been modified such that the group DBET in SCA is updated correctly during DBET rectify.
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PM77066
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
910
Status
CLOSED PER
PE
YesPE
HIPER
YesHIPER
Special Attention
NoSpecatt
Submitted date
2012-11-14
Closed date
2013-01-31
Last modified date
2013-03-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK91321 UK91322 UK91323
Modules/Macros
DSNIDBNG DSNIDBNI
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RA10 PSY UK91321
UP13/02/16 P F302 ®
R810 PSY UK91322
UP13/02/16 P F302 ®
R910 PSY UK91323
UP13/02/16 P F302 ®
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":"9.1","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":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
04 March 2013