This appendix describes the parameters needed for a gateway featuring the TCP/IP for IMS Connect communication protocol. It also provides a sample output of the pg4tcpmap
tool. In addition, this appendix contains sample listener.ora
and tnsnames.ora
files for a gateway using TCP/IP. It contains the following sections:
The parameter file for the Oracle Database Gateway for APPC using TCP/IP for IMS Connect is located in the $ORACLE_HOME/dg4appc/admin
directory and is called init
sid.
ora
.
Note:
Theinit
sid.
ora
file contains both SNA and TCP/IP parameters. You will need to modify these files with the suitable parameters.The PGA parameters control the TCP/IP interface portion of the gateway. PGA parameters are specified using the SET
gateway initialization parameter. For example:
SET pga_parm=value
where:
pga_parm
is one of the PGA parameter names in the list that follows
value
is a character string with contents that depend on pga_parm
Table B-1 provides a list of PGA parameters and their descriptions.
Table B-1 PGA Parameters on Gateway Using TCP/IP for IMS Connect
Parameter | Description |
---|---|
where:
NOTE: This parameter will be used for the |
|
PGA transaction capability. The following are valid values:
|
|
TCP/IP conversation security option. This controls what security parameters are sent to the OLTP. The following are valid values:
The default is For further information on these options, refer to Chapter 12, "Security Requirements". Important: You must specify your RACF group name through the If you have already loaded the table |
|
The Oracle Net service name for the Oracle database in which the gateway receives its TCP/IP for IMS Connect information, such as host name and port number. This parameter can be from There is no default value. |
|
The Oracle password to be used by the gateway when connecting to the Oracle database specified by the There is no default value. |
|
The Oracle user ID to be used by the gateway when connecting to the Oracle database specified by the There is no default value. |
|
PGA trace level. This controls tracing output written to The default is NOTE: This parameter is used in the |
The following output illustrates the results from executing the pg4tcpmap
tool when running TCP/IP for IMS Connect on the gateway. Refer to Loading the PGA_TCP_IMSC Table of this guide and to Chapter 6, of the Oracle Database Gateway for APPC User's Guide for detailed information about the function and parameters of the pg4tcpmap
tool.
Note that input in this sample is shown within angle brackets (<>
).
$ pg4tcpmap PG4TCPMAP: Release 12.1.0.1.0 - Production on Tue Dec 11 15:09:00 2012 This tool takes the IMS Connect TCP/IP information, such as host name and port number and maps them to your TIPs. You may use this tool to insert or delete IMS Connect TCP/IP information. If you want to insert a row, type I If you want to delete a row, type D i Enter the Unique Side Profile. IMSPGA Enter either the remote hostname or its TCP/IP address. mvs09 Enter the IMS CONNECT port number. 9900 Do you want to select a CONVERSATIONAL PROTOCOL?(Y|N) The default is NO, 'no request for acknowledgment or deallocation' n Enter one of the following letters for Timer. For .25 second, enter 'D'. For .01 to .25 second, enter 'S'. For 'does not set the timer, no wait occurs', enter 'N'. For Receive waits indefinitely, enter 'I'. The default is 'D'. D Enter one of the following letters for 'socket connection type'. For transaction socket, enter 'T'. For persistent socket, enter 'P'. For non-persistent socket, enter 'N'. The default is 'T'. T Do you want to enter the CLIENT ID name? (Y|N) If NO, IMS CONNECT (USER EXIT) will generate it. n Enter one of the following letters for 'COMMIT MODE'. For Commit Mode set to 0, enter '0'. For Commit Mode set to 1, enter '1'. The default is '1'. 1 Enter the DATASTORE name (IMS DESTINATION ID). The maximum string length is 8 and the Datastore name must be specified. IMSE Do you want to enter the LTERM? (Y|N) If NO, the default is blank. n Do you want to enter the RACF GROUP name? (Y|N) If NO, the default is blank. n Do you want to enter the IRM_ID? (Y|N) If NO, the default is *IRMREQ*. n Does your exit return the LLLL prefix field? (Y|N) The default is 'N'. n Requested to INSERT a row. 'Side Profile name' is 'IMSPGA' 'remote host name' is 'MVS09' 'IMS Connect port number' is '9900' 'conversational protocol' is ' ' 'Timer' is 'D' 'socket connection type' is 'T' 'client ID' is ' ' 'commit mode' is '1' 'Datastore name (IMS destination ID)' is 'IMSE ' 'IMS LTERM override' is ' ' 'RACF group name' is ' ' 'IRM ID' is '*IRMREQ*' 'LLLL prefix present' is 'N' PG4TCPMAP is complete.
The following is an example of a listener.ora
file for a gateway using TCP/IP:
LISTENER = (ADDRESS_LIST = (ADDRESS= (COMMUNITY= TCP.world) (Host = bay) (PROTOCOL= TCP) (Port= 2621) ) (ADDRESS= (COMMUNITY= TCP.world) (Host = bay) (PROTOCOL= TCP) (Port= 2623) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PGA) (ORACLE_HOME = /oracle/pga/12.1) (PROGRAM = pg4t4ic) ) )
The following is an example of a tnsnames.ora
file for a gateway using TCP/IP:
ORA920 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = bay.us.oracle.com)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORA920.bay) ) ) PGA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = bay)(PORT = 2623)) ) (CONNECT_DATA = (SID = PGA) ) (HS = OK) )