Skip to content

Using Db2 to replace the impact analysis LDS

The default mechanism for hosting the baseline Impact Analysis (I/A) table is via an LDS backed dataspace. It is, however, possible to use a Db2 table to host this information. If you are migrating from a prior release, please see the Changeman ZMF Migration guide for details.

This appendix describes how to configure a Db2 table for the I/A data when performing a new installation of ZMF.

It assumes that you have already performed the steps required to install ZMF in general.

Note

You do not need a ZMF Db2 option license to do this.

  1. Tailor and run CMNDB2IA.JCS. This will create the baseline I/A tables CMNIABUN, CMNIACMP, and CMNIARLN. It will also bind the required packages and plan.

  2. Start up the ZMF stc for the first time, it will generate messages about missing ddnames and it will attempt to start the dataspace subtask IADS, for example: 

     2020/10/28 05:33:26.34 19A08000 CMN8800I CMNSTART Opened VSAM file CMNDEV.CMNSYS.U900STEV.CMNPMAST Exclusive
 2020/10/28 05:33:26.41 19A08000 CMN8800I CMNSTART Opened VSAM file CMNDEV.CMNSYS.U900STEV.CMNLOG Exclusive
 2020/10/28 05:33:26.52 19A08000 CMN8800I CMNSTART Opened VSAM file CMNDEV.CMNSYS.U900STEV.CMNRECV Exclusive
 2020/10/28 05:33:26.54 19A08000 CMN8350I CMNSTART *** Warning *** Missing DD Name = CMNIMPCT
 2020/10/28 05:33:26.54 19A08000 CMN8350I CMNSTART *** Warning *** Missing DD Name = CMNIALOG
 2020/10/28 05:33:26.59 19A08000 CMN8800I CMNSTART Opened VSAM file CMNDEV.CMNSYS.U900STEV.CMNCMPNT Exclusive
 2020/10/28 05:33:26.66 19A08000 CMN8800I CMNSTART Opened VSAM file CMNDEV.CMNSYS.U900STEV.CMNCMPNL Exclusive
 2020/10/28 05:33:26.66 19A08000 CMN8300I CMNSTART Attach: U=CMNSTART,F1=ATTACH,F2=IADS,@TCA=1A9F2000,@TCB=8A78D0

  3. Connect to ZMF and use global admin to set the Db2 for I/A option and indicate the Db2 subsystem which owns the tables. This is the third panel of the global admin parms, viz:

    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: D20L
  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

  4. Restart ZMF and you should see the following in SERPRINT during initialization.

    2020/10/28 09:40:29.94 19A08000 CMN8560I CMNSTART Default Db2 subsystem is D20L and is at version: V12R1
2020/10/28 09:40:30.02 19A08000 CMN8561I CMNSTART The baseline Impact Analysis database is hosted by the default
Db2 subsystem.

  5. Define application admin as you see fit and then run CMNIA000 using a form of the sample JCS member IMPACTD2 modified to meet your requirements. It will generate the 3 I/A data flat files.

  6. Load the flat files to the Db2 tables using a form of the CMNDB2IL.JCS sample component modified to meet your requirements. Note that Db2 ensures integrity while the load is taking place so there is no need to do anything within the ZMF stc (there is no IADS subtask when we are using Db2). The I/A information will be available once the tables have been loaded and any 'pending' states have been resolved (e.g. by performing an image copy, or simply resetting the pending states).