Preface

Read this guide if you are responsible for performing tasks such as:

Running Oracle tools or utilities, such as SQL*Plus, Export, or SQL*Loader on OS/390 or z/OS
Designing or developing Oracle applications, using Pro*C, Pro*COBOL, Pro*PL/I, or Oracle Call Interface (OCI), that will run on an OS/390 or z/OS system.
Running Oracle application programs on OS/390 or z/OS

You need to understand the fundamentals of OS/390 operating systems before using this guide. This guide provides information only on Oracle9i products and their interactions with OS/390.

Structure

This guide contains the following chapters and appendixes:

Chapter 1	provides an overview of Oracle9i products.
Chapter 2	discusses basic information about installation tools and utilities needed for using Oracle9i Enterprise Edition for OS/390.
Chapter 3	discusses the interaction between OS/390 files and Oracle tools and utilities.
Chapter 4	discusses running Oracle tools under OS/390 UNIX System Services.
Chapter 5	describes the functions of the Export and Import utilities as they relate to the OS/390 operating system.
Chapter 6	discusses how the SQL*Loader utility capabilities are used with OS/390.
Chapter 7	discusses OS/390-specific information about using the Oracle Precompilers.
Chapter 8	discusses OS/390-specific information about using the Oracle Call Interface.
Chapter 9	discusses accessing and running SQL*Plus commands and procedures in an OS/390 environment.
Chapter 10	discusses using Oracle Net in an OS/390 environment.
Chapter 11	This chapter describes migration issues from an Oracle8 database with OSDI to an Oracle9i database, and with an earlier Oracle8 database with MPM to an Oracle9i database.
Appendix A	This appendix describes API short name support.

Product Name

The complete name for this product is Oracle9i Enterprise Edition for OS/390. To maintain readability and conciseness in this document, the Oracle9i Enterprise Edition is referred to as Oracle9i for OS/390.

In all cases, the referenced product remains Oracle9i Enterprise Edition for OS/390.

Tool and Utility Prompts

Certain Oracle tools and utilities operate interactively, displaying a prompt message in TSO or USS sessions when input is expected from the user. For example SQL*Plus uses "SQL>" and Recovery Manager uses "RMAN>". These prompts appear in examples but are not part of the text that is typed by the user.

Storage Measurements

Storage measurements use the following abbreviations:

K, for kilobyte, which equals 1,024 bytes
M, for megabyte, which equals 1,048,576 bytes
G, for gigabyte, which equals 1,073,741,824 bytes

Conventions

Examples of input and output to the system are shown in a special font:

//SYSIN   DSN=oran.orav.INSTJCL(member)

All output is shown as it actually appears. For input, the following conventions apply:

Convention	Meaning
`italic font`	indicates that a word or phrase of your choice must be substituted for the term in italic font, such as the actual member name. For example: `member`
`oran.orav`	is the standard example for high-level and second-level data set name qualifiers. Substitute your system's actual high-level and second-level qualifiers. These qualifiers may appear in lowercase or in UPPERCASE typeface.
`<>` Angle brackets	indicate that the enclosed arguments are required and at least one of the arguments must be entered. Do not enter the brackets themselves.
`[]` Square brackets	indicate that the enclosed arguments are optional. Do not enter the brackets themselves.
`{}` Braces	indicate that one of the enclosed arguments is required. Do not enter the braces themselves.
`\|` Vertical lines	separate choices.
`...` Ellipses	indicate that the preceding item can be repeated. You can enter an arbitrary number of similar items.
Other punctuation	must be entered as shown unless otherwise specified. For example, commas and quotes.

Commands, reserved words, and keywords appear in uppercase in both examples and text. A fileid can appear with both uppercase and lowercase text. When portions of a fileid appear in italics, the use of italic characters indicates that those portions can vary. Reserved words and keywords must always be entered as is, because they have reserved meanings within Oracle.

Documentation Accessibility

Oracle's goal is to make our products, services, and supporting documentation accessible to the disabled community with good usability. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For additional information, visit the Oracle Accessibility Program web site at http://www.oracle.com/accessibility/.

Documents Referenced in this Guide

Oracle9i for OS/390 Books:

Oracle9i Enterprise Edition Installation Guide for OS/390

Oracle9i Enterprise Edition Messages Guide for OS/390

Oracle9i Enterprise Edition System Administration Guide for OS/390

Other Oracle Books:

OCI Programmer's Guide

Oracle Intelligent Agent User's Guide

Oracle Label Security Administrator's Guide

Oracle9i Application Developer's Guide - Fundamentals

Oracle9i Database Globalization Support Guide

Oracle9i Database Utilities

Oracle9i JDBC Developer's Guide and Reference

Oracle9i Net Services Administrator's Doc

PL/SQL User's Guide and Reference

Pro*C/C++ Precompiler Programmer's Guide

Pro*COBOL Precompiler Programmer's Guide

Pro*PL/I Supplement to the Oracle Precompilers Guide

Programmer's Guide to the Oracle Precompilers

SQL*Plus User's Guide and Reference

IBM Books:

OS/390 Run Time Library Reference