On z/OS, the Workload Manager (WLM) procedures associated with theDB2 stored procedures SYSPROC.DSNUTILS and SYSIBM.SQLxxx must be active. DB2 WLM-managed stored procedures also require z/OS Resource Recovery Services (RRS) to be active. If necessary, verify that the stored procedures are active by comparing the names of the DB2 WLM environment variables with the active WLM procedures. Use the SQL SELECT command to retrieve the WLM procedure names through DB2 SPUFI or your preferred technique:
SELECT DISTINCT WLM_ENVIRONMENT FROM SYSIBM.SYSROUTINES WHERE
(NAME='DSNUTILS' OR (SCHEMA='SYSIBM' AND NAME LIKE 'SQL%'));
This
command produces results similar to the following example:---------+---------+---------+---------+---------+---------+---
WLM_ENVIRONMENT
---------+---------+---------+---------+---------+---------+---
DSN9WLM1
Use the following command from the z/OS console to display the WLM active procedures: D
WLM,APPLENV=*. This command produces results similar to
the following example: SDSF SYSLOG 2493.101 2094 2094 07/10/2008 0W 14886 COMMAND ISSUED
RESPONSE=RALNS32
IWM029I 16.31.12 WLM DISPLAY 465
APPLICATION ENVIRONMENT NAME STATE STATE DATA
BBOASR1 AVAILABLE
BBOASR2 AVAILABLE
BBOC001 AVAILABLE
CBINTFRP AVAILABLE
CBNAMING AVAILABLE
CBSYSMGT AVAILABLE
DSN9WLM1 AVAILABLE
DSN9WLM2 AVAILABLE
DSN9WLM3 AVAILABLE
In this
case, you can see that the DSN9WLM1 procedure is active.