Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.4.1 - Installation Guide

What Files 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.

 

Related Topic

Embedded and Dynamic SQL Statements

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating