Preface

The Oracle9i release of the Oracle Procedural Gateway and Tools for IBM MQSeries provides access to MQSeries services.  This gateway requires a host with or without multiple processors that is capable of running 64-bit applications.  The UNIX platforms supported by this gateway release are: Sun Solaris Operating System (SPARC), IBM RS/6000 AIX-based system, Hewlett-Packard 9000 Series 700 or 800.

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

• administering the gateway

• setting up gateway security

• using the gateway

• diagnosing gateway errors

Understand the fundamentals of your operating system, the procedural gateways, PL/SQL, the Oracle server, and MQSeries software before using this guide to install, configure, or administer the gateway.

Intended Audience

This guide is intended for anyone responsible for installing, configuring, or administering the Oracle9i Procedural Gateway for IBM MQSeries, and also for developers writing applications that access message queuing systems, especially for those who need to access queues owned by both IBM MQSeries and other non-Oracle message queuing systems as well as queues owned by Oracle Advanced Queuing (AQ).

Documentation Accessibility

Our goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disabled community.  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 Corporation 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/.

Accessibility of Code Examples in Documentation

JAWS, a Windows screen reader, may not always correctly read the code examples in this document.  The conventions for writing code require that closing braces should appear on an otherwise empty line; however, JAWS may not always read a line of text that consists solely of a bracket or brace.

Product Name

The complete name for this product is Oracle Procedural Gateway and Tools for IBM MQSeries, also called Oracle9i Procedural Gateway for IBM MQSeries with this release, and also called PG4MQ.

Conventions

Examples of input and output for the gateway and Oracle environment are shown in a special font:

$ mkdir /ORACLE/your_name 

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

Convention	Meaning
example text	Words or phrases, such as mkdir and ORACLE, must be entered exactly as spelled and in the letter case shown.  In this example, mkdir must be entered in lowercase letters and ORACLE in uppercase.
italic text	Italicized uppercase or lowercase, such as your_name, indicates that you must substitute a word or phrase, such as the actual directory name.
{ }	Curly braces indicate that one of the enclosed arguments is required.  Do not enter the braces themselves.
[ ]	Square brackets indicate that the enclosed arguments are optional.  Do not enter the brackets 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, such as commas, quotes, or the pipe symbol (|), must be entered as shown unless otherwise specified.  Directory names, fileids, and so on appear in the required letter case in examples.  The use of italics in a fileid indicates that those portions that are in italics can vary.

Gateway commands, fileids, reserved words, and keywords appear in uppercase in examples and text.  UNIX commands, environment variables, and keywords appear in the required letter case in examples and text.  Reserved words and keywords must always be entered as shown because they have reserved meanings within the Oracle system.

The PGM8 procedures follow a slightly different set of convention rules.  Refer to "Procedure Conventions" for more information.

Related Publications

A supporting Oracle document, Oracle9i Heterogeneous Connectivity Administrator's Guide, contains information common to all procedural gateways, including important information on functions, parameters, and error messages.

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.

UNIX Prompts

The UNIX prompt, $, appears in UNIX command examples.  Enter your response at the prompt.  Do not enter the text of the prompt, "$", in your response.  A dollar sign is part of some UNIX directory names and should not be confused as a prompt character.

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

Documents Referenced in this Guide

Oracle Call Interface Programmer's Guide

Oracle9i Database Administrator's Guide

Oracle9i Database Error Messages

Oracle9i Database Reference

Oracle9i Database Utilities

Oracle9i Heterogeneous Connectivity Administrator's Guide

Oracle9i Net Services Administrator's Guide

Oracle9i Net Services Reference Guide

Oracle9i Security Overview

Oracle9i SQL Reference

Oracle9i Supplied PL/SQL Packages and Types Reference

PL/SQL User's Guide and Reference

Oracle9i Administrator's Reference Release 2 (9.2.0.1.0) for UNIX Systems: AIX-Based Systems, Compaq Tru64 UNIX, HP 9000 Series HP-UX, Linux Intel, and Sun Solaris

Oracle9i Installation Guide Release 2 (9.2.0.1.0) for UNIX Systems: AIX-Based Systems, Compaq Tru64 UNIX, HP 9000 Series HP-UX, Linux Intel, and Sun Solaris

Oracle Visual Workbench for Oracle Procedural Gateways for IBM MQSeries Installation and User's Guide