Verify that Db2-supplied stored
procedures SYSPROC.ADMIN_INFO_SYSPARM, SYSPROC.DSNUTILU, and SYSPROC.ADMIN_COMMAND_Db2 are set to
run in Workload Manager (WLM) environments that are separate from the one used by the Data Gate stored procedures.
Before you begin
Important: If you have installed IBM® Db2® Analytics Accelerator
for use with the same Db2
for z/OS system, you have
already set up the required Db2-supplied
stored procedures, so that you can skip this task.
About this task
The Db2-supplied stored procedures
SYSPROC.ADMIN_INFO_SYSPARM, SYSPROC.DSNUTILU, and SYSPROC.ADMIN_COMMAND_Db2 must run in different
Workload Manager (WLM) environments that are separate from the one used by the Data Gate stored procedures. Verify that this and a few
other requirements are met by following the steps here.
Procedure
-
Verify that each Db2-supplied stored procedure,
SYSPROC.ADMIN_INFO_SYSPARM, SYSPROC.DSNUTILU and SYSPROC.ADMIN_COMMAND_DB2, runs in a different WLM
environment.
- Make sure that NUMTCB is set to 1 (
NUMTCB=1
) for the
SYSPROC.ADMIN_INFO_SYSPARM and SYSPROC.DSNUTILU WLM environments.
-
In the start-up JCL job for the WLM environment for SYSPROC.DSNUTILU, use the MNSPAS parameter.
Set the parameter to a value that matches the maximum number of table partitions that are to be
loaded in parallel. Set the value at least to 10, but to no more than 50.
Mind that the number of parallel load operations (simultaneous runs of the
SYSPROC.ACCEL_LOAD_TABLES stored procedure) and the maximum number of simultaneous unload operations
per stored procedure call (determined by the AQT_MAX_UNLOAD_PARALLEL
environment variable) influence the total number of
parallel DSNUTILU calls.
- Verify that all WLM environments include the following libraries in their STEPLIB
statements:
//STEPLIB DD DISP=SHR,DSN=<HLQDb2SSN>.SDSNEXIT
// DD DISP=SHR,DSN=<HLQBASE>.SDSNLOAD
// DD DISP=SHR,DSN=<HLQBASE>.SDSNLOD2