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 13
The DSNTIWMS workflow migrates a non-data sharing Db2 subsystem, or the first Db2 member of a data sharing group, to Db2 13. 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
S Take image copies of the directory and catalog (DSNTIJIB)2
S Make Db2 CLISTs available to TSO and batch users (DSNTIJVC)
s Stop Db2 12 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)
s Convert BSDS records to support 1000 logs (DSNTIJCU)
Define Db2 13 to z/OS (DSNTIJMV)
Add Db2 13 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.
- DSNTIJIB is tailored based on DSNTIJIC, using the Db2 12 SDSNLOAD library.
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 13 (DSNTIJSA)
s Tailor Db2 13 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 a Db2 for z/OS subsystem to Db2 13 at function level 100.
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 13
The DSNTIWMD workflow migrates subsequent members of a Db2 data sharing group to Db2 13. 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:
s Stop Db2 12 activity (DSNTIJSO)
s Convert BSDS records to support 1000 logs (DSNTIJCU)
s Define the Db2 subsystem parameter module (DSNTIJUZ)
Add Db2 13 address space startup JCL procedures (DSNTIJMA)
s Start Db2 13 (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 13. 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 13 function level 500 or higher
The DSNTIWMN sample workflow activates Db2 13 new function in the Db2 subsystem. It uses the DSNTIVMN input variable file.Panel DSNTIPMN shows the steps of the DSNTIWMN workflow.
The panel options differ depending on the function level that you are activating. The following configuration is used for activating function level 500.
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 V13R1M500 (DSNTIJA0)
s Tailor the Db2 catalog (DSNTIJTC)
s Activate a Db2 function level (DSNTIJAF)
Ensure that new catalog indexes have no problems (DSNTIJX2)
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 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 The following configuration is used for activating function level 501.
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)
s Activate Db2 function level V13R1M500 (DSNTIJA0)
s Tailor the Db2 catalog (DSNTIJTC)
s Activate a Db2 function level (DSNTIJAF)
S Ensure that new catalog indexes have no problems (DSNTIJX2)
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 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 a Db2 for z/OS subsystem to Db2 13 at function level 100 , beginning with Migration step 23: Take an image copy of the Db2 13 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 13 function level
The DSNTIWAF workflow activates a specified Db2 13 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)
Ensure that new catalog indexes have no problems (DSNTIJX2)
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 
If the current function level is V13R1M501 or higher, the following step cannot be selected in panel DSNTIPMF:Ensure that new catalog indexes have no problems (DSNTIJX2)Otherwise, it can be selected.
For more information about the steps, see Activating Db2 13 function level 500 or higher
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 13
The DSNTIWIN sample workflow definition file installs a new Db2 13 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)
s Stop the Db2 subsystem (DSNTIJSO)
s Initialize active logs 94 - n (DSNTIJL1 - DSNTIJLx)
s Start the Db2 subsystem (DSNTIJSA)
PRESS: ENTER to continue RETURN to exit HELP for more information _ Tailor the Db2 catalog (DSNTIJTC)
_ Activate a Db2 function level (DSNTIJAF)For installing Db2 13 at function level 502 or higher, they are force selected.
For more information about the steps, see Installing Db2 13.
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)
s Stop the Db2 subsystem (DSNTIJSO)
s Initialize active logs 94 - n (DSNTIJL1 - DSNTIJLx)
s Start the Db2 subsystem (DSNTIJSA)
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.