SQL details for a job
Displaying the current SQL for a job allows you to examine the SQL that is currently running a
job or the last SQL statement run for a job. You can examine the SQL and determine if the query
needs to be optimized. Additionally, you can edit the SQL, display the job log, and end jobs that
are taking too long to execute.
To display SQL details for a job:
- In the System i Navigator window, expand the system you want to use.
- Right-click Databases and select Current SQL for a Job.
- Select Show SQL for a job from the menu.
- On the Show SQL dialog, select the job you want to show the SQL for from the Available jobs list. To go directly
the current job, click Show Current.
- Click SQL statement.
- To display the job log, select Job Log.
- To end the job, select End Job.
- To refresh the list of available jobs, select Refresh.
- To edit the SQL statements, select Edit SQL.
- To run Visual Explain, select Visual Explain.
- When you are finished viewing the SQL, click Close.