Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Introduction

Introduction to Message Queuing

Introduction to IBM MQSeries

MQSeries Terms

Introduction to the Gateway

Developing Gateway Applications

Gateway Terms

Advantages of Using the Gateway

Gateway Architecture

Component Descriptions

Gateway Structure

Starting the Gateway

Communication

2 Release Information

The Product Set

Changes and Enhancements for Version 9.0.1.1.1

Changes

Enhancements

Known Problems

Known Restrictions

3 Requirements

Hardware Requirements

Software Requirements

Certified Software

Recommended Documentation

4 Pre-installation

Preinstallation Tasks

MQSeries Software

About Oracle Universal Installer

oraInventory Directory

Starting Oracle Universal Installer

5 Installation

Installation

Start the Oracle Universal Installer

Installing the Gateway from CD-ROM

Step 1: Log on to the Pentium-Based host

Step 2: Load the CD-ROM into the CD-ROM Drive

Step 3: Start the Oracle Universal Installer on MS Windows NT

Step 4: Step through the Oracle Universal Installer

Running root.sh

6 Deinstallation and Reinstallation

Deinstallation

Deinstalling Using Oracle Universal Installer

Deinstalling Oracle9i Procedural Gateway for IBM MQSeries

Reinstallation

7 Configuration

Configuration Overview

Configuring the Gateway

Using the Gateway with the Default Values

Using the Gateway without the Default Values

Changing Default Values

Configuring Oracle Net for the Gateway

Using Oracle Net with Gateway Default Values

Using Oracle Net When Changing the Gateway Default Values

Configuring Oracle Net for the Oracle Integrating Server

Using Gateway Default Values

Changing Gateway Default Values

Creating a Transaction Log Queue

Administering Database Links

Creating Database Links

Dropping Database Links

Examining Available Database Links

Limiting the Number of Active Database Links

Installing the Visual Workbench Repository

Preinstallation Tasks

Visual Workbench Repository Installation Tasks

After the Repository is Created

Deinstall the Visual Workbench Repository

Preparing the Production Oracle Server

Introduction

Verifying and Installing PL/SQL Packages

Removing the PL/SQL Packages

8 Gateway Running Environment

Security Models

Relaxed Model

Strict Model

Authorization for MQSeries Objects

Transaction Support

Single-Site

Commit-Confirm

Troubleshooting

Message and Error Code Processing

Common Error Codes

Gateway Tracing

Verifying Gateway Operation

9 Heterogeneous Message Propagation

Heterogeneous Message Propagation Option

Oracle Advanced Queuing (AQ)

Operational and Administrative Interfaces

Outbound Interfaces

Inbound Interfaces

Heterogeneous Outbound Propagation

Outbound Propagation in General

Heterogeneous Inbound Propagation

Inbound Propagation in General

10 Installing Heterogeneous Message Propagation

Oracle Software Requirement

Installing the Heterogeneous Message Propagation Option

PL/SQL^TM Installation Scripts

Installation

Privileges and Access Control

Verifying the Heterogeneous Message Propagation Option

Deinstalling the Heterogeneous Message Propagation Option

11 Configuring Heterogeneous Outbound Message Propagation

Overview of Outbound Message Propagation

Translation of Oracle AQ/IBM MQSeries Interfaces

Translation for Outbound Propagation for MQSeries

Configuring Outbound Message Propagation

Operational Interface for Individual Messages

Operational Interface for Queues

Oracle AQ Procedures and Structures

Administrative Interfaces

Procedures for Outbound Message Propagation

Example

Security

Exception Handling

Schedule Status

Status of an Outbound Message Propagation Schedule

12 Configuring Heterogeneous Inbound Message Propagation

Overview of Inbound Message Propagation From MQSeries

Translation of MQSeries/Oracle AQ Interfaces

Translations for inbound propagation for MQSeries:

Configuring Inbound Message Propagation

Operational Interface

Administrative Interface

Procedures for Inbound Message Propagation

Example

Security

Exception Handling

Schedule Status

A The PGM8, PGM_UTL8, and PGM_SUP Packages

PGM8 Package and PG4MQ Gateway Procedures

Summary of Procedures and Type Definitions

Procedure Conventions

MQI Calls Performed by the Gateway

Unsupported MQI Calls

Migration Tips

MQCLOSE Procedure

MQGET Procedure

PGM8.MQMD Type Definition

PGM8.MQGMO Type Definition

MQOPEN Procedure

PGM8.MQOD Type Definition

MQPUT Procedure

PGM8.MQPMO Type Definition

PGM_SUP Package

PGM8.MQGMO Values

PGM8.MQMD Values

PGM8.MQOD Values

PGM8.MQPMO Values

MQCLOSE Values

MQOPEN Values

Maximum Lengths for Fields of PGM8 Type Definitions

Error Code Definitions

B UTL_RAW Package

Message Data Types

UTL_RAW Functions

UTL_RAW.TO_RAW

UTL_RAW.BIT_AND

UTL_RAW.BIT_COMPLEMENT

UTL_RAW.BIT_OR

UTL_RAW.BIT_XOR

UTL_RAW.CAST_TO_RAW

UTL_RAW.CAST_TO_VARCHAR2

UTL_RAW.COMPARE

UTL_RAW.CONCAT

UTL_RAW.CONVERT

UTL_RAW.COPIES

UTL_RAW.LENGTH

UTL_RAW.OVERLAY

UTL_RAW.REVERSE

UTL_RAW.SUBSTR

UTL_RAW.TRANSLATE

UTL_RAW.TRANSLITERATE

UTL_RAW.XRANGE

C Gateway Initialization Parameters

Gateway Initialization File

Gateway Parameters

HS_DB_DOMAIN

HS_DB_NAME

LOG_DESTINATION

AUTHORIZATION_MODEL

QUEUE_MANAGER

TRACE_LEVEL

TRANSACTION_LOG_QUEUE

TRANSACTION_MODEL

TRANSACTION_RECOVERY_PASSWORD

TRANSACTION_RECOVERY_USER

D Heterogeneous Message Propagation DBA Views

DBA_OUTBOUND_SCHEDULES:

DBA_INBOUND_SCHEDULES:

Index