This section discusses restrictions and workarounds that can be used when customizing or maintaining in Oracle Database applications that were originally designed for IBM DB2.
This chapter contains these topics:
Oracle Database Provider for DRDA supports Sync Point Manager services for Distributed Units of Work. It also supports Resynchronization Manager services for resynchronization during migrations that use a source Sync Point Manager without a log.
This release of Oracle Database Provider for DRDA does not support active in-doubt transaction resolution services. Transactions that have been migrated and are in-doubt require manual resolution between the client system and Oracle Database. See Oracle® Database Administrator’s Guide for information on manual resolution of in-doubt transactions.
Cursors marked with the HOLD attribute have the following restrictions:
Under Remote Unit of Work (RUOW), cursors that have been prepared with the FOR UPDATE clause are implicitly closed on COMMIT or ROLLBACK.
Under Distribute Unit of Work (DUOW), all cursors are implicitly closed if any updates occur to the server containing the open cursor on COMMIT or ROLLBACK.
When passwords are encrypted and sent through DRDA, DB2 for z/OS inserts blank spaces into passwords that have less than 8 characters. This results in a log-on failure, error ORA-01017. Oracle recommends that user account passwords be at least 8 characters long.
Please note the following restrictions on use of data types.
Oracle DATE data type contains a time component that DRDA DATE data type does not support. Operating on Oracle DATE data may not yield expected results if the DATE data contains a time component. For consistency, do not store a time component when inserting DATE data using Oracle native DATE syntax. Alternatively, remap the DATE column to TIMESTAMP.
This release does not support queries on objects that contain columns defined through Object-Relational data types.
This release does not support calling SQL procedures defined through Object-Relational data types for their input or return arguments.
Oracle Database Provider for DRDA represents TIMESTAMP with a fixed precision of 6 decimal places.
For compatibility reasons, extra care should be exercised when using TIMESTAMP data, and programmatic adjustments, such as type casting, may have to be made. See Oracle® Database SQL Language Reference for information about casting with the TIMESTAMP data type.
Representation of TIMESTAMP WITH TIMEZONE is significantly different between Oracle Database and DB2.
Oracle Database Provider for DRDA represents TIMESTAMP WITH TIMEZONE according to Oracle's presentation rules. For best compatibility between client and server, use four digit time zone suffix notation instead of written timezone description notation, such as -08:00.
The DRDA XML data type (988, 989) is not supported as a program or bind variable data type in this release.
Other restrictions, such as "SQL Clause Restrictions", are outlined in Chapter 14.