Oracle® Procedural Gateway and Tools for IBM MQSeries Installation and User's Guide
Release 22.214.171.124.0 for UNIX
Part No. A96196-01
This chapter contains information specific to Release 126.96.36.199.0 of the gateway:
The following table lists the release numbers of the components included with the Oracle9i server.
|Oracle9i Procedural Gateway for IBM MQSeries||188.8.131.52.0|
The following changes and enhancements are for all releases of the Oracle9i gateway products.
For heterogeneous message propagation, refer to Chapter 9.
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.
The following changes and enhancements are for the previous release of the Oracle9i gateway products.
When configuring the connect descriptor entry in tnsnames.ora for the gateway, the release 8.0.4 gateway used
(HS=(DRIVER=)), and the release 184.108.40.206.1 gateway uses
(HS=OK). Refer to "Configuring Oracle Net for the Oracle Integrating Server" for details.
|Data Type||V401||V804||V817 and V901|
|Procedure||V401||V804||V817 and V901|
|API||V401 arguments||V804 arguments||V817 & V901 arguments|
Refer to Appendix A for the details of APIs.
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.
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.
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.
Table 2-1 Bugs Fixed in Release 9 of the Gateway
|2329347||GATEWAY HANGS OR GIVES ORA-4062 ON MQGET CALL TO EMPTY QUEUE|
|2321389||PG4MQ 220.127.116.11.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|
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.
The following restrictions are known to exist for the products in this release. Restrictions are not scheduled to change in future releases.
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.
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.