2
Release Information

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

The Product Set
Changes and Enhancements
Known Problems for Release 9.2.0.1.0
Known Restrictions for Release 9.2.0.1.0

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.

2 Release Information