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 IBM Z Software Asset Management 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 IBM Z Software Asset Management 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.