Creating a test Repository database in Db2®

Creating the IBM Z Software Asset Management 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 HSISDB01 job to create the storage groups.
  2. Run the HSISDB02 job to create the database objects for the Global Knowledge Base (GKB).
  3. Run the HSISDB03 job to create the Repository database and database objects.
  4. Run the HSISDB04 job to create the Notifications database and database objects.
    Note: Before running this job, review the comments in the job. In member HSISSQ18 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.
  5. Run the HSISGKBL job to load the GKB.
  6. Run the HSISGRNT job to grant DBADMIN access to the IBM Z Software Asset Management administrator to the Repository and the GKB databases.