Oracle Transparent Gateway® for EDA/SQL

Release Notes

Release 8.0.4.1.2 for IBM OS/390 (MVS)

January 2002

Part No. A96179-01

RELEASE NOTES

PATCHSET TO BE APPLIED TO BASE RELEASE 8.0.4.1.0

This release of the Oracle Transparent Gateway for EDA/SQL is a patchset to be applied on top of the base release 8.0.4.1.0. The base release must be installed before installing this patchset.

This patchset is for use with EDA/SQL Server release 4.3.5 only.

Earlier releases of Oracle Transparent Gateway for EDA/SQL will not work with EDA/SQL Server release 4.3.5. This release of Oracle Transparent Gateway for EDA/SQL must not be used with EDA/SQL Server releases prior to release 4.3.5.

Installing Oracle Transparent Gateway for EDA/SQL

One distribution tape contains the following two files:

ORACLE.TG4EDA.V80412.INSTALL

This file contains installation JCL and release notes about this patchset.
ORACLE.TG4EDA.V80412.AUTHLOAD

This file contains the replacement modules for the Gateway AUTHLOAD library.

Installation Checklist

Step 1: Copy the INSTALL data set from the distribution tape.

To copy the ORACLE.TG4EDA.INSTALL file from the distribution tape, create and run an IEBCOPY job similar to the following example:

//jobname JOB (001),'COPY TG4EDA',
//   CLASS=a,MSGCLASS=X,REGION=4096K,
//   NOTIFY=&SYSUID
//STEP1     EXEC PGM=IEBCOPY,REGION=5M
//SYSPRINT  DD   SYSOUT=*
//IN        DD   DSN=ORACLE.TG4EDA.V80412.INSTALL,
//           DISP=(OLD,KEEP),
//           VOL=SER=OS0201,
//           LABEL=(1,SL,EXPDT=98000),
//           UNIT=tapedrv
//OUT       DD  DSN=ora.tg4eda.v80412.INSTALL,
//           DISP=(NEW,CATLG,DELETE),
//           UNIT=SYSDA,
//           VOL=SER=volser,
//           DCB=(RECFM=FB,LRECL=80,BLKSIZE=27920),
//           SPACE=(27920,(100,50,20),RLSE)
//SYSIN     DD   *
  COPY INDD=IN,OUTDD=OUT
/*
//

where:

jobname

is the name of the IEBCOPY job.

a

is the job class.

ora.tg4eda.v80412

is the high-level qualifier to be used for the Oracle Transparent Gateway for EDA/SQL patchset libraries. These need to be different from the high-level qualifiers that are used for your base 8.0.4.1.0 Gateway libraries.

tapedrv

is the tape drive name where you mount the distribution tape.

volser

is the volume serial number of the disk for the new Gateway INSTALL data set.

After the IEBCOPY job has successfully completed with a return code of zero, the ora.tg4eda.v80412.INSTALL data set contains the following members:

$INDEX

This member contains a table of contents for the library.
$README

This member contains brief installation information.
BUGS

This member contains a list of bugs that are fixed in this release 8.0.4.1.2 patchset.
INSTALL

This member contains JCL to load the libraries for Oracle Transparent Gateway for EDA/SQL.
MPM

This member contains information on changes to MPM that are included in the patchset.
NOTES

This member contains any extra information (e.g., problems or restrictions) that is not included in the Release Notes.

Step 2: Copy the remaining file from the distribution tape.

The INSTALL job that is provided in the ora.tg4eda.v80412.INSTALL data set is used to copy the remaining data set from the distribution tape. This job must be customized for your installation by doing the following:

Change all occurrences of ora.eda to the high-level qualifiers that are to be used for the Oracle Transparent Gateway for EDA/SQL patchset data sets. Normally this would be the same value that you specified for ora.tg4eda.v80412 in Step 1.
Change all occurrences of oravol to the volume serial number of the disk that you want to use for the new Gateway library.
Change all occurrences of 3480 to the tape unit specification on which the distribution tape will be mounted.

After the job is customized for your installation, you can submit it. This job requires the distribution tape to be mounted.

Step 3: Authorize the Gateway AUTHLOAD library.

You must APF-authorize the Gateway AUTHLOAD library. Your OS/390 system might need to be IPLed before this change takes effect.

To mark the Gateway AUTHLOAD library as authorized, use the ISPF EDIT command, the IEBUPDTE utility, or an equivalent function to add the library name to the appropriate PROGxx member in the SYS1.PARMLIB library.

The simplest method for updating the SYS1.PARMLIB library is to use the ISPF EDIT command to edit the library directly.

Step 4: IPL your system, if necessary.

On systems that support the SETPROG system command, the Gateway AUTHLOAD library can be APF-authorized dynamically using SETPROG. Use this system command to avoid an IPL. However, you must still make the previously mentioned change to the SYS1.PARMLIB library in order to make the APF entry permanent.

You can either IPL OS/390 or use the SETPROG system command to ensure that the Gateway AUTHLOAD is APF-authorized before attempting to start your Gateway.

Step 5: Update your Gateway Procedures.

Update your existing Oracle Transparent Gateway for EDA/SQL procedure by concatenating the new Gateway AUTHLOAD library before the base release 8.0.4.1.0 Gateway AUTHLOAD library on the STEPLIB DD statement. If you have been using a release 8.0.4.1.1 patchset AUTHLOAD, then it can be removed from the STEPLIB concatenation because this patchset is cumulative and includes all the fixes that were included in that earlier patchset.

Update your existing TNS (SQL*Net) JCL by concatenating the new Gateway AUTHLOAD library before the base release 8.0.4.1.0 Gateway AUTHLOAD on the STEPLIB DD statement. If you have been using a release 8.0.4.1.1 patchset AUTHLOAD, then it can be removed from the STEPLIB concatenation because this patchset is cumulative and includes all the fixes that were included in that earlier patchset.

Restart

After the installation steps are complete, restart your Gateway and TNS.

Oracle is a registered trademark, and Oracle Transparent Gateway and SQL*Net are trademarks or registered trademarks of Oracle Corporation. Other names may be trademarks of their respective owners.