Sample workflow artifacts for installation and migration with z/OS Management Facility
Db2 provides sample z/OSMF workflow artifacts for Db2 installation and migration. The artifacts include several sample workflow definition files, and an associated a set of sample JCL templates and a sample workflow input variable file for each definition file.
You can find the sample z/OSMF workflow artifacts in the prefix.SDSNIVPD Db2 SMP/E library.
You can find the steps of each workflow on one or more scenario-specific panels. Each workflow supports only the steps that are shown on the panel.
Required, optional, and default workflow steps
Each panel indicates the required and optional steps and whether they are selected by default, for example:
sindicates a required step.Sindicates an optional step that is selected by default.- An empty selection field indicates an optional step that is not selected by default.
DSNTIWMS and DSNTIVMS: migrate to Db2 12
The DSNTIWMS workflow migrates a non-data sharing Db2 subsystem, or the first Db2 member of a data sharing group, to Db2 12. It uses the DSNTIVMS input variable file.Panel DSNTIPMS shows the steps of the DSNTIWMS workflow.
DSNTIPMS REVIEW STEPS IN Z/OSMF MIGRATION WORKFLOW DEFINITION (PANEL 1)
===>
Select the steps which should be included in the workflow definition:
S Actions to complete before migration (DSNTIJPM) 1
Convert BSDS records to support 10-byte RBA and LRSN fields 2
(DSNTIJCB)
S Take image copies of the directory and catalog (DSNTIJIB) 3
S Make DB2 CLISTs available to TSO and batch users (DSNTIJVC)
s Stop DB2 Version 11 activity (DSNTIJSO)
s Define the DB2 subsystem parameter module (DSNTIJUZ)
s Define the DB2 application defaults module (DSNTIJUA)
s Define the DB2 offline message CCSIDs module (DSNTIJUM)
Define DB2 12 to z/OS (DSNTIJMV)
Add DB2 12 address space startup JCL procedures (DSNTIJMA)
Add DB2 program preparation and utilities invocation JCL procs (DSNTIJMP)
Add address space JCL procs for the DB2-supplied WLM environments (DSNTIJMW)
Add environment files for the DB2-supplied Java WLM environment (DSNTIJMJ)
s Define system data sets (DSNTIJIN)
Define user authorization exit routines (DSNTIJEX)
PRESS: ENTER to continue RETURN to exit HELP for more information
- Complete this step before migration.
- If this job is selected, job DSNTIJSO runs before to stop Db2, and job DSNTIJSB runs after to start Db2.
- DSNTIJIB is tailored based on DSNTIJIC, using the Db2 11 SDSNLOAD library.
The steps on panel DSNTIPMS continue on panel DSNTIPMT: DSNTIPMT REVIEW STEPS IN Z/OSMF MIGRATION WORKFLOW DEFINITION (PANEL 2)
===>
Select additional steps which should be included in the workflow definition:
s Start DB2 Version 12 (DSNTIJSA)
s Tailor DB2 Version 12 catalog (DSNTIJTC)
Ensure that the catalog indexes have no problems (DSNTIJCX)
s Prepare dynamic SQL program (DSNTIJTM)
s Bind SPUFI and DCLGEN and user-maintained DB activity (DSNTIJSG)
Set up DB2-supplied routines (DSNTIJRW)
s Configure DB2 for running SPs and user-defined routines (DSNTIJRT)
S Validate the installation of DB2-supplied routines (DSNTIJRV)
S Convert EXPLAIN tables to the current format (DSNTIJXA)
s Take an image copy of the DB2 catalog (DSNTIJIC)
PRESS: ENTER to continue RETURN to exit HELP for more information 
For more information about the steps, see Migrating your Db2 subsystem to Db2 12.
Panels DSNTIPMS and DSTIPMT are shown only when you specify the following values on panel DSNTILA1:
- USE Z/OSMF WORKFLOW ===> YES
- INSTALL TYPE ===> MIGRATE
- DATA SHARING ===> NO, or DATA SHARING ===> YES with option 1 selected in the DSNTIP0B window.
DSNTIWMD and DSNTIVMD: migrate data sharing members to Db2 12
The DSNTIWMD workflow migrates subsequent members of a Db2 data sharing group to Db2 12. It uses the DSNTIVMD input variable file.Panel DSNTIPMD shows the steps of this workflow.
DSNTIPMD REVIEW STEPS IN Z/OSMF MIGRATION WORKFLOW DEFINITION
===>
Select the steps which should be included in the workflow definition:
Stop DB2 Version 11 activity (DSNTIJSO)
Convert BSDS records to support 10-byte RBA and LRSN fields
(DSNTIJCB)
Define the DB2 subsystem parameter module (DSNTIJUZ)
Add DB2 12 address space startup JCL procedures (DSNTIJMA)
Start DB2 Version 12 (DSNTIJSA)
S Create additional work file table spaces (DSNTIJTM)
PRESS: ENTER to continue RETURN to exit HELP for more information
For more information about the steps, see Migrating subsequent members of a group to Db2 12. The workflow supports only steps that are shown in the panel.
DSNTIPMD is shown only when you specify the following values on panel DSNTILA1:- USE Z/OSMF WORKFLOW ===> YES
- INSTALL TYPE ===> MIGRATE
- DATA SHARING ===> YES with option 2 selected in the DSNTIP0B window.
DSNTIWMN and DSNTIVMN: activate Db2 12 function level 500 or higher
The DSNTIWMN sample workflow activates Db2 12 new function in the Db2 subsystem. It uses the DSNTIVMN input variable file.Panel DSNTIPMN shows the steps of the DSNTIWMN workflow.
DSNTIPMN REVIEW STEPS IN Z/OSMF COMPLETING MIGRATION WORKFLOW DEFINITION
===>
Select the steps which should be included in the workflow definition:
S Back up the DB2 directory and catalog (DSNTIJIC)
Activate DB2 function level V12R1M501 (DSNTIJA1)
S Tailor the DB2 catalog (DSNTIJTC)
s Activate a DB2 function level (DSNTIJAF)
S Rebuild the subsystem parameter module to change APPLCOMPAT level
(DSNTIJUZ)
S Bring the APPLCOMPAT change online (DSNTIJOZ)
S Rebuild the application defaults module to change SQLLEVEL setting
(DSNTIJUA)
s Install and configure DB2-supplied routines that use new function
(DSNTIJRT)
S Convert EXPLAIN tables to the current format (DSNTIJXA)
S Validate DB2-supplied routines (DSNTIJRV)
s Remove sample applications and sample schema authorizations (DSNTEJ0)
S Create and load sample tables (DSNTEJ1)
S Prepare and invoke program DSNTEP2 (DSNTEJ1L)
S Prepare and invoke program DSNTIAUL (DSNTEJ2A)
PRESS: ENTER to continue RETURN to exit HELP for more information
For more information about the steps, see Migrating your Db2 subsystem to Db2 12 , beginning with Migration step 27: Take an image copy of the Db2 12 catalog : DSNTIJIC.
DSNTIPMN is shown only when you specify the following values on panel DSNTILA1:
- USE Z/OSMF WORKFLOW ===> YES
- INSTALL TYPE ===> MIGRATE
- DATA SHARING ===> NO, or DATA SHARING ===> YES with option 1 selected in the DSNTIP0B window.
DSNTIWAF and DSNTIVAF: activate a Db2 12 function level
The DSNTIWAF workflow activates a specified Db2 12 function level in the Db2 subsystem. It can also be used to updated the default Db2 application compatibility (APPLCOMPAT subsystem parameter) setting and to bring that change online. It uses the DSNTIVAF input variable file.
Panel DSNTIPMF shows the steps of the DSNTIWAF workflow.
DSNTIPMF REVIEW STEPS IN Z/OSMF ACTIVATION WORKFLOW DEFINITION
===>
Select the steps which should be included in the workflow definition:
S Back up the DB2 directory and catalog (DSNTIJIC)
S Tailor the DB2 catalog (DSNTIJTC)
s Activate a DB2 function level (DSNTIJAF)
S Rebuild the subsystem parameter module to change APPLCOMPAT level
(DSNTIJUZ)
S Bring the APPLCOMPAT change online (DSNTIJOZ)
S Rebuild the application defaults module to change SQLLEVEL setting
(DSNTIJUA)
PRESS: ENTER to continue RETURN to exit HELP for more information
For more information about the steps, see Activating Db2 12 new function at migration
This panel is shown only when you specify the following values on panel DSNTILA1:
- USE Z/OSMF WORKFLOW ===> YES
- INSTALL TYPE ===> ACTVATE
- DATA SHARING ===>
DSNTIWIN and DSNTIVIN: install Db2 12
The DSNTIWIN sample workflow definition file installs a new Db2 12 subsystem.
Panel DSNTIPMI shows the steps of the DSNTIWIN workflow.
DSNTIPMI REVIEW STEPS IN Z/OSMF INSTALLATION WORKFLOW DEFINITION (PANEL 1)
===>
Select the steps which should be included in the workflow definition:
s Define DB2 to z/OS (DSNTIJMV)
s Add DB2 for z/OS address space startup JCL procedures (DSNTIJMA)
s Add DB2 program preparation and utilities invocation JCL procs (DSNTIJMP)
s Add address space JCL procs for the DB2-supplied WLM environments (DSNTIJMW)
s Add environment files for the DB2-supplied Java WLM environment (DSNTIJMJ)
s Define the ICF catalog and alias (DSNTIJCA)
s Define system data sets (DSNTIJIN)
s Define the DB2 subsystem parameter module (DSNTIJUZ)
s Define the DB2 application defaults module (DSNTIJUA)
s Define the DB2 offline message CCSIDs module (DSNTIJUM)
s Update DDF related information in the BSDS (DSNTIJUL)
s Initialize system data sets - 1 (DSNTIJID)
s Initialize system data sets - 2 (DSNTIJIE)
s Initialize system data sets - 3 (DSNTIJIF)
Define user authorization exit routines (DSNTIJEX)
Connect DB2 to TSO (DSNTIJVC)
PRESS: ENTER to continue RETURN to exit HELP for more information
DSNTIPMJ REVIEW STEPS IN Z/OSMF INSTALLATION WORKFLOW DEFINITION (PANEL 2)
===>
Select the steps which should be included in the workflow definition:
s Start the DB2 subsystem (DSNTIJSA)
s Tailor the DB2 catalog (DSNTIJTC)
S Activate a DB2 function level (DSNTIJAF)
s Create default storage group, define temporary work files, and
bind DB2 REXX Language Support (DSNTIJTM)
s Define and bind DB2 objects (DSNTIJSG)
s Setting up the DB2 core WLM environments during migration (DSNTIJRW)
s Installing DB2-supplied routines during migration (DSNTIJRT)
s Validate the installation of DB2-supplied routines (DSNTIJRV)
Back up the DB2 directory and catalog (DSNTIJIC)
PRESS: ENTER to continue RETURN to exit HELP for more information
For more information about the steps, see Installing Db2 12.
DSNTIPMI is shown only
when you specify the following values on panel DSNTILA1:
- USE Z/OSMF WORKFLOW ===> YES
- INSTALL TYPE ===> INSTALL
- DATA SHARING ===> NO, or DATA SHARING ===> YES with option 1 selected in the DSNTIP0A window.
DSNTIWIA and DSNTIVIA: add a new data sharing member
The DSNTIWIA sample workflow definition file adds new members to a data sharing group. It uses the DSNTIVIA input variable file.
Panel DSNTIPMA shows the steps of the DSNTIWIA workflow.
DSNTIPMA REVIEW STEPS IN Z/OSMF INSTALLATION WORKFLOW DEFINITION
===>
Select the steps which should be included in the workflow definition:
Define DB2 to z/OS (DSNTIJMV)
Add DB2 address space startup JCL procedures (DSNTIJMA)
s Define system data sets (DSNTIJIN)
s Define the DB2 subsystem parameter module (DSNTIJUZ)
s Update DDF related information in the BSDS (DSNTIJUL)
s Initialize system data sets (DSNTIJID/DSNTIJIE/DSNTIJIF)
Define user authorization exit routines (DSNTIJEX)
s Start the DB2 subsystem (DSNTIJSA)
s Create default storage group, define temporary work files, and
bind DB2 REXX Language Support (DSNTIJTM)
S Back up the DB2 directory and catalog (DSNTIJIC)
PRESS: ENTER to continue RETURN to exit HELP for more information
For more information about the steps, see Adding a new data sharing member. The workflow supports only steps that are shown in the panel.
DSNTIPMA is shown only when you specify the following values on panel DSNTILA1:- USE Z/OSMF WORKFLOW ===> YES
- INSTALL TYPE ===> INSTALL
- DATA SHARING ===> YES with option 2 selected in the DSNTIP0A window.