Skip Headers
Oracle Procedural Gateway® for APPC User's Guide
10g Release 2 (10.2) for UNIX

Part Number B16210-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

6 PG4TCPMAP Commands (TCP/IP Only)

This chapter contains the commands and instructions to operate the pg4tcpmap tool. This tool enables relevant parameters to map to a gateway using TCP/IP support for IMS Connect. You can use the tool to populate the PGA_TCP_IMSC table.

This chapter contains the following sections:

6.1 Preparation for Populating the PGA_TCP_IMSC Table

If your gateway is using TCP/IP support for IMS Connect, then you must use the pg4tcpmap tool to prompt PGAINIT to provide the required TCP/IP parameters as input. The pg4tcpmap tool maps the Side Profile name defined in the .ctl file to TCP/IP and IMS Connect attributes, such as port number, IP address (hostname) and IMS subsystem ID. The TCP/IP parameters are sent across the TCP/IP network to start a conversation with the target transaction program.

The pg4tcpmap tool must be run before executing any PL/SQL gateway statements in order to populate the PGA_TCP_IMSC table, which uses the corresponding TIPs.

Note that you do not need to rerun the pg4tcpmap tool for additional IMS transactions if they share the same IMS Connect attributes.

The PGA_TCP_IMSC table was created when you executed the $ORACLE_HOME/pg4appc/admin/pgaimsc.sql script during your gateway configuration. If you need further information about creating the PGA_TCP_IMSC table, then refer to Chapter 12 of the Oracle Procedural Gateway for APPC Installation and Configuration Guide.

6.2 Overview

In a PGAINIT procedure call, the user must specify a Side Profile Name and TP Name. The values of these parameters will be inserted into a table named PGA_TCP_IMSC.

Configure userid and Password Before Running gateway Mapping Tool

Before executing the pg4tcpmap tool, you must configure a valid userid and password and TNSNAMES alias for the Oracle Integrating Server where the PGA_TCP_IMSC table resides. You must specify the userid, password, and database in the PGA_TCP_USER, PGA_TCP_PASS, and PGA_TCP_DB parameters, respectively, located in the gateway initialization file $ORACLE_HOME/pg4appc/admin/initsid.ora.

6.3 Populating the PGA_TCP_IMSC Table

Table 6-1 describes the parameter information contained in the column names, types and contents column found in the PGA_TCP_IMSC table.

Table 6-1 PGA_TCP_IMSC Table Columns

Column Name Type Content
SideProfileName varchar2(8) This parameter has no SNA implication. It is simply a name that is defined in the .ctl file for the PGAU utility. It represents a group of IMS transactions with similar IMS Connect attributes, such as time delay, socket type and IMS subsystem ID.

Unique index.

HostName varchar2(169) NOT NULL The OLTP TCP/IP address or the hostname.
PortNumber varchar2(17) NOT NULL The OLTP port number.
ANDRS char(1) NOT NULL ANDRS specifies whether the client is sending:

A = ACK: Positive Acknowledgement;

N = NAK: Negative Acknowledgement;

D = DEALLOCATE: Deallocate Connection;

R = RESUME: Resume TPIPE;

S = SENDONLY: Send only Acknowledgment or Deallocate.

blank: no request for Acknowledgement or Deallocate.

The default is "blank".

TIMER char(1) NOT NULL Time delay for the receive to the datastore after an ACK or RESUME TPIPE:

D = default value X'00' .25 second;

S = short wait X'01' through X'19': 01 to .25 second

N = No Wait occurs

I = Receive waits indefinitely.

The default is "D".

SOCK char(1) NOT NULL Socket Connection Type

T = Transaction Socket:

P = Persistent Socket

N = Non-persistent Socket

The default is "T".

CLIENTID char(8) NOT NULL Specifies the name of the client ID that is used by IMS Connect. The default is 'null'.
COMMITMODE char(1) NOT NULL It specifies the commit mode:

0 = the commit mode is 0;

1 = the commit mode is 1

The default is "1".

IMSDESTID char(8) NOT NULL Specifies the datastore names (IMS subsystem ID) 8 bytes.

This parameter must be specified.

LTERM char(8) NOT NULL Specifies the IMS LTERM override. The default is "blank".
RACFGRPNAM char(8) NOT NULL Specifies the RACF group name.

The default is "blank".

You need to specify the RACF group name if you have set PGA_SECURITY_TYPE to PROGRAM.

Refer to "PGA_SECURITY_TYPE" in Table B-1 "PGA Parameters on Gateway Using TCP/IP for IMS Connect" in the Oracle Procedural Gateway for APPC Installation and Configuration Guide.

Refer to "TCP/IP Security Option SECURITY=PROGRAM" in Chapter 13 of the Oracle Procedural Gateway for APPC Installation and Configuration Guide to learn more about how to set the RACF userid and RACF password.


6.4 Before You Run the pg4tcpmap Tool

Follow these steps to prepare for running the pg4tcpmap tool before you run the gateway.

  1. Set the ORACLE_HOME and ORACLE_SID for the Oracle Integrating Server.

  2. Make certain that the user, PGAADMIN, has been created in the Oracle Integrating Server and you can talk to the database. Issue

    $ORACLE_HOME/pg4appc/admin/pgacr8au.sql
    
    
  3. The initsid.ora file must contain appropriate parameters. Set the following parameters:

    • PGA_TCP_USER

    • PGA_TCP_PASS

    • PGA_TCP_DB

    • If you intend to enable the tracing, you also need to set the following parameters:

      • TRACE_LEVEL=255

      • LOG_DESTINATION=<valid directory>

      Refer to Chapter 8, "Problem Determination" for information about tracing.

  4. Make certain that the PGA_TCP_IMSC table has been created. Issue:

    $ORACLE_HOME/pg4appc/admin/pgaimsc.sql
    
    

    Refer to Chapter 12, "Gateway Configuration Using the TCP/IP Communication Protocol" in the Oracle Procedural Gateway for APPC Installation and Configuration Guide for more information on the PGA_TCP_IMSC table and on creating the user PGAADMIN.

Figure 6-1 illustrates the relationship between the gateway, the database and the pg4tcpmap tool in mapping the Side Profile Name to TCP/IP and IMS Connect attributes in the PGA_TCP_IMSC table.

Figure 6-1 Mapping SNA Parameters to TCP/IP Using the pg4tcpmap Tool

Description of 6_1map.gif follows
Description of the illustration 6_1map.gif

A copy of the screen output file for the pg4tcpmap tool is located in Appendix B of the Oracle Procedural Gateway for APPC Installation and Configuration Guide.

An example of a trace file from a sample pg4tcpmap execution can be found in Chapter 8, "Problem Determination".

6.5 pg4tcpmap Tool Commands

There are two commands for the pg4tcpmap tool:

6.5.1 Inserting a Row into the PGA_TCP_IMSC Table

Issue the following command from the gateway Oracle home $ORACLE_HOME/bin directory:

$ pg4tcpmap 

The following text appears:

PG4TCPMAP: Release 10.2.0.1.0 - Production on Wed Feb 19 17:43:15 2005
Copyright (c) 1982, 2005, Oracle. 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"

Enter <i>, and after that, you need only enter the required parameters.

6.5.2 Deleting Rows from the PGA_TCP_IMSC Table

Issue the following command from the gateway Oracle home $ORACLE_HOME/bin directory:

$ pg4tcpmap 

The following text appears:

PG4TCPMAP: Release 10.2.0.1.0 - Production on Wed Feb 19 17:43:15 2005
Copyright (c) 1982, 2005, Oracle. 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"

Enter <d>, and the pg4tcpmap tool will ask you what Side Profile Name you want to delete.

If the row does not exist, you will receive an ORA-1403 error message.

Note:

Do not use SQL*Plus to update the PGA_TCP_IMSC table. If you have problems or incorrect data in the table, use $ORACLE_HOME/pg4appc/admin/pgaimsc.sql to re-create the table and its index.

6.5.3 Querying the PGA_TCP_IMSC Table

Use the regular SQL*Plus select statement to query the table. For example:

$ sqlplus userid/password@databasename 
SQL> column hostname format A22
SQL> column portnumber format A6
SQL> select sideprofilename, hostname,portnumber,imsdestid,commitmode from
     pga_tcp_imsc;

SIDEPROF           HOSTNAME                PORTNU    IMSDESTI    C
---------------    ----------------------  ------    --------    -
IMSPGA             MVS08.US.ORACLE.COM     9900      IMSE        1