I tried to run the following select statement in Toad Editor window:
SELECT * from SYSCAT.NICKNAMES
Returns 8 rows then fails with error:
Error:2/23/2012 3:11:18 PM 0:00:00.937: Lookup Error - DB2 Database Error: ERROR [58005] [IBM][DB2.NET] SQL0902 An unexpected exception has occurred in Process: 5800 Thread 54 AppDomain: Name:toad.exe
There are no context policies.
Function: DB2DataReader.Read()
CallStack: at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
at System.Environment.get_StackTrace()
at IBM.Data.DB2.DB2ConnPool.HandleUnknownErrors(String strFncMsg, Exception exception, Boolean bThrow)
at IBM.Data.DB2.DB2DataReader.Read()
at Quest.Toad.Db.ToadDataAdapter.InternalReadBackground()
at Quest.Toad.Db.ToadDataAdapter.InternalFillBackground()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart() InnerException Message: Specified argument was out of the range of valid values. Check InnerException property for more detail. SQLSTATE=58005
I also tried to view the data in the Explorer window with the same results. This works fine in IBM's DB2 Control Center. 80 rows are returned.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center