When having a problem that needs to be reported to IBM I found that explain information is not dumped into the explain tables, but can be saved to a file. IBM always requests a command that pulls information from the explain tables. In order to satisfy the request I have to open IBM Control Center, explain the query, and then run the db2exfmt command. My request is that there be an option to load the explain tables with explain information.
STATUS:
Enhancement request 'ST70729' has been submitted to Development for consideration in a future release of Toad for DB2.
WORKAROUND:
None
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy