Skip to content

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

New Install

Run the following jobs.

  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. DB2OPTN/R—This sample job creates the full function ZMF Db2 option admin tables, binds the related packages, and binds the plan for full function ZMF Db2 option support. DB2OPTNR is for P-sites, and DB2OPTN is for all other types of sites.

Migration from a prior version of ZMF

You most likely already have the ZMF Db2 option tables in place (depending on which release of ZMF they are coming from).

  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. (This 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. (This must be run after HSTALTR4, if applicable).

  6. DB2OPTN/R—This sample job creates the full function ZMF Db2 option admin tables, binds the related packages, and binds the plan for full function ZMF Db2 option support. DB2OPTNR is for P-sites, and DB2OPTN for all other types of sites. If you already have the tables in place, remove the TABLES step from the job (i.e., do not drop/create your tables).

  7. DB2ADMGT —This sample JCL shows how to reformat an existing CMNADMIN_GENERAL table to support ZMF versions 8.2.0 and greater. You don’t need to run it unless you are migrating from a version earlier than 8.2.0.

  8. DB2ALTER—This sample JCL shows how to add the columns to an existing CMNADMIN_NAMED table to support ZMF versions 8.2 patch 4 and greater. You don’t need to run it unless you are migrating from a version earlier than 8.2 patch 4.