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
-
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)
- Run the DSNTIJTM job from Db2® SDSNSAMP to bind the DSNREXX plan and enable the REXX Db2® plan.