Skip to Content
Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Ops Monitor for Db2 13.1 image-2024-5-19_8-5-1.png .

Other examples

This topic lists alternative examples for printing reports.

  • To print an SQL statement summary per thread, sorted by Average CPU usage, followed by average SQL row processing statistics per statement, specify:

    LTRAC ==> Y
    STRAC ==> SQL,SORTSQL=AC,SQLPOPUP

  • To print a detail event trace per thread, with pop-up displays per SQL statement, specify:

    LTRAC ==> Y
    DTRAC ==> Y
    POPUP ==> SQL

  • To print SQL statement text and EXPLAIN data for all dynamic SQL executed or BINDs of static SQL, specify:

    POPUP ==> (SQL-TEXT,EXPLAIN)

The following formatting options are available:

Option

Description

NEWPAGE

Controls page breaks

WIDTH

Specifies wide (133) or narrow (81) output

LINECNT

Adjusts the number of lines printed per page

HEADING

Suppresses headings

MAXPAGES

Limits the amount of output to prevent an unexpectedly high prints volume

Related topic

Printing-a-trace-report

 

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

BMC AMI Ops Monitor for Db2 12.2