Summary
The Summary page in the Add Jobs wizard in the SQL Scanner shows a list of the jobs that were selected for scanning.
Scan
The SQL Scanner only scans Jobs that are "marked." The Jobs are automatically marked when they are added by the Add Jobs wizard.
To mark a Job
Clicking the Job row. The 
To unmark a Job
Click the marked row.
To scan the marked Jobs
Click 
During and after scanning, information is updated on the Job Manager window and the 
To abort the scanning process
Click 
Scan Source Code with Temporary Tables
During scanning, if the scanned SQL statement is used to create or modify a temporary table, the SQL will be automatically executed if the Create Scanner Temp Table checkbox in the Options is selected. The created Scanner Temp Tables will be dropped after the job has finished scanning.
Example
Source Code
declare global temporary table session.ABC
like EMPLOYEE
on commit delete rows
not logged
select *
from session.ABC
After scanning in the Scanned SQL Viewer, you will see the SQL statement displayed in the Scanned SQL pane as:
select *
from session.ABC
The DDL for creating the temporary tables is displayed under the Scanner Temp Table tab in the SQL Information. This includes the DDL found by the SQL Scanner or the DDL used to create the User-Defined Temp Table.
declare global temporary table session.ABC
like EMPLOYEE
on commit delete rows
not logged
Note: To create or modify temporary tables SQL Scanner, the logon user needs the following privileges:
-
Connection to DB2 LUW 7 or above
-
USE privilege on the USER TEMPORARY table space or SYSADM or DBADM authority.
Abort Scan
To abort the scanning process
Click
The Abort Scan function may take a few seconds to complete, as time is needed to close down all the necessary processes.