My Oracle Support Banner

Select From DB2 10.2 Column-organized Table Using DG4DRDA 12.1 Gives ORA-28501 (Doc ID 2014047.1)

Last updated on JULY 26, 2021

Applies to:

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


 A select from a column-organised table in DB2 10.5 using the Database Gateway for DRDA (DG4DRDA) 12.1 gives the error -

SQL> select * from db2inst.testcol@db2;
select * from db2inst.testcol@db2
ERROR at line 1:
ORA-28501: communication error on heterogeneous database link
ORA-02063: preceding line from DB2

The table was created in DB2 as -



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.