This appendix lists and describes the parameters needed specifically 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 Procedural Gateway for APPC using TCP/IP for IMS Connect is located in the %ORACLE_HOME%\pg4appc\admin directory and is called initsid.ora.
Note:
The initsid.ora file contains both SNA and TCP/IP parameters. You will need to modify these files with the appropriate parameters.The Procedural Gateway Administration (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 pg4tcpmap tool when you set your Trace Level to 255. The log file for this tool will reside in the same place as the gateway log file, in |
|
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 11, "Security Requirements". Important: You must specify your RACF group name through the pg4tcpmap tool if you have set your PGA security option to If you have already loaded the table pga_tcp_imsc and you did not first specify the RACF group name, then delete the row and reinsert it with the value for the RACF group name. |
|
The Oracle Net service name for the Oracle server in which the gateway receives its TCP/IP for IMS Connect information, such as host name and port number. This parameter can be from 1 to 255 characters long. This parameter is required. There is no default value. |
|
The Oracle password to be used by the gateway when connecting to the Oracle server specified by the There is no default value. |
|
The Oracle user ID to be used by the gateway when connecting to the Oracle server specified by the PGA_TCP_DB parameter. The user ID can be from 1 to 30 characters long. This parameter is required. There is no default value. |
|
PGA trace level. This controls tracing output written to The default is 0, indicating no tracing. NOTE: This parameter will be used in the pg4tcpmap tool as well as the gateway. |
The following output illustrates the results from executing the pg4tcpmap tool when running TCP/IP for IMS Connect on the gateway. Refer to Section 10.8, "Loading the PGA_TCP_IMSC Table" of this guide and to Chapter 6 of the Oracle Procedural 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 brackets angle brackets (<>
).
C:\oracle\bin\<pg4tcpmap> PG4TCPMAP: Release 10.2.0.1.0 - Production on Fri Jun 3 14:57:41 2005 Copyright(c) 1982,2005 Oracle Corporation. All rights reserved. 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. pgaimst Enter either the remote hostname or its TCP/IP address. <mvs08> 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 goup name? (Y|N) If NO, the default is blank. <n> Requested to INSERT a row. 'Side Profile name' is 'PGAIMST' 'remote host name' is 'MVS08' '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 ' ' pg4tcpmap is complete.
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 = C:\oracle\pga\10.2) (PROGRAM = pg4t4ic) ) )
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) )