Have you ever wanted to know what is going on within an active SQL Query Engine, SQE, query?
If, like me, you do there is a table function that shows all kinds of interesting information.
The table function ACTIVE_QUERY_INFO has been around since IBM i 7.3 . It has four parameters that allow you to select the results you want returned.
- JOB_NAME: This is the parameter I have found the most useful. Rather than it using the qualified job name it uses the job name part of the job name. Therefore I can just search for jobs with wildcards, for example 'DSP1*'. I can also use '*' to return results for the current job only, and '*ALL', or blank, to return the results for all active jobs.
- JOB_USER: The user name from the job name. A wildcard can be used here too.
- JOB_NUMBER: The job number part of the job name. '*ALL' can be used here.
- USER_NAME: The user name for the job, which may not be the same as the job user name.