This chapter summarizes all the steps needed and provides methods to check the connection and error detection.

1. Firstly, let's recap the step-by-step procedures:

   db2icrt -a server -u db2art db2art
   db2 catalog tcpip node wasa-host remote wasa server 4001
   db2 catalog dcs database db2wasa as qwa1
   db2 catalog database db2wasa at node wasa-host authentication dcs
   db2 update dbm cfg using SVCENAME db2c_db2art
   db2set DB2COMM=tcpip
   db2set DB2AUTOSTART=yes
   db2stop & db2start

2. And then, let's check whether the connection is reachable:

   export DB2INSTANCE=db2art
   export DB2BASE=db2wasa
   db2 connect to $DB2BASE user user-name using password

3. And check the output, if the screen shows some database connection information as below, it means you are able to access the database residing on mainframe, and you can create table or insert data as you required. If screen shows some errors with error code, maybe there are some failures there. Please find the most common errors and its correction in the APPENDIX.

   Database Connection Information
   Database server= DB2 OS/390 9.1.5
   SQL authorization ID= BEAUSR1
   Local database alias= DB2QWA1

4. Finally, let's configure the Tuxedo application and start it up.

   export TUXDIR=/home/db2art/tuxedo11gR1
   export DB2INSTANCE=db2art
   export DB2DIR=/opt/ibm/db2_connect/V9.1
   db2 update dbm cfg using tp_mon_name TUXEDO
   db2 update dbm cfg using spm_name bjaix
   db2 update dbm cfg using max_connections 500 AUTOMATIC
   db2 update dbm cfg using max_coordagents 200 AUTOMATIC
   db2stop & db2start 
   Add "UDB_XA:db2xa_switch_std:-L${DB2DIR}/lib -ldb2" into
   $TUXDIR/udataobj/RM
   ${TUXDIR}/bin/buildtms -r UDB_XA -o ${TUXDIR}/bin/TMS_UDB
   ${TUXDIR}/bin/buildserver -r UDB_XA -f svcfile.o -s SVC1,SVC2 -o
   UDBserver
   Configure OPENINFO in ubbconfig:
   OPENINFO="UDB_XA:db=sample,uid=username,pwd=password,tpm=tuxedo"
   tmboot -y