What does the SQL Scanner scan?

The SQL Scanner extracts SQL statements from the following items:

Item	Description
Database Objects	Database objects. The SQL Scanner only scans the database objects that contain SQL statements: materialized query tables, views, procedures, user-defined functions, triggers, packages, and plan tables.
Event Monitors	Files or tables created by the DB2 Event Monitor. An Event Monitor collects data when certain events occur on the database such as the completion of the execution of a SQL statement.
Text/Binary Files	Application source code files and binary files.
COBOL Files	COBOL source code files.

SQL Optimizer for DB2 LUW 4.4.1 - Release Notes