Prerequisites to set up a DB2 database on a z/OS system

Ensure that IBM® DB2® Version 10.1 for z/OS® with the Universal JDBC driver is installed and running on the z/OS system that is used as the database server. You must use a DB2 mode that supports the new functions introduced in version 10.1. These prerequisites are required if the server is on z/OS or is on another operating system and connecting to DB2 for z/OS.

Prerequisites

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.

Feedback