UDB Linking

Installation Time UDB Linking

The file makefile_intg is provided as an example to help you generate a runtime linked with UDB, you can adapt it for other uses (partial linking with UDB, linking with DB2 connect, etc.).

CICS Runtime servers can be linked with an Oracle database or a UDB (LUW) database using a makefile named makefile_intg. This makefile detects the database that you are using thru the following environment variables: DB2DIR or ORACLE_HOME.

•	If DB2DIR exists, the makefile links the servers with UDB libraries instead of the Oracle libraries, binds or rebinds the impacted servers and builds the TMS_UDB.

•	Remark1 for ARTTSQ: ARTTSQ server uses a specific module for UDB or Oracle access, so in the makefile there is not only the database library changes, but also the linking of kix_tsrecov_UDB or kix_tsrecov_Oracle to build the ARTTSQ server.

•	Remark 2 for ARTTSQ, if you have recoverable TS Queues, and are using UDB then you need to create the TS queue table for UDB. This should be done by using the script crtstable_UDB instead of the script crtstable_Oracle

•	If ORACLE_HOME exists, the makefile links or relinks the servers with Oracle libraries and builds the TMS_ORA.

•	If both variables (DB2DIR and ORACLE_HOME) exist or neither of these variables exist, the makefile stops and publishes a clear error message.

You can also change the DATABASE variable in the makefile_intg file to force the UDB or Oracle linking, as shown in the following example:

Listing A‑1 Setting the Database Variable

#DATABASE=$(DATABASE_U)$(DATABASE_O)

DATABASE=UDB

 

Rebuilding Servers for UDB

The servers delivered are built to be used with Oracle, to rebuild these servers for UDB:

1.	Check that the DB2DIR variable is set .

2.	Check that the ORACLE_HOME variable is not set (or change the makefile).

3.	Open the tools directory.

4.	Run make -f makefile_intg all

Note:

For UDB linking, make sure that you have the following line in the Tuxedo RM file:

UDB_XA:db2xa_switch_std:-L${DB2DIR}/lib64 -ldb2