Use lists

Use the LIST command to define a list of values for an OMEGAMON for Db2 Performance Expert identifier that can be used in INCLUDE and EXCLUDE, instead of individually entering each member. The members of the list are treated as if they were entered individually.

LIST processing does not affect OMEGAMON for Db2 Performance Expert performance, but can make it easier to specify and read your command stream.

Assume that you want to see how some plans that are used by the sales department affect performance. To do that, produce an Accounting report and an SQL Activity trace. If you specify a list for all plan name values, as in the following example, you can use the list name (SALES) in all commands in that job step.

 
LIST            (PLANNAME(SALES(PLAN001,
                               PLAN002,
                               PLAN003,
                               PLAN004,
                               PLAN005,
                               PLAN006,
                               PLAN007,
                               PLAN008)))

ACCOUNTING
     REPORT
        INCLUDE (PLANNAME(L(SALES)))
        ORDER (PLANNAME)
SQLACTIVITY
     TRACE
        INCLUDE (PLANNAME(L(SALES)))
 

Both, the Accounting report and the SQL Activity trace show information for all individual plans that are specified in the list.

You can use LIST with all report sets. You can specify lists for any OMEGAMON for Db2 Performance Expert identifier values that are allowed in that report set.