Connecting to a database on z/OS

Complete these tasks to connect to your databases on z/OS®.

1. Obtain the following IBM DB2® values for the IBM Db2 subsystem that you want to connect your integration node to.
   Use these values to customize the BIPEDIT, BIPDSNAO, and BIPBRKP files.

   JCL variable	Description	Example value
   ++DB2CONVERSION++	The IBM Db2 converter	SINGLE
   ++DB2SUBSYSTEM++	The IBM Db2 subsystem ID which the component connects	DFK4
   ++DB2LOCATION++	The IBM Db2 location value of the IBM Db2 subsystem to which the component connects	DSN910PK
   ++DB2CURRENTSQLID++	The default IBM Db2 user ID for connecting	MQP1BRK
   ++DB2DSNACLIPLAN++	The IBM Db2 plan name.	DSNACLI
   ++DB2HLQ++	The IBM Db2 high-level-qualifier	SYS2.DB2.V910
   ++DB2RUNLIB++	The IBM Db2 run library value	DSN910PK.RUNLIB.LOAD

2. Copy the supplied sample BIPDSNAO file into the component data set, and customize its content based on the values obtained in step 1.
   The stanza for your database will look like the following content:

   [COMMON]
   APPLTRACE=0
   APPLTRACEfilename="DD:APPLTRC" 
   TRACETIMESTAMP=3
   CONNECTTYPE=2
   DIAGTRACE=0
   DIAGTRACE_NO_WRAP=0
   MAXCONN=0
   MULTICONTEXT=0
   MVSDEFAULTSSID=DFK4
   
   ; SUBSYSTEM
   [DFK4]
   MVSATTACHTYPE=RRSAF
   PLANNAME=DSNACLI
   
   ; DATASOURCES
   [DSN910PK]
   CURRENTSQLID=MQP1BRK

3. Update the integration node profile BIPBPROF in the component data set.
   1. Check that the environment variable DSNAOINI points to your copy of the BIPDSNAO file in the component data set. By default, it is set to the correct value; update this variable if you use a different name.
   2. Check that the environment variable MQSI_DB2_CONVERSION is set correctly.
4. Submit BIPGEN to re-create the integration node ENVFILE and any integration server specific profiles.
5. Update the EGENV and EGNOENV steps in the integration node started task JCL to include the following IBM Db2 data sets:

   //STEPLIB DD DISP=SHR,DSN=&DB2HLQ..SDSNEXIT
   //        DD DISP=SHR,DSN=&DB2HLQ..SDSNLOAD
   //        DD DISP=SHR,DSN=&DB2HLQ..SDSNLOD2
   //        DD DISP=SHR,DSN=++DB2RUNLIB++

   Check that the PROC variable DB2HLQ='++DB2HLQ++' is not commented out.
6. Start the integration node by using the start (/S) command.