GROUPBY statement and parameter
The following figure shows the syntax of the GROUPBY statement/parameter:
The type values define the type of qualifiers to group. You can specify a maximum of two qualifiers for the GROUPBY parameter. Multiple values must be separated by commas (,). The default is GROUPBY(AUTHID,PLAN).
type parameter
Value | Description of value |
|---|---|
AUTHID | Authorization ID Valid abbreviations: AUTH, A |
CONNECTION | Connection ID Valid abbreviations: CONN, N |
CONTYP | Connection type (DRDA, CICS, DB2_CALL, DB2_UTILITY, DLI, IMS_ATT_BMP, IMS_ATT_MPP, IMS_CTL, IMS_TRAN_BMP, RRSAF_ATTACH, RMT_PRIV_PRO, TSO) Valid abbreviation: CONT |
CORRID | Correlation ID Valid abbreviations: CORR, C |
CORRNAME | Correlation name Valid abbreviation: CORRNM |
DSGROUP | Db2 data sharing group Valid abbreviation: DSG |
ENDUNAME | End user name Valid abbreviation: EUN |
ENDTNAME | End transaction name Valid abbreviation: ETN |
ENDWSNAME | End workstation name Valid abbreviations: ENDWSN, EWN, EUW |
OPERATOR | Original operator ID Valid abbreviations: OPID, OPER, O |
PACKAGE | Package or DBRM name Valid abbreviations: PROGRAM, PROG, G, DBRM |
PLAN | Plan name Valid abbreviations: P |
ROLE | Role name Valid abbreviation: no abbreviation |