ORA-600 opidsa-2 ORA-24338: statement handle not executed or ORA-28511 with DG4DRDA (Doc ID 1509283.1)

Last updated on JANUARY 09, 2017

Applies to:

Oracle Database Gateway for DRDA - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

The session in which the database link to the gateway DG4DRDA has been opened will get an ORA-28511 when trying to run the next SQL-statement after several minutes.

 
The database link points to a DB2 Z/OS database.

When using HS_IDLE_TIMEOUT=0 in the gateway init file,  error still occurs .


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