Migrating from IBM Z Software Asset Management 8.3/8.3.1 to HCL Z Asset Optimizer 9.1 (optional)

If you wish to port data from IBM Z Software Asset Management 8.3/8.3.1 to HCL Z Asset Optimizer 9.1, you need to unload data from the 8.3/8.3.1 repository and reload the unloaded data into a new HCL Z Asset Optimizer 9.1 repository.

About this task

The HCL Z Asset Optimizer 9.1 repository can be either a Db2® database or an SQLite database. To perform the migration, run the following migration jobs:

Procedure

  1. HSISUN83– Run this job to unload the 8.3/8.3.1 repository. Ensure that all groups are unloaded, including group 3. To accomplish this, you need to comment the // NULL statement just before the //UNLOAD3 EXEC statement in order for jobsteps UNLOAD3, UNLOAD4, and UNLOAD5 to run. Otherwise, data from tables TJOBDATA, TMODULE, AND TUSEMTD will not be selected for unload.
  2. HZASCUST– Run this customization job to create a new set of JCLLIB/PARMLIB members for HCL Z Asset Optimizer. Before you decide where to define your 9.1 repository, read the comments in step 5, below.
  3. HZASDB01:
    1. Db2® - Run this job to create new storage groups.
    2. SQLite – Run this job to create a new zFS file.
  4. HZASDB02 – Run this job to create a new 9.1 GKB database.
  5. HSISDB03 – Run this job to create the new 9.1 repository database and database objects. LKB/LKU. database objects are also created in this job but note that LKB/LKU data are not unloaded in the 8.3/8.3.1 job, HSISUN83.
    1. Db2®:If the same Db2® subsystem is used by 8.3/8.3.1 repositories, you must define different database and schema names for the 9.1 Repository. Having identical database and schema names in the same Db2® system will result in Db2® errors.
    2. SQLite: You can use the same 8.3/8.3.1 database name and schema names for the 9.1 Repository, as long as the 9.1 Repository is defined in a different ZFS file system.
  6. HZASDB04 - Run this job to create the Notifications database and database objects. Upon successful completion of the job, proceed to the next job. A condition code of 0 is expected.
  7. HSISGKBL – Run this job to populate the GKB database. Always use the latest GKB version which can be found in the latest GKB PTF.
  8. HZASMI83– Run this job to load data into the newly created 9.1 Repository, using the input file generated from step 1.
  9. Verify the loaded V9.1 Repository:
    1. To verify that Group 3 data has been loaded, run the following SQL statements (replace REPZSCHM with the schema name of the V8.3.1 Repository). 
      SELECT COUNT(*) FROM REPZSCHM.TUSEMTD ;
SELECT COUNT(*) FROM REPZSCHM.TMODULE ;

      Expected result: The number of rows from these two tables must be identical to the number of rows unloaded from the V8.3/8.3.1 job, HSISUN83.

      Note:
      LKB/LKU data are not ported in this migration. LKB/LKU must be re-created in IBM Z Software Asset Management 9.1.

What to do next

After the successful completion of job HZASMS83, you must perform the following tasks to bring your V9.1 repository up to speed:
  1. HZASIQIM - Run IQ Imports with a setting of FULLREMATCH=Y for ALL LPARs that are defined in the repository. This will ensure that vendors and products are re-identified.

  2. //AGGR - Run at least one Aggregator jobstep (//AGGR) with a setting of COUNTUSAGEFULL=Y. This will ensure that vendors and products are populated with the latest information for the new V9.1 tables and columns.

    Jobstep //AGGR is included as part of job, HZASIQIM.

  3. Lastly, run other operational jobs such as: HZASZCAT, HZASUIMP, HZASUMON, HZASANLO (Analyzer), and so forth.