DB2 prerequisites

You must ensure that the DB2® Version 9.1 for z/OS® with the Universal JDBC driver is installed and running on the z/OS machine that is used as the database server. This might not be the same machine on which the Jazz™ Team Server runs.
The Jazz Team Server requires the WLM procedures associated with the DB2 stored procedures SYSPROC.DSNUTILS and SYSIBM.SQLxxx to be active. If necessary, this can be verified by comparing the names of the DB2 WLM environment variables with the active WLM procedures. The SQL SELECT command can be used 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 the following:
---------+---------+---------+---------+---------+---------+---
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 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.

Feedback

Did this help? You can provide feedback at Jazz.net (registration required): Comment in the forums or submit a bug