Installing the Adapter for Oracle on z/VM

In this section: Creating Disk Space for the Adapter Linking to the FOCUS Maintenance and Production Disks Disabling Native SQL Commands (Optional) Linking to the Oracle USER and DBA Disks Running the GENFORA EXEC

The adapter installation consists of five tasks:

1. Creating disk space for the adapter.

2. Linking to the FOCUS maintenance and production disks.

3. Optionally disabling Native SQL commands.

4. Linking to the Oracle USER and DBA disks.

5. Running the GENFORA EXEC.

Creating Disk Space for the Adapter

In order to accommodate the adapter, you must increase the size of the FOCUS production minidisk. If you are using a 3390 disk pack, you must increase the space by an additional 2 cylinders above what is specified in the CMS Installation Guide.

Note:

• If you have not yet installed FOCUS, allocate the additional space when you create the FOCUS production disk.
• If you are unable to expand the size of the minidisk, create a new minidisk of the appropriate size, and copy the contents of the old FOCUS disk.

Linking to the FOCUS Maintenance and Production Disks

Link to the FOCUS maintenance disk with read/write privileges and access it as your A disk.

Then, link to the FOCUS production disk with read/write privileges and access it as your C disk.

If the FOCUS maintenance disk is not available, you must restore it using one of the following methods:

• Restore the disk from a backup or archive copy.
• Unload the FOCUS distribution tape to create a new maintenance disk. If you unload a distributed tape, make sure it is at the same maintenance level as your production version of FOCUS.

Disabling Native SQL Commands (Optional)

At this point, you may disable support for native SQL commands. The adapter can pass SQL statements, (for example, CREATE TABLE, INSERT, DROP TABLE), directly to the ORACLE RDBMS. To disable this function, edit the ORAPARMS ASSEMBLE file located on the FOCUS maintenance disk and change the line that reads:

  IMMED    DC   F'1'

to:

  IMMED    DC   F'0'

Save these changes and continue with the installation process.

Note: Currently, only the IMMED parameter in member ORAPARMS may be changed.

Linking to the Oracle USER and DBA Disks

In this section: Verifying the DCSS or NSS Name in ORADCSS ASSEMBLE Copying ORADCSS ASSEMBLE to the FOCUS Maintenance Disk Assembling ORADCSS

Link to the Oracle USER disk (normally the ORACLE 191 disk) in read-only mode and access it as any unused filemode. Your Oracle DBA can supply the exact link instructions for this minidisk. The Oracle USER disk contains text libraries required for installation. For Oracle Version 8.0 the required library is V8ORALNK.

Link to the Oracle DBA disk (normally the ORACLE 193 disk) in read-only mode and access it as any unused filemode. Your Oracle DBA can supply the exact link instructions for this minidisk.

Verifying the DCSS or NSS Name in ORADCSS ASSEMBLE

Examine the contents of the ORADCSS ASSEMBLE file located on the Oracle DBA disk. This file should contain the name of the Discontiguous Saved Segment (DCSS) or Named Saved Segment (NSS) that contains SQLLIB. This name should appear to the right of the CL8 statement in the CSECT. For example:

ORADCSS  CSECT
DC    CL8'segname'
END

The usual name for this segment is ORAUTLX. If an asterisk appears instead of a name, the CSECT does not contain a segment name. In either case, you must verify that the ORADCSS ASSEMBLE file contains the correct DCSS or NSS name before proceeding. If the DCSS or NSS name is less than eight characters, left justify and supply blanks for the full length of eight characters. For example:

'ORA1    '

Consult your Oracle DBA or Oracle RDBMS installer for this site-specific name.

Note: It is recommended that the address of the ORACLE segment not overlap the address of the FOCUS segment.

Copying ORADCSS ASSEMBLE to the FOCUS Maintenance Disk

Copy the ORADCSS ASSEMBLE file to the FOCUS maintenance disk, which you accessed as filemode A. Edit this file, if necessary, to include the name of the DCSS or NSS containing entry SQLLIB.

Assembling ORADCSS

Issue the following command to create an ORADCSS TEXT file on the FOCUS maintenance disk:

A ORADCSS

Running the GENFORA EXEC

In this section: Erasing ORADCSS ASSEMBLE and ORADCSS TEXT

Information Builders supplies a procedure on the FOCUS maintenance disk, the GENFORA EXEC, which links the adapter with Oracle. GENFORA creates a run-time module that is placed on the FOCUS production disk.

When you execute GENFORA, you must specify the Oracle version in use. For example, for Oracle version 8.0, issue the following command:

EXEC GENFORA 80

Erasing ORADCSS ASSEMBLE and ORADCSS TEXT

Erase the ORADCSS ASSEMBLE and ORADCSS TEXT files from the FOCUS maintenance disk accessed as filemode A.