User ran 'select * from syscat.tables' from Toad for DB2 and got error: IBM.Data.DB2.DB2Exception: ERROR [58005] [IBM][DB2.NET] SQL0902 An unexpected exception has occurred in Process: 4548 Thread 7 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
The problem has been tracked down to NICKNAME records (TYPE N) in SYSCAT.TABLES. When the system is a FEDERATED system and there are nicknames, DB2 adds TYPE N records into SYSCAT.TABLES with TIMESTAMP values of all zeroes.
STATUS
Waiting for a fix with ST 85987 on a future release of Toad for DB2.
WORKAROUND:
SELECT * FROM SYSCAT.TABLES WHERE TYPE <> 'N'
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy