My Oracle Support Banner

DG4DRDA Gateway Fails With ORA-28500 When Statistics Are Turned On And Connecting To AS400 (Doc ID 1538708.1)

Last updated on SEPTEMBER 20, 2021

Applies to:

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


Selecting from an AS400 table using the Database Gateway for DRDA (DG4DRDA) with HS_SUPPORT_STATISTICS set to TRUE fails with error:


select count(*) from DUAL@IOS_EMGTW_11_2_0_3_DB
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ORA-02063: preceding line from IOS_EMGTW_11_2_0_3_DB


and a gateway trace shows:



SQLGetDiagRec returns rc=100 (SQL_NO_DATA) for handle 1aed47a0 (SQL_HANDLE_STMT)
Exiting hgopoer, rc=0 at 2013/03/18-10:45:22 with error ptr FILE:hgopoer.c LINE:186 FUNCTION:hgopoer() ID:GetDiagRec error
hgotcis, line 571: calling SQLStatistics got sqlstate





 Enabling statistics for the gateway using -




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.