Example of tailoring an Accounting report
This example describes how to add a block of fields to an existing report layout and how to replace some of the existing fields with new fields.
Suppose that the standard layout of the short Accounting report (supplied as Accounting report layout SHORT) does not provide the information that you need to monitor your Db2 installation and its specific workload.
Accounting report - standard layout
Here is an example of the standard layout for Accounting reports.
LOCATION: STLEC1 OMEGAMON for DB2 Performance Expert (V5R5M0) PAGE: 1-1
GROUP: DSNCAT ACCOUNTING REPORT - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: SSDQ TO: NOT SPECIFIED
SUBSYSTEM: SSDQ ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 05/15/15 20:18:00.23
DB2 VERSION: V11 SCOPE: MEMBER TO: 05/15/15 20:48:38.68
PRIMAUTH #OCCURS #ROLLBK SELECTS INSERTS UPDATES DELETES CLASS1 EL.TIME CLASS2 EL.TIME GETPAGES SYN.READ LOCK SUS
PLANNAME #DISTRS #COMMIT FETCHES OPENS CLOSES PREPARE CLASS1 CPUTIME CLASS2 CPUTIME BUF.UPDT TOT.PREF #LOCKOUT
---------------------------------- ------- ------- ------- ------- ------- ------- -------------- -------------- -------- -------- --------
ADMF001 13 0 0.00 0.00 0.00 0.00 0.662349 0.662264 N/P N/P 0.00
'BLANK' 0 13 0.00 0.00 0.00 0.00 0.004677 0.004589 N/P N/P 0
ADMF001 3 2 0.00 0.00 0.00 0.00 5.161409 5.161304 220.67 9.00 0.00
DSNBIND 0 3 0.00 0.00 0.00 0.00 0.139584 0.139478 157.00 0.67 0
Accounting report - tailored layout
Assume that you want to include more buffer pool information in your layout, as in the following tailored report layout.
The tailored layout has been named BUFFER and contains buffer pool information in addition to General Accounting data. The buffer pool fields in the General Accounting block have been replaced with other fields to avoid duplicate information. In this example, class 3 suspension times and events are shown.
LOCATION: STLEC1 OMEGAMON for DB2 Performance Expert (V5R5M0) PAGE: 1-1
GROUP: DSNCAT ACCOUNTING REPORT - BUFFER REQUESTED FROM: NOT SPECIFIED
MEMBER: SSDQ TO: NOT SPECIFIED
SUBSYSTEM: SSDQ ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 05/15/15 20:18:00.23
DB2 VERSION: V11 SCOPE: MEMBER TO: 05/15/15 20:48:38.68
PRIMAUTH #OCCURS #ROLLBK SELECTS INSERTS UPDATES DELETES CLASS1 EL.TIME CLASS2 EL.TIME CL3 SUSP LOCK SUS
PLANNAME #DISTRS #COMMIT FETCHES OPENS CLOSES PREPARE CLASS1 CPUTIME CLASS2 CPUTIME CLS3 SUSP.TIME #LOCKOUT
---------------------------------- ------- ------- ------- ------- ------- ------- -------------- -------------- -------- -------- --------
ADMF001 13 0 0.00 0.00 0.00 0.00 0.662349 0.662264 7.77 0.00
'BLANK' 0 13 0.00 0.00 0.00 0.00 0.004677 0.004589 0.537943 0
ADMF001 3 2 0.00 0.00 0.00 0.00 5.161409 5.161304 39.00 0.00
DSNBIND 0 3 0.00 0.00 0.00 0.00 0.139584 0.139478 2.472389 0
------------------------------------------------------------------------------------------
|BP ID GETPAGES SYN.READ SEQ.PREF LISTPREF DYN.PREF ASY.READ BUF.UPDT #SYNWRTE|
|BP0 220.67 9.00 0.00 0.00 0.67 0.67 157.00 0|
------------------------------------------------------------------------------------------
ADMF001 9 0 0.00 4.22 1.00 0.00 30.714273 30.067720 141.13 0.00
DSNTEP61 0 15 3.67 0.56 0.56 10.22 0.346763 0.305899 23.810092 0
------------------------------------------------------------------------------------------
|BP ID GETPAGES SYN.READ SEQ.PREF LISTPREF DYN.PREF ASY.READ BUF.UPDT #SYNWRTE|
|BP0 360.00 99.56 0.89 0.00 0.00 6.44 99.56 6|
|BP1 2.00 0.00 0.00 0.00 0.00 0.00 0.00 0|
|BP2 6.22 0.33 0.22 0.00 0.00 0.89 3.56 2|
|TOT4K 368.22 99.89 1.11 0.00 0.00 7.33 103.11 8|
------------------------------------------------------------------------------------------
The following steps describe how to produce the tailored layout.