B Gateway Initialization Parameters for TCP/IP Communication Protocol

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:

Important: You must specify your RACF group name through the pg4tcpmap tool if you have set your PGA security option to SECURITY=PROGRAM. For more information about this issue, refer to the Oracle Database Gateway for APPC User's Guide.

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.

PGA_TCP_DB

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 1 to 255 characters long. This parameter is required.

There is no default value.

PGA_TCP_PASS

The Oracle password to be used by the gateway when connecting to the Oracle database specified by the PGA_TCP_DB parameter. The password can be from 1 to 30 characters long. This parameter is required. The password can be encrypted. For more information about encrypting the password, refer to Section 10.6, "Passwords in the Gateway Initialization File".

There is no default value.

PGA_TCP_USER

The Oracle user ID to be used by the gateway when connecting to the Oracle database 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.

TRACE_LEVEL

PGA trace level. This controls tracing output written to STDERR (the target of the LOG_DESTINATION parameter.) The value must be an integer from 0 to 255.

The default is 0, indicating no tracing.

NOTE: This parameter will be used in the pg4tcpmap tool as well as the gateway.

Note that input in this sample is shown within brackets angle brackets (<>).

C:\oracle\bin\<pg4tcpmap>
PG4TCPMAP: Release 11.2.0.1.0 - Production on Thu Jun 11 15:09:00 2009
Copyright (c) 1982, 2009, Oracle and/or its affiliates. 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.
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.