Preparing Db2® database prerequisites

The Db2® environment for the test z/OS® installation has prerequisites that you must configure.

Before you begin

Db2® database administrator and Z Asset Optimizer administrator privileges are required to perform this task.

Db2® for z/OS® must be installed. See Installation prerequisites. Db2® must have access to a minimum of 1600 cylinders of 3390 DASD space.

All Db2® table spaces defined in Z Asset Optimizer are partition-by-growth universal table spaces (UTS). UTS is a combination of partitioned and segmented table space schemes. Non-UTS table space types are deprecated.

Procedure

  1. Run the DSNTIJCL job from Db2® SDSNSAMP to bind the DSNACLI plan and enable the Call Library Interface (CLI/ODBC) Db2® plan.

    If you encounter a SQL error, code -805, rebind this plan with the latest Db2® maintenance package and include the following package in the job:

    BIND PACKAGE (DSNAOCLI) MEMBER(DSNCLIMS) - CURRENTDATA(YES) ENCODING(EBCDIC) SQLERROR(CONTINUE)
  2. Run the DSNTIJTM job from Db2® SDSNSAMP to bind the DSNREXX plan and enable the REXX Db2® plan.