A fix is available
APAR status
Closed as program error.
Error description
Customer uses z/OSMF flow to perform migration to V11. When running DSNTIJSO to STOP Db2, the following is returned: CSV003I REQUESTED MODULE DSNHMCID NOT FOUND CSV028I ABEND806-04 JOBNAME=DSNTIJSO STEPNAME=DSNTMVSB IEF450I DSNTIJSO DSNTMVSB - ABEND=S806 U0000 REASON=00000004
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All users of the Db2 12 for z/OS * * and Db2 11 for z/OS installation * * CLIST and DSNTIDxx member refresh * * tool DSNTXAZP * **************************************************************** * PROBLEM DESCRIPTION: * * This APAR addresses some problems * * that occur when running the Db2 * * install CLIST DSNTINST with the * * USE Z/OSMF WORKFLOW option set to * * YES: * * 1. The CLIST generated jobs * * DSNTIJSA/DSNTIJSM/DSNTIJSB (START * * DB2) and DSNTIJSO/DSNTIJSB (STOP * * DB2) do not reference the Db2 * * SDSNEXIT libary in their respective * * JOBLIB DD statement. * * 2. The same DSNTIJSO job is used to * * stop a prior release Db2 and a * * current release Db2 in the same * * workflow. * **************************************************************** * RECOMMENDATION: * * APPLY PTF * **************************************************************** This APAR addresses the following problems that occur when running the Db2 install CLIST with the USE Z/OSMF WORKFLOW option set to YES: 1. The install CLIST generates jobs DSNTIJSO and DSNTIJSA/DSNTIJSM/DSNTIJSB to stop and start a prior release or a current release Db2. These jobs execute the batch program DSNTMVSB to issue the STOP DB2 and START DB2 commands respectively. The JOBLIB DD statement of these jobs references the Db2 SDSNLOAD library only. It does not reference the Db2 SDSNEXIT library. 2. During migration of a stand-alone Db2 subsystem or the first member of a data sharing group, z/OSMF workflow DSNTIWMS uses the same job, DSNTIJSO, to stop a prior release Db2 and later to stop a current release Db2. In both cases, the JOBLIB DD allocates the prior release Db2 SDSNLOAD library. DSNTIWMS needs to be modified to run two different jobs for these tasks so that each job can allocate the appropriate Db2 release libraries on the JOBLIB DD.
Problem conclusion
The following Db2 install CLIST panels, CLIST input members, Db2-supplied sample jobs, and Db2-supplied z/OSMF workflow definition files and variable input files have been modified to address the problems described above. CLIST Panel Changes: -------------------- 1. DSNTILM1 (V11) / DSNTIPM1 (V12) A new field, PRIOR RELEASE SDSNEXIT LIBRARY, is added to the Z/OSMF ARTIFACTS CONFIGURATION PANEL. For migration only, the setting of this new field specifies the name of the SDSNEXIT library from the previous Db2 release. The corresponding z/OSMF variable for this new field is OLDEXIT. For the new layouts of the panels, search for "DSNTILM1" and "DSNTIPM1" in IBM Knowledge Center: https://www.ibm.com/support/knowledgecenter/SSEPEK/ db2z_prodhome.html DSNTIDXA and DSNTIDXB changes: ------------------------------ These members contain, respectively, the Db2-supplied defaults and the SAP-supplied defaults for installing and migrating to Db2 12. They are the basis of the user's DSNTIDxx member that will be generated by the CLIST and contain the site-specified settings. 1. A new entry, OLDEXIT, is added to store the setting specified in the PRIOR RELEASE SDSNEXIT LIBRARY field on panel DSNTILM1/DSNTIPM1. OLDEXIT DSET M NULL Db2-supplied sample jobs (SDSNSAMP) changes: -------------------------------------------- 1. DSNTIJSA (Start Db2) and DSNTIJSO (Stop Db2) The Db2 SDSNEXIT library is added to the JOBLIB DD statement as follows: //JOBLIB DD DSN=DSN!!0.SDSNEXIT,DISP=SHR // DD DSN=DSN!!0.SDSNLOAD,DISP=SHR z/OSMF variable input files (DSNTIV*) and z/OSMF workflow definition files (DSNTIW*) changes: --------------------------------------------------- 1. The Db2-supplied z/OSMF variable input files and workflow definition files which are affected by the following changes are listed in Tables A - D below. o New z/OSMF variable OLDEXIT for PRIOR RELEASE SDSNEXIT LIBRARY field on panel DSNTILM1/DSNTIPM1. o New job DSNTIJSC, generated by the install CLIST, for stopping current release Db2, instead of DSNTIJSO. The CLIST edits the DSNTIJSO job in SDSNSAMP into a new job called DSNTIJSC, which allocates the current release Db2 libraries on the JOBLIB DD. o Prior release Db2 libraries referenced in the JOBLIB DD of job DSNTIJSO when stopping a prior release Db2. o Library SDSNEXIT added in the JOBLIB DD concatenation of libraries for Db2-supplied jobs DSNTIJSO and DSNTIJSA. Table A (Db2 11) and Table B (Db2 12) describe the changes to the variable input files. Table C (Db2 11) and Table D (Db2 12) describe the changes to the workflow definition files. Table A (Db2 11) - Variable Input Files Changes ------------------------------------- | z/OSMF | Modifications | | VARIABLE | | | INPUT | | | File | | |===================================| | DSNTIVMD | o Add variables | | | "OLDEXIT" | | | "OLDLOAD" | |-------------|---------------------| | DSNTIVMS | o Add variable | | | "OLDEXIT" | | |---------------------| | | o Fix panel field | | | info for variable | | | "OLDLOAD" | |-------------|---------------------| Table B (Db2 12) - Variable Input Files Changes ------------------------------------- | z/OSMF | Modifications | | VARIABLE | | | INPUT | | | File | | |===================================| | DSNTIVMD | o Add variable | | | "OLDEXIT" | | |---------------------| | | o Fix panel field | | | info for variable | | | "OLDLOAD" | |-------------|---------------------| | DSNTIVMN | o Remove variables | | | "OLDLOAD" | | | "CONSNAME" | |-------------|---------------------| | DSNTIVMS | o Add variable | | | "OLDEXIT" | | |---------------------| | | o Fix panel field | | | info for variable | | | "OLDLOAD" | |-------------|---------------------| Table C (Db2 11) - Workflow Definition Files Changes --------------------------------------------------- | z/OSMF | Modifications | WORKFLOW | | WORKFLOW | | DEFINITION | | DEFINITION | | File | | File | | JOB STEP | |==================================|==============| | DSNTIWIA | o Add variable | step6 | | | "DSNEXIT" | (DSNTIJSA) | |-------------|--------------------|--------------| | DSNTIWIE | o Execute job | step1 | | | DSNTIJSC instead | (DSNTIJSO) | | | of DSNTIJSO | | | |--------------------|--------------| | | o Add variable | step1 | | | "DSNEXIT" | (DSNTIJSC) | | | | step6 | | | | (DSNTIJSA) | |-------------|--------------------|--------------| | DSNTIWIN | o Add variable | step14 | | | "DSNEXIT" | (DSNTIJSA) | |-------------|--------------------|--------------| | DSNTIWMD | o Add definition | | | | for variable | | | | "OLDEXIT" | | | |--------------------|--------------| | | o Fix abstract | | | | for variable | | | | "OLDLOAD" | | | |--------------------|--------------| | | o Add variables | step9 | | | "OLDEXIT" | (DSNTIJSO) | | | "OLDLOAD" | | | |--------------------|--------------| | | o Add variable | step17 | | | "DSNEXIT" | (DSNTIJSA) | |-------------|--------------------|--------------| | DSNTIWMN | o Execute job | step9a | | | DSNTIJSC instead | (DSNTIJSO) | | | of DSNTIJSO | | | |--------------------|--------------| | | o Add variable | step9a | | | "DSNEXIT" | (DSNTIJSC) | | | | step9c | | | | (DSNTIJSA) | |-------------|--------------------|--------------| | DSNTIWMS | o Add definition | | | | for variable | | | | "OLDEXIT" | | | |--------------------|--------------| | | o Fix abstract | | | | for variable | | | | "OLDLOAD" | | | |--------------------|--------------| | | o Add variables | step9 | | | "OLDEXIT" | (DSNTIJSO) | | | "OLDLOAD" | | | |--------------------|--------------| | | o Execute job | step18b | | | DSNTIJSC instead | (DSNTIJSO) | | | of DSNTIJSO | | | |--------------------|--------------| | | o Add variable | step17 | | | "DSNEXIT" | (DSNTIJSM) | | | | step18b | | | | (DSNTIJSC) | | | | step18c | | | | (DSNTIJSA) | --------------------------------------------------- Table D (Db2 12) - Workflow Definition Files Changes --------------------------------------------------- | z/OSMF | Modifications | WORKFLOW | | WORKFLOW | | DEFINITION | | DEFINITION | | File | | File | | JOB STEP | | | | | | | | | | | | | |==================================|==============| | DSNTIWIA | o Add variable | step6 | | | "DSNEXIT" | (DSNTIJSA) | |-------------|--------------------|--------------| | DSNTIWIE | o Execute job | step1 | | | DSNTIJSC instead | (DSNTIJSO) | | | of DSNTIJSO | | | |--------------------|--------------| | | o Add variable | step1 | | | "DSNEXIT" | (DSNTIJSC) | | | | step6 | | | | (DSNTIJSA) | |-------------|--------------------|--------------| | DSNTIWIN | o Add variable | step14 | | | "DSNEXIT" | (DSNTIJSA) | |-------------|--------------------|--------------| | DSNTIWMD | o Add definition | | | | for variable | | | | "OLDEXIT" | | | |--------------------|--------------| | | o Fix abstract | | | | for variable | | | | "OLDLOAD" | | | |--------------------|--------------| | | o Add variables | step9 | | | "OLDEXIT" | (DSNTIJSO) | | | "OLDLOAD" | | | | o Remove variables | | | | "DSNLOAD" | | | | "DSNTLIBP" | | | | "DSNTLIBS" | | | |--------------------|--------------| | | o Add variable | step17 | | | "DSNEXIT" | (DSNTIJSA) | |-------------|--------------------|--------------| | DSNTIWMN | o Remove variables | | | | "OLDLOAD" | | | | "CONSNAME" | | |-------------|--------------------|--------------| | DSNTIWMS | o Add definition | | | | for variable | | | | "OLDEXIT" | | | |--------------------|--------------| | | o Fix abstract | | | | for variable | | | | "OLDLOAD" | | | |--------------------|--------------| | | o Add variables | step1b | | | "OLDEXIT" | (DSNTIJSO) | | | "OLDLOAD" | step9 | | | o Remove variables | (DSNTIJSO) | | | "DSNLOAD" | | | | "DSNTLIBP" | | | | "DSNTLIBS" | | | |--------------------|--------------| | | o Add variable | step1d | | | "OLDEXIT" | (DSNTIJSB) | | | o Remove variables | | | | "DSNTLIBP" | | | | "DSNTLIBS" | | | |--------------------|--------------| | | o Execute job | step18b | | | DSNTIJSC instead | (DSNTIJSO) | | | of DSNTIJSO | | | |--------------------|--------------| | | o Add variable | step17 | | | "DSNEXIT" | (DSNTIJSM) | | | | step18b | | | | (DSNTIJSC) | | | | step18c | | | | (DSNTIJSA) | --------------------------------------------------- 2. The description of the CONSNAME variable in the following files is modified to refer to the new DSNTIJSC job. o DSNTIVIA, DSNTIVIE, DSNTIVIN, DSNTIVMD, DSNTIVMN, DSNTIVMS o DSNTIWIA, DSNTIWIE, DSNTIWIN, DSNTIWMD, DSNTIWMN, DSNTIWMS DSNTXAZP changes ---------------- DSNTXAZP, the DSNTIDxx member refresh tool, is modified to handle the new parameter OLDEXIT.
Temporary fix
Comments
APAR Information
APAR number
PH04244
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-10-18
Closed date
2019-01-21
Last modified date
2019-03-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI60838 UI60840
Modules/Macros
DSN@XAZP DSNTIPM1 DSNTIVMN DSNTIWMN DSNTIJSA DSNTIVIN DSNTIVMS DSNTIWIN DSNTIWMS DSNTIJSO DSNTXAZP DSNTIDXA DSNTIVMD DSNTIWMD DSNTIVIA DSNTIDXB DSNTIWIA DSNTINST DSNTILM1 DSNTINM1 DSNTIVIE DSNTIWIE
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:
01 March 2019