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.
The Accounting report shows information for the sales department as a single entry.
GROUP ( PRIMAUTH ( SALES (USER001, USER002, USER003))) ACCOUNTING REDUCE INCLUDE (PRIMAUTH(G(SALES))) REPORT ORDER (PRIMAUTH)