Group data

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 members of the set is consolidated into one record. This improves OMEGAMON for Db2 Performance Expert performance because fewer records must be processed.

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

This is how you specify sets. Assume that your sales department consists of three users, USER001, USER002, and USER003. You want to produce an Accounting report that shows performance data for that department. You can enter:

 
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.

You can use GROUP with all report sets except Audit, Record Trace, and Statistics. The most common identifiers used to group data are:

• ORIGAUTH and PRIMAUTH
• PLANNAME
• CONNECT and CONNTYPE
• CORRNAME and CORRNMBR