Automating Db2 migration by using z/OS Management Facility

You can use z/OSMF to automate the process of migrating Db2 subsystems to Db2 12 for z/OS.

To migrate to Db2 12 by using z/OSMF, use the following general approach:

1. Prepare for creating workflow definition files by running the DSNTXAZP tool to update the CLIST defaults input member, as described in Updating the CLIST defaults input member: job DSNTIJXZ .
   Important: The DSNTXAZP tool does not update the DSNTIDxx CLIST input member with current settings for the following parameters or panel fields. Update the values as you complete the CLIST, or modify the values directly in the DSNTIDxx member:

   Table 1. Settings not updated by the DSNTXAZP tool in Db2 12

   CLIST Panel	Field Name (DSNTIDxx entry)
   DSNTIPA2	The following fields: DEFINE CATALOG (VCATSTAT)
   DSNTIPA3	All fields: PERMANENT UNIT NAME (VOLSDEVT) TEMPORARY UNIT NAME (TVOLSDEVT) CLIST ALLOCATION: VOL/SER (VOLSDAT1) CLIST ALLOCATION: DATA CLASS (DATACLS1) CLIST ALLOCATION: MGMT CLASS (MGMTCLS1) CLIST ALLOCATION: STOR CLASS (STORCLS1) NON-VSAM DATA: VOL/SER (VOLSDAT2) NON-VSAM DATA: DATA CLASS (DATACLS2) NON-VSAM DATA: MGMT CLASS (MGMTCLS2) NON-VSAM DATA: STOR CLASS (STORCLS2)
   DSNTIPG1	All fields: INSTALL DS PREFIX (INSDSPRE) IC DATA SET UNIT NAME (ICDSDEV) IC TEMPLATE EXPRESSION (ICDSTPLT) IC TEMPLATE DATA CLASS (ICDSDC) IC TEMPLATE MGMT CLASS (ICDSMC) IC TEMPLATE STOR CLASS (ICDSSC) PKG APPLCOMPAT (JRTAPCO) PKG PLANMGMT (JRTPMGMT) MQ ADMIN ID(S) (JRTMQADM)
   DSNTIPT	All fields: TEMP CLIST LIBRARY (NEWCL) SAMPLE LIBRARY (NEWSAMP) CLIST LIBRARY (OUTCL) APPLICATION DBRM (DBRMLIB) APPLICATION LOAD (RUNLIB) DECLARATION LIBRARY (SRCLIB) LINK LIST LIBRARY (DSNLINK) LOAD LIBRARY (DSNLOAD) JDBC AND SQLJ DLLS (DSNLOD2) MACRO LIBRARY (DSNMACS) EXIT LIBRARY (DSNEXIT) DBRM LIBRARY (DSNDBRM) IRLM LOAD LIBRARY (DSNIRLM) IVP DATA LIBRARY (DSNIVPD) INCLUDE LIBRARY (DSNCHDRS)
   DSNTIPU	All fields: IBM® LE RUNTIME LIBRARY (LERUN) IBM LE RUNTIME LIBRARY 2 (LERUN2) IBM LE LINK EDIT LIB (LELKED) IBM LE PRELINK MSG LIB (LEPLMSGL) HIGH LEVEL ASSEMBLER LIB (ASMLIB) C/CPP COMPILER MODULE (CPROG) C/CPP COMPILER LIBRARY (CCOMP) C/CPP HEADER LIBRARY (CHDRS) C/370 COMPILER MESSAGES (CMSGS) C LE PRELINKER PHASE (CPRLK) CPP LE PRELINKER PHASE (CPPPRLK) CPP CLASS LIB HEADERS (CPPHDRS) CPP AUTO CALL LIBRARY (CPPAUTCL) CPP CLASS LIBRARY (CPPCLASS) CPP PROCEDURE LIBRARY (CPPPROC)
   DSNTIPU1	All fields: COBOL COMPILER LIBRARY (ICOBCOMP) COBOL LE PRELINKER PHASE (ICOBPRLK) FORTRAN COMPILER LIBRARY (FORTCOMP) FORTRAN LINK EDIT LIB (FORTLINK) PL/I COMPILER LIBRARY (PLICOMP) PL/I LE PRELINKER PHASE (PLIPRLK)
   DSNTIPW	All fields: SYSTEM MACLIB (MACLIB) SYSTEM PROCEDURES (PROCLIB) SORT LIBRARY (SORTLIB) IMS RESLIB (RESLIB) ISPF ISPLINK MODULE (ISPLOAD) GDDM MACLIB (GDDMMACS) GDDM LOAD MODULES (GDDMLOAD) CICS® LOAD LIBRARY (CICSMOD) CICS MACRO LIBRARY (CICSMAC) CICS COBOL LIBRARY (CICSCOB) CICS PL/I LIBRARY (CICSPLI) CICS EXCI LIBRARY (CICSEXCI)
   DSNTIPD	All fields: EXECUTED STMTS (NUMSTMTE) TABLES IN STMT (NUMSTMTL)
   DSNTIP9	All fields: 4K SORT PRIMARY SPACE (S4KSPAC) 32K SORT PRIMARY SPACE (S32KSPAC) 4K TEMP PRIMARY SPACE (T4KSPAC ) 32K TEMP PRIMARY SPACE (T32KSPAC)
   DSNTIPE	DATABASES (NUMCONDB)
   DSNTIPI: IRLM panel 1	INSTALL IRLM (IRLMINST)
   DSNTIPM	SUBSYSTEM MEMBER (MVSSMEMB) SUBSYSTEM SEQUENCE(MVSSSEQN) AUTH MEMBER (MVSAMEMB) AUTH SEQUENCE (MVSASEQN) LINK LIST ENTRY (MVSLMEMB) LINK LIST SEQUENCE (MVSLSEQN) COMMAND SCOPE (MVSCMSC)
   DSNTIPL	ARCHIVE LOG FREQ (NUMHRARC) UPDATE RATE (NUMCOMHR)
   DSNTIPX	The following fields: WLM PROC NAME (STORWLM) NUMBER OF TCBS (STORTCBS)
   DSNTIPX1	SDK HOME DIR (JAVAHOME) JAVA CLASSES (CLASPATH) JAVA RUNTIME (LIBPATH) JDBC/SQLJ ENV VAR DIR (JCCHOME) JDBC/SQLJ INSTALL ID (JCCSID) DB2 BASE JAVA DIR (DB2BASE) JAVA ENV DATA SET (JAVAENV) JAVA ENV VAR FILE (JAVAENVV) JVM PROPERTIES FILE (JVMPROPS) JVM ADDRESSING MODE (JVMAMODE) INIT JAVA HEAP SIZE (JVMHEAP) MAX APPL HEAP SIZE (JVMAPPH)
   DSNTIPM1	PATH FOR Z/OSMF ARTIFACTS (ZARTPATH) PRIOR RELEASE SDSNLOAD LIBRARY (OLDZPARM) PRIOR RELEASE SDSNEXIT LIBRARY (OLDEXIT)

2. Create the workflow definition files and input variable files by running the installation CLIST and specifying USE Z/OSMF WORKFLOW ===> YES on panel DSNTIPA1.
   When you specify that option, the CLIST runs with modified and extra panels that support generation of the z/OSMF workflow artifacts.

   Tip: You can specify an HFS or zFS directory for storing the z/OSMF artifacts. Specify the directory in the PATH FOR Z/OSMF ARTIFACTS field on panel DSNTIPM1.

   For more information about the specific panels that support the generation of z/OSMF workflow artifacts, see Installation panels for installing or migrating with z/OSMF.

   1. Create the workflow definition file for migrating the first subsystem to Db2 12 by running the installation CLIST and specifying the following field values on panel DSNTIPA1:
      • USE Z/OSMF WORKFLOW ===> YES
      • INSTALL TYPE ===> MIGRATE
      • DATA SHARING ===> YES, with option 1. Group selected on DSNTIP0A

      As you complete the CLIST, select each subsystem parameter that you want to include in the input variable file.

      When you complete the CLIST, the DSNTIWMS and DSNTIWMN workflow definition files and associated input variable files are created.
   2. If you are migrating a data sharing group, create the workflow definition file for migrating other data sharing members (DSNITWMD) by running the CLIST again and setting the following options on panel DSNTILA1:
      • USE Z/OSMF WORKFLOW ===> YES
      • INSTALL TYPE ===> MIGRATE
      • DATA SHARING ===> YES, with option 2. Member selected on DSNTIP0A

      As you complete the CLIST, select each subsystem parameter that you want to include in the input variable file.

      When you complete the CLIST, the DSNITWMD workflow definition file and the DSNTIVMD input variable file are created.
3. Create extra input variable files, as required to support the efficient migration of your environment.
   The goal is to structure the input variable files so that you can specify subsystem parameters that are common across many subsystems in a single file.
   For an example of how you might and structure and name a set of input variable files for migrating a particular environment, see Example of migrating a data sharing group to Db2 12 by using z/OSMF.
   Important: All input variable files must include the following variables, with supported values:

   INSTYPE=

   The installation type. The following values are accepted:

   ACTV

   Activating a Db2 12 function level.

   MNDS

   Migration of a non-data-sharing subsystem to Db2 12.

   MDS1

   Migration of the first member of a data sharing group to Db2 12.

   MDSS

   Migration of subsequent members of a data sharing group to Db2 12

   MNFM

   Activation of Db2 12 new function. (Function level 500 or higher.)

   INDS

   Installation of a non-data-sharing Db2 subsystem.

   IDS1

   Installation of the first member of a data sharing group

   IDSS

   Adding a member to a data sharing group

   NEWSAMP2=

   NEWSAMP2 is the partitioned data that contains tailored JCL templates for the z/OSMF workflow. You must change this value if the workflow artifacts are moved to a different location.

   B=

   The indicator for line breaks in z/OSMF. Do not change or remove this variable in a generated input variable file.

4. Create the workflow instances in z/OSMF.
   1. Specify the path of the workflow definition file and the input variable file.
      The path of the input variable file is optional, but it is best to always specify it. Otherwise, z/OSMF prompts you to provide the variable values during execution, preventing full automation of the process.
   2. Specify a name for the workflow instance.
      Tip: Specify a name that describes the purpose of the workflow and includes the name of the target system.
   3. Assign all workflow steps to the same person to fully automate the migration process.
   4. Validate the JCL job and the substituted input variables.
      You can find the input variable files and the JCL jobs with the substituted input variables on the Perform tab for the workflow in z/OSMF.

      1. Review the input variables. You can edit the values of input variables during your review, but any changes that you make apply to this workflow instance only.
      2. In the Create JOB statement step, z/OSMF prompts you to review and update the JOB statement JCL. You can specify appropriate CLASS or MSGCLASS values.

         If installation or migration step requires authorization, you can also specify the USERNAME and PASSWORD. For detailed information about required authorizations see Required authorization for installation or migration.

      3. Review the JCL including the JOB statement. You can click Edit JCL to make changes. However, any changes that you make apply only to this workflow instance. It is best to make any changes that apply to all instances in the JCL template before you create the instances.
5. Start running the workflow steps.
   You can run the workflow steps in z/OSMF, or by embedding z/OSMF REST services in your own automation programs.

   • For a single Db2 subsystem, run the migration steps in the following order:
     1. Run DSNTIWMS to migrate to subsystem to Db2 12.
     2. Run DSNTIWMN to activate Db2 12 new function (function level 500 or higher).
   • For a data sharing group, run the migration steps in the following order:
     1. Run DSNTIWMS to migrate the first member to Db2 12.
     2. Run DSNTIWMD to migrate each subsequent member to Db2 12.
     3. Run DSNTIWMN to migrate the data sharing group to activate Db2 12 new function (function level 500 or higher).
     
   1. Certain workflow steps, such as the pre-migration job DSNTIJPM, might need to be run repeatedly.
      For such repeated steps, you can select Manually perfrom the selected step. After you run the step, it is marked Completed in z/OSMF. However, you can still rerun this step. That is, you can take the required actions that are identified in the premigration reports, and then return to z/OSMF to repeat this step until all premigration tasks are completed.
   2. After any manual steps are complete, select Automatically perform the selected step, and all subsequent steps... on the Perform Automated Step page.
      z/OSMF runs all subsequent steps in order until all steps complete successfully, or until an error is encountered.
   3. If errors are encountered, check the job output on the z/OSMF Status tab.
      The maximum return code that a step tolerates is defined the workload definition file, and it might be a return code other than 0. The maximum return code for most steps is 0 or 4.

What to do next

Activate function level 500 or higher, as described in Activating Db2 function levels by using z/OSMF