A fix is available
APAR status
Closed as program error.
Error description
ABEND04E RC00E40600 and SQLCODE -531 can occur when running CATMAINT UPDATE UNLDDN PI34964 and PI34964 is applied.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 10 and 11 for z/OS users of * * SYSRELS.RELNAME catalog column * * with APAR PI34964 PTFs * * UI29182.HDBAA10/UI29183.HDBBB10 applied. * **************************************************************** * PROBLEM DESCRIPTION: 1. Relationship DSN1T@1T for the * * SYSUTILX directory table was recorded * * in SYSRELS.RELNAME catalog column with * * an incorrect '@' character for some * * EBCDIC CCSIDs. * * * * 2. ABEND04E RC00E40600 and SQLCODE531 * * when running CATMAINT UPDATE with * * the UNLDDN specification or when * * running the DSNTIJEN job. * **************************************************************** * RECOMMENDATION: * **************************************************************** User receives: SQLCODE=-531,ERROR:PARENT KEY IN A PARENT ROW CANNOT BE UPDATED when running the hold action in UI29182/UI29183 The same problem can occur when running DSNTIJEN. Relationship DSN1T@1T for the SYSUTILX directory table was recorded incorrectly in SYSRELS.RELNAME catalog column with a bad '@' character for some EBCDIC CCSIDs. APAR PI34964(PTFs UI29182.HDBAA10/UI29183.HDBBB10) provided CATMAINT UPDATE UNLDDN PI34964 to fix the above problem but it failed if the DB2 is running in certain CCSIDs (such as 1147).
Problem conclusion
DB2 has been updated to correct the problem. ++HOLD ACT: This PTF fixes APAR PI34964 and prevent a bad entry in SYSRELS.RELNAME column for the relationship DSN1T@1T for SYSUTILX directory table. This PTF will not correct the existing bad DSN1T@1T entry in SYSRELS.RELNAME. To identify the bad DSN1T@1T entry in SYSRELS.RELNAME, please run the following query: SELECT HEX(RID(R)),R.RELNAME FROM SYSIBM.SYSRELS AS R WHERE R.CREATOR='SYSIBM' AND R.TBNAME='SYSUTILX' AND R.RELNAME <> 'DSN1T'||X'40'||'1T'; If the query returns a row, you can run the following utility to correct them: CATMAINT UPDATE UNLDDN PI45414 Please note that CATMAINT UPDATE UNLDDN PI34964 has been removed.
Temporary fix
Comments
APAR Information
APAR number
PI45414
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
A10
Status
CLOSED PER
PE
YesPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2015-07-21
Closed date
2015-11-12
Last modified date
2015-12-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI32925 UI32926
Modules/Macros
DSNUECM0 DSNUECSE
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":"10.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":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 December 2015