Skip to content

Core ZMF Db2 Option, with ERO, Not Using Db2 to Host the Baseline I/A Table

New Install

  1. CMNDB2RM—This sample job creates the main ERO tables.

  2. CMNDB2RA—This sample job creates the ERO audit tables.

  3. CMNDB2RP—This sample job binds the ERO packages.

  4. CMNDB2RB—This sample job binds the ERO plans.

  5. CMNDB2RG—This sample job grants the relevant Db2 authorities for ERO.

  6. DB2CORE—This sample JCL binds the package and plan required for the core ZMF Db2 option support. It should be run instead of DB2OPTN or DB2OPTNR.

  7. Global Db2 general parms update for Core ZMF Db2 option—The ZMF subsystem must be started up and the global Db2 general parms updated to indicate that you want to use only core Db2 functions. This is located (via ISPF option A.G.O.2.G) on this panel:

    CMNGDPM0                    Global Db2 General Parameters
    Command ===>
    Enter "/" to select option
        / Use Core Db2 Option Functions Only
          Use Package Name in Db2 PC version
          Force Pkg Name in Db2 PC version
    

    This setting takes effect immediately.

Migration from a prior version of ZMF

  1. CIMALTR4—This sample job alters the ERO CIM table for migration from versions prior to ZMF v7.1.2.

  2. HSTALTR4—This sample job alters the ERO HST table for migration from versions prior to ZMF v7.1.2.

  3. CIMALTR5—This sample job alters the ERO CIM table for migration from versions prior to ZMF v8.1.2 (It must be run after CIMALTR4, if applicable.)

  4. CIMALTR6—This sample job alters the ERO CIM table for migration from versions prior to ZMF v8.2 patch 1. (It must be run after CIMALTR4 & CIMALTR5, if applicable.)

  5. HSTALTR5—This sample job alters the ERO HST table for migration from versions prior to ZMF v8.2 patch 1. (It must be run after HSTALTR4, if applicable.)

  6. DB2CORE—This sample JCL binds the package and plan required for the core ZMF Db2 option support. It should be run instead of DB2OPTN.

  7. Global Db2 general parms update for Core ZMF Db2 option—The ZMF subsystem must be started up and the global Db2 general parms updated to indicate that you wish to use only core Db2 functions. This is located (via ISPF option A.G.O.2.G) on this panel:

    CMNGDPM0                    Global Db2 General Parameters
    Command ===>
    Enter "/" to select option
        / Use Core Db2 Option Functions Only
          Use Package Name in Db2 PC version
          Force Pkg Name in Db2 PC version
    
    This setting takes effect immediately.

After you are satisfied with the core Db2 option functionality, you can drop the now redundant Db2 option admin tables and free the relevant packages using sample job DB2DRPNC.