Preface

Intended Audience

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

Using User's Guide
Using any of the tools, such as SQL*Plus, on OS/390
Using the Oracle utilities for OS/390
Using the Oracle Programmatic Interfaces on OS/390
Remote access to Oracle on OS/390 as well as accessing remote Oracle databases for OS/390

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.

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.

SQL*Plus Prompts

The SQL*Plus prompt, SQL>, appears in SQL statement and SQL*Plus command examples. Enter your response at the prompt. Do not enter the text of the prompt, SQL>, in your response.

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 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.

Switches

Switches are listed with a brief description and any OS/390-specific information. Refer to the product-specific documentation for syntax and a thorough description of its purpose. Before using a command line option switch, such as -A or -C, refer to the appropriate product-specific documentation.

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

Oracle9i Enterprise Edition User's Guide for OS/390

Other Oracle Books:

Oracle Advanced Security Administrator's Guide

Oracle Call Interface Programmer's Guide

Oracle Intelligent Agent User's Guide

Oracle9i Net Services Administrator's Guide

Oracle Technical Publications Catalog and Price Guide

Oracle9i Application Developer's Guide - Fundamentals

Oracle9i Application Developer's Guide - XML

Oracle9i Globalization and National Language Support Guide

Oracle9i JDBC Developer's Guide and Reference

Oracle9i Utilities

Oracle9i XML Reference

PL/SQL User's Guide and Reference

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

Pro*COBOL Precompiler Programmer's Guide

Pro*FORTRAN Supplement to the Oracle Precompilers Guide

Pro*PL/I Supplement to the Oracle Precompilers Guide

Programmer's Guide to the Oracle Precompilers

SQL*Plus User's Guide and Reference