Skip to Content

SQL Snapshot facility

The SQL Snapshot facility is another tool that you can use in PATROL for DB2 UDB to capture the SQL activity of a DB2 application. You can capture only dynamic SQL.

SQL Snapshot enables you to get information about the most recently processed dynamic SQL statement of a specific DB2 application. You can obtain general information about the dynamic SQL statement or you can get Explain information depending on which command option you select. Explain information is available only when the SQL statement is explainable.

Error
Warning

 Do not run the SQL Snapshot facility in DB2 UDB EEE version 6 unless you have fixpack U469453 installed. The fixpack is required to run the SQL Snapshot and SQL Explain commands. An attempt to run the commands without the fixpack in version 6 results in a database manager crash.

Warning

Note

The SQL Viewer facility is not available when you use a remote database.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC PATROL for DB2 Universal Database 9.0