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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center