UNCOMMITED READ Does not Work with DRDA Gateway 11.2 (Doc ID 1072027.1)

Last updated on NOVEMBER 18, 2016

Applies to:

Oracle Database Gateway for DRDA - Version 11.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 08-JAN-2014***

Symptoms


Comments
--------
=== ODM Issue Clarification ===
Update a DB2 table without committing the update.

Using the DRDA 11.2 gateway hangs and comes back with a timeout error:
SQL> ERROR:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC DB2 Wire Protocol driver][UDB DB2 for OS/390 and z/OS]FAILED
EXECUTION DUE TO DEADLOCK/TIMEOUT. REASON 00C9008E TYPE 00000304.
DSN00904.EMPLOYEE.X'00000002'.X'29' {HY000,NativeErr = SP2-0042: -913}[Oracle][ODBC DB2
Wire Protocol driver]Cursor identified in Fetch statement is not open. It could
have been closed by a previous commit or rollback. {unknown command "ERROR:" - rest of line ignored.HY000,NativeErr = 8301}
ORA-02SQL> 063: preceding 2 lines from SYSC0_32

Changes

Update from TG4DB2 or DG4DRDA/TG4DRDA to Database Gateway for DRDA 11.2

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms