A fix is available
APAR status
Closed as program error.
Error description
In a data sharing environment with only one V11 member active and after this member is migrated to V12, the statement CATMAINT UPDATE LEVEL V12R1M503 incurs return code=8. DSNU777I DSNUECM0 - CATMAINT UPDATE STATUS - VERIFYING CATALOG IS AT CORRECT LEVEL FOR MIGRATION. DSNU777I DSNUECM0 - CATMAINT UPDATE STATUS - BEGINNING MIG- RATION SQL PROCESSING PHASE. DSNU012I DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8 This problem is not limited to CATMAINT UPDATE LEVEL V12R1M503. The problem can occur on any CATMAINT UPDATE LEVEL xxxxxx statement as long as the member executing the CATMAINT UPDATE LEVEL xxxxxx is the only member active in the data sharing group.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All users of the DSNTIJTC job for Db2 12 * * for z/OS. * **************************************************************** * PROBLEM DESCRIPTION: * * DSNTIJTC failed in a data sharing * * environment with RC=8 with all but * * the migrating member of the group * * being down. * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** The DSNTIJTC CATMAINT job can fail in a data sharing environment if all but the migrating member of a group are down. DSNTIJTC fails with a RC8 in this case with no other diagnostic information in the job output or on the console. This problem is storage dependent. As such, not every Db2 12 data sharing migration where the migrating member is the only active group member will be impacted.
Problem conclusion
Db2 code has been changed to correct the problem. If CATMAINT fails as described during migration processing, the problem can be circumvented by starting a single Db2 11 member. This is a data sharing only issue. Non-data sharing migrations are not affected by this issue. Additional keywords: DB2MIGV12/K DSNTIJTC
Temporary fix
Comments
APAR Information
APAR number
PH04057
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-10-12
Closed date
2018-11-08
Last modified date
2018-12-12
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI59576
Modules/Macros
DSNUECMI
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RC10 PSY UI59576
UP18/11/16 P F811
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":"12.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":"12.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
12 December 2018