B Sample Files

B.1 Sample Gateway Initialization File

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

#
# HS specific parameters
#
FDS_CLASS=TG4DRDA_DB2MVS
#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=DB2V7R1
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  

B.2 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-ora=(DESCRIPTION=
             (ADDRESS=
                 (PROTOCOL=IPC)
                 (KEY=ORCL)
             )
             (CONNECT_DATA=(SID=ORA101))
            (HS=)
                                         )
ipc-gw=(DESCRIPTION=
           (ADDRESS=
               (PROTOCOL=IPC)
               (KEY=ORCL)
           )
           (CONNECT_DATA=(SID=drdahoa1))
                                     (HS=)
                                                                 

                                        )  

B.3 Sample Oracle Net listener.ora File

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

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

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC=
      (SID_NAME=drdahoa1)
      (ORACLE_HOME=C:\Oracle\GTWHome)
      (PROGRAM=g4drsrv)
    )
          )

STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF

This sample listener.ora 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=ORCL)
         )
with
        (ADDRESS=
           (PROTOCOL=TCP)
           (HOST=your_IP_node_name)
           (PORT=your_port_number)
        )