A fix is available
APAR status
Closed as program error.
Error description
ENFM0047 and ENFM0077 fail with SQLCODE-904 or RC00C90096, CATENFM CONVERT PHASE 1 COMPLETED messages are issued but the V10 tablespaces DSNDB06.SYSRTSTS and DSNDB06.SYSSTR remain in the catalog. Customer continues into V11 NFM, but then CATMAINT does not allow CATENFM CONVERT INPUT CLEANUP to run in V11 NFM. Customer has to run DSNTIJES to revert back to ENFM* to run it. The purpose of this apar is to allow CATENFM CONVERT INPUT CLEAN UP to run in NFM and clarify CATENFM CONVERT PHASE 1 COMPLETED message to indicate which tablespace is completed.
Local fix
Before running DSNTIJEN do the following: 1.user can increase zparm NUMLKTS and NUMLKUT 2.run MODIFY DELETE AGE(*) for the SYSSTR and SYSRTSTS with IC afterwards.
Problem summary
**************************************************************** * USERS AFFECTED: All users of the DSNTIJEN job for Db2 11 * * for z/OS. * **************************************************************** * PROBLEM DESCRIPTION: This APAR addresses two issues: * * 1. Messages DSNU750I and DSNU752I * * are generated in the DSNTIJEN job * * output multiple times with the same * * token "CATENFM CONVERT" though each * * of them is generated for processing * * different catalog and directory * * table spaces. * * 2. CATENFM CONVERT INPUT CLEANUP is * * only allowed in ENFM. It should be * * allowed as long as the system has * * been converted to ENFM or NFM * * previously. * **************************************************************** * RECOMMENDATION: Apply PTF when available * **************************************************************** The ENFM job DSNTIJEN uses CATENFM CONVERT INPUT <name> to convert the catalog and directory table spaces. The DSNTIJEN job also uses CATENFM CONVERT INPUT CLEANUP for house keeping the catalog. Each invocation of CATENFM CONVERT puts a DSNU750I message out at the beginning and a DSNU752I message out at the end, for example: DSNU750I: CATENFM CONVERT PHASE 1 STARTED DSNU752I: CATENFM CONVERT PHASE 1 COMPLETED This can cause confusion because they were the same for all the different invocations. Another problem is that CATENFM CONVERT INPUT CLEANUP can fail due to lock timeouts. Although users can manually re-run the CATENFM CONVERT INPUT CLEANUP outside of the DSNTIJEN job, it was only allowed to be run while the system is in ENFM. Users that are already in NFM have to switch back to ENFM* if they ever need to run CATENFM CONVERT INPUT CLEANUP again.
Problem conclusion
Db2 code has been updated to improve usability. Additional details have been added to the message token, for example: DSNU750I 171 18:07:09.13 DSNUECM0 - CATENFM CONVERT INPUT SYSUTILX PHASE 1 STARTED DSNU752I 171 18:07:09.13 DSNUECM0 - CATENFM CONVERT INPUT SYSUTILX PHASE 1 COMPLETED CATENFM CONVERT INPUT CLEANUP can now be run in ENFM and NFM.
Temporary fix
Comments
APAR Information
APAR number
PI97099
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-23
Closed date
2018-07-03
Last modified date
2018-08-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI57045
Modules/Macros
DSNUECM0
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RB10 PSY UI57045
UP18/07/20 P F807
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 August 2018