A fix is available
APAR status
Closed as program error.
Error description
ABEND04E RC00C90101 at DSNIDBLG 5460 when IRLM is brought down in a datasharing system. D75284..
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All Db2 for zOS users of Alter Table Add * * Partition and users of partitioned * * tablespaces. * **************************************************************** * PROBLEM DESCRIPTION: ABEND04E RC00C90101 in DSNIDBLG with * * ERQUAL5460 when IRLM is brought down * * in a datasharing environment. * * Also ABEND04E RC00C90101 in DSNIDBEL * * with ERQUAL5460. * **************************************************************** * RECOMMENDATION: * **************************************************************** During rollback of an ALTER TABLE ADD PARTITION, abends occurred processing a partitioned table. The total number of partitions is less than the high partition range of an entry in an internal DBET control block. During processing of the ALTER to add a new partition, the new partition is placed in extend-in-progress and the entry added to an internal DBET control block. During rollback, this newly added entry is not cleaned up properly and is left in the control block. Checks done later to ensure consistency fail when it finds this entry still in the control block.
Problem conclusion
DBET has been modified to correctly clean up during rollback of an ALTER TABLE ADD PARTITION.
Temporary fix
Comments
APAR Information
APAR number
PI96921
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-04-18
Closed date
2018-05-15
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:
UI55872 UI55873
Modules/Macros
DSNIDBEL DSNIDBLG
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