Real Time Statistics Advisor Overflow Exception

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.