IBM Support

PH04244: ABEND S806 RC4 REQUESTED MODULE DSNHMCID NOT FOUND EXECUTING DSNTIJSO TO STOP DB2

A fix is available

Subscribe

You can track all active APARs for this component.

 

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

  • RB10 PSY UI60840

       UP19/02/13 P F902

  • RC10 PSY UI60838

       UP19/02/13 P F902

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