Grouping data using sets of identifiers

You can use the GROUP command to define a set of OMEGAMON for Db2 PE identifier values that can be used when you request certain reports. The information for the set is reported as a single entry in the reports.

In GROUP processing the data for all items of the set is consolidated into one record. This improves OMEGAMON for Db2 Performance Expert performance because less records must be processed.

Sets are also useful for reporting purposes such as to report data for an entire department instead of every individual person.

Assume that your sales department consists of three users (USER001, USER002, and USER003) and you want to specify sets to produce an Accounting report with performance data for this department. You can specify:


 
GROUP (
     PRIMAUTH (
        SALES (USER001,
               USER002,
               USER003)))

ACCOUNTING
   REDUCE
      INCLUDE (PRIMAUTH(G(SALES)))
   REPORT
      ORDER   (PRIMAUTH)

The Accounting report shows information for the sales department as a single entry.