Skip to Content

Default language.

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

Related topic

Printing-a-trace-report

  • 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

 

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

BMC AMI Ops Monitor for Db2 13.1