Ensure that DB2® Version
9.1 for z/OS® with the Universal
JDBC driver running on the z/OS system
that is used as the database server. This system might not be the
same system on which theJazz™ Team Server runs.
On System z®,
the
Jazz Team Server requires
the WLM procedures associated with the DB2 stored
procedures SYSPROC.DSNUTILS and SYSIBM.SQLxxx 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 like this example:
---------+---------+---------+---------+---------+---------+---
WLM_ENVIRONMENT
---------+---------+---------+---------+---------+---------+---
DSN9WLM1
Use the following command from the z/OS console to show the WLM active procedures:
D
WLM,APPLENV=*. This command produces results like the following:
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.