PM88733: MIGRATE / MIG FUNCTION JCL REFERENCES INCORRECT LIBRARY DATASETS AS SOURCE DSNS ARE USED INSTEAD OF TARGET LIBRARY DSNS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' MIGRATE / MIG function
  created JCL which references the source library datasets rather
  than then target library datasets.
  The DD's being affected are ADBALIB and DB2RLIB.
  

Local fix

• Manual correct the library names referenced in the DD's.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool and     *
  *                 IBM Tools Customizer (TCz) for z/OS.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the Migrate (MIG) function   *
  *                      with the following Target options       *
  *                      enabled on panel ADB28M 'Migrate        *
  *                      Parameters':                            *
  *                                                              *
  *                      Target JCL job data sets for            *
  *                      Admin and DB2:                          *
  *                        Use customization settings for        *
  *                        Admin libs . . . . . YES (Yes/No)     *
  *                        Use customization settings for        *
  *                        the following libs . YES (Yes/No)     *
  *                        <--- Primarily this option.           *
  *                                                              *
  *                      the following generated DDs             *
  *                      ADBALIB and DB2RLIB for the target      *
  *                      job ADBMGT1 uses the dsname value       *
  *                      of the DB2 Admin / TCz input            *
  *                      field 'DB2 Admin APF library' from      *
  *                      panel CCQPPRD 'Product Parameter'       *
  *                      instead of panel CCQPDB2 'DB2           *
  *                      Parameters'.                            *
  *                                                              *
  *                      For example:                            *
  *                                                              *
  *                      >HLQ<.TEST1.JCL(ADBMGT1)                *
  *                                                              *
  *                      would contain:                          *
  *                                                              *
  *                      //CREAT1   EXEC PGM=IKJEFT01,           *
  *                                      DYNAMNBR=100            *
  *                      //STEPLIB  DD DISP=SHR,                 *
  *                                    DSN=>HLQ<.SADBLLIB        *
  *                      //         DD DISP=SHR,DSN=             *
  *                                    DSN.>ssid<.SDSNEXIT       *
  *                      //         DD DISP=SHR,DSN=             *
  *                                    DSN.>ssid<.SDSNLOAD       *
  *                      //SYSEXEC  DD DISP=SHR,                 *
  *                                    DSN=>HLQ<.SADBEXEC        *
  *                      //MSGLIB   DD DISP=SHR,                 *
  *                                    DSN=>HLQ<.SADBLLIB        *
  *                      //ADBALIB  DD DISP=SHR,DSN=             *
  *                                    >HLQ<.SADBLINK <---       *
  *                      Should have used the 'DB2 Admin APF     *
  *                      library' input field setting from       *
  *                      panel CCQPDB2 'DB2 Parameters'          *
  *                      (i.e., >hlq<.>ssid<.SADBLINK).          *
  *                      /DB2RLIB   DD DISP=SHR,DSN=             *
  *                                    DSN=DSN.>ssid<.SDSNEXIT   *
  *                      //         DD DISP=SHR,DSN=             *
  *                                    DSN.>ssid<.SDSNLOAD       *
  *                      //         DD DISP=SHR,DSN=             *
  *                                    >HLQ<.SADBLINK <---       *
  *                      Should have used the 'DB2 Admin APF     *
  *                      library' input field setting from       *
  *                      panel CCQPDB2 'DB2 Parameters'          *
  *                      (i.e., >hlq<.>ssid<.SADBLINK).          *
  *                      //SYSTSPRT DD SYSOUT=*                  *
  *                      //SYSPRINT DD SYSOUT=*                  *
  *                      //ADBRPTSM DD SYSOUT=*                  *
  *                      //SYSTSIN  DD *                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using the Migrate (MIG) function with the following Target
  options enabled on panel ADB28M 'Migrate Parameters':
  
  Target JCL job data sets for Admin and DB2:
    Use customization settings for Admin libs . . . YES (Yes/No)
    Use customization settings for the following libs. . .
    YES (Yes/No) <--- Primarily this option.
  
  the following generated DDs ADBALIB and DB2RLIB for the target
  job ADBMGT1 uses the dsname value of the DB2 Admin / TCz input
  field 'DB2 Admin APF library' from panel CCQPPRD 'Product
  Parameter' instead of panel CCQPDB2 'DB2 Parameters'.
  
  For example:
  
  >HLQ<.TEST1.JCL(ADBMGT1)
  
  would contain:
  
  //CREAT1   EXEC PGM=IKJEFT01,
             DYNAMNBR=100
  //STEPLIB  DD DISP=SHR,DSN=>HLQ<.SADBLLIB
  //         DD DISP=SHR,DSN=DSN.>ssid<.SDSNEXIT
  //         DD DISP=SHR,DSN=DSN.>ssid<.SDSNLOAD
  //SYSEXEC  DD DISP=SHR,DSN=>HLQ<.SADBEXEC
  //MSGLIB   DD DISP=SHR,DSN=>HLQ<.SADBLLIB
  //ADBALIB  DD DISP=SHR,DSN=>HLQ<.SADBLINK <--- Should have
             used the 'DB2 Admin APF library' input field
             setting from panel CCQPDB2 DB2 Parameters (i.e.,
             >hlq<.>ssid<.SADBLINK).
  //DB2RLIB  DD DISP=SHR,DSN=DSN.>ssid<.SDSNEXIT
  //         DD DISP=SHR,DSN=DSN.>ssid<.SDSNLOAD
  //         DD DISP=SHR,DSN=>HLQ<.SADBLINK  <--- Should have
             used the 'DB2 Admin APF library' input field
             setting from panel CCQPDB2 DB2 Parameters (i.e.,
             >hlq<.>ssid<.SADBLINK).
  //SYSTSPRT DD SYSOUT=*
  //SYSPRINT DD SYSOUT=*
  //ADBRPTSM DD SYSOUT=*
  //SYSTSIN  DD *
  

Problem conclusion

• Problem has been resolved.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• ADB2CUST ADB28M
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UK94522

     UP13/05/25 P F305

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.