Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

• Intended Audience
• Documentation Accessibility
• Product Name
• Typographic Conventions
• Command Syntax
• Related Publications
• Related Documents

1 Introduction

• Introduction to Message Queuing
• Introduction to WebSphere MQ
• • WebSphere MQ Terms
• Introduction to the Gateway
• • Developing Gateway Applications
  • Gateway Terms
  • Advantages of Using the Gateway
  • Gateway Architecture
  • Component Descriptions
  • • Oracle Applications
    • Oracle Integrating Server
    • Oracle Net
    • Gateway
    • WebSphere MQ Queue Manager
    • WebSphere MQ Application
  • Gateway Structure
  • Gateway Operation

2 Release Information

• Changes and Enhancements
• • Changes and Enhancements for Release 10.2.0
  • • Oracle Server Dependencies
  • Changes and Enhancements for Release 10.2.0
  • • Support for Large Data Buffers
    • PGM_UTL Procedures
    • PG4MQ API Prototype Changes
    • Heterogeneous Services Architecture
    • Performance Enhancements
    • New PG4MQ Packages
    • New PG4MQ Deployment Scripts
    • Large Payload Support
    • Database Link and Alias Library
• Known Problems for 10g Release 2
• Known Restrictions for 10g Release 2

3 Requirements

• Hardware Requirements
• Software Requirements
• Oracle Integrating Server
• Related Documentation

4 Preinstallation

• Preinstallation Tasks
• • WebSphere MQ Software
  • Setting Environment Variables
  • • ORACLE_HOME
    • Preventing Conflicts Between ORACLE_HOME Directories
    • Setting ORACLE_HOME
    • Setting ORACLE_SID
    • DISPLAY
    • On Server where the Installer is Running
    • In Session on Your Workstation
    • TMP
• About Oracle Universal Installer
• • oraInventory Directory
  • Starting Oracle Universal Installer

5 Installation

• Installation
• Running root.sh

6 Deinstallation and Reinstallation

• Deinstallation
• • Deinstalling Using Oracle Universal Installer
  • Deinstalling Oracle Procedural Gateway for WebSphere MQ
• 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
  • • Step 1: Choose a System ID for the Gateway
    • Step 2: Customize the Gateway Initialization File
• Configuring Oracle Net for the Gateway
• • Using Oracle Net with Default Gateway Values
  • Using Oracle Net When Changing the Default Gateway Values
  • • Step 1: Configure the Oracle Net TNS Listener for the Gateway
    • Step 2: Stop and Start the TNS Listener for the Gateway
• Configuring Oracle Net for Oracle Integrating Server
• • Using Default Gateway Values
  • Changing Default Gateway Values
  • • TCP/IP Example
    • IPC Example
• Creating a Transaction Log Queue
• Administering the Database Links Alias Library
• • Using Database Links
  • Creating Database Links
  • Examining Available Database Links
  • Creating Alias Library
  • Dropping Alias Library
• Installing the Oracle Visual Workbench Repository
• • Preinstallation Tasks
  • • Step 1: Choose a Repository Server
    • Step 2: Locate the Installation Scripts
    • Step 4: Ensure that the UTL_RAW Package is Installed
    • Step 5: Ensure that the DBMS_OUTPUT Package is Enabled
    • Step 6: Create a Database Link
  • Visual Workbench Repository Installation Tasks
  • • Step 1: Enter the Database Connection Information
    • Step 2: Check for Existing Workbench Repository
    • Step 3: Check for The Required PL/SQL Packages
    • Step 4: Install the UTL_PG Package
    • Step 5: Create the Administrative User and All Repository Tables
    • Step 6: Create Public Synonyms and Development Roles
  • After the Repository is Created
  • Deinstall the Visual Workbench Repository
  • • Step 1: Enter the Database Connection Information
    • Step 2: Check for the Existing 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 Process for a WebSphere MQ Server Application
    • Authorization Process for a WebSphere MQ Client Application
  • Authorization for WebSphere MQ Objects
• Transaction Support
• • Non-Oracle Data Sources and Distributed Transactions
  • Transaction Capability Types
  • Transaction Capability Types of Procedural Gateway for WebSphere MQ
  • • Single-Site Transactions
    • Commit-Confirm Transactions
• Troubleshooting
• • Message and Error Code Processing
  • • Interpreting Gateway Messages
  • Common Error Codes
  • Gateway Tracing
  • • LOG_DESTINATION Parameter
  • Verifying Gateway Operation

A The PGM, PGM_UTL8, and PGM_SUP Packages

• PGM Package, PG4MQ Gateway Procedures, and Data Type Definitions
• • Summary of Procedures and Type Definitions
  • Procedure Conventions
  • MQI Calls Performed by the Gateway
  • Unsupported MQI Calls
  • Migration Tips
• MQCLOSE Procedure
• MQGET Procedure
• • PGM.MQMD Type Definition
  • PGM.MQGMO Type Definition
• MQOPEN Procedure
• • PGM.MQOD Type Definition
• MQPUT Procedure
• • PGM.MQPMO Type Definition
• PGM_SUP Package
• • PGM.MQGMO Values
  • • OPTIONS Field
    • VERSION Field
    • MATCHOPTIONS Field
    • WAITINTERVAL
  • PGM.MQMD Values
  • • CODEDCHARSETID Field
    • ENCODING Field
    • ENCODING Field, Values for Binary Integers
    • ENCODING Field, Values for Floating Point Numbers
    • ENCODING Field, Mask Values
    • ENCODING Field, Values for Packed Decimal Integers
    • EXPIRY Field
    • FEEDBACK Field
    • FORMAT Field
    • MSGTYPE Field
    • PERSISTENCE Field
    • PRIORITY Field
    • PUTAPPLTYPE Field
    • REPORT Field
    • VERSION Field
    • Report Field, Mask Values
  • PGM.MQOD Values
  • • OBJECTTYPE Field
    • OBJECTTYPE Field, Extended Values
    • VERSION Field
  • PGM.MQPMO Values
  • • OPTIONS Field
    • VERSION Field
  • MQCLOSE Values
  • • hobj Argument
    • options Argument
  • MQOPEN Values
  • • options Argument
  • Maximum Lengths for Fields of PGM 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
• • LOG_DESTINATION
  • AUTHORIZATION_MODEL
  • QUEUE_MANAGER
  • TRACE_LEVEL
  • TRANSACTION_LOG_QUEUE
  • TRANSACTION_MODEL
  • TRANSACTION_RECOVERY_PASSWORD
  • TRANSACTION_RECOVERY_USER

Index