DG4DRDA Gateway Fails With ORA-28500 When Statistics Are Turned On And Connecting To AS400
(Doc ID 1538708.1)
Last updated on MARCH 21, 2013
Applies to:Oracle Database Gateway for DRDA - Version 18.104.22.168 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:
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!