Example of ordering by activity name: ORDER (ACTNAME)

This example shows how to order an Accounting report by activity name.

If you want to use ORDER (ACTNAME), you should consider the following:

• ACTNAME cannot be combined with other OMEGAMON for Db2 Performance Expert identifiers in the ORDER subcommand.
• ORDER (ACTNAME) is only allowed for reports that are created from input trace specified with //INPUTDD.
• If you use the RESTORE subcommand, you cannot order by activity name in the subsequent REPORT subcommands.

The following command orders an Accounting report by activity name.

⋮
ACCOUNTING
      REPORT
      ORDER (ACTNAME)
⋮

To identify the real number of stored procedures (SP) or user-defined functions (UDF) instead of the number of packages used, you must include the trace collection of IFCID 233 (Start/Stop for each SP or UDF), 380 (Start/Stop for SP), or 381 (Start/Stop for UDF) in your input trace data. Stored procedures and user-defined functions are determined and can be counted if IFCID 233, 380, or 381 is found. Subprograms called by these routines and functions are not taken into account for the number of occurrences.