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 11.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
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
*
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
...
Changes
Enabling statistics for the gateway using -
HS_SUPPORT_STATISTICS=TRUE
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 |
Changes |
Cause |
Solution |
References |