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 31, 2023
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)))
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
206 DUMPID=002 REQUESTED BY JOB (ORATGXI )
206 DUMP TITLE=Oracle server TGXI server LE session (MIRREC) ORATGX
206 I ABEND U1111
.
.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |