Attaching a Db2 for z/OS subsystem to IMS using RRSAF

To attach a Db2 for z/OS subsystem to IMS using RRSAF so that IMS JMP and JBP regions can access Db2 for z/OS databases, follow this procedure.

1. Create an IMS PROCLIB data set member for information about the Db2 for z/OS subsystem.
   The member name must follow the same naming conventions you follow when you attach Db2 for z/OS with ESAF.
2. In the IMS PROCLIB data set member, define the following three parameters for the Db2 for z/OS subsystem that JMP and JBP applications need access to:

   SST=DB2,SSN=db2name,COORD=RRS

   You can provide two different definitions for the same Db2 for z/OS system

   • An ESAF definition for non-Java regions
   • An RRSAF definition for Java™ regions
3. Add the followings paths to the Java class path. If you use the //STDENV DD statement, add the paths to the shell script that specifies the JVM settings. Otherwise, add the paths to the class path of the DFSJVMMS member, which is provided by IMS in a sample library.
   • Path to the .zip file of the Db2 for z/OS JDBC driver
   • Path to the .zip file and .zip file name of the Db2 for z/OS JDBC driver

   For example:

   -Djava.class.path=>
   /usr/lpp/db2/db2710/classes: >
   /usr/lpp/db2/db2710/classes/db2j2classes.zip

4. Add the path to the SO file of the Db2 for z/OS JDBC driver to the LIBPATH= environment variable. If you use the //STDENV DD statement, add the path to the LIBPATH= parameter in the shell script that specifies the JVM settings. Otherwise, add the path in the DFSJVMEV member, which is provided by IMS in a sample library.
   For example:

   LIBPATH=/usr/lpp/db2/db2710/lib

5. Add the following parameters to the IMS control region EXEC statement:

   SSM=nameRRS=Y

6. In the DFSJMP or DFSJBP procedure of the region that has access to Db2 for z/OS, add the DFSDB2AF DD statement to point to the Db2 for z/OS libraries, which must be APF-authorized.