B
Sample Files

This appendix contains sample files of gateway initialization and Oracle Net tnsnames.ora and listener.ora file.

This appendix includes the following sections:

• Sample Gateway Initialization File

• Sample Startup Shell Script

• Sample Oracle Net tnsnames.ora File

• Sample Oracle Net listener.ora File

Sample Gateway Initialization File

The following sample Gateway Initialization File (initdrdahoa1.ora) needs customization.  For information on customizing this file, refer to "Configuring the RS/6000 Host" in Chapter 8, "Configuring the Gateway".  Also refer to Appendix C.

#
# HS specific parameters
#
#TRACE_LEVEL=255
#LOG_DESTINATION=DB2.log
#ORACLE_DRDA_TCTL=debug.tctl
HS_COMMIT_POINT_STRENGTH=255
HS_NLS_DATE_FORMAT=YYYY-MM-DD
HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P1
HS_RPC_FETCH_REBLOCKING=off
HS_RPC_FETCH_SIZE=32767
HS_FDS_FETCH_ROWS=20
#
# DRDA specific parameters
#
DRDA_CONNECT_PARM=DRDACON1
DRDA_REMOTE_DB_NAME=DB2V2R3
DRDA_PACKAGE_COLLID=ORACLE
DRDA_PACKAGE_NAME=G2DRSQL
DRDA_PACKAGE_CONSTOKEN=A92617CB3FE54701
DRDA_RECOVERY_USERID=ORADRDA 
DRDA_RECOVERY_PASSWORD=ORADRDA
DRDA_ISOLATION_LEVEL=CS
#DRDA_PACKAGE_OWNER=ORADRDA
#DRDA_DISABLE_CALL=TRUE  

Sample Startup Shell Script

The following is a sample Startup Shell Script (initdrdahoa1.sh).  Refer to "Configuring the RS/6000 Host" to determine if there is a need to customize the script.  Also refer to the Startup Shell Script parameters in Appendix C for specific information about customizing them.

#!/bin/sh
#
# Oracle Transparent Gateway for IBM DRDA driver
#
FDS_CLASS='TG4DRDA_DB2MVS';export FDS_CLASS
PATH="$ORACLE_HOME/tg4drda/admin":$PATH; export PATH
exec $ORACLE_HOME/bin/g4drsrv $*

Sample Oracle Net tnsnames.ora File

For information on tailoring your tnsnames.ora file for the gateway, refer to the instructions for "Configuring Oracle Net".

ipc-ora9=(DESCRIPTION=
             (ADDRESS=
                 (PROTOCOL=IPC)
                 (KEY=ORAIPC)
 
             )
             (CONNECT_DATA=(SID=ORA901))

          )
   ipc-gtw=(DESCRIPTION=
              (ADDRESS=
                  (PROTOCOL=IPC)
                  (KEY=ORAIPC)

               )
              (CONNECT_DATA=(SID=drdahoa1))
              (HS=)
          )

Sample Oracle Net listener.ora File

For information on tailoring your listener.ora file for the gateway, refer to the instructions for "Configuring Oracle Net".

#
# Sample listener.ora file for the Transparent Gateway for IBM DRDA
# Version Date: Jan-01-1998
# Filename: Listener.ora
# 
LISTENER =
  (ADDRESS_LIST =
        (ADDRESS= 
        (PROTOCOL= IPC)
        (KEY= ORAIPC))
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC=
      (SID_NAME=drdahoa1)
      (ORACLE_HOME=/oracle/tg4drda/9.0.1)
      (PROGRAM=drdahoa1.sh)
    )
  )

STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF

This sample listener.ora file resides in the $ORACLE_HOME/network/admin directory.  If your listener uses the Oracle Net TCP/IP adapter instead of the IPC adapter, then replace these lines under the LISTENER keyword:

        (ADDRESS=
           (PROTOCOL=IPC)
           (KEY=ORAIPC)
         )
with
        (ADDRESS=
           (PROTOCOL=TCP)
           (HOST=your_IP_node_name)
           (PORT=your_port_number)
        )