Discussions
SQTXPLAIN: Dealing with Long SQLT Execution Times
This thread is for discussion and questions about why SQLTXPLAIN (SQLT) may be taking a long time to generate output.
General Advice:
- Depending on a number of factors (such as the complexity of the SQL and the methods used etc.), SQLT can take some time to complete.
Typically this is not because it is stuck or similar but because of the work it is doing in the background. - To check how SQLT is progressing, then the log file (created in your current directory) that is produced by the run can provide some pointers.
For general discussion of SQLTXPLAIN use: SQLTXPLAIN (SQLT): General Discussion
1