Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.4.1 - Installation Guide

Retrieve Run Time

There are two functions used to retrieve the run time for an SQL statement: Run for All Records and Run for First Record.

On the SQL tab of SQL Optimizer window, select the SQL or index-set alternative for which you would like the run time.


First Record

To retrieve the time for the first record

Click image\B_RunForFirstRecord.gif.

To terminate the run time process for the first record

lick image\B_AbortRunForFirstRecord.gif.


All Records

To retrieve the time for the all the records

Click image\B_RunForAllRecords.gif.

To terminate the execution to retrieve the run time for all the records

Click image\B_AbortRunForAllRecords.gif.

All run time information is displayed in the SQL Run Time pane of the SQL Optimizer window.


New Database Session

When you log on to SQL Optimizer, it connects to the database and maintains this database connection throughout the application execution. Another database session is required for run time processing. This connection is established when the Run for First Record, Run for All Records, or Batch Run function is initiated and then dropped after the performance figures are acquired.


Related Documents