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.
Quest Software reported this error to IBM and it was fixed in the .NET Data Provider (9.7.5).
The problem dealt with the STATS_TIME field in SYSCAT.SYSTABLES.
Since SYSCAT.NICKNAMES is a VIEW over this table, a user would see this same error.
WORKAROUND:
None
STATUS:
Waiting for fix in a future version of Toad for DB2.
IDB Defect ID: APAR IC74291
