Accounting Report - Short
The short Accounting report shows some of the most significant fields averaged over the number of threads.
Short Accounting reports are arranged in blocks. Each block contains Accounting information about a particular activity. The layout of each block is presented followed by the field descriptions.
You can generate a short version of the Accounting report using
the following command:
...
ACCOUNTING
REPORT
LAYOUT (SHORT)
ORDER (PRIMAUTH-PLANNAME)
SCOPE (MEMBER)
...Accounting Report - Short
This is an example of a short Accounting report.
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-1
GROUP: N/P ACCOUNTING REPORT - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA5 ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 08/24/16 08:18:18.92
DB2 VERSION: V10 SCOPE: MEMBER TO: 08/24/16 09:41:00.00
#OCCURS #COMMIT INSERTS OPENS PREPARE CLASS2 EL.TIME BUF.UPDT LOCK SUS
PRIMAUTH #DISTRS SELECTS UPDATES CLOSES CLASS1 EL.TIME CLASS2 CPUTIME SYN.READ #LOCKOUT
PLANNAME #ROLLBK FETCHES MERGES DELETES CLASS1 CPUTIME GETPAGES TOT.PREF
---------------------------------- ------- ------- ------- ------- -------------- -------------- -------- --------
DB2PM 1 0 0.00 0.00 0.00 N/P N/P 0.00
'BLANK' 0 0.00 0.00 0.00 8:13.695925 N/P N/P 0
0 0.00 0.00 0.00 0.002014 N/P N/P
DB2PM 10 655 0.60 505.20 10.40 0.060370 1.20 0.00
DB2PM 0 443.20 12.60 505.20 5:40.386999 0.052687 0.60 0
1 1551.70 0.00 3.20 0.115894 3318.30 168.50
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!DGOZDATE PACKAGE 10 4081 4081.00 0.047074 0.039262 0.000000 0.00!
!DGOZPC1 PACKAGE 10 154 1069.00 0.038439 0.035705 0.001971 154.00!
!DGOZPC2 PACKAGE 10 4158 17.6K 0.414151 0.359071 0.000003 2.00!
!DGOZPC4 PACKAGE 10 77 308.00 0.010961 0.010693 0.000000 0.00!
!FPEVWRPA PACKAGE 10 1 2.00 0.000913 0.000473 0.000000 0.00!
!FPEVWR2C PACKAGE 10 1 192.00 0.048516 0.043706 0.001238 6.00!
----------------------------------------------------------------------------------------------------------------
DB2PM 22 13214 42.09 4776.82 209.64 1.213447 168.95 0.18
KO2PLAN 0 4106.95 104.09 4776.82 1:03:48.234755 0.596238 9.45 0
2 9503.18 0.00 33.91 0.960242 29212.68 152.05
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!DGOZCHKB PACKAGE 10 1 2.00 0.001000 0.000779 0.000000 0.00!
!DGOZDATE PACKAGE 20 22716 44.3K 0.519441 0.424610 0.000000 0.00!
!DGOZPC1 PACKAGE 20 3331 8775.00 0.480424 0.408331 0.041889 1672.50!
!DGOZPC2 PACKAGE 20 24381 190.7K 8.798312 3.824541 0.001399 9.50!
!DGOZPC4 PACKAGE 20 1665 3330.00 0.125221 0.118657 0.000000 0.00!
!DGOVEXCP PACKAGE 10 1 7922.00 2.222845 1.690191 0.463894 1379.00!
!FPEVWRPA PACKAGE 20 3 11.33 0.005725 0.003119 0.001866 2.67!
!FPEVWR2C PACKAGE 20 2 2001.00 0.648361 0.510854 0.014540 75.50!
----------------------------------------------------------------------------------------------------------------
*** TOTAL ***
DB2PM 33 13869 28.24 3337.64 142.91 0.829088 116.53 0.12
0 2872.27 73.21 3337.64 44:30.264561 0.413458 6.69 0
3 6805.67 0.00 23.58 0.675342 21120.69 157.19
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ALL PROG PACKAGE 200 60572 25.2K 1.140219 0.607773 0.028017 241.14!
----------------------------------------------------------------------------------------------------------------
MIS 2 2 0.00 0.00 0.00 0.004471 N/P 0.00
'BLANK' 0 0.00 0.00 0.00 0.004492 0.000403 N/P 0
0 0.00 0.00 0.00 0.000411 N/P N/P
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-2
GROUP: N/P ACCOUNTING REPORT - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA5 ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 08/24/16 08:18:18.92
DB2 VERSION: V10 SCOPE: MEMBER TO: 08/24/16 09:41:00.00
#OCCURS #COMMIT INSERTS OPENS PREPARE CLASS2 EL.TIME BUF.UPDT LOCK SUS
PRIMAUTH #DISTRS SELECTS UPDATES CLOSES CLASS1 EL.TIME CLASS2 CPUTIME SYN.READ #LOCKOUT
PLANNAME #ROLLBK FETCHES MERGES DELETES CLASS1 CPUTIME GETPAGES TOT.PREF
---------------------------------- ------- ------- ------- ------- -------------- -------------- -------- --------
MIS 2 17 1.00 4.00 9.00 0.193028 416.00 0.00
ADB 0 0.00 0.00 4.00 1:59.441151 0.040293 21.50 0
0 11.50 0.00 0.00 0.047758 1519.50 57.00
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ADBMAIN PACKAGE 2 18 4.83 0.021397 0.004427 0.048849 6.94!
!ADB2CON PACKAGE 2 2 1.00 0.000041 0.000041 0.000000 0.00!
!ADB2GET PACKAGE 2 4 6.00 0.000326 0.000322 0.000000 0.00!
----------------------------------------------------------------------------------------------------------------
MIS 4 4 0.00 1.00 0.00 0.054070 5.00 0.00
ADB27SPC 0 0.50 0.00 1.00 0.055843 0.005919 5.00 0
0 4.25 0.00 0.00 0.006521 348.00 10.50
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ADB27SP PACKAGE 4 4 11.75 0.047895 0.005826 0.038352 7.50!
----------------------------------------------------------------------------------------------------------------
MIS 2 20 0.00 0.00 0.00 0.158877 12.00 0.00
DSNUTIL 0 0.00 0.00 0.00 0.972823 0.018292 18.00 0
2 0.00 0.00 0.00 0.040689 796.50 110.00
*** TOTAL ***
MIS 10 43 0.20 1.20 1.80 0.092903 109.50 0.00
0 0.20 0.00 1.20 24.106031 0.014165 12.38 0
2 4.00 0.00 0.00 0.020380 753.00 47.00
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ALL PROG PACKAGE 10 28 5.69 0.022210 0.003989 0.039718 5.96!
----------------------------------------------------------------------------------------------------------------
*** GRAND TOTAL ***
43 13912 21.72 2561.72 110.09 0.645042 115.13 0.09
0 2204.35 56.19 2561.72 34:14.878856 0.320599 7.82 0
5 5223.88 0.00 18.09 0.523025 17047.15 135.15
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ALL PROG PACKAGE 210 60600 11.3K 0.521746 0.273765 0.034490 111.04!
----------------------------------------------------------------------------------------------------------------
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-1
GROUP: DBC1 ACCOUNTING REPORT - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12 SCOPE: MEMBER TO: 08/24/16 09:56:00.00
#OCCURS #COMMIT INSERTS OPENS PREPARE CLASS2 EL.TIME BUF.UPDT LOCK SUS
PRIMAUTH #DISTRS SELECTS UPDATES CLOSES CLASS1 EL.TIME CLASS2 CPUTIME SYN.READ #LOCKOUT
PLANNAME #ROLLBK FETCHES MERGES DELETES CLASS1 CPUTIME GETPAGES TOT.PREF
---------------------------------- ------- ------- ------- ------- -------------- -------------- -------- --------
DB2PM 10 30 0.30 1.60 4.60 0.042704 1.40 0.40
'BLANK' 0 0.10 2.00 1.60 3:22.884144 0.001992 1.50 0
0 1.60 0.00 0.70 0.008648 71.40 0.00
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRPA PACKAGE 10 1 6.00 0.002133 0.000826 0.001043 1.00!
!FPEVWRP2 PACKAGE 10 2 22.00 0.002520 0.001379 0.000684 1.00!
----------------------------------------------------------------------------------------------------------------
DB2PM 116 2003 9.59 16.56 48.48 0.425692 39.12 3.61
KO2PLAN 0 0.15 5.82 16.56 10:50.679206 0.032228 1.40 0
0 46.72 0.00 7.04 0.052569 251.49 3.65
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!DGOVEXCP PACKAGE 10 1 9526.00 26.533861 2.278888 23.958403 3383.00!
!FPEVWRPA PACKAGE 20 2 6.00 0.014765 0.003113 0.008823 6.50!
!FPEVWRP2 PACKAGE 113 52 21.85 0.003054 0.001229 0.001327 1.31!
!FPEVWR2C PACKAGE 30 3 1398.00 4.516698 0.425947 4.019518 236.33!
----------------------------------------------------------------------------------------------------------------
*** TOTAL ***
DB2PM 126 2033 8.86 15.37 45.00 0.395296 36.13 3.36
0 0.14 5.52 15.37 10:15.139916 0.029828 1.40 0
0 43.13 0.00 6.54 0.049083 237.20 3.36
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ALL PROG PACKAGE 193 61 244.56 0.660319 0.059515 0.591902 68.46!
----------------------------------------------------------------------------------------------------------------
MIS 2 2 0.00 0.00 0.00 0.021518 N/P 0.00
'BLANK' 0 0.00 0.00 0.00 0.021522 0.000374 N/P 0
0 0.00 0.00 0.00 0.000378 N/P N/P
MIS 1 9 1.00 5.00 10.00 6.930629 448.00 12.00
ADB 0 0.00 0.00 5.00 4:39.789682 0.317732 102.00 0
0 24.00 0.00 0.00 0.325938 82939.00 5136.00
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ADBMAIN PACKAGE 1 1 63.00 6.930166 0.317277 4.883117 5206.00!
!ADB2CON PACKAGE 1 1 1.00 0.000041 0.000041 0.000000 0.00!
!ADB2GET PACKAGE 1 2 6.00 0.000331 0.000324 0.000000 0.00!
----------------------------------------------------------------------------------------------------------------
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-2
GROUP: DBC1 ACCOUNTING REPORT - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12 SCOPE: MEMBER TO: 08/24/16 09:56:00.00
#OCCURS #COMMIT INSERTS OPENS PREPARE CLASS2 EL.TIME BUF.UPDT LOCK SUS
PRIMAUTH #DISTRS SELECTS UPDATES CLOSES CLASS1 EL.TIME CLASS2 CPUTIME SYN.READ #LOCKOUT
PLANNAME #ROLLBK FETCHES MERGES DELETES CLASS1 CPUTIME GETPAGES TOT.PREF
---------------------------------- ------- ------- ------- ------- -------------- -------------- -------- --------
MIS 2 2 0.00 1.00 0.00 2.375169 0.00 1.00
ADB27SPC 0 0.50 0.00 1.00 2.377101 1.029620 30.00 0
0 4.00 0.00 0.00 1.030365 40987.50 2540.50
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ADB27SP PACKAGE 2 2 11.50 2.369315 1.029301 1.095418 2561.00!
----------------------------------------------------------------------------------------------------------------
MIS 1 28 0.00 0.00 0.00 2.163899 464.00 43.00
DSNUTIL 0 0.00 0.00 0.00 2.202907 0.036611 123.00 0
0 0.00 0.00 0.00 0.041090 1651.00 27.00
*** TOTAL ***
MIS 6 41 0.17 1.17 1.67 2.314650 228.00 9.50
0 0.17 0.00 1.17 47.798306 0.402388 71.25 0
0 5.33 0.00 0.00 0.404752 41641.25 2561.00
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ALL PROG PACKAGE 5 6 18.60 2.333834 0.475249 1.414790 2065.60!
----------------------------------------------------------------------------------------------------------------
MIS1 1 10 0.00 0.00 0.00 0.052472 13.00 3.00
DSNUTIL 0 0.00 0.00 0.00 0.075969 0.004677 0.00 0
0 0.00 0.00 0.00 0.006032 57.00 0.00
*** GRAND TOTAL ***
133 2084 8.40 14.62 42.71 0.479305 41.81 3.63
0 0.14 5.23 14.62 9:44.921016 0.046446 3.53 0
0 41.11 0.00 6.20 0.064804 1500.07 81.43
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ALL PROG PACKAGE 198 67 227.44 0.787100 0.091010 0.654242 219.76!
----------------------------------------------------------------------------------------------------------------
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 3-1
GROUP: DBEE ACCOUNTING REPORT - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE1 TO: NOT SPECIFIED
SUBSYSTEM: SEE1 ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 08/24/16 08:16:02.78
DB2 VERSION: V11 SCOPE: MEMBER TO: 08/24/16 09:28:00.00
#OCCURS #COMMIT INSERTS OPENS PREPARE CLASS2 EL.TIME BUF.UPDT LOCK SUS
PRIMAUTH #DISTRS SELECTS UPDATES CLOSES CLASS1 EL.TIME CLASS2 CPUTIME SYN.READ #LOCKOUT
PLANNAME #ROLLBK FETCHES MERGES DELETES CLASS1 CPUTIME GETPAGES TOT.PREF
---------------------------------- ------- ------- ------- ------- -------------- -------------- -------- --------
DB2PM 9 500 0.44 44.00 2.00 0.268818 1.22 3.11
'BLANK' 0 20.44 7.56 44.00 5:16.787789 0.016421 18.56 0
1 388.67 0.00 0.78 0.040730 436.89 117.22
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!DGOZDATE PACKAGE 9 60 60.00 0.002446 0.002390 0.000000 0.00!
!DGOZPC1 PACKAGE 9 120 603.00 2.149922 0.043017 2.078318 122.00!
!DGOZPC2 PACKAGE 9 120 420.00 0.070453 0.047602 0.000000 0.00!
!DGOZPC4 PACKAGE 9 60 240.00 0.028219 0.015639 0.000000 0.00!
!FPEVWRPA PACKAGE 9 1 6.00 0.014902 0.004894 0.004718 9.00!
----------------------------------------------------------------------------------------------------------------
DB2PM 11 16 0.18 1.00 1.36 0.011619 0.18 0.18
KO2PLAN 0 0.18 0.09 1.00 44.183480 0.001087 0.09 0
0 1.00 0.00 0.00 0.002309 10.55 0.00
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 10 2 16.00 0.048211 0.003222 0.003097 2.00!
----------------------------------------------------------------------------------------------------------------
*** TOTAL ***
DB2PM 20 516 0.30 20.35 1.65 0.127358 0.65 1.50
0 9.30 3.45 20.35 2:46.855419 0.007987 8.40 0
1 175.45 0.00 0.35 0.019598 202.40 52.75
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ALL PROG PACKAGE 55 363 194.43 0.337481 0.017141 0.298461 19.29!
----------------------------------------------------------------------------------------------------------------
MIS 2 36 0.00 0.00 0.00 N/P 240.00 27.50
DSNUTIL 0 0.00 0.00 0.00 1.243841 N/P 73.50 0
0 0.00 0.00 0.00 0.154357 72551.00 6397.50
*** GRAND TOTAL ***
22 552 0.27 18.50 1.50 0.127358 22.41 3.86
0 8.45 3.14 18.50 2:31.799821 0.007261 14.32 0
1 159.50 0.00 0.32 0.031849 6779.55 629.55
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ALL PROG PACKAGE 55 363 194.43 0.337481 0.017141 0.298461 19.29!
----------------------------------------------------------------------------------------------------------------
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 4-1
GROUP: DBEE ACCOUNTING REPORT - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE2 TO: NOT SPECIFIED
SUBSYSTEM: SEE2 ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 08/24/16 07:08:00.00
DB2 VERSION: V11 SCOPE: MEMBER TO: 08/24/16 09:51:14.25
#OCCURS #COMMIT INSERTS OPENS PREPARE CLASS2 EL.TIME BUF.UPDT LOCK SUS
PRIMAUTH #DISTRS SELECTS UPDATES CLOSES CLASS1 EL.TIME CLASS2 CPUTIME SYN.READ #LOCKOUT
PLANNAME #ROLLBK FETCHES MERGES DELETES CLASS1 CPUTIME GETPAGES TOT.PREF
---------------------------------- ------- ------- ------- ------- -------------- -------------- -------- --------
DB2PM 12 11794 38.25 847.08 169.33 2.335032 153.92 28.17
'BLANK' 0 269.25 148.58 847.08 1:33:44.881646 0.368045 14.83 0
2 1232.50 0.00 24.50 0.490043 3807.75 90.00
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!DGOZCHKB PACKAGE 10 1 2.00 0.004624 0.001057 0.002596 3.00!
!DGOZDATE PACKAGE 12 1581 790.50 0.032933 0.031186 0.000214 0.50!
!DGOZPC1 PACKAGE 12 3163 7945.50 1.418494 0.497777 0.652339 1593.50!
!DGOZPC2 PACKAGE 12 3162 5533.50 1.284005 0.566589 0.487791 25.50!
!DGOZPC4 PACKAGE 12 1581 3162.00 0.582435 0.182844 0.253138 2.00!
!DGOVEXCP PACKAGE 10 1 3942.00 2.192355 0.990217 1.101690 1107.00!
!FPEVWRPA PACKAGE 10 3 7.00 0.013585 0.004557 0.006415 9.00!
!FPEVWRP2 PACKAGE 10 2 23.00 0.003236 0.001213 0.000922 1.50!
!FPEVWR2C PACKAGE 10 1 1296.00 2.382283 0.330348 2.000514 199.00!
----------------------------------------------------------------------------------------------------------------
DB2PM 129 1652 0.17 10.03 5.17 0.014577 0.67 0.40
KO2PLAN 0 3.35 2.71 10.03 2:34.850083 0.004482 0.94 0
2 81.87 0.00 0.71 0.010373 70.29 16.31
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!DGOZCHKB PACKAGE 10 1 51.00 0.024374 0.014012 0.002236 37.00!
!DGOZDATE PACKAGE 20 130 65.00 0.002673 0.002567 0.000000 0.00!
!DGOZPC1 PACKAGE 20 261 877.50 0.067914 0.041366 0.004863 132.00!
!DGOZPC2 PACKAGE 20 260 455.00 0.069024 0.046336 0.000098 0.50!
!DGOZPC4 PACKAGE 20 130 260.00 0.027133 0.015035 0.000000 0.00!
!DGOVSDOB PACKAGE 10 1 3054.00 0.023059 0.016264 0.002115 1.00!
!FPEVTCO1 PACKAGE 10 1 2.00 0.000284 0.000280 0.000000 0.00!
!FPEVWRPA PACKAGE 30 6 19.75 0.005831 0.002025 0.002168 3.75!
!FPEVWRP2 PACKAGE 105 53 22.38 0.002536 0.001205 0.000711 1.44!
!FPEVWR2C PACKAGE 30 3 166.00 0.131806 0.040080 0.082693 21.00!
----------------------------------------------------------------------------------------------------------------
*** TOTAL ***
DB2PM 141 13446 3.41 81.27 19.14 0.212062 13.71 2.77
0 25.98 15.12 81.27 10:20.384684 0.035424 2.12 0
4 179.79 0.00 2.74 0.051196 388.37 22.58
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ALL PROG PACKAGE 373 10341 568.54 0.143299 0.050848 0.073111 59.16!
----------------------------------------------------------------------------------------------------------------
MIS 1 5 0.00 2.00 2.00 0.084914 0.00 2.00
ADB 0 0.00 0.00 2.00 25.835590 0.007726 9.00 0
0 11.00 0.00 0.00 0.010615 67.00 1.00
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 4-2
GROUP: DBEE ACCOUNTING REPORT - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE2 TO: NOT SPECIFIED
SUBSYSTEM: SEE2 ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 08/24/16 07:08:00.00
DB2 VERSION: V11 SCOPE: MEMBER TO: 08/24/16 09:51:14.25
#OCCURS #COMMIT INSERTS OPENS PREPARE CLASS2 EL.TIME BUF.UPDT LOCK SUS
PRIMAUTH #DISTRS SELECTS UPDATES CLOSES CLASS1 EL.TIME CLASS2 CPUTIME SYN.READ #LOCKOUT
PLANNAME #ROLLBK FETCHES MERGES DELETES CLASS1 CPUTIME GETPAGES TOT.PREF
---------------------------------- ------- ------- ------- ------- -------------- -------------- -------- --------
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ADBMAIN PACKAGE 1 1 19.00 0.084382 0.007224 0.068382 14.00!
!ADBPARM PACKAGE 1 1 2.00 0.000224 0.000200 0.000000 0.00!
!ADB2CON PACKAGE 1 1 1.00 0.000039 0.000039 0.000000 0.00!
!ADB2GET PACKAGE 1 2 6.00 0.000202 0.000197 0.000000 0.00!
----------------------------------------------------------------------------------------------------------------
*** GRAND TOTAL ***
142 13451 3.39 80.71 19.02 0.211167 13.61 2.76
0 25.80 15.01 80.71 10:16.197719 0.035229 2.17 0
4 178.61 0.00 2.72 0.050911 386.11 22.43
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ALL PROG PACKAGE 377 10346 543.30 0.137812 0.048649 0.070594 56.66!
----------------------------------------------------------------------------------------------------------------
LOCATION: OMPDBZ2 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 5-1
GROUP: DBZ2 ACCOUNTING REPORT - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: SZ22 TO: NOT SPECIFIED
SUBSYSTEM: SZ22 ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 08/24/16 07:05:32.04
DB2 VERSION: V10 SCOPE: MEMBER TO: 08/24/16 09:41:00.00
#OCCURS #COMMIT INSERTS OPENS PREPARE CLASS2 EL.TIME BUF.UPDT LOCK SUS
PRIMAUTH #DISTRS SELECTS UPDATES CLOSES CLASS1 EL.TIME CLASS2 CPUTIME SYN.READ #LOCKOUT
PLANNAME #ROLLBK FETCHES MERGES DELETES CLASS1 CPUTIME GETPAGES TOT.PREF
---------------------------------- ------- ------- ------- ------- -------------- -------------- -------- --------
DB2PM 12 55 0.25 3.17 9.42 0.015558 1.08 1.50
'BLANK' 0 0.50 4.00 3.17 7:35.350865 0.005036 32.25 0
0 575.50 0.00 2.25 0.017628 94.92 5.92
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRPA PACKAGE 7 1 6.00 0.002059 0.000846 0.000857 1.00!
!FPEVWRP2 PACKAGE 7 1 22.00 0.002090 0.001043 0.000762 1.00!
!FPEVWR2C PACKAGE 5 1 192.00 0.131928 0.047971 0.075986 26.00!
----------------------------------------------------------------------------------------------------------------
DB2PM 102 383 0.07 3.30 7.44 0.256966 0.41 3.51
KO2PLAN 0 0.12 2.52 3.04 11:45.739907 0.011790 6.66 0
27 137.96 0.00 1.60 0.020090 27.76 1.89
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRPA PACKAGE 14 2 6.00 0.016150 0.003336 0.011599 18.00!
!FPEVWRP2 PACKAGE 88 48 11.69 0.046769 0.001085 0.004643 2.94!
!FPEVWR2C PACKAGE 14 2 729.00 1.457784 0.229839 1.189254 203.50!
----------------------------------------------------------------------------------------------------------------
*** TOTAL ***
DB2PM 114 438 0.09 3.29 7.65 0.231554 0.48 3.30
0 0.16 2.68 3.05 11:19.383166 0.011079 9.35 0
27 184.02 0.00 1.67 0.019831 34.83 2.32
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ALL PROG PACKAGE 135 55 40.93 0.096888 0.010332 0.049130 11.13!
----------------------------------------------------------------------------------------------------------------
MIS 1 1 0.00 0.00 0.00 0.005642 N/P 0.00
'BLANK' 0 0.00 0.00 0.00 0.005646 0.000370 N/P 0
0 0.00 0.00 0.00 0.000375 N/P N/P
MIS 1 15 2.00 8.00 18.00 1.040978 764.00 7.00
ADB 0 0.00 0.00 8.00 4:52.468235 0.078167 238.00 0
0 35.00 0.00 0.00 0.089688 1966.00 86.00
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ADBMAIN PACKAGE 1 1 99.00 0.944751 0.076371 0.568195 282.00!
!ADB2CON PACKAGE 1 1 1.00 0.000043 0.000043 0.000000 0.00!
!ADB2GET PACKAGE 1 2 6.00 0.072743 0.001239 0.049363 5.00!
----------------------------------------------------------------------------------------------------------------
LOCATION: OMPDBZ2 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 5-2
GROUP: DBZ2 ACCOUNTING REPORT - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: SZ22 TO: NOT SPECIFIED
SUBSYSTEM: SZ22 ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 08/24/16 07:05:32.04
DB2 VERSION: V10 SCOPE: MEMBER TO: 08/24/16 09:41:00.00
#OCCURS #COMMIT INSERTS OPENS PREPARE CLASS2 EL.TIME BUF.UPDT LOCK SUS
PRIMAUTH #DISTRS SELECTS UPDATES CLOSES CLASS1 EL.TIME CLASS2 CPUTIME SYN.READ #LOCKOUT
PLANNAME #ROLLBK FETCHES MERGES DELETES CLASS1 CPUTIME GETPAGES TOT.PREF
---------------------------------- ------- ------- ------- ------- -------------- -------------- -------- --------
MIS 2 2 0.00 1.00 0.00 0.072999 5.00 0.50
ADB27SPC 0 0.50 0.00 1.00 0.074793 0.007377 16.50 0
0 4.00 0.00 0.00 0.007991 244.00 13.00
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ADB27SP PACKAGE 2 2 11.50 0.067391 0.007117 0.050804 17.00!
----------------------------------------------------------------------------------------------------------------
MIS 3 44 0.00 0.00 0.00 0.985921 147.00 16.00
DSNUTIL 0 0.00 0.00 0.00 1.022531 0.014510 80.67 0
0 0.00 0.00 0.00 0.016776 670.67 72.67
*** TOTAL ***
MIS 7 62 0.29 1.43 2.57 0.592911 202.50 8.00
0 0.14 0.00 1.43 42.241580 0.019546 85.50 0
0 6.14 0.00 0.00 0.022339 744.33 55.00
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ALL PROG PACKAGE 5 6 25.80 0.230464 0.018377 0.143833 64.20!
----------------------------------------------------------------------------------------------------------------
*** GRAND TOTAL ***
121 500 0.10 3.18 7.36 0.252459 10.58 3.57
0 0.16 2.52 2.96 10:42.523735 0.011568 13.16 0
27 173.73 0.00 1.57 0.019976 70.31 4.95
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ALL PROG PACKAGE 140 61 39.67 0.108019 0.011003 0.057022 15.55!
----------------------------------------------------------------------------------------------------------------
LOCATION: OMPDB51 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 6-1
GROUP: N/P ACCOUNTING REPORT - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DB51 ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 08/24/16 08:17:26.37
DB2 VERSION: V11 SCOPE: MEMBER TO: 08/24/16 09:29:43.10
#OCCURS #COMMIT INSERTS OPENS PREPARE CLASS2 EL.TIME BUF.UPDT LOCK SUS
PRIMAUTH #DISTRS SELECTS UPDATES CLOSES CLASS1 EL.TIME CLASS2 CPUTIME SYN.READ #LOCKOUT
PLANNAME #ROLLBK FETCHES MERGES DELETES CLASS1 CPUTIME GETPAGES TOT.PREF
---------------------------------- ------- ------- ------- ------- -------------- -------------- -------- --------
DB2PM 9 0 0.00 0.00 0.00 0.001968 N/P 0.00
'BLANK' 0 0.00 0.00 0.00 1:01:34.703314 0.001001 N/P 0
0 0.00 0.00 0.00 0.009477 N/P N/P
DB2PM 3 12336 0.00 2923.00 0.00 0.656694 0.00 0.00
DB2PM 0 617.67 586.00 2923.00 59:03.377015 0.614368 2.67 0
3 2923.00 0.00 1.00 0.861259 8301.67 378.67
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!DGOZCHKB PACKAGE 1 1 2.00 0.001980 0.000899 0.000302 1.00!
!DGOZPC1 PACKAGE 3 3487 5833.00 0.292932 0.264283 0.021860 1164.00!
!DGOZPC2 PACKAGE 3 1743 1743.00 0.278159 0.268009 0.000190 0.67!
!DGOZPC4 PACKAGE 3 1743 2324.00 0.085597 0.081679 0.000000 0.00!
----------------------------------------------------------------------------------------------------------------
DB2PM 21 1209 29.67 54.24 174.95 0.251134 118.29 0.05
KO2PLAN 0 1.00 30.81 54.24 35:03.049442 0.117918 2.24 0
0 246.10 0.00 31.71 0.171146 805.76 1.19
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!DGOVEXCP PACKAGE 1 1 5270.00 1.728788 1.364789 0.336860 1065.00!
!FPEVWRPA PACKAGE 4 4 9.00 0.003903 0.002244 0.001298 2.00!
!FPEVWR2C PACKAGE 3 3 1392.00 0.352809 0.311820 0.009066 52.33!
----------------------------------------------------------------------------------------------------------------
*** TOTAL ***
DB2PM 33 13545 18.88 300.24 111.33 0.237881 103.50 0.03
0 56.79 72.88 300.24 44:28.075732 0.131163 2.29 0
3 422.33 0.00 20.27 0.189792 1742.75 48.38
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ALL PROG PACKAGE 18 6982 2176.89 0.265271 0.230669 0.024206 262.50!
----------------------------------------------------------------------------------------------------------------
MIS 2 8 0.00 1.00 1.00 0.096774 0.00 0.00
ADB 0 0.00 0.00 1.00 4:19.000484 0.003043 9.50 0
0 2.00 0.00 0.00 0.005096 26.50 0.00
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ADBMAIN PACKAGE 2 2 6.00 0.048995 0.001987 0.046690 5.50!
!ADBPARM PACKAGE 2 2 2.00 0.021260 0.000497 0.020785 2.50!
!ADB2CON PACKAGE 2 2 1.00 0.000040 0.000038 0.000000 0.00!
!ADB2GET PACKAGE 2 4 6.00 0.012750 0.000365 0.012404 3.00!
----------------------------------------------------------------------------------------------------------------
LOCATION: OMPDB51 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 6-2
GROUP: N/P ACCOUNTING REPORT - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DB51 ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 08/24/16 08:17:26.37
DB2 VERSION: V11 SCOPE: MEMBER TO: 08/24/16 09:29:43.10
#OCCURS #COMMIT INSERTS OPENS PREPARE CLASS2 EL.TIME BUF.UPDT LOCK SUS
PRIMAUTH #DISTRS SELECTS UPDATES CLOSES CLASS1 EL.TIME CLASS2 CPUTIME SYN.READ #LOCKOUT
PLANNAME #ROLLBK FETCHES MERGES DELETES CLASS1 CPUTIME GETPAGES TOT.PREF
---------------------------------- ------- ------- ------- ------- -------------- -------------- -------- --------
*** GRAND TOTAL ***
35 13553 17.80 283.14 105.03 0.225611 95.54 0.03
0 53.54 68.71 283.14 42:10.414289 0.123842 2.85 0
3 398.31 0.00 19.11 0.179238 1610.73 44.65
----------------------------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE #OCCURS #ALLOCS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ALL PROG PACKAGE 26 6992 1508.23 0.190037 0.159916 0.022902 182.58!
----------------------------------------------------------------------------------------------------------------
ACCOUNTING REPORT COMPLETE