SQL PA cost summary under QMF

The QMF Intercept Exit for SQL PA produces the standard Cost Summary Report, along with any warnings that are warranted by the SQL statement.

The three types of costing information displayed for the user to consider are:

Resource Consumption: CPU time
Relative Cost Valuation: QUNITS (Query Units)
Financial Valuation: Monetary cost of execution (Charge Back)

The example in the following figure shows this report.

Figure 1. Cost summary under QMF

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
* QMF ONLINE QUERY WILL REQUIRE       2.37486 SECONDS OF  TIME *
* DURING WHICH       0.63661 SECONDS OF CPU TIME WILL BE CONSUMED AND *
* A TOTAL OF           7 PHYSICAL I/O REQUESTS WILL BE ISSUED TO DISK *
* QUNITS            9 ESTIMATED PROCESSING COST $      0.4566 DOLLARS *
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
   * SQL PERFORMANCE ANALYZER * 5697-W51 * PTF5100 *  
   * (C) COPYRIGHT IBM CORPORATION 2000, 2015      *
   * (C) COPYRIGHT INNOVATIVE MANAGEMENT SOLUTIONS *
   *     INC. 1993, 2005   *  ALL RIGHTS RESERVED  *