IBM Tivoli Composite Application Manager for Application Diagnostics, Version

Define a SQL Analysis report

The SQL Analysis report provides the information for the SQL calls' performance in the requests that have been processed by the application server. You can also view the Trend report, Decomposition report, and detailed SQL report after defining the SQL Analysis report.

To define a SQL Analysis report:

  1. From the top navigation, click...

      Performance Analysis> Create Application Reports > SQL

  2. Select yes or no to decide if you want the report to recur and click Next. For the purpose of these instructions we are selecting No. If you want further instructions on scheduling reports, refer to Define a Schedule report.

  3. Select the group and the server on which you want to report from the list box.

  4. Click Next to continue creating the report. The Report Filtering options page opens. It displays the options based on the Report Type you select.

  5. Set the following options to filter the records returned in the report:

    • Metric

      Throughput per Second, Throughput per Minute, Throughput per Hour and Response Time.

    • SQL Call

      All, Insert, Delete, Update, Execute, Select, Lock, Unlock, Open, Close and Fetch.

    • Table Name

      Leave blank for all table names or type in the specific table name.

    • Request Type

      All, EJB, JSP, Servlet, CICS, Web Service, and Portal.

    • Request Name

      Unless you know exactly what the request string is, otherwise always leave the field blank to return all requests or type in the specific request name.

    • Method/Component Trace

      Leave blank for all methods or type in the specific name.

  6. Click Next to continue creating the report. The Date Range settings page opens.

  7. Set the parameters to restrict the data returned in your report. For detailed instructions, see Understanding the Date Range settings.

  8. Click View Report to view the report. To get a second data set for comparative analysis, click Next to open the Report Comparison page. The Report Comparison page opens.

  9. Select a report comparison type and view the comparison report by clicking View Report.

  10. Click Save if you want to save the report.

Parent topic:

Define reports

Related topics

Define a Schedule report
Understanding the Date Range settings
Define a Schedule report
E-mailing a report
Export a file
Modify a report
View a PDF file