I'm getting the following the error while the following query is being executed,
SELECT M_V.OPERATION, M_V.COMBINATION, M_V.VDS, M_V.VDS_6, M_V.FLAG,
M_V.FRANCHISE, M_V.WARRANTY, M_V.SUBMISSION, M_V.MULTI_HOUR, M_V.YEAR, M_V.YEAR_ALPHA, M_V.SOURCE, M_V.ACTION, M_V.HOUR, M_V.ACTIVITY_DATE,
M_V.WMI FROM M_V
In this query M_V is a view which access DB2 tables using the Database link DB2.WORLD.Code:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
DSNT408I SQLCODE = -924,
ERROR: DB2 CONNECTION INTERNAL ERROR, 0001, 0100,
ORA-02063: preceding 3 lines from DB2.WORLD
Now I checked the Database link and by giving select * from M_V, it is giving the result.
This problem occurs quite often even when the DB2 db is up and running and there is no connection
problem.Can anyone tell me what could be the root cause of this problem? My database is 9iR2 and OS is HP_UX.