DB2 prerequisites for z/OS

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.

Feedback