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 UNIX. 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 9, "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 11, "Gateway Configuration Using TCP/IP Communication Protocol" to complete configuration of the gateway and its components.