SQL*Plus Copy Using TG4DB2 Consumes Virtual Memory And Causes Errors ORA-02055, ORA-02068 and ORA-28511 (Doc ID 377171.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Database Gateway for DB2 - Version 10.1.0.3 to 10.2.0.2 [Release 10.1 to 10.2]
IBM z/OS on System z
Oracle Transparent Gateway for DB2 - Version: 10.1.0.3IBM z/OS (OS/390)
TG4DB2 version 10.1.0.3 , 10.2.0.2



Symptoms

Depending on the number of rows which are copied - failure occurs :
SQL copy of 3043912 rows from Oracle to DB2 (Version 7).
The following error occurs:

ERROR:
ORA-02055: distributed update operation failed; rollback required
ORA-02068: following severe error from DB2LINK
ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=(DESCRIPTION=(ADDRESS=(PROTO =TCP)(Host=myhostname)(Port=9999))(CONN

CT_DATA=(SID=TGXI)))


.
In gateway address space:

09.29.25 STC04988 IEA794I SVC DUMP HAS CAPTURED: 206
206 DUMPID=002 REQUESTED BY JOB (ORATGXI )
206 DUMP TITLE=Oracle server TGXI server LE session (MIRREC) ORATGX
206 I ABEND U1111




.


.

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