Customization and implementation of Z License Verification

Before you use ZLV, there are some customization and implementation steps that must be run.

Select an existing IZSAM V8.2 repository to implement ZLV. If you have multiple repositories running on the same Db2® subsystem, you need to only implement ZLV in one repository.
Table 1. List of supplied members in z/OS
Member name Description Target Dataset

ZLVLICPM

 Job to create tablespaces, tables, and indexes JCLLIB

ZLVLICRE

Job to create License Key dataset

 JCLLIB

ZLVLICI

 License Import job JCLLIB

ZLVLICV

 License Verify job JCLLIB

ZLVLIC20

DDLs to drop/create tablespaces - VLICENSE and VLICENTL

 PARMLIB

ZLVLIC21

DDLs to create tables/indexes - TLICENSE and LICENSE_VERIFY

 PARMLIB

ZLVLIC22

Unload statements for TLICENSE and LICENSE_VERIFY tables

 PARMLIB

ZLVLIC23

Load statements for TLICENSE and LICENSE_VERIFY tables

 PARMLIB

  1. Copy the 4 members – ZLVLICPM, ZLVLICRE, ZLVLICI, and ZLVLICV, to the JCLLIB dataset where you intend to implement ZLV.

  2. Edit and update members ZLVLICPM, ZLVLICRE, ZLVLICI, and ZLVLICV in the JCLLIB dataset.

  3. Concatenate the ZLV load library, zlv.SZLVMOD1, to the //STEPLIB DD statement of the JCLLIB member, HSIJSQLE.

  4. Copy the 4 members – ZLVLIC20, ZLVLIC21, ZLVLIC22, and ZLVLIC23, to the PARMLIB dataset where you intend to implement ZLV.

  5. Edit and update members ZLVIC20 and ZLVLIC21. Member ZLVLIC20 contains definitions of the tablespaces and ZLVLIC21 contains definitions of the tables and indexes. Db2® parameters that are defined in these members must be replaced with the same Db2® parameter values that are used in an existing IZSAM V8.2 repository, where ZLV is to be implemented.

    Members ZLVLIC20 and ZLVLIC21 are to be edited and updated before running the batch jobs.

    Members ZLVLIC22 and ZLVLIC23 are to be edited and updated for 'Post Implementation'.

    &DB
    Name of the Db2® database
    &REPZSCHM
    Name of the repository
    &SGHSITAB
    Storage Group for tablespaces
    &SGHSIIDX
    Storage Group for indexes
    &BPTS
    Buffer pool for tablespaces
    &BPIX
    Buffer pool for indexes
  6. To run these jobs, see ‘Running batch jobs from JCLLIB’.