PK
>Aoa, mimetypeapplication/epub+zipPK >A iTunesMetadata.plist
Oracle Database Gateway for APPC uses the SNA Advanced Program to Program Communication (APPC/LU6.2) protocol to communicate with an online transaction processing (OLTP). HP-UX system support for APPC is provided by the SNAPlus2 product.
This chapter describes how to set up and configure SNAPlus2 on a HP-UX system to run Oracle Database Gateway for APPC.
Note: When you finish following the instructions in this chapter, refer to Chapter 5, "Configuring Your Oracle Network" to continue network configuration. |
This chapter contains the following sections:
Many OLTPs provide options for manipulating the security conduct of an inbound (client) APPC session request. Refer to the appropriate documentation for your OLTP for detailed information about this topic.
Note that for CICS, one security option is not supported by the gateway: ATTACHSEC=PERSISTENT
, specified on the CICS CONNECTION
definition, requires capability that is not yet available in the gateway.
ATTACHSEC=LOCAL
, ATTACHSEC=IDENTIFY
, ATTACHSEC=VERIFY
, and ATTACHSEC=MIXIDPE
are fully supported by the gateway.
All SNAPlus2 product configuration is done using the xsnapadmin
program. xsnapadmin
is an X-Windows application that provides a graphical interface to view and modify the current SNAPlus2 configuration and the current running state of the host SNA node. Refer to vendor documentation for more information about using xsnapadmin
.
Oracle Database Gateway for APPC requires a stored set of definitions, called Side Information Profiles, to support connections between the gateway and remote server. Each profile consists of a profile name and a profile type, which is a set of fields describing the profile. The fields in a profile type are generally a mix of operating parameter values and names of other SNA profiles relevant to the profile. Each functional part of APPC, such as Mode, Remote Transaction Program name and Logical Unit (LU), is described by a distinct profile type.
Oracle recommends independent LUs for the gateway because they support multiple parallel sessions or conversations. This means multiple Oracle client applications can be active simultaneously with the same OLTP through the independent LU.
Dependent LUs only support a single active session. SNAPlus2 queues additional conversation requests from Oracle Database Gateway for APPC behind an active conversation. That is, conversations are single-threaded for dependent LUs.
If a dependent LU is correctly defined, no alterations are needed for the gateway configuration, to the host transaction, or to how the OLTP is started.
The operational impact of dependent LUs is that the first client application can initiate a conversation through the gateway with the OLTP, and while that transaction is active (which could be for seconds, minutes, or hours, depending on how the client application and transaction are designed), any other client application initiating a conversation with the same OLTP instance appears to hang as it waits behind the previous conversation.
If a production application really only uses a single conversation or transaction at any one time, there should be no impact.
However, additional concurrent conversations or transactions might be required for testing or other application development. Each requires that additional dependent LUs be defined on the remote host in addition to an SNAPlus2 configuration file entry that defines the additional dependent LUs on the HP-UX workstation. The TIP that initiates the conversation must specify the different SNAPlus2 Partner LU through a different Side Information Profile. Refer to the PGAU DEFINE TRANSACTION SIDEPROFILE
parameter in Chapter 2 of Oracle Database Gateway for APPC User's Guideand the SNAPlus2 Symbolic Destination Name discussed in the section, "Sym Dest Name".
In some uses of the gateway, independent LUs cannot be used. For example, with the IMS LU6.1 Adapter for LU6.2, parallel sessions are not supported. In this case, multiple concurrent sessions with the IMS LU6.1 Adapter for LU6.2 can be achieved by defining a pool of dependent LUs. For each dependent LU, select the "LU in the pool of default LUs" option. When a conversation is requested, an available local LU from the default LU pool is assigned automatically by SNAPlus2. For more information, refer to vendor documentation.
This option lets you enter the side information associated with a particular symbolic destination name. You can use an alphanumeric string up to 8 characters as the Sym Dest Name
. The symbolic destination name is referred to as the side information profile in other parts of this guide. This name is specified by the SIDEPROFILE
keyword in the DEFINE TRANSACTION
statement used to define your transaction to PGAU.
The Partner TP name field specifies the name of the transaction to be run on the OLTP side of the conversation. This field must be specified, but the TP name can be overridden by the gateway at conversation startup.
The Partner LU field specifies the LU name of the OLTP on the remote host. The Mode Name field specifies the mode name to be used for conversations with the specified OLTP.
The security information that can be specified in this menu is not usable for the gateway. The security parameters are always set by the gateway based on gateway initialization parameters.
SNAPlus2 definitions are stored in the following files, which are located in the /etc/opt/sna
directory:
SNA node definitions: sna_node.cfg
SNA domain definitions: sna_domn.cfg
These files are created and maintained with the xsnapadmin
tool. Maintenance of the SNA definitions is normally done by a user with administrative authority. The following information is intended for the person creating SNA definitions for the gateway. You should have some knowledge of SNA before reading this section.
The gateway $ORACLE_HOME/dg4appc/sna
subdirectory contains a set of sample SNAPlus2 definitions for the gateway, created with the xsnapadmin
. SNA definitions are very specific to the HP 9000 host and SNA network. Because of this, these sample definitions will not work without being tailored for the local host and SNA network.
This section describes the process of creating SNA definitions for SNAPlus2 using the xsnapadmin
tool. All configuration is done using the various dropdown menus and panels in xsnapadmin
. The configuration descriptions in the steps below follow the samples provided. You must tailor the various SNA values for your local host and SNA network.
Use the following commands to run xsnapadmin
. The DISPLAY
environment variable must be appropriately set. If you are running xsnapadmin
from the local HP 9000 console, then DISPLAY
should already be set. If you are running xsnapadmin
from a remote X display, then set DISPLAY
to the host name or IP address of that display.
$ DISPLAY=xstation10.us.oracle.com:0 $ export DISPLAY $ xsnapadmin &
At xsnapadmin
startup, the main screen opens and displays the current configuration of the local SNA node.
On the main screen of xsnapadmin
, pull down the Services menu and select Configure Node Parameters.
In the Node Parameters dialog box, enter the APPN support type, the Control Point Name, Control Point, and Node ID as needed. The Control Point Name is composed of the SNA Network Name and the CP name of the local host.
Click OK.
From the Service menu, select Connectivity and then select Add Port.
In the Add to nodename
dialog box, select the Port and type you are using and click OK.
In the subsequent SAP dialog box, enter a Port name and network card number. The Port name is used to logically name the physical network card you are using and to bind a Service Access Port to the card for SNA protocols. Usually, you can accept the values provided in the dialog box. If a different network card is needed, however, enter the card number as reported with the lanscan
command.
Click OK.
When the Port has been defined, you need to create a Link Station. The Link Station represents the SNA node of the remote host of the APPC server. But before you can create the Link Station, you must create a Remote Node definition.
From the Services menu, select APPC and select Add Remote Node.
In the Remote Node dialog box, enter the SNA CPNAME
of the remote node and click OK.
Now you are ready to create the Link Station. From the Services menu, select Connectivity and select Add Link Station. In the dialog box that is displayed, select the Port previously defined and click OK.
In the Link Station dialog box, enter a name for the Link Station, choose the SNA Port name, and choose the type of link activation.
Choose the LU Traffic type. For maximum flexibility, choose the Any option.
For Independent LU traffic, specify the Remote Node name.
Click on Remote Node and select the node you previously created. Click OK.
For Dependent LU traffic, specify the Local Node ID, and optionally, Remote Node ID. Then, specify the Contact Information. Contact information contains the MAC address of the remote host as well as the SAP number. Click Advanced for additional parameters of the Link Station.
The Ethernet Parameters screen shows additional parameters of the Link Station. These parameters affect initial XID contact and retransmission times and limits. You need not change the default values. Click OK.
When the Remote Node definitions have been made, create the Local LU names for the local host. From the Services menu, select APPC and Add Local LU.
In the Local LU dialog box, enter the name of the local LU and an alias. This name must correspond to the VTAM definitions on the remote server host for the HP 9000 host.
Click OK.
Now define a Partner LU that represents the LU that the remote server is using to communicate. From the Services menu, select APPC and Add Partner LUs and Partner LU on Remote Node.
In the dialog box that is displayed, enter the Partner LU name and characteristics. The Partner LU name will contain the SNA Network Name as well as the LU name of the remote LU.
Enable parallel session support. The location is the name as the Remote Node name. You can click on Location for a list.
Click OK.
Once the local and remote LU definitions have been made, create the necessary Mode and CPI-C definitions. From the Services menu, select APPC and Modes.
In the Modes dialog box, click on Add to add a new mode.
In the subsequent Mode dialog box, enter the Mode Name and other session parameters. The recommended name for an APPC mode is ORAPLU62
. Contact your Remote Host system administrator for an appropriate mode parameter name.
Click OK.
Now that the Mode has been defined, create the CPI-C Side Information Profile, which the gateway will use as a connection name. From the menu, select APPC and CPI-C. In the CPI-C destination names dialog box, click on Add to add a new profile.
In the CPI-C destination dialog box, enter the Profile name, Partner TP, Partner LU, mode, and Security option. The partner TP name is the name of the host transaction program or a dummy value to be overridden in the TIP.
For the Partner LU, enter either the full LU name or the alias created previously. Enter ORAPLU62
for the mode name.
Lastly, choose the type of security these sessions will use. This affects how session authorization is done.
Click OK.
Ensure that your connection is working. Do this by starting the SNAPlus2 Node and then starting the individual link stations.
Figure 8-1 shows the relationship between SNAPlus2 definitions and the VTAM definitions on the remote host.
Figure 8-1 Relationship Between SNAPlus2 Definitions and Remote Host Definitions
When you have finished configuring SNAPlus2 for HP-UX, proceed to Chapter 10, "Configuring the OLTP" to continue configuring the network.
This chapter describes the system requirements of the gateway. It contains the following sections:
The hardware requirements for this release of the gateway on your platform are described in the following sections:
Table 3-1 lists the minimum hardware requirements for Oracle Database Gateway fro APPC.
Table 3-1 Hardware requirements for Oracle Database Gateway for APPC
Hardware Items | Required for AIX-Based System | Required for HP-UX Itanium | Required for Solaris Operating System (SPARC) | Required for Linux x86 | Required for Linux x86 64 bit |
---|---|---|---|---|---|
Temporary Disk Space |
190 MB |
415 MB |
180 MB |
80 MB |
120 MB |
Disk Space |
3 GB |
3.5 GB |
2 GB |
1 GB |
1.2 GB |
Physical Memory* |
512 MB |
512 MB |
512 MB |
512 MB |
512 MB |
Swap Space |
150 MB |
150 MB |
150 MB |
150 MB |
150 MB |
Processor |
IBM RS/6000 AIX-Based System Processor |
HP Itanium processor for hp-ux 11 |
Sun Solaris Operating System (SPARC) Processor |
x86 |
x86_64 |
The following factors affect the virtual memory requirements of the gateway server process:
Number of concurrent gateway connections open by each user
Number of data items being transferred between the gateway and the remote transaction program
The Oracle Net protocol adapters that were included during the gateway installation
Additional factors, such as configured network buffer size
The gateway requires any network attachment supported by either the SNA communication package for your platform or the TCP/IP Networking Facility for TCP/IP communication.
However, if you are using only the new TCP/IP support for IMS Connect feature, you will not need an SNA package. Your operating system comes with TCP/IP installed.
The system software configuration described in this section is supported by Oracle, provided that the underlying system software products are supported by their respective vendors. Verify the latest support status with your system software vendors.
This section contains the following topics:
Refer to the Oracle Database Installation Guide and to the certification matrix on My Oracle Support for the most up-to-date list of certified operating system version requirements to operate the gateway for your Linux for Intel Pentium-based 32-bit systems, AIX-Based, HP-UX or Solaris system. The My Oracle Support Web site is available at
Each operating system uses specific communications servers, as described in this section.
Note: If you choose to use TCP/IP support for IMS Connect as communication protocol, then you do not need to use an SNA communication package from the following list. Each operating system comes with a TCP/IP protocol automatically installed. If you choose to use the TCP/IP protocol, then you need to configure it to work properly with the gateway. Refer to Chapter 12, "Gateway Configuration Using TCP/IP Communication Protocol". |
Communications Protocols for Linux for Intel Pentium-based 32-bit Systems
Communications protocols for Linux for Intel Pentium-based 32-bit System IBM Communications Server V6.0.1.1 for Linux or higher, or the TCP/IP communication software that comes with your operating system.
Communications Protocols for AIX-based Systems
SNA Server for AIX version 6.01 or higher, or the TCP/IP communications software that comes with your operating system.
Communications Protocols for HP-UX
HP-UX SNAPlus2 Link Release 11.x and HP-UX SNAPlus2 API Release 11.x or higher or the TCP/IP communications software that comes with your operating system.
Communications Protocols for Solaris
SNAP-IX version 6 or higher, or the TCP/IP communications software that comes with your operating system.
All UNIX platforms require that the Oracle database, that is to act as the Oracle database be up to date with the latest patchset for supported Oracle database releases.
Oracle Net is automatically installed on the system where Oracle database is installed and on the system where the gateway is installed. Refer to Chapter 5, "Configuring Your Oracle Network" in this guide for detailed configuration information. Additionally, you might refer to the Oracle Database Net Services Administrator's Guide.
In addition to the other software requirements of the gateway and the platform being used, the following list outlines other requirements necessary on the IBM mainframe:
OLTP for SNA
The OLTP must support mapped APPC conversations. If the OLTP transaction programs to be executed through the gateway perform database updates, then the APPC verbs CONFIRM
, CONFIRMED
, and SEND_ERR
must be supported by the OLTP. These verbs implement APPC SYNCLEVEL 1
.
All resources controlled by an OLTP that can be updated by transaction programs invoked through the gateway must be defined as recoverable resources to the OLTP and host system if COMMIT
/ROLLBACK
capability is required for those resources. For example, a VSAM file updated by a CICS transaction must be defined to CICS as a recoverable file for COMMIT
/ROLLBACK
to control the updates.
The gateway is compatible with all supported releases of SNA-enabled products such as CICS, IMS/TM, IDMS and z/OS.
Note: For a list of known restrictions, read the "Known Restrictions" section before proceeding with the installation of the gateway. |
IMS/TM: Release 7.1 or later is required, as well as any APARs (patches) listed in the IBM IMS Connect Guide and Reference.
The following sections describe how to configure the online transaction processing OLTP.
If your communications protocol is SNA: Proceed to Configuring the OLTP for an SNA Environment.
If your communications protocol is TCP/IP: Proceed to Configuring the OLTP for a TCP/IP Environment.
Note: On a gateway using TCP/IP support for IMS Connect, you must specifyEDIT=ULC in the IMS TRANSACT macro if you need input case sensitivity. When you are using SNA support, you do not need to specify EDIT=ULC in the IMS TRANSACT macro. |
The steps for configuring OLTP to communicate with the Oracle Database Gateway for APPC vary depending on which OLTP you are using and on which platform the OLTP is running. CICS Transaction Server for z/OS, IMS/TM, APPC/MVS, and z/OS are the currently supported OLTPs. Choose the instructions corresponding to your OLTP from the following sections:
Note: You need to perform the configuration steps for an OLTP only if this is the first time that you are configuring that OLTP. |
If your OLTP is CICS Transaction Server for z/OS, then perform the following steps to configure it for communication with the gateway:
Configure MVS VTAM for the SNA communication package that will make the APPC connection to your system. At least one independent LU must be available to the gateway.
Check the VTAM logmode table used by the CICS Transaction Server for z/OS. (The table name is specified in the MODETAB
parameter in the VTAM APPL definition for CICS.) Ensure that an entry exists for APPC sessions with parallel session and sync-level support.
The oraplu62.asm
file in the $ORACLE_HOME/dg4appc/sna
directory contains a sample mode entry, including comments that indicate the required values in the mode entry.
Using a file transfer facility, transfer the following files from the $ORACLE_HOME/dg4appc/demo/CICS
directory to the z/OS system on which you run CICS Transaction Server for z/OS:
Using the comments in the dfhcsdup.jcl
file, tailor the JCL and input statements to match your system setup, and submit it for batch execution. Performing this step updates your Transaction Server for z/OS system definitions.
Using the instructions in the pgaflip.jcl
file comments, tailor the JCL to match your system setup, and submit it for batch execution. Performing this step assembles and linkedits the pgaflip.asm
file into a load module library accessible to your Transaction Server for z/OS through the DFHRPL
DD statement in the CICS startup procedure.
Log on to your CICS Transaction Server for z/OS and enter the following transaction:
CEDA INSTALL GROUP(ORAPGA)
This transaction installs the CICS connection and session definitions for APPC communication with the gateway on UNIX. It also installs definitions for the sample CICS programs and transactions provided with the gateway.
Your CICS Transaction Server for z/OS configuration is now complete.
If your OLTP is IMS/TM, then perform the following steps to configure IMS/TM and z/OS for communication with the gateway:
Configure your IMS system for the APPC.
Configure MVS VTAM for the SNA APPC connection to UNIX. At least one independent LU must be available for use by the gateway, unless you are using the IMS LU6.1 Adapter for LU6.2 applications. In this case, you must have one dependent LU defined for each concurrent session. For example, if you want to support 10 concurrent sessions, then you must have 10 dependent LUs defined.
Check the VTAM logmode table used by IMS/TM. The table name is specified by the MODETAB
parameter in the VTAM APPL definition. For APPC/IMS, ensure that an entry exists for APPC sessions with sync-level support and parallel session support. The oralu62.asm
and oraplu62.asm
files in the $ORACLE_HOME/dg4appc/sna
directory contain sample mode entries for single session and parallel session support, respectively. The samples include comments that indicate the required values in the mode entries.
Using your file transfer facility, transfer the following files from the $ORACLE_HOME/dg4appc/demo/IMS
directory to the z/OS system on which you run IMS/TM:
pgaflip.asm
is assembler source for IMS FLIP
transaction
pgaflip.jcl
is JCL to assemble and linkedit IMS FLIP
transaction
imsgen.asm
is IMS stage 1 gen definitions for the IMS FLIP
transaction
Add the statements in the imsgen.asm
file to your IMS stage 1 gen and run your IMS stage 1 and stage 2 gens. Use the online change utility to enable the new transaction definition.
Using the comments in the pgaflip.jcl
file, tailor the JCL to match your system setup and submit it for batch execution. This assembles and linkedits the pgaflip.asm
file into a load module library that is accessible to your IMS/TM system and creates an PSB and an ACB for the FLIP
transaction.
Perform the tasks necessary on your system to make the new transaction available to IMS/TM. Depending on your system setup, you might have to restart IMS.
The IMS/TM configuration is now complete.
If your OLTP is APPC/MVS, then perform the following steps to configure APPC/MVS for communication with the gateway:
Configure MVS VTAM for the SNA APPC connection to HP-UX. At least one independent LU must be available for use by the gateway.
Check the VTAM logmode table used by APPC/MVS. (The table name is specified by the MODETAB
parameter in the VTAM APPL definition for APPC/MVS.) Ensure that an entry exists for APPC sessions with SYNCLEVEL
and parallel session support. The oraplu62.asm
file in the $ORACLE_HOME/dg4appc/sna
directory contains a sample mode entry, including comments that indicate the required values in the mode entry.
Allocate a partitioned data set (PDS) on your z/OS system where the sample files are placed. The PDS should be allocated with RECFM=FB
, LRECL=80
, and a BLKSIZE
appropriate for the device type on which it is located. Approximately two tracks of 3390 disk space are required with one directory block. Oracle suggests naming this partitioned data set (PDS) ORAPGA.APPCMVS.SAMPLIB
.
Using a file transfer facility, transfer the following files from the $ORACLE_HOME/dg4appc/demo/MVS
directory to the z/OS PDS you allocated in the previous step, using the following specified member names:
pgaflip.jcl
: JCL to add an APPC/MVS TP
profile and to define the execution environment for the transaction. Store this file in your z/OS PDS as member PGAFLIPJ
.
pgaflip.rex
: The REXX source for the APPC/MVS PGAFLIP transaction. Store this file in your z/OS PDS as member PGAFLIP
.
Using the comments in the pgaflip.jcl
file, tailor the JCL to match your system setup and submit it for batch execution. Performing this step defines the APPC/MVS TP
profile for the PGAFLIP
transaction and stores it in the APPC/MVS profile data set. Ensure that you change the data set name in the JCL to match the name of the z/OS PDS allocated in Step 3.
The APPC/MVS configuration is now complete.
Now that you have completed configuration of the network on a gateway using the SNA protocol, refer to Chapter 11, "Gateway Configuration Using SNA Communication Protocol". Refer to "Configuring Commit-Confirm" for more information on configuring commit-confirm.
These are the steps for configuring OLTP to communicate with Oracle Database Gateway for APPC using TCP/IP for IMS Connect. IMS/TM, through IMS Connect, is the only supported OLTP for this release of the gateway.
Perform the following steps to configure IMS/TM and z/OS for communication with the gateway:
Configure your IMS system.
Configure IMS Connect
For information on how to configure IMS Connect, refer to the IBM manual, IMS Connect Guide and Reference.
Using a file transfer facility, transfer the following files from the $ORACLE_HOME/dg4appc/demo/IM
S directory to the z/OS system on which you run IMS/TM:
Add the statements in the imsgen.asm
file to your IMS stage 1 gen and run your IMS stage 1 and stage 2 gens. Use the online change utility to enable the new transaction definition.
Using the comments in the pgaflip.jcl
file, tailor the JCL to match your system setup and submit it for batch execution. This assembles and linkedits the pgaflip.asm
file into a load module library that is accessible to your IMS/TM system and creates an PSB and an ACB for the FLIP transaction.
Perform the tasks necessary on your system to make the new transaction available to IMS/TM. Depending on your system setup, you might have to restart IMS.
The IMS/TM configuration is now complete.
At this point, proceed to Chapter 12, "Gateway Configuration Using TCP/IP Communication Protocol" to complete configuration of the gateway and its components.
Installation and Configuration Guide
11g Release 2 (11.2) for AIX 5L Based Systems (64-Bit), HP-UX Itanium, Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64
E12078-01
July 2009
Oracle Database Gateway for APPC Installation and Configuration Guide, 11g Release 2 (11.2) for AIX 5L Based Systems (64-Bit), HP-UX Itanium, Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64
E12078-01
Copyright © 2004, 2009, Oracle and/or its affiliates. All rights reserved.
Primary Author: Maitreyee Chaliha
Contributor: Vira Goorah, Govind Lakkoju, Peter Wong, Juan Pablo Ahues-Vasquez, Peter Castro, and Charles Benet
This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.
If this software or related documentation is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:
U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.
This software is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications which may create a risk of personal injury. If you use this software in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure the safe use of this software. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software in dangerous applications.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
This software and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.
Table D-1 lists the parameter names and the reasons you will need them to configure the gateway and the communications interface you have chosen (either SNA or TCP/IP). You can use this table as a worksheet to gather the specific information you need before you begin the configuration process.
Ask your systems administrator to provide you with any parameter names you do not know.
Table D-1 Parameters for Configuring Gateway and Communication Protocols
Name of Parameter Needed | Purpose | Your Specific Parameters Here |
---|---|---|
|
For: gateway's Oracle home |
_______________________________ |
|
For: gateway's system ID |
_______________________________ |
Any Security Options Needed |
For: SNA remote LU properties options |
_______________________________ |
Appropriate Name for Each Side Information Profile |
for: SNA creating CPI-C symbolic destination names (side information profiles), general information |
_______________________________ |
Appropriate Mode |
For: SNA |
______________________________ |
TP Name |
For: SNA partner information in CPI-C name properties |
_______________________________ |
Partner LU Name Alias |
For: SNA partner information in CPI-C name properties |
______________________________ |
Unique Side Profile Name |
For: Configuring TCP/IP support for IMS Connect |
______________________________ |
Remote Host name or TCP/IP Address |
For: Configuring TCP/IP support for IMS Connect, |
_______________________________ |
IP Address |
For: Configuring TCP/IP support for IMS Connect, |
_______________________________ |
IMS Connect Port Number |
For: Configuring TCP/IP support for IMS Connect, |
_______________________________ |
Conversational Protocol (Y/N) |
For: Configuring TCP/IP support for IMS Connect, |
_______________________________ |
Timer choice: a) .25 b) .01 to .25 c) Does not exist d) Receives wait |
For: Configuring TCP/IP support for IMS Connect, |
_______________________________ |
Socket Connection Type Choice: a) Transaction b) Persistent c) Nonpersistent |
For: Configuring TCP/IP support for IMS Connect, |
______________________________ |
IMS Client ID Name |
For: Configuring TCP/IP support for IMS Connect, |
______________________________ |
IMS Commit Mode Choice: a) 0 b) 1 |
For: Configuring TCP/IP support for IMS Connect, |
_____________________________ |
IMS Destination ID, data store name |
For: Configuring TCP/IP support for IMS Connect, |
_____________________________ |
|
For: Configuring TCP/IP support for IMS Connect, |
______________________________ |
RACF Group Name |
For: Configuring TCP/IP support for IMS Connect, |
_____________________________ |
IRM_ID |
For: Configuring TCP/IP support for IMS Connect, |
_____________________________ |
LLLL (Y/N) |
For: Configuring TCP/IP support for IMS Connect, |
_____________________________ |
The Oracle Database Gateway for APPC (the gateway) enables users to initiate transaction program execution on remote online transaction processors (OLTPs). The Oracle Database Gateway for APPC can establish a connection with OLTP using the SNA communication protocol. The gateway can also use TCP/IP for IMS Connect to establish communication with the OLTP through TCP/IP. The gateway provides Oracle applications with seamless access to IBM mainframe data and services through remote Procedural Call (RPC) processing. The gateway can access any application capable of using the CPI-C API either directly or through a TP monitor such as CICS.
This chapter discusses the architecture, uses and features of the gateway. It contains the following sections:
The Oracle Database Gateway for APPC extends the RPC facilities available with the Oracle database. The gateway enables any client application to use PL/SQL to request execution of a remote transaction program (RTP) residing on a host. The gateway provides RPC processing to systems using the SNA APPC (Advanced Program-to-Program Communication) protocol and to systems using TCP/IP for IMS Connect protocol. This architecture allows efficient access to data and transactions available on the IBM mainframe and IMS, respectively.
The gateway requires no Oracle software on the remote host system. As a result, the gateway uses existing transactions with little or no programming effort on the remote host.
The gateway can access any application capable of using the CPI-C API either directly or through a TP monitor such as CICS.
The Oracle Database Gateway for APPC provides the following benefits:
TCP/IP support for IMS Connect
This release of the gateway includes TCP/IP support for IMS Connect, providing users a choice between the SNA or TCP/IP communication protocol. IMS Connect is an IBM product which enables TCP/IP clients to trigger execution of IMS transactions. The gateway can use a TCP/IP communication protocol to access IMS Connect, which triggers execution of IMS transactions. If you choose to use TCP/IP, then there is no SNA involvement with this configuration.
Related to this new feature of the gateway is the pg4tcpmap
tool. This release of the gateway includes a tool whose purpose is to map the information from your Side Profile Name to TCP/IP and IMS Connect. For more information about the gateway mapping tool, refer to Chapter 6, of the Oracle Database Gateway for APPC User's Guide , and to Chapter 12, "Gateway Configuration Using TCP/IP Communication Protocol" in this guide.
The gateway is optimized for minimum network traffic when you execute programs remotely. The interface to the gateway is an optimized PL/SQL stored procedure specification called the transaction interface package (TIP). This specification is precompiled in the Oracle database. Because there are no additional software layers on the remote host system, overhead occurs only when your program executes.
Client applications need not be operating system-specific. For example, your application can call a program on a CICS Transaction Server for z/OS. If you move the program to a CICS region on pSeries, then you need not change the application.
Users calling applications that execute a remote transaction program are unaware that a request is sent to a host.
You can use the gateway as an interface with an existing procedural logic or to integrate new procedural logic into an Oracle database environment.
Integration of Oracle database with the gateway enables you to benefit from existing and future Oracle features. For example, the gateway can be called from an Oracle stored procedure or database trigger.
Transactional support
The gateway and the Oracle database allow remote transaction updates and Oracle database updates to be performed in a coordinated fashion.
The gateway supports any tool or application that supports PL/SQL.
The Oracle Database Gateway for APPC provides a powerful development environment, including:
A data dictionary to store information relevant to the remote transaction
A tool to generate the PL/SQL Transaction Interface Package, or TIP
A report utility to view the information stored in the gateway dictionary
A complete set of tracing and debugging facilities
A wide set of samples to demonstrate the use of the product against datastores such as DB2, IMS, and CICS.
The gateway provides site autonomy, allowing you to perform tasks such as authenticate users. It also provides role-based security compatible with any security package running on your mainframe computer.
The following terms and definitions are used throughout this guide. Refer to Appendix C, "Gateway Terminology" for the complete list of terms and definitions pertaining to the gateway, its components, and functions.
This is any Oracle database instance that communicates with the gateway for purposes of performing remote procedural calls to execute RTP. The Oracle database can be on the same system as the gateway or on a different system. If it is on a different system, then Oracle Net is required on both systems. Refer to Figure 1-2, "Gateway Architecture" for a view of the gateway architecture.
OLTP (Online Transaction Processor)
OLTP is an online transaction processor available from other vendors, including CICS Transaction Server for z/OS, IMS/TM, and z/OS.
PGAU (Procedural Gateway Administration Utility)
PGAU is the tool that is used to define and generate PL/SQL Transaction Interface Packages (TIPs). Refer to Chapter 2, Procedural Gateway Administration Utility in the Oracle Database Gateway for APPC User's Guide for more information about PGAU.
This gateway component is a repository of remote host transaction (RHT) definitions and data definitions. PGAU accesses definitions in the PG DD when generating TIPs. The PG DD has data type dependencies because it supports the PGAU and is not intended to be directly accessed by the customer. Refer to Appendix A, Procedural Gateway for APPC Data Dictionary in the Oracle Database Gateway for APPC User's Guide for a list of PG DD tables.
RPC is a programming call that executes program logic on one system in response to a request from another system. Refer to "Gateway Term Definitions" for more information, and refer to Appendix B, Gateway RPC Interface in the Oracle Database Gateway for APPC User's Guide as well.
A remote transaction program is a customer-written transaction, running under the control of an OLTP, which the user invokes remotely using a PL/SQL procedure. To execute a remote transaction program through the gateway, you must use RPC to execute a PL/SQL program to call the gateway functions.
TIP (Transaction Interface Package)
A TIP is an Oracle PL/SQL package that exists between your application and the remote transaction program. TIP is a set of PL/SQL stored procedures that invoke the remote transaction program through the gateway. TIPs perform the conversion and reformatting of remote host data using PL/SQL and UTL_RAW
/UTL_PG
functions.
Figure 1-1 illustrates the Relationship of the gateway and the Oracle database. The terminology discussed in the preceding sections has been used in the architecture of the gateway.
Figure 1-1 Relationship of Gateway and the Oracle Database
The architecture of Oracle Database Gateway for APPC consists of several components:
The gateway
Oracle Database Gateway for APPC must be installed on a server that can run the required version of the operating system.
An OLTP (online transaction processor)
The OLTP must be accessible from the gateway using SNA or TCP/IP communication protocol. Multiple Oracle databases can access the same gateway. A single system gateway installation can be configured to access more than one OLTP.
The OLTP must be accessible to the system using the TCP/IP protocol. Multiple Oracle databases can access the same gateway. A single system gateway installation can be configured to access more than one OLTP. Multiple IMS can be accessed from an IMS Connect. If you have a number of IMS Connect systems available, any of these may be connected to one or more IMS systems.
Figure 1-2 illustrates the architecture of Oracle Database Gateway for APPC using either SNA or TCP/IP, as described in the preceding section.
The basic structure of the gateway is the same whether your communications protocol is SNA or TCP/IP support for IMS Connect. The gateway has some of the same components as an Oracle database instance on UNIX. It has the following components:
A home directory, similar to the one associated with an Oracle instance ORACLE_HOME
environment variable
A system identifier, identified as sid
or ORACLE_SID
An initialization parameter file, similar to the Oracle database init
sid
.ora
file.
The gateway does not have:
Control, redo log, or database files
The full set of subdirectories and ancillary files associated with an installed Oracle database
Because the gateway has no background processes and does not need a management utility such as Oracle Enterprise Manager, you do not need to start the gateway. Each Oracle database user session that accesses a particular gateway creates an independent process on UNIX which in turn runs the gateway server and executes either the SNA or TCP/IP functions to communicate with an OLTP.
All communication between the user or client program and the gateway is handled through a transaction interface package (TIP), which executes on an Oracle database. The TIP is a standard PL/SQL package that provides the following functions:
Declares the PL/SQL variables that can be exchanged with a remote transaction program
Calls the gateway packages that handle the communications for starting the conversation, exchanging data and terminating the conversation
Handles all data type conversions between PL/SQL data types and the target program data types
The Procedural Gateway Administration Utility (PGAU), provided with the gateway automatically generates the TIP specification.
The gateway is identified to the Oracle database using a database link. The database link is the same construct used to identify other Oracle databases. The functions in the gateway are referenced in PL/SQL as:
function_name@dblink_name
The Oracle Database Gateway for APPC provides a set of functions that are invoked by the client through RPC. These functions direct the gateway to initiate, transfer data, and terminate remote transaction programs running under an OLTP on another system.
Table 1-1 lists the remote procedural call functions and the correlating commands that are invoked in the gateway and remote host.
Table 1-1 RPC Functions and Commands in the Gateway and Remote Host
Applications | Oracle TIP | Gateway | Remote Host |
---|---|---|---|
|
|
|
Initiate program |
|
|
|
Exchange data |
|
|
|
Terminate program |
The following sections describe how the RPC functions perform on gateways using SNA or TCP/IP communication protocols.
The TIP initiates a connection to the remote host system, using one of the gateway functions, PGAINIT
.
When the communication protocol is SNA: PGAINIT
provides, as input, the required SNA parameters to start a conversation with the target transaction program. These parameters are sent across the SNA network, which returns a conversation identifier to PGAINIT
. Any future calls to the target program use the conversation identifier as an INPUT
parameter.
When the communication protocol is TCP/IP: PGAINIT
provides, as input, the required TCP/IP parameters. Use the pg4tcpmap
tool to map the parameters. These parameters are sent across the TCP/IP network to start the conversation with the target transaction program. The TCP/IP network returns a socket file descriptor to PGAINIT
. Any future calls to the target program made by PGAXFER
and PGATERM
use the socket file descriptor as an input parameter.
Refer to Appendix B, "Gateway Initialization Parameters for TCP/IP Communication Protocol", and Chapter 6 in the Oracle Database Gateway for APPC User's Guide, for more information about the function and use of the pg4tcpmap
tool.
After the conversation is established, a database gateway function called PGAXFER
can exchange data in the form of input and output variables. PGAXFER
sends and receives buffers to and from the target transaction program. The gateway sees a buffer as only a RAW
stream of bytes. The TIP that is residing in the Oracle database is responsible for converting the application PL/SQL data types to RAW
before sending the buffer to the gateway. It is also responsible for converting RAW
to the PL/SQL data types before returning the results to the application.
When communication with the remote program is complete, the gateway function PGATERM
terminates the conversation between the gateway and the remote host.
When the communication protocol is SNA, PGATERM
uses the conversation identifier as an INPUT
parameter to request conversation termination.
When the communication protocol is TCP/IP, PGATERM
uses the socket file descriptor for TCP/IP as an INPUT
parameter to request conversation termination.
The Oracle Database Gateway for APPC supports three types of transactions that read data from and write data to remote host systems:
One-shot
In a one-shot transaction, the application initializes the connection, exchanges data and terminates the connection, all in a single call.
Persistent
In a persistent transaction, multiple calls to exchange data with the remote transaction can be made before terminating the conversation.
Multiconversational
In a multiconversation transaction, the database gateway server can be used to exchange multiple records in one call to the remote transaction program.
Refer to Remote Host Transaction Types in Chapter 4, Client Application Development of the Oracle Database Gateway for APPC User's Guide for more information on transaction types.
The following list demonstrates the power of the Oracle Database Gateway for APPC:
You can initiate a CICS transaction on the mainframe to retrieve data from a VSAM file for a PC application.
You can modify and monitor the operation of a remote process control system.
You can initiate an IMS/TM transaction that executes static SQL in DB2.
You can initiate a CICS transaction that returns a large number of records in a single call.
The Oracle Database Gateway for APPC using TCP/IP for IMS Connect supports three types of transaction socket connections:
The socket connection lasts across a single transaction.
The socket connection lasts across multiple transactions.
The socket connection lasts across a single exchange consisting of one input and one output.
Note: Do not use the nonpersistent socket type if you plan on implementing conversational transactions because multiple connects and disconnects will occur. |
Refer to pg4tcpmap Tool Commands in Chapter 6 of the Oracle Database Gateway for APPC User's Guide and to Chapter 12, "Gateway Configuration Using TCP/IP Communication Protocol" in this guide for more information about how to enter these parameters.
You can initiate an IMS/TM transaction that executes static SQL in DB2; this illustrates the power of the Oracle Database Gateway for APPC feature supporting TCP/IP for IMS Connect.
This chapter describes how to install and configure the Oracle Database Gateway for APPC. It contains the following sections:
Configuring an online transaction processor to allow access by the gateway requires actions on the OLTP and on certain components of the host operating system. Although no Oracle software is installed on the host system, access to, and some knowledge of the host system and the OLTP are required. Although this chapter includes some information about host system and OLTP installation steps, you must ensure that you have the applicable OLTP and host system documentation available.
Some configuration actions on the OLTP might require you to restart the OLTP. Ensure that your host system programmer or DBA review the instructions for your OLTP before you restart it.
To install and configure the gateway with a single Oracle database and a single OLTP, perform the procedures described in this chapter.
Note: If your gateway uses the SNA communication protocol, then follow the instructions for installation and configuration in this chapter, in Chapter 5, "Configuring Your Oracle Network", and in Chapter 11, "Gateway Configuration Using SNA Communication Protocol".If your gateway uses the TCP/IP communication protocol, then follow the instructions for installation and configuration in this chapter, in Chapter 5, "Configuring Your Oracle Network", and in Chapter 12, "Gateway Configuration Using TCP/IP Communication Protocol". |
This section is only for customers who have a previous release of Oracle Database Gateway for APPC. If you have a previous gateway installation, then you need to perform some tasks before you can install release 11.2 of the Oracle Database Gateway for APPC.
Note: After reading this section, you must read Chapter 14, "Migration From Existing Gateways" to determine the specific actions you must perform to prepare for upgrade or migration of your gateway. If you are migrating to Oracle Database Gateway for APPC release 11.2 from version 4.01 or earlier, then you will find content related to migrating the gateway in Chapter 14, "Migration From Existing Gateways".If you are installing Oracle Database Gateway for APPC for the first time, then begin with "Preinstallation Steps". |
This section includes the following topics:
Perform the following steps to prepare for upgrading the previous versions of Oracle Database Gateway for APPC to current versions:
Make backups of altered PGA shipped files.
Remove or rename any old gateway directories.
Upgrade considerations are as follows:
PGAU control files from Gateway release 8 or 9 are upward compatible and you do not need to change them.
After upgrade, the PG Data Dictionary (PG DD) contains all of its earlier entries without modification. New PGAU control information is added along with some columns to support new features, but no customer entries are altered by the upgrade.
All TIPs from Oracle Database Gateway for APPC release 4.0.1 or earlier must be recompiled because of the changes in the following:
PL/SQL compatibility
Gateway server RPC interface
UTL_PG
interface
If you have existing TIPs that were generated previously on a gateway using the SNA communication protocol and you want to utilize the new TCP/IP feature, then TIPs will have to be regenerated by PGAU with mandatory NLS_LANGUAGE
and Side Profile Settings. Specify the appropriate ASCII character set in the DEFINE TRANSACTION
command.
This is because the gateway assumes that the user exit in IMS Connect is being used, which would translate between the ASCII and EBCDIC character sets.
Before you install the gateway, perform the following pre-installation procedures:
Ensure that your system meets all of the hardware and software requirements specified in Chapter 3, "System Requirements".
Ensure that your security requirements are met.
Refer to Chapter 3, "System Requirements" for more information about the security requirements for connections and data access on your OLTP.
Fill out the worksheet identifying unique parameter names needed to configure your system and your chosen communication protocol (either SNA or TCP/IP), which is located in Appendix D, "Configuration Worksheet".
Decide on a SID (system identifier) for your gateway. This SID is used in "Configuring the Gateway".
The SID must be unique and must not be used by any other gateway or Oracle database on the system.
SNA only: Your SNA package must be installed and configured before you can proceed with installation of the gateway. Ensure that your system can communicate with the OLTP using the SNA communication package appropriate for your platform.
For more information about setting up and configuring the SNA communication package your platform needs to run the Oracle Database Gateway for APPC, refer to the appropriate chapter in this guide from the following list:
For Linux for Intel Pentium-based 32-bit systems, refer to Chapter 6, "Configuring the SNA Communication Package on Linux".
For AIX-Based Systems, refer to Chapter 7, " Configuring the SNA Communication Package on AIX-Based Systems".
For HP-UX, refer to Chapter 8, "Configuring the SNA Communication Package on HP-UX".
For Solaris Operating System (SPARC 64-bit), refer to Chapter 9, "Configuring the SNA Communication Package on Solaris".
TCP/IP only: Your TCP/IP package must be installed and configured before you can proceed with installation of the gateway.
Ensure that your system can communicate with the OLTP using the TCP/IP communication package for your platform.
If you need general information about installing Oracle products and using the Oracle Universal Installer, then refer to the Oracle Database Installation Guide.
You can install the gateway in any of the following ways:
On the same system as the existing Oracle database but in a different directory.
All tasks for this type of installation or upgrade are discussed in this section.
On a system different from a local Oracle database.
On the same system as the Oracle database, and in the same Oracle home directory. Note that in this case, the Oracle database and the gateway must be at the same Release level.
For general information about installing Oracle products and how to use the Oracle Universal Installer, refer to the Oracle Database Installation Guide and perform all necessary tasks there first.
If your server release is different than your gateway release, do not install the gateway in the same Oracle home directory as the Oracle database. This is required to isolate the gateway from the Oracle database upgrades that might cause incompatibilities if the gateway executables were relinked with later versions of the Oracle database libraries.
If you want to install the gateway in the same Oracle home as the Oracle database, then the release number of both products must be the same. This section provides the steps for installing the gateway. It contains the following topics:
Caution: Oracle Universal Installer automatically installs the Oracle-supplied version of the Java Runtime Environment (JRE). This version is required to run the Oracle Universal Installer and several Oracle assistants. Do not modify the JRE except by using a patch provided by Oracle Support Services. The Oracle Universal Installer also installs JDK. |
Oracle Universal Installer is a menu-driven utility that guides you through installing the gateway by prompting you with action items. The action items and the sequence in which they appear depend on your platform.
The following section describes how use the Oracle Universal Installer to install the gateway on your platform:
Use Table 4-1 as a guide to step through the Oracle Universal Installer. At each prompt from the Oracle Universal Installer, perform the actions described in the Response column of the table to install the gateway on your UNIX platform.
Table 4-1 The Oracle Universal Installer: Steps for Installing the Gateway
Prompt | Response |
---|---|
Oracle Universal Installer: Welcome |
Click Next. |
Oracle Universal Installer: Specify Inventory Directory and credentials |
a. Specify the full path of the inventory directory. b. Specify the operating system group name. c. Click Next. |
Oracle Universal Installer: Specify Home Details |
a. Specify the name of the installation. b. Specify the full path where you want to install the product. c. Click Next. |
Oracle Universal Installer: Available Product Components |
a. Deselect the checked products. b. Select "Oracle Database Gateway 11.2", open up this row. c. Select "Oracle Database Gateway for APPC 11.2". d. Click Next. |
Oracle Universal Installer: Network Software |
Specify your network package and click Next. |
Oracle Universal Installer: Summary |
Click Install. |
Oracle Net Configuration Assistance: Welcome |
Click Next. |
Oracle Net Configuration Assistance: Listener Configuration, Listener Name |
Specify the name of Listener you want to create and click Next. |
Oracle Net Configuration Assistance: Listener Configuration, Select Protocols |
Select the protocols and click Next. |
Oracle Net Configuration Assistance: Listener Configuration, TCP/IP Protocol |
Specify a port number and click Next. |
Oracle Net Configuration Assistance:Listener Configuration, More Listeners? |
Click "No" and then click Next. |
Oracle Net Configuration Assistance: Listener Configuration Done |
Click Next. |
Oracle net Configuration Assistance: Naming Methods Configuration |
Click No and then click Next. |
Oracle Net Configuration Assistance: Done |
Click Finish. |
Execute Configuration scripts |
You must run the |
Oracle Universal Installer: End of Installation |
Click Exit. |
When the Oracle Universal Installer confirms that the installation is complete, verify that the installation procedure was successful. To do this, read the contents of the installation log file, which is located in the $ORACLE_HOME/install
directory. The default file name is make.log
.
Attention: Print the contents of the$ORACLE_HOME/dg4appc/doc/README.doc file and read the entire document; it contains important information about the installation. After reading the README.doc file, proceed with configuration of the gateway. |
This section describes how to remove Oracle Database Gateway from an Oracle home directory. It contains information about the following topics:
The Deinstallation Tool (deinstall
) is available in the installation media before installation, and is available in Oracle home directories after installation. It is located in the path $ORACLE_HOME/deinstall
.
The deinstall
command stops Oracle software, and removes Oracle software and configuration files on the operating system.
The command uses the following syntax, where variable content is indicated by italics:
deinstall -home complete path of Oracle home [-silent] [-checkonly] [-local] [-paramfile complete path of input parameter property file] [-params name1=value name2=value . . .] [-o complete path of directory for saving files] [-help | -h]
The options are:
-silent
Use this flag to run the command in silent or response file mode. If you use the -silent
flag, then you must use the -paramfile
flag, and provide a parameter file that contains the configuration values for the Oracle home that you want to deinstall or deconfigure.
You can generate a parameter file to use or modify by running deinstall
with the -checkonly
flag. The deinstall
command then discovers information from the Oracle home that you want to deinstall and deconfigure. It generates the properties file, which you can then use with the -silent
option.
You can also modify the template file deinstall.rsp.tmpl
, located in the response folder.
-checkonly
Use this flag to check the status of the Oracle software home configuration. Running the command with the -checkonly
flag does not remove the Oracle configuration. The -checkonly
flag generates a parameter file that you can use with the deinstall command.
-local
Use this flag on a multinode environment to deconfigure Oracle software in a cluster.
When you run deconfig
with this flag, it deconfigures and deinstalls the Oracle software on the local node (the node where deconfig is run). On remote nodes, it deconfigures Oracle software, but does not deinstall the Oracle software.
-paramfile
complete path of input parameter property file
Use this flag to run deconfig with a parameter file in a location other than the default. When you use this flag, provide the complete path where the parameter file is located.
The default location of the parameter file depends on the location of deconfig:
From the installation media or stage location: $ORACLE_HOME/inventory/response
From a unzipped archive file from OTN: /ziplocation/response
After installation from the installed Oracle home: $ORACLE_HOME/deinstall/response
-params [name1=
value
name 2=
value
name3=
value . . .]
Use this flag with a parameter file to override one or more values that you want to change in a parameter file you have already created.
-o
complete path of directory for saving response files
Use this flag to provide a path other than the default location where the properties file (deinstall.rsp.tmpl
) is saved.
The default location of the parameter file depends on the location of deconfig:
From the installation media or stage location before installation: $ORACLE_HOME/
From a unzipped archive file from OTN: /ziplocation/response/
After installation from the installed Oracle home: $ORACLE_HOME/deinstall/response
-help | -h
Use the help option (-help
or -h
) to obtain additional information about the command option flags.
Complete the following procedure to remove Oracle software:
Log in as the installation owner.
Run the deinstall
command, providing information about your servers as prompted.
The Oracle Database Gateway for APPC uses the SNA Advanced Program to Program Communication (APPC/LU6.2) protocol to communicate with an OLTP. Linux for Intel Pentium-based 32-bit system support for APPC is provided by IBM Communications Server for Linux.
This chapter describes how to configure your SNA Server on a Linux for Intel Pentium-based 32-bit system to run the Oracle Database Gateway for APPC, using IBM Communications Server for Linux.
This chapter contains the following sections:
Note: The term SNA Server is used in this guide to generally refer to the IBM Communications Server. |
When the gateway receives an RPC request to start a remote transaction program, the gateway attempts to start an APPC conversation with online transaction processing (OLTP). Before the conversation can begin, a session must start between the Linux Logical Unit (LU) and the OLTP LU.
SNA and its various access method implementations (including SNA Server and VTAM) provide security validation at session initiation time, enabling each LU to authenticate its partner. This validation is carried out entirely by network software before the gateway and OLTP application programs begin their conversation and process conversation-level security data. If session-level security is used, then correct password information must be established in the gateway SNA Server definitions and in similar parameter structures in the OLTP to be accessed. Refer to the appropriate communications software product documentation for detailed information about this subject.
Many OLTPs provide options for manipulating the security conduct of an inbound (client) APPC session request. Refer to the appropriate OLTP documentation for detailed information about this topic.
Note: For CICS, one security option is not supported by the gateway:ATTACHSEC=PERSISTENT , specified in the CICS CONNECTION definition, requires capability that is not yet available in the gateway.
However, the |
Oracle recommends that you use independent LUs for the Oracle Database Gateway for APPC because they support multiple parallel sessions or conversations. This means that multiple Oracle client applications can be active simultaneously using the same OLTP through the independent LU.
Dependent LUs support only a single active session. The CP (Control Point for the node) queues additional conversation requests from the gateway server behind an already active conversation.In other words, conversations are single threaded for dependent LUs. If a gateway LU is correctly defined, then you do not need to alter the configuration for the Oracle Database Gateway for APPC and the gateway server.
The operational impact of dependent LUs is that the first client application can initiate a conversation through the Oracle Database Gateway with the gateway server. While that transaction is active (which could be seconds to minutes to hours, depending on how the client application and transaction are designed), any other client application initiating a session with the same gateway server appears to hang as it waits behind the previous session.
If a production application uses only a single conversation at any one time, then there should be no impact.
However, additional concurrent conversations might be required for testing or for other application development. Each conversation requires that you define additional dependent LUs on the remote host, plus additional IBM Communication Server configuration entries, which define the additional dependent LUs on the gateway system. Additional Side Information Profiles should be defined to use the new dependent LUs. New gateway instances should be created and configured to use these new Side Information Profiles.
See Also: Refer toPGAU DEFINE TRANSACTION SIDEPROFILE and LUNAME parameters in Chapter 2, "Procedural Gateway Administration Utility," in Oracle Database Gateway for APPC User's Guide |
Several types of IBM Communications Server definitions are relevant to gateway APPC/LU6.2 operation. Each definition can be created and edited using a corresponding SNA Node Configuration menu.The definitions relevant to the gateway are presented in Section 6.5 in hierarchical order. This section provides an overview of IBM Communications Server definitions in relation to the Oracle Database Gateway for APPC. Those definition types that are lowest in the hierarchy are discussed first. This matches the logical sequence in which to create the definitions.Refer to the IBM Communications Server online documentation for a complete discussion of IBM Communications Server definitions.
IBM Communications Server definitions are created using the SNA Node Configuration tool, while the operation of the server is done using the SNA Node Operations tool, both of which are provided with IBM Communications Server. Maintenance of SNA definitions is normally done by a user with Administrator privileges.
The following sections describe the process of creating SNA definitions for IBM Communications Server using the SNA Node Configuration tool. All of the tasks described in this section are performed within SNA Node Configuration.
The section includes the following topics:
The SNA Node Configuration screen prompts you to specify if you are creating a new configuration or loading an existing configuration. These tasks are based on the assumption that a new configuration is being created.
SNA Node Configuration next prompts you for a configuration scenario.
Each SNA Server must have a Control Point defined. This is typically called the Node definition. To define the node:
Click Node.
Click Create.
In the Define the Node dialog box:
Select the Basic tab.
Enter information in the Control Point, Local Node ID, and Node Type boxes.
You can select Advanced tab options depending on your SNA network configuration.
Click OK.
Select the type of device to use for communication. The LAN type is typical for either Ethernet or Token Ring attached network devices.
To configure a LAN device:
Select the Basic tab.
Choose the Adapter to use and the Local SAP. The other tabs provide options for network tuning parameters.
Click OK.
To define the link station:
In the Basic tab, enter a Link Station name for this connection.
Choose the device for the connection.
Enter the Destination address and Remote SAP.
To define the adjacent node:
Select the Adjacent Node tab.
Enter the Adjacent CP name of the remote system and select its CP type.
You might have to choose a different transmission group (TG) than the default. Consult your SNA network administrator for details.Other tabs provide options on tuning and reactivation.
Click OK.
To define local LUs:
In the Basic tab, enter the name of the Local LU, and, optionally, an alias. The name must match the Local LU definition of the remote host for this Node. You can examine the other tab for synchronization support and for LU session limits.
Click OK.
To define partner LUs:
In the Basic tab, enter the name of the Remote or Partner LU, and, optionally, an alias.
Choose the Fully Qualified CP from the Existing list. You can examine the other tab for logical record limits and security support.
Click OK.
Before proceeding with the gateway configuration tasks, ensure that your connection is working.
Figure 6-1 shows the relationship between SNA Server definitions and the VTAM definitions on the host.
Figure 6-1 SNA server definitions and VTAM
When you have finished configuring the SNA communication package for your Linux for Intel Pentium-based 32-bit System, proceed to Chapter 10, "Configuring the OLTP" to continue configuring the network.
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 13, "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 Section 12.8, "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 11.2.0.1.0 - Production on Thu Jun 11 15:09:00 2009 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/11.2) (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) )