Real Time Statistics Advisor Overflow Exception

Toad for IBM DB2
1

When starting RealTime Stats Advisor on a database with a larger number of objects(100+), I receive an OverFlow error. Using Toad 6.5, Db2 Client 11.1, Db2 z/OS v10 NFM. I have not performed the z/OS Component installation.
Works correctly with databases containing a smaller number of objects.

error log messages…

System.OverflowException
Value was either too large or too small for an Int16.
Stack Trace:
at System.Convert.ToInt16(Int64 value)
at Quest.Toad.DB2.RTS.RTSMainForm.CreateIxObjects(FastTable table)
at Quest.Toad.DB2.RTS.RTSMainForm.LoadIndexspaceObjects()
at Quest.Toad.DB2.RTS.RTSMainForm.StartLoadDataThread()
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()

2

Thanks for supplying the detail - we have a fix for this issue.
The fix currently is available in our latest 7.0.1.12 beta which can be downloaded at the top of this Topic:
https://forums.toadworld.com/t/toad-for-db2-beta/41276

The fix will be in our 7.0.1 GA commercial product as well.
We do not yet have a target date for that GA.

There also is a work around you can use in your Toad DB2 v6.5 version:

  1. Save this SQLDictionary.xml file:
    https://toadworlddownloads.blob.core.windows.net/legacy/toadsoft/DB2/ToadDB2patch/SqlDictionary.xml
    In your Toad DB2 application Data directory.
    (you can find a link to your Application Data Directory via Help - about)
  2. Exit and restart Toad DB2 v6.5
  3. Drive the Realtime Statictics Advisor feature again

Hope this helps.

3

Thanks a bunch - will give your suggestions a try…