Creating a test Repository database in Db2®

Creating the HCL Z Asset Optimizer database includes setting up storage groups, the database name, and the administrator logon details. You also create the Global Knowledge Base (GKB) environment and then grant access to the database.

Procedure

  1. Run the HZASDB01 job to create the storage groups.
  2. Run the HZASDB02 job to create the database objects for the Global Knowledge Base (GKB).
  3. Run the HZASDB03 job to create the Repository database and database objects.
    Note: Before running this job, review the comments in the job. In member HZASSQ18 of the PARMLIB library, the COMPRESS keyword is set for all indexes. Bufferpool BP8K0 must first be activated in Db2® before these compressed indexes can be created. Rename and activate different Bufferpool names according to site requirements.
  4. Run the HZASGKBL job to load the GKB.
  5. Run the HZASGRNT job to grant DBADMIN access to the Z Asset Optimizer administrator to the Repository and the GKB databases.