Skip to content

No ZMF Db2 Option License but Using Db2 to Host the Baseline I/A Table

New Install

Note that the following steps 1,2, and 3 are part of the base ZMF install process. You can save time by following these instructions during that part of your install. However, you can also execute the "Follow-on step:" on page 61 at some later time if you didn't follow steps 1,2,3 during the base product installation.

  1. INITIAL1—This sample JCL member is customized and runs as part of the creation of the vsam master files, which support a new installation of ZMF. For this task, you should remove the step which allocates the I/A dataspace LDS (stepname IADSP) prior to running INITIAL1.

  2. INITIAL2—This is the job run after INITIAL1. For this task, you need to remove the step which initializes the I/A dataspace LDS (stepname CMNIAIN) prior to running INITIAL2.

  3. STARTJCL—This sample member forms the basis for your ZMF started task procedure. For this task, you need to edit your ZMF proc to remove the CMNIALOG and CMNIMPCT ddnames prior to attempting to start the ZMF stc for the first time.

  4. CMNDB2IA—This sample JCL member creates the Db2 tables, binds the packages, and binds the plan to enable the baseline I/A table to be hosted by Db2.

  5. Global parms update for Db2 for I/A—The ZMF subsystem must be started up and the global parms updated to indicate that you wish to use Db2 for baseline I/A. The global parm for this is located (via ISPF option A.G.1) on this panel:

    CMNGGP03                Global Parameters - Part 3 of 8
Command ===>
Enter "/" to select option
       Baselines
       / Stacked Reverse Delta
       / Panvalet
       User defined
       / Librarian
       Librarian Access Method (LAM)
       Notification Vehicles
       / Email
       / Batch
       Other options
       / Use primary Db2 subsystem for I/A: D10L
       Require CR number
       Require Department
       / Disable installation calendar
       / Allow temporary packages
       / Process participating packages by install date
       / Hierarchical approval process
       / Use global notification file
       / Allow application update to file
       Force display of global notification file
Global notification file . . CMNDEV.CMNSYS.U900DP.GNFFILE

    This setting takes effect only after a restart of the ZMF started task.

  6. IMPACTD2—This job runs the mass data extraction process for an installation where Db2 has been used for the I/A database. It produces the usual three flat files (i.e. BUNSPACE, CMPSPACE, and RELSPACE).

  7. CMNDB2IL—This job loads the I/A data from the three flat files into the set of Db2 tables that are hosting the I/A database.

  8. You should take your usual measures to ensure the best access paths are chosen by Db2 for this new data. This would usually include using the RUNSTATS utility, with the INDEX clause, to update the stats for the tablespaces involved (i.e. those created when you ran CMNDB2IA) and then rebinding the packages involved (those you originally bound using sample JCL member CMNDB2IA). As with any collection of Db2 table data, using the RUNSTATS/rebind mechanism is something you should do on a regular basis.

Follow-on step:

If you didn't follow the instructions in steps 1, 2, and 3 during the initial product install, you can now delete the redundant I/A LDS and log dataset and remove references to them from your ZMF stc procedure.

Migration from a prior version of ZMF

If you’re migrating from a prior version of ZMF, you most likely have the I/A dataspace in place and will be making a conscious decision to convert to using Db2. We recommend moving to Db2 some time after you have successfully migrated to this latest release of ZMF. However, if you must do this at the same time, perform the following steps:

  1. STARTJCL—This sample member forms the basis for your ZMF started task procedure. For this task, you need to edit your ZMF proc to remove the CMNIALOG and CMNIMPCT ddnames prior to attempting to start the migrated ZMF stc for the first time.

  2. CMNDB2IA—This sample JCL member creates the Db2 tables, binds the packages, and binds the plan to enable the baseline I/A table to be hosted by Db2.

  3. LDSUNLD or IMPACTD2—LDSUNLD is a sample job that unloads your existing I/A dataspace to flat files. IMPACTD2 creates these flat files by running the batch data extract (CMNIA000). Choose one of these in order to create the flat files to be used to load the new Db2 database. Run IMPACTD2 only if you have made application admin changes (e.g. new appls, new baselines) as part of the conversion (this is not recommended). Either job produces the usual three flat files (i.e. BUNSPACE, CMPSPACE, and RELSPACE).

  4. CMNDB2IL—This job loads the I/A data from the three flat files into the set of Db2 tables which are hosting the I/A database.

  5. You should take your usual measures to ensure the best access paths are chosen by Db2 for this new data. This would usually include using the RUNSTATS utility, with the INDEX clause, to update the stats for the tablespaces involved (i.e. those created when you ran CMNDB2IA) and then rebinding the packages involved (those you originally bound using sample JCL member CMNDB2IA). As with any collection of Db2 table data, using the RUNSTATS/rebind mechanism is something you should do on a regular basis.

  6. Global parms update for Db2 for I/A—The ZMF subsystem must be started up and the global parms updated to indicate that you want to use Db2 for baseline I/A. The global parm for this is located (via ISPF option A.G.1) on this panel:

    CMNGGP03                Global Parameters - Part 3 of 8
Command ===>
Enter "/" to select option
    Baselines
    / Stacked Reverse Delta
    / Panvalet
      User defined
    / Librarian
      Librarian Access Method (LAM)
    Notification Vehicles
    / Email
    / Batch
    Other options
    / Use primary Db2 subsystem for I/A: D10L
      Require CR number
      Require Department
    / Disable installation calendar
    / Allow temporary packages
    / Process participating packages by install date
    / Hierarchical approval process
    / Use global notification file
    / Allow application update to file
      Force display of global notification file
Global notification file . . CMNDEV.CMNSYS.U900DP.GNFFILE

    This setting is in effect only after a restart of the ZMF started task.

    After you are satisfied that all is well, you can delete the now redundant I/A LDS and log dataset.