Skip Headers

Oracle® Procedural Gateway and Tools for IBM MQSeries Installation and User's Guide
Release 9.2.0.1.0 for UNIX
Part No. A96196-01
Go To Table Of Contents
Contents
Go To Index
Index

Previous Next

2
Release Information

This chapter contains information specific to Release 9.2.0.1.0 of the gateway:

The Product Set

The following table lists the release numbers of the components included with the Oracle9i server.

Product Release Number
Oracle9i Procedural Gateway for IBM MQSeries 9.2.0.1.0
Oracle Net 9.2.0.1.0

Changes and Enhancements

The following changes and enhancements are for all releases of the Oracle9i gateway products.

Changes and Enhancements for Release 9.2.0.1.0

For heterogeneous message propagation, refer to Chapter 9.

Oracle Server Dependencies

This release of the Oracle Procedural Gateway and Tools for IBM MQSeries requires the latest released patch set for Oracle9i server release 9.2 or release 9.0.1, or Oracle8i server release 8.1.7.

Password Encryption Utility

This release of the Oracle Procedural Gateway and Tools for IBM MQSeries includes a utility to support encryption of plain text passwords in the Gateway Initialization File.  For more information, refer to "TRANSACTION_RECOVERY_PASSWORD" on page C-8.

Changes and Enhancements for Release 9.0.1.0.1

The following changes and enhancements are for the previous release of the Oracle9i gateway products.

HS= Parameter in tnsnames.ora file

When configuring the connect descriptor entry in tnsnames.ora for the gateway, the release 8.0.4 gateway used (HS=(DRIVER=)), and the release 9.0.1.0.1 gateway uses (HS=OK). Refer to "Configuring Oracle Net for the Oracle Integrating Server" for details.

PG4MQ Data Types

Data Type V401 V804 V817 and V901
MQOD PGM.MQOD@dblink PGM.MQOD PGM8.MQOD
MQMD PGM.MQMD@dblink PGM.MQMD PGM8.MQMD
MQPMO PGM.MQPMO@dblink PGM.MQPMO PGM8.MQPMO
MQGMO PGM.MQGMO@dblink PGM.MQGMO PGM8.MQGMO
MQODRAW N.A. PGM.MQODRAW PGM8.MQODRAW
MQMDRAW N.A. PGM.MQMDRAW PGM8.MQMDRA
MQPMORAW N.A. PGM.MQPMORAW PGM8.MQPMORAW
MQGMORAW N.A. PGM.MQGMORAW PGM8.MQGMORAW

PGM_UTL Procedures

Procedure V401 V804 V817 and V901
TO_RAW N.A. PGM_UTL.TO_RAW PGM_UTL8.TO_RAW
RAW_TO_MQMD N.A. PGM_UTL.RAW_TO_MQMD PGM_UTL8.RAW_TO_MQMD
RAW_TO_MQPMO N.A. PGM_UTL.RAW_TO_MQPMO PGM_UTL8.RAW_TO_MQPMO
RAW_TO_MQGMO N.A. PGM_UTL.RAW_TO_MQGMO PGM_UTL8.RAW_TO_MQGMO

PG4MQ API prototype changes

API V401 arguments V804 arguments V817 & V901 arguments
MQOPEN (MQOD,INT,INT) (RAW,INT,INT) (RAW,INT,INT)
MQPUT (INT,MQMD,MQPMO,RAW) (INT,RAW,RAW,RAW) (INT,RAW,RAW,RAW)
MQGET (INT,MQMD,MQGMO,RAW) (INT,RAW,RAW,RAW) (INT,RAW,RAW,RAW)
MQCLOSE (INT,INT) (INT,INT) (INT,INT)

Refer to Appendix A for the details of APIs.

Heterogeneous Services Architecture

This release of the Oracle9i Procedural Gateway for IBM MQSeries utilizes the Oracle Heterogeneous Services component within the Oracle9i server.

For additional information, refer to Oracle9i Heterogeneous Connectivity Administrator's Guide.

Performance Enhancements

Oracle9i Procedural Gateway for IBM MQSeries contains several internal performance enhancements.  This product has shown major improvements in response time and CPU utilization for all relevant address spaces for a variety of workloads compared to version 4 gateways.  The actual performance improvement at your site might vary, depending upon your installation type and workload.

New PG4MQ Packages

PGM8 and PGM_UTL8 packages are new in this release.  These packages provide new features as well as ensure backward compatibility.  Refer to "Migration Tips" in Appendix A for the details of upgrading your existing PL/SQL application programs to use Oracle9i PG4MQ features.

Bugs Fixed

Table 2-1 Bugs Fixed in Release 9 of the Gateway

Bug Number Description
2329347 GATEWAY HANGS OR GIVES ORA-4062 ON MQGET CALL TO EMPTY QUEUE
2321389 PG4MQ 9.2.0.1.0 PG4MQ FAILS WHEN AUTHORIZATION_MODE=STRICT
2321387 TRANSACTION RECOVERY USER/PASSWORD IS SET AND CHECKED INCORRECTLY.
2182483 MQMD.USERIDENTIFIER CONTAINS WHITE SPACES AND CAUSED MQ-IMS BRIDGE FAILURE
2147453 BROWSE OPTION OF THE PGM.MQGET PACKAGE RETURNS ONLY 1 MESSAGE.
2115441 PUTDATE AND PUTTIME ARE NOT REPORTED TO THE QUEUE
2074241 MQPUT.MQMD.USERIDENTIFIER NOT POSTED CORRECTLY UNDER VERSION 8
2026117 ORA-4062 WHEN SENDING MESSAGES > 4000 BYTES, WHILE SMALLER MESSAGES ARE OK
1925901 PG4MQ9I RETRUNS ORA-4062 WHEN TRANSACTION_MODE IS SET TO COMMIT_CONFIRM
1918699 LONG MESSAGES CAN NOT BE PASSED TO PGM.MQPUT/PGM.MQGET PROCEDURES
1917293 VERSION 8 OF THE GATEWAY DOES NOT CREATE THE COORRECT MSG HDR FOR MQSERIES MSG
1897823 ORA-4062 WHEN RUNNING A MIP

Known Problems for Release 9.2.0.1.0

The problems documented in this section are specific to the Oracle Procedural Gateway for IBM MQSeries and are known to exist in this release of the product.  These problems will be fixed in a future gateway release.  If you have any questions or concerns about these problems, contact Oracle Support Services.

A current list of problems is available online.  Contact your local Oracle Corporation office for information about accessing this online information.

Known Restrictions for Release 9.2.0.1.0

The following restrictions are known to exist for the products in this release.  Restrictions are not scheduled to change in future releases.


32K buffer size limitation

The buffer sizes of MQPUT and MQGET gateway function calls are limited to 32K (32767) bytes due to the limitation of PL/SQL RAW data type.


Encrypted Format Login

If the DBLINK_ENCRYPT_LOGIN parameter is set to TRUE in the initialization parameter file (initSID.ora) for the database that is used by the Oracle client, then you must change the setting to FALSE to allow Oracle to communicate with the gateway.


Previous Next
Oracle Logo
Copyright © 2001, 2002 Oracle Corporation

All rights reserved
Go To Table Of Contents
Contents
Go To Index
Index