Accounting Trace - Short
The short Accounting trace shows some of the most significant fields summarized by thread.
Short Accounting traces 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.
The following example shows a short version of the Accounting trace
produced by the following command:
...
ACCOUNTING
TRACE
LAYOUT (SHORT)
...Accounting Trace - Short
The following example shows a short version of the Accounting trace.
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-1
GROUP: N/P ACCOUNTING TRACE - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 08:18:18.92
DB2 VERSION: V10 PAGE DATE: 08/24/16
PRIMAUTH CORRNMBR ACCT TIMESTAMP SELECTS DELETES MERGES CPU TIME(CL1) GETPAGES TOT.PREF
PLANNAME CONNECT TERM. CONDITION OPENS INSERTS PREPARE EL. TIME(CL2) BUF.UPDT LOCK SUS
CORRNAME THR.TYPE COMMITS FETCHES UPDATES EL. TIME(CL1) CPU TIME(CL2) SYN.READ LOCKOUTS
-------- -------- --------------- ------- ------- -------------- -------------- -------- --------
MIS 'BLANK' 08:18:18.929442 0 0 0 0.005557 30 1
ADB TSO NORM DEALLOC 1 0 1 0.053410 0 0
MIS ALLIED 3 2 0 48.277700 0.003498 4 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ADB2GET PACKAGE 6 0.000333 0.000328 0.000000 0!
!ADB2CON PACKAGE 1 0.000041 0.000041 0.000000 0!
!ADBMAIN PACKAGE 6 0.052952 0.003046 0.049679 7!
----------------------------------------------------------------------------------------------
MIS 'BLANK' 08:18:52.804954 N/P N/P N/P 0.044812 800 118
DSNUTIL UTILITY ABNM PROG ABEND N/P N/P N/P 0.293246 12 0
MISIDC ALLIED 10 N/P N/P 1.790735 0.018438 36 0
MIS 'BLANK' 08:21:00.905714 0 0 0 0.002113 346 12
ADB27SPC TSO NORM DEALLOC 1 0 0 0.075858 0 0
MIS ALLIED 1 2 0 0.077495 0.001597 9 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ADB27SP PACKAGE 9 0.051289 0.001345 0.049855 15!
----------------------------------------------------------------------------------------------
MIS 'BLANK' 08:21:01.254177 1 0 0 0.010110 394 16
ADB27SPC TSO NORM DEALLOC 1 0 0 0.125321 10 0
MIS ALLIED 1 7 0 0.127365 0.009326 11 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ADB27SP PACKAGE 15 0.125278 0.009285 0.103551 15!
----------------------------------------------------------------------------------------------
MIS 'BLANK' 08:21:01.343215 N/P N/P N/P 0.000433 0 0
'BLANK' TSO NORM DEALLOC N/P N/P N/P 0.004626 0 N/P
MIS ALLIED 1 N/P N/P 0.004632 0.000427 0 N/P
MIS 'BLANK' 08:21:37.502064 0 0 0 0.001956 337 0
ADB27SPC TSO NORM DEALLOC 1 0 0 0.001430 0 0
MIS ALLIED 1 2 0 0.003141 0.001370 0 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ADB27SP PACKAGE 9 0.001376 0.001322 0.000000 0!
----------------------------------------------------------------------------------------------
MIS 'BLANK' 08:21:37.662951 1 0 0 0.011903 315 14
ADB27SPC TSO NORM DEALLOC 1 0 0 0.013670 10 0
MIS ALLIED 1 6 0 0.015371 0.011382 0 0
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-2
GROUP: N/P ACCOUNTING TRACE - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 08:18:18.92
DB2 VERSION: V10 PAGE DATE: 08/24/16
PRIMAUTH CORRNMBR ACCT TIMESTAMP SELECTS DELETES MERGES CPU TIME(CL1) GETPAGES TOT.PREF
PLANNAME CONNECT TERM. CONDITION OPENS INSERTS PREPARE EL. TIME(CL2) BUF.UPDT LOCK SUS
CORRNAME THR.TYPE COMMITS FETCHES UPDATES EL. TIME(CL1) CPU TIME(CL2) SYN.READ LOCKOUTS
-------- -------- --------------- ------- ------- -------------- -------------- -------- --------
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ADB27SP PACKAGE 14 0.013637 0.011353 0.000000 0!
----------------------------------------------------------------------------------------------
MIS 'BLANK' 08:21:37.728018 N/P N/P N/P 0.000389 0 0
'BLANK' TSO NORM DEALLOC N/P N/P N/P 0.004316 0 N/P
MIS ALLIED 1 N/P N/P 0.004353 0.000379 0 N/P
MIS 'BLANK' 08:22:10.306515 N/P N/P N/P 0.036566 793 102
DSNUTIL UTILITY ABNM PROG ABEND N/P N/P N/P 0.024508 12 0
MISIDC ALLIED 10 N/P N/P 0.154912 0.018146 0 0
MIS 'BLANK' 08:22:31.779027 0 0 0 0.089959 3009 113
ADB TSO NORM DEALLOC 7 2 17 0.332647 832 0
MIS ALLIED 14 21 0 3:10.604602 0.077087 39 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ADB2GET PACKAGE 6 0.000320 0.000316 0.000000 0!
!ADB2CON PACKAGE 1 0.000041 0.000041 0.000000 0!
!ADBMAIN PACKAGE 81 0.332195 0.076641 0.829595 118!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 09:03:22.794879 81493 694 0 19.018617 579314 1567
KO2PLAN RRSAF NORM END USER 94930 920 4436 14.068989 3705 3
'BLANK' ALLIED 11961 183935 2054 21:08:16.92267 12.023208 145 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRPA PACKAGE 32 0.016758 0.008963 0.005598 8!
!DGOVEXCP PACKAGE 7922 2.222845 1.690191 0.463894 1379!
!FPEVWR2C PACKAGE 3618 1.167043 0.919444 0.026050 137!
!DGOZCHKB PACKAGE 2 0.001000 0.000779 0.000000 0!
!DGOZPC1 PACKAGE 15960 0.877475 0.743542 0.077204 3027!
!DGOZPC2 PACKAGE 344874 7.823140 6.911345 0.002493 17!
!DGOZDATE PACKAGE 79818 0.934093 0.767495 0.000000 0!
!DGOZPC4 PACKAGE 6024 0.227013 0.214899 0.000000 0!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 09:18:00.000440 2 0 0 0.000401 10 0
KO2PLAN RRSAF NORM STALENESS 0 0 0 N/P 0 0
'BLANK' ALLIED 2 0 0 0.001347 N/P 0 0
DB2PM 'BLANK' 09:21:29.033173 8858 52 0 2.106302 63355 1778
KO2PLAN RRSAF NORM END USER 10160 6 176 10.199946 12 1
'BLANK' ALLIED 1251 25135 236 2:15:24.240585 1.094033 63 0
LOCATION: OMPDA5 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 1-3
GROUP: N/P ACCOUNTING TRACE - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DA5 ACTUAL FROM: 08/24/16 08:18:18.92
DB2 VERSION: V10 PAGE DATE: 08/24/16
PRIMAUTH CORRNMBR ACCT TIMESTAMP SELECTS DELETES MERGES CPU TIME(CL1) GETPAGES TOT.PREF
PLANNAME CONNECT TERM. CONDITION OPENS INSERTS PREPARE EL. TIME(CL2) BUF.UPDT LOCK SUS
CORRNAME THR.TYPE COMMITS FETCHES UPDATES EL. TIME(CL1) CPU TIME(CL2) SYN.READ LOCKOUTS
-------- -------- --------------- ------- ------- -------------- -------------- -------- --------
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRPA PACKAGE 2 0.000417 0.000394 0.000000 0!
!FPEVWR2C PACKAGE 384 0.129680 0.102263 0.003030 14!
!DGOZPC2 PACKAGE 36454 9.773484 0.737737 0.000304 2!
!DGOZDATE PACKAGE 8683 0.104788 0.081725 0.000000 0!
!DGOZPC1 PACKAGE 1590 0.083373 0.073120 0.006574 318!
!DGOZPC4 PACKAGE 636 0.023430 0.022416 0.000000 0!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 09:29:43.092513 4432 32 0 1.158943 33183 1685
DB2PM RRSAF NORM END USER 5052 6 104 0.603703 12 0
'BLANK' ALLIED 655 15517 126 56:43.869995 0.526870 6 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRPA PACKAGE 2 0.000913 0.000473 0.000000 0!
!FPEVWR2C PACKAGE 192 0.048516 0.043706 0.001238 6!
!DGOZPC2 PACKAGE 17633 0.414151 0.359071 0.000003 2!
!DGOZDATE PACKAGE 4081 0.047074 0.039262 0.000000 0!
!DGOZPC1 PACKAGE 1069 0.038439 0.035705 0.001971 154!
!DGOZPC4 PACKAGE 308 0.010961 0.010693 0.000000 0!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 09:41:00.009453 N/P N/P N/P 0.002014 0 0
'BLANK' RRSAF NORM STALENESS N/P N/P N/P N/P 0 0
'BLANK' ALLIED 0 N/P N/P 8:13.695925 N/P 0 0
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-1
GROUP: DBC1 ACCOUNTING TRACE - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ACTUAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12 PAGE DATE: 08/24/16
PRIMAUTH CORRNMBR ACCT TIMESTAMP SELECTS DELETES MERGES CPU TIME(CL1) GETPAGES TOT.PREF
PLANNAME CONNECT TERM. CONDITION OPENS INSERTS PREPARE EL. TIME(CL2) BUF.UPDT LOCK SUS
CORRNAME THR.TYPE COMMITS FETCHES UPDATES EL. TIME(CL1) CPU TIME(CL2) SYN.READ LOCKOUTS
-------- -------- --------------- ------- ------- -------------- -------------- -------- --------
DB2PM 'BLANK' 07:02:00.001641 0 0 0 0.006817 48 0
KO2PLAN RRSAF NORM STALENESS 20 0 24 0.058363 4 5
'BLANK' ALLIED 24 20 4 0.058896 0.006288 1 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 88 0.047027 0.005399 0.039315 14!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 07:16:00.002621 0 0 0 0.008521 60 0
KO2PLAN RRSAF NORM STALENESS 25 0 30 0.029507 5 0
'BLANK' ALLIED 30 25 5 0.030244 0.007807 0 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 110 0.011752 0.006384 0.002717 5!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 07:30:00.010339 0 0 0 0.008263 60 0
KO2PLAN RRSAF NORM STALENESS 25 0 30 0.028963 5 0
'BLANK' ALLIED 30 25 5 0.029757 0.007562 0 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 110 0.011564 0.006231 0.003202 5!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 07:45:00.000945 0 0 0 0.006962 48 0
KO2PLAN RRSAF NORM STALENESS 20 0 24 0.026348 4 1
'BLANK' ALLIED 24 20 4 0.026993 0.006341 0 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 88 0.009209 0.005065 0.002366 4!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 07:58:00.001003 0 0 0 0.008137 60 0
KO2PLAN RRSAF NORM STALENESS 25 0 30 0.024403 5 0
'BLANK' ALLIED 30 25 5 0.025180 0.007400 0 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 110 0.012073 0.006284 0.003909 5!
----------------------------------------------------------------------------------------------
MIS 'BLANK' 08:06:29.638496 0 0 0 0.002043 12 1
ADB27SPC TSO NORM DEALLOC 1 0 0 0.049194 0 1
MIS ALLIED 1 2 0 0.050798 0.001513 8 0
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-2
GROUP: DBC1 ACCOUNTING TRACE - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ACTUAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12 PAGE DATE: 08/24/16
PRIMAUTH CORRNMBR ACCT TIMESTAMP SELECTS DELETES MERGES CPU TIME(CL1) GETPAGES TOT.PREF
PLANNAME CONNECT TERM. CONDITION OPENS INSERTS PREPARE EL. TIME(CL2) BUF.UPDT LOCK SUS
CORRNAME THR.TYPE COMMITS FETCHES UPDATES EL. TIME(CL1) CPU TIME(CL2) SYN.READ LOCKOUTS
-------- -------- --------------- ------- ------- -------------- -------------- -------- --------
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ADB27SP PACKAGE 9 0.037525 0.000906 0.008376 5!
----------------------------------------------------------------------------------------------
MIS 'BLANK' 08:06:34.489475 1 0 0 2.058687 81963 5080
ADB27SPC TSO NORM DEALLOC 1 0 0 4.701144 0 1
MIS ALLIED 1 6 0 4.703404 2.057726 52 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ADB27SP PACKAGE 14 4.701106 2.057696 2.182460 5117!
----------------------------------------------------------------------------------------------
MIS 'BLANK' 08:06:34.601360 N/P N/P N/P 0.000408 0 0
'BLANK' TSO NORM DEALLOC N/P N/P N/P 0.038540 0 N/P
MIS ALLIED 1 N/P N/P 0.038544 0.000403 0 N/P
MIS 'BLANK' 08:06:34.772147 N/P N/P N/P 0.000348 0 0
'BLANK' TSO NORM DEALLOC N/P N/P N/P 0.004496 0 N/P
MIS ALLIED 1 N/P N/P 0.004499 0.000344 0 N/P
MIS 'BLANK' 08:08:36.801415 N/P N/P N/P 0.041090 1651 27
DSNUTIL UTILITY NORM DEALLOC N/P N/P N/P 2.163899 464 43
MISIDC ALLIED 28 N/P N/P 2.202907 0.036611 123 0
MIS1 'BLANK' 08:09:37.032181 N/P N/P N/P 0.006032 57 0
DSNUTIL UTILITY NORM DEALLOC N/P N/P N/P 0.052472 13 3
MISIDC ALLIED 10 N/P N/P 0.075969 0.004677 0 0
MIS 'BLANK' 08:09:52.382881 0 0 0 0.325938 82939 5136
ADB TSO NORM DEALLOC 5 1 10 6.930629 448 12
MIS ALLIED 9 24 0 4:39.789682 0.317732 102 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ADB2GET PACKAGE 6 0.000331 0.000324 0.000000 0!
!ADB2CON PACKAGE 1 0.000041 0.000041 0.000000 0!
!ADBMAIN PACKAGE 63 6.930166 0.317277 4.883117 5206!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 08:12:00.001684 0 0 0 0.006594 48 0
KO2PLAN RRSAF NORM STALENESS 20 0 24 0.026586 4 0
'BLANK' ALLIED 24 20 4 0.027222 0.006068 0 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 88 0.009215 0.004838 0.002516 4!
----------------------------------------------------------------------------------------------
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-3
GROUP: DBC1 ACCOUNTING TRACE - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ACTUAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12 PAGE DATE: 08/24/16
PRIMAUTH CORRNMBR ACCT TIMESTAMP SELECTS DELETES MERGES CPU TIME(CL1) GETPAGES TOT.PREF
PLANNAME CONNECT TERM. CONDITION OPENS INSERTS PREPARE EL. TIME(CL2) BUF.UPDT LOCK SUS
CORRNAME THR.TYPE COMMITS FETCHES UPDATES EL. TIME(CL1) CPU TIME(CL2) SYN.READ LOCKOUTS
-------- -------- --------------- ------- ------- -------------- -------------- -------- --------
DB2PM 'BLANK' 08:26:00.003481 0 0 0 0.008326 60 0
KO2PLAN RRSAF NORM STALENESS 25 0 30 0.030577 5 0
'BLANK' ALLIED 30 25 5 0.031337 0.007633 5 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 110 0.013467 0.006254 0.004305 10!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 08:39:00.000994 0 0 0 0.006871 48 0
KO2PLAN RRSAF NORM STALENESS 20 0 24 0.022722 4 0
'BLANK' ALLIED 24 20 4 0.023335 0.006289 0 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 88 0.010631 0.005273 0.002740 4!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 08:53:00.003331 0 0 0 0.008192 60 0
KO2PLAN RRSAF NORM STALENESS 25 0 30 0.030533 5 0
'BLANK' ALLIED 30 25 5 0.031266 0.007483 0 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 110 0.013516 0.006225 0.004495 6!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 09:01:19.374179 6 750 0 5.238321 27950 418
KO2PLAN RRSAF NORM END USER 1577 1108 5070 45.025345 4479 361
'BLANK' ALLIED 1586 2743 532 13:18:16.08950 3.440602 152 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 44 0.004293 0.002398 0.001081 2!
!FPEVWRPA PACKAGE 6 0.027109 0.005337 0.016964 12!
!DGOVEXCP PACKAGE 9526 26.533861 2.278888 23.958403 3383!
!FPEVWR2C PACKAGE 3618 13.022947 1.111549 11.716457 627!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 09:12:47.179187 0 0 0 0.008721 48 0
KO2PLAN RRSAF NORM END USER 20 0 24 0.017791 4 0
'BLANK' ALLIED 24 20 4 2:39:55.959753 0.004344 0 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 66 0.006536 0.003498 0.001276 3!
----------------------------------------------------------------------------------------------
LOCATION: OMPDBC1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-4
GROUP: DBC1 ACCOUNTING TRACE - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: SC11 TO: NOT SPECIFIED
SUBSYSTEM: SC11 ACTUAL FROM: 08/24/16 07:02:00.00
DB2 VERSION: V12 PAGE DATE: 08/24/16
PRIMAUTH CORRNMBR ACCT TIMESTAMP SELECTS DELETES MERGES CPU TIME(CL1) GETPAGES TOT.PREF
PLANNAME CONNECT TERM. CONDITION OPENS INSERTS PREPARE EL. TIME(CL2) BUF.UPDT LOCK SUS
CORRNAME THR.TYPE COMMITS FETCHES UPDATES EL. TIME(CL1) CPU TIME(CL2) SYN.READ LOCKOUTS
-------- -------- --------------- ------- ------- -------------- -------------- -------- --------
DB2PM 'BLANK' 09:13:00.004470 N/P N/P N/P 0.195725 0 0
KO2PLAN RRSAF NORM STALENESS N/P N/P N/P 3.434947 0 0
OMEGAMON ALLIED 0 N/P N/P 2:38:29.497535 0.042030 0 0
DB2PM 09:20:20.453396 1 7 0 0.086478 714 0
'BLANK' RRSAF NORM END USER 16 3 46 0.427041 14 4
ALLIED 30 16 20 33:48.841437 0.019919 15 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 44 0.005041 0.002758 0.001368 2!
!FPEVWRPA PACKAGE 6 0.002133 0.000826 0.001043 1!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 09:26:42.034796 5 40 0 0.326233 316 4
KO2PLAN RRSAF NORM END USER 61 0 157 0.354745 2 33
'BLANK' ALLIED 67 1227 59 1:07:57.571559 0.116209 4 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWR2C PACKAGE 384 0.341052 0.113764 0.214333 57!
!FPEVWRP2 PACKAGE 22 0.002171 0.001227 0.000513 1!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 09:32:00.000950 N/P N/P N/P 0.034667 0 0
KO2PLAN RRSAF NORM STALENESS N/P N/P N/P 0.023040 0 0
OMEGAMON ALLIED 0 N/P N/P 24:15.880606 0.006538 0 0
DB2PM 'BLANK' 09:40:58.536089 6 27 0 0.219075 317 1
KO2PLAN RRSAF NORM END USER 33 5 102 0.228800 12 19
'BLANK' ALLIED 50 1199 39 49:03.333417 0.061006 0 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 22 0.001915 0.001066 0.000499 1!
!FPEVWRPA PACKAGE 6 0.002420 0.000888 0.000682 1!
!FPEVWR2C PACKAGE 192 0.186095 0.052527 0.127764 25!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 09:56:00.001016 0 0 0 0.006545 50 0
KO2PLAN RRSAF NORM STALENESS 25 0 25 0.017547 0 0
'BLANK' ALLIED 30 25 0 0.171328 0.004822 0 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 80 0.005422 0.003744 0.000071 4!
----------------------------------------------------------------------------------------------
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 3-1
GROUP: DBEE ACCOUNTING TRACE - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE1 TO: NOT SPECIFIED
SUBSYSTEM: SEE1 ACTUAL FROM: 08/24/16 08:16:02.78
DB2 VERSION: V11 PAGE DATE: 08/24/16
PRIMAUTH CORRNMBR ACCT TIMESTAMP SELECTS DELETES MERGES CPU TIME(CL1) GETPAGES TOT.PREF
PLANNAME CONNECT TERM. CONDITION OPENS INSERTS PREPARE EL. TIME(CL2) BUF.UPDT LOCK SUS
CORRNAME THR.TYPE COMMITS FETCHES UPDATES EL. TIME(CL1) CPU TIME(CL2) SYN.READ LOCKOUTS
-------- -------- --------------- ------- ------- -------------- -------------- -------- --------
MIS 'BLANK' 08:16:02.787508 N/P N/P N/P 0.305161 144960 12788
DSNUTIL UTILITY NORM DEALLOC N/P N/P N/P N/P 467 52
MISIDC ALLIED 26 N/P N/P 2.411696 N/P 147 0
MIS 'BLANK' 08:16:02.926351 N/P N/P N/P 0.003552 142 7
DSNUTIL UTILITY NORM DEALLOC N/P N/P N/P N/P 13 3
MISIDC ALLIED 10 N/P N/P 0.075986 N/P 0 0
DB2PM 'BLANK' 09:16:33.119594 2 0 0 0.010277 116 0
KO2PLAN RRSAF NORM END USER 11 2 15 0.113032 2 2
'BLANK' ALLIED 16 11 1 0.171472 0.007403 1 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 32 0.096422 0.006444 0.006194 4!
----------------------------------------------------------------------------------------------
DB2PM 09:28:00.001512 184 7 0 0.366568 3932 1055
'BLANK' RRSAF NORM STALENESS 396 4 18 2.419360 11 28
ALLIED 500 3498 68 47:31.090097 0.147791 167 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRPA PACKAGE 6 0.014902 0.004894 0.004718 9!
!DGOZPC2 PACKAGE 420 0.070453 0.047602 0.000000 0!
!DGOZDATE PACKAGE 60 0.002446 0.002390 0.000000 0!
!DGOZPC1 PACKAGE 603 2.149922 0.043017 2.078318 122!
!DGOZPC4 PACKAGE 240 0.028219 0.015639 0.000000 0!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 09:28:00.002481 N/P N/P N/P 0.015119 0 0
KO2PLAN RRSAF NORM STALENESS N/P N/P N/P 0.014772 0 0
OMEGAMON ALLIED 0 N/P N/P 8:05.846810 0.004553 0 0
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 4-1
GROUP: DBEE ACCOUNTING TRACE - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE2 TO: NOT SPECIFIED
SUBSYSTEM: SEE2 ACTUAL FROM: 08/24/16 07:08:00.00
DB2 VERSION: V11 PAGE DATE: 08/24/16
PRIMAUTH CORRNMBR ACCT TIMESTAMP SELECTS DELETES MERGES CPU TIME(CL1) GETPAGES TOT.PREF
PLANNAME CONNECT TERM. CONDITION OPENS INSERTS PREPARE EL. TIME(CL2) BUF.UPDT LOCK SUS
CORRNAME THR.TYPE COMMITS FETCHES UPDATES EL. TIME(CL1) CPU TIME(CL2) SYN.READ LOCKOUTS
-------- -------- --------------- ------- ------- -------------- -------------- -------- --------
DB2PM 'BLANK' 07:08:00.000991 0 0 0 0.006385 50 0
KO2PLAN RRSAF NORM STALENESS 25 0 25 0.018700 0 0
'BLANK' ALLIED 30 25 0 0.019284 0.005811 2 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 100 0.008006 0.004911 0.000770 7!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 07:22:00.000580 0 0 0 0.007555 50 0
KO2PLAN RRSAF NORM STALENESS 25 0 25 0.025554 0 0
'BLANK' ALLIED 30 25 0 0.026339 0.006865 1 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 100 0.009323 0.005755 0.000715 8!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 07:36:00.000721 0 0 0 0.005831 40 0
KO2PLAN RRSAF NORM STALENESS 20 0 20 0.022280 0 0
'BLANK' ALLIED 24 20 0 0.022827 0.005291 1 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 80 0.006712 0.004267 0.000339 5!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 07:50:00.001371 0 0 0 0.006910 50 0
KO2PLAN RRSAF NORM STALENESS 25 0 25 0.026007 0 0
'BLANK' ALLIED 30 25 0 0.026635 0.006289 2 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 100 0.008166 0.005129 0.000702 7!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 08:02:00.021003 0 0 0 0.005354 40 0
KO2PLAN RRSAF NORM STALENESS 20 0 20 0.017447 0 0
'BLANK' ALLIED 24 20 0 0.018000 0.004839 0 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 80 0.006536 0.004107 0.000072 4!
----------------------------------------------------------------------------------------------
MIS 'BLANK' 08:15:21.225653 0 0 0 0.010615 67 1
ADB TSO NORM DEALLOC 2 0 2 0.084914 0 2
MIS ALLIED 5 11 0 25.835590 0.007726 9 0
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 4-2
GROUP: DBEE ACCOUNTING TRACE - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE2 TO: NOT SPECIFIED
SUBSYSTEM: SEE2 ACTUAL FROM: 08/24/16 07:08:00.00
DB2 VERSION: V11 PAGE DATE: 08/24/16
PRIMAUTH CORRNMBR ACCT TIMESTAMP SELECTS DELETES MERGES CPU TIME(CL1) GETPAGES TOT.PREF
PLANNAME CONNECT TERM. CONDITION OPENS INSERTS PREPARE EL. TIME(CL2) BUF.UPDT LOCK SUS
CORRNAME THR.TYPE COMMITS FETCHES UPDATES EL. TIME(CL1) CPU TIME(CL2) SYN.READ LOCKOUTS
-------- -------- --------------- ------- ------- -------------- -------------- -------- --------
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ADB2GET PACKAGE 6 0.000202 0.000197 0.000000 0!
!ADB2CON PACKAGE 1 0.000039 0.000039 0.000000 0!
!ADBPARM PACKAGE 2 0.000224 0.000200 0.000000 0!
!ADBMAIN PACKAGE 19 0.084382 0.007224 0.068382 14!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 08:17:00.002930 0 0 0 0.008907 86 0
KO2PLAN RRSAF NORM STALENESS 21 2 37 0.041493 6 4
'BLANK' ALLIED 26 21 13 0.042180 0.008219 1 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 116 0.025316 0.007099 0.014487 14!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 08:32:00.000942 0 0 0 0.008235 60 0
KO2PLAN RRSAF NORM STALENESS 25 0 30 0.029390 5 0
'BLANK' ALLIED 30 25 5 0.030244 0.007518 2 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 110 0.013651 0.006391 0.004327 7!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 08:45:00.002199 0 0 0 0.006262 48 0
KO2PLAN RRSAF NORM STALENESS 20 0 24 0.026913 4 0
'BLANK' ALLIED 24 20 4 0.027461 0.005726 1 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 88 0.010995 0.004747 0.003629 6!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 08:58:00.004783 0 0 0 0.006567 48 0
KO2PLAN RRSAF NORM STALENESS 20 0 24 0.022655 4 0
'BLANK' ALLIED 24 20 4 0.023452 0.005983 1 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 88 0.011504 0.005146 0.003790 5!
----------------------------------------------------------------------------------------------
DB2PM 09:01:07.387859 3019 293 0 5.605112 42046 43
'BLANK' RRSAF NORM END USER 9676 459 2032 27.834364 1847 338
ALLIED 11193 14220 1700 18:28:25.39167 4.293098 178 0
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 4-3
GROUP: DBEE ACCOUNTING TRACE - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE2 TO: NOT SPECIFIED
SUBSYSTEM: SEE2 ACTUAL FROM: 08/24/16 07:08:00.00
DB2 VERSION: V11 PAGE DATE: 08/24/16
PRIMAUTH CORRNMBR ACCT TIMESTAMP SELECTS DELETES MERGES CPU TIME(CL1) GETPAGES TOT.PREF
PLANNAME CONNECT TERM. CONDITION OPENS INSERTS PREPARE EL. TIME(CL2) BUF.UPDT LOCK SUS
CORRNAME THR.TYPE COMMITS FETCHES UPDATES EL. TIME(CL1) CPU TIME(CL2) SYN.READ LOCKOUTS
-------- -------- --------------- ------- ------- -------------- -------------- -------- --------
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 46 0.006471 0.002426 0.001844 3!
!FPEVWRPA PACKAGE 14 0.027169 0.009114 0.012829 18!
!DGOVEXCP PACKAGE 3942 2.192355 0.990217 1.101690 1107!
!FPEVWR2C PACKAGE 1296 2.382283 0.330348 2.000514 199!
!DGOZCHKB PACKAGE 2 0.004624 0.001057 0.002596 3!
!DGOZPC1 PACKAGE 15096 2.763138 0.948087 1.302044 3033!
!DGOZPC2 PACKAGE 10528 2.490285 1.077723 0.975582 51!
!DGOZDATE PACKAGE 1504 0.062824 0.059400 0.000427 1!
!DGOZPC4 PACKAGE 6016 1.133495 0.348258 0.506277 4!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 09:12:44.174540 2 0 0 0.007890 58 0
KO2PLAN RRSAF NORM END USER 20 0 24 0.020276 4 0
'BLANK' ALLIED 26 20 4 0.038290 0.005021 2 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 66 0.009286 0.004284 0.002651 3!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 09:13:00.004632 N/P N/P N/P 0.303294 0 0
KO2PLAN RRSAF NORM STALENESS N/P N/P N/P 0.643887 0 0
OMEGAMON ALLIED 0 N/P N/P 2:38:29.495333 0.099692 0 0
DB2PM 'BLANK' 09:16:39.383954 292 40 0 0.516880 4855 1053
KO2PLAN RRSAF NORM END USER 758 6 154 0.552142 19 27
'BLANK' ALLIED 934 3914 185 1:25:18.138671 0.259413 104 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRPA PACKAGE 6 0.002049 0.000752 0.000856 1!
!FPEVWR2C PACKAGE 258 0.215159 0.067499 0.130415 37!
!DGOZPC2 PACKAGE 805 0.114918 0.080446 0.000000 0!
!DGOZDATE PACKAGE 115 0.004741 0.004543 0.000000 0!
!DGOZPC1 PACKAGE 1153 0.112785 0.071542 0.004170 231!
!DGOZPC4 PACKAGE 460 0.047836 0.026444 0.000000 0!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 09:20:14.841854 3 12 0 0.017845 161 0
KO2PLAN RRSAF NORM END USER 22 6 77 0.034442 23 0
'BLANK' ALLIED 49 22 37 3:35.431707 0.013458 0 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVTCO1 PACKAGE 2 0.000284 0.000280 0.000000 0!
!FPEVWRP2 PACKAGE 132 0.013577 0.005936 0.003830 4!
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 4-4
GROUP: DBEE ACCOUNTING TRACE - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE2 TO: NOT SPECIFIED
SUBSYSTEM: SEE2 ACTUAL FROM: 08/24/16 07:08:00.00
DB2 VERSION: V11 PAGE DATE: 08/24/16
PRIMAUTH CORRNMBR ACCT TIMESTAMP SELECTS DELETES MERGES CPU TIME(CL1) GETPAGES TOT.PREF
PLANNAME CONNECT TERM. CONDITION OPENS INSERTS PREPARE EL. TIME(CL2) BUF.UPDT LOCK SUS
CORRNAME THR.TYPE COMMITS FETCHES UPDATES EL. TIME(CL1) CPU TIME(CL2) SYN.READ LOCKOUTS
-------- -------- --------------- ------- ------- -------------- -------------- -------- --------
(CONTINUED)
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRPA PACKAGE 67 0.018810 0.006520 0.006902 13!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 09:21:35.926846 127 8 0 0.249438 3020 1044
KO2PLAN RRSAF NORM END USER 229 0 32 0.155214 1 5
'BLANK' ALLIED 302 3302 49 22:26.619302 0.071734 3 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWR2C PACKAGE 48 0.010908 0.004423 0.004144 1!
!DGOVSDOB PACKAGE 3054 0.023059 0.016264 0.002115 1!
!DGOZCHKB PACKAGE 51 0.024374 0.014012 0.002236 37!
!DGOZPC1 PACKAGE 602 0.023042 0.011190 0.005555 33!
!DGOZPC2 PACKAGE 105 0.023130 0.012226 0.000196 1!
!DGOZDATE PACKAGE 15 0.000606 0.000591 N/P N/P!
!DGOZPC4 PACKAGE 60 0.006430 0.003626 N/P N/P!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 09:27:00.002528 N/P N/P N/P 0.030473 0 0
KO2PLAN RRSAF NORM STALENESS N/P N/P N/P 0.023877 0 0
OMEGAMON ALLIED 0 N/P N/P 14:30.335179 0.009544 0 0
DB2PM 'BLANK' 09:29:44.116433 6 32 0 0.128658 451 7
KO2PLAN RRSAF NORM END USER 44 8 130 0.195942 20 16
'BLANK' ALLIED 73 3082 48 40:48.854570 0.054203 1 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 44 0.004828 0.002246 0.001634 2!
!FPEVWRPA PACKAGE 6 0.002465 0.000826 0.000915 1!
!FPEVWR2C PACKAGE 192 0.169351 0.048319 0.113521 25!
----------------------------------------------------------------------------------------------
DB2PM 09:40:00.001842 212 1 0 0.275400 3647 1037
'BLANK' RRSAF NORM STALENESS 489 0 0 0.186022 0 0
ALLIED 601 570 83 16:33.188075 0.123437 0 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!DGOZPC2 PACKAGE 539 0.077726 0.055455 N/P N/P!
!DGOZDATE PACKAGE 77 0.003041 0.002973 N/P N/P!
!DGOZPC1 PACKAGE 795 0.073849 0.047466 0.002634 154!
!DGOZPC4 PACKAGE 308 0.031374 0.017430 N/P N/P!
----------------------------------------------------------------------------------------------
LOCATION: OMPDBEE OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 4-5
GROUP: DBEE ACCOUNTING TRACE - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: SEE2 TO: NOT SPECIFIED
SUBSYSTEM: SEE2 ACTUAL FROM: 08/24/16 07:08:00.00
DB2 VERSION: V11 PAGE DATE: 08/24/16
PRIMAUTH CORRNMBR ACCT TIMESTAMP SELECTS DELETES MERGES CPU TIME(CL1) GETPAGES TOT.PREF
PLANNAME CONNECT TERM. CONDITION OPENS INSERTS PREPARE EL. TIME(CL2) BUF.UPDT LOCK SUS
CORRNAME THR.TYPE COMMITS FETCHES UPDATES EL. TIME(CL1) CPU TIME(CL2) SYN.READ LOCKOUTS
-------- -------- --------------- ------- ------- -------------- -------------- -------- --------
DB2PM 'BLANK' 09:40:00.001955 N/P N/P N/P 0.015818 0 0
KO2PLAN RRSAF NORM STALENESS N/P N/P N/P 0.008832 0 0
OMEGAMON ALLIED 0 N/P N/P 7:45.553988 0.005219 0 0
DB2PM 'BLANK' 09:51:14.254063 2 0 0 0.005867 50 0
KO2PLAN RRSAF NORM END USER 20 0 20 0.015363 0 0
'BLANK' ALLIED 26 20 0 0.957269 0.003400 0 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 60 0.003968 0.002645 0.000051 3!
----------------------------------------------------------------------------------------------
LOCATION: OMPDBZ2 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 5-1
GROUP: DBZ2 ACCOUNTING TRACE - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: SZ22 TO: NOT SPECIFIED
SUBSYSTEM: SZ22 ACTUAL FROM: 08/24/16 07:05:32.04
DB2 VERSION: V10 PAGE DATE: 08/24/16
PRIMAUTH CORRNMBR ACCT TIMESTAMP SELECTS DELETES MERGES CPU TIME(CL1) GETPAGES TOT.PREF
PLANNAME CONNECT TERM. CONDITION OPENS INSERTS PREPARE EL. TIME(CL2) BUF.UPDT LOCK SUS
CORRNAME THR.TYPE COMMITS FETCHES UPDATES EL. TIME(CL1) CPU TIME(CL2) SYN.READ LOCKOUTS
-------- -------- --------------- ------- ------- -------------- -------------- -------- --------
DB2PM 'BLANK' 07:05:32.045572 0 0 0 0.003533 5 0
KO2PLAN RRSAF NORM END USER 5 0 5 0.014251 0 0
'BLANK' ALLIED 5 5 0 0.014531 0.003254 0 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 15 0.003380 0.002343 0.000801 10!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 07:18:29.692599 0 0 0 0.003329 4 0
KO2PLAN RRSAF NORM END USER 4 0 4 0.019136 0 0
'BLANK' ALLIED 4 4 0 0.019427 0.003045 0 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 12 0.002839 0.001997 0.000662 8!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 07:31:00.001016 0 0 0 0.002992 4 0
KO2PLAN RRSAF NORM STALENESS 4 0 4 0.025926 0 0
'BLANK' ALLIED 4 4 0 0.026223 0.002741 0 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 12 0.015225 0.001936 0.013189 9!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 07:43:51.729755 0 0 0 0.003225 4 0
KO2PLAN RRSAF NORM END USER 4 0 4 0.018731 0 0
'BLANK' ALLIED 4 4 0 0.019006 0.002959 0 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 12 0.002705 0.001918 0.000664 8!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 07:57:36.745026 0 0 0 0.003509 5 0
KO2PLAN RRSAF NORM END USER 5 0 5 0.014682 0 0
'BLANK' ALLIED 5 5 0 0.014946 0.003240 0 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 15 0.003394 0.002379 0.000807 10!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 08:09:49.030656 0 0 0 0.003223 4 0
KO2PLAN RRSAF NORM END USER 4 0 4 0.020432 0 0
'BLANK' ALLIED 4 4 0 0.020679 0.002970 0 0
LOCATION: OMPDBZ2 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 5-2
GROUP: DBZ2 ACCOUNTING TRACE - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: SZ22 TO: NOT SPECIFIED
SUBSYSTEM: SZ22 ACTUAL FROM: 08/24/16 07:05:32.04
DB2 VERSION: V10 PAGE DATE: 08/24/16
PRIMAUTH CORRNMBR ACCT TIMESTAMP SELECTS DELETES MERGES CPU TIME(CL1) GETPAGES TOT.PREF
PLANNAME CONNECT TERM. CONDITION OPENS INSERTS PREPARE EL. TIME(CL2) BUF.UPDT LOCK SUS
CORRNAME THR.TYPE COMMITS FETCHES UPDATES EL. TIME(CL1) CPU TIME(CL2) SYN.READ LOCKOUTS
-------- -------- --------------- ------- ------- -------------- -------------- -------- --------
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 12 0.002668 0.001907 0.000503 8!
----------------------------------------------------------------------------------------------
MIS 'BLANK' 08:11:44.410940 0 0 0 0.001597 11 0
ADB27SPC TSO NORM DEALLOC 1 0 0 0.026215 0 1
MIS ALLIED 1 2 0 0.027784 0.001106 7 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ADB27SP PACKAGE 9 0.015071 0.000656 0.014318 4!
----------------------------------------------------------------------------------------------
MIS 'BLANK' 08:11:45.764460 1 0 0 0.014385 477 26
ADB27SPC TSO NORM DEALLOC 1 0 0 0.119782 10 0
MIS ALLIED 1 6 0 0.121802 0.013648 26 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ADB27SP PACKAGE 14 0.119711 0.013577 0.087290 30!
----------------------------------------------------------------------------------------------
MIS 'BLANK' 08:11:45.842195 N/P N/P N/P 0.000375 0 0
'BLANK' TSO NORM DEALLOC N/P N/P N/P 0.005642 0 N/P
MIS ALLIED 1 N/P N/P 0.005646 0.000370 0 N/P
MIS 'BLANK' 08:12:34.842144 N/P N/P N/P 0.038508 1789 205
DSNUTIL UTILITY NORM DEALLOC N/P N/P N/P 2.790666 412 40
MISIDC ALLIED 24 N/P N/P 2.856899 0.033877 163 0
MIS 'BLANK' 08:12:35.035478 N/P N/P N/P 0.006573 154 10
DSNUTIL UTILITY NORM DEALLOC N/P N/P N/P 0.107999 13 3
MISIDC ALLIED 10 N/P N/P 0.128838 0.005444 71 0
MIS 'BLANK' 08:14:30.252056 N/P N/P N/P 0.005247 69 3
DSNUTIL UTILITY NORM DEALLOC N/P N/P N/P 0.059097 16 5
MISIDC ALLIED 10 N/P N/P 0.081857 0.004209 8 0
MIS 'BLANK' 08:14:49.713117 0 0 0 0.089688 1966 86
ADB TSO NORM DEALLOC 8 2 18 1.040978 764 7
MIS ALLIED 15 35 0 4:52.468235 0.078167 238 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ADB2GET PACKAGE 6 0.072743 0.001239 0.049363 5!
!ADB2CON PACKAGE 1 0.000043 0.000043 0.000000 0!
!ADBMAIN PACKAGE 99 0.944751 0.076371 0.568195 282!
----------------------------------------------------------------------------------------------
LOCATION: OMPDBZ2 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 5-3
GROUP: DBZ2 ACCOUNTING TRACE - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: SZ22 TO: NOT SPECIFIED
SUBSYSTEM: SZ22 ACTUAL FROM: 08/24/16 07:05:32.04
DB2 VERSION: V10 PAGE DATE: 08/24/16
PRIMAUTH CORRNMBR ACCT TIMESTAMP SELECTS DELETES MERGES CPU TIME(CL1) GETPAGES TOT.PREF
PLANNAME CONNECT TERM. CONDITION OPENS INSERTS PREPARE EL. TIME(CL2) BUF.UPDT LOCK SUS
CORRNAME THR.TYPE COMMITS FETCHES UPDATES EL. TIME(CL1) CPU TIME(CL2) SYN.READ LOCKOUTS
-------- -------- --------------- ------- ------- -------------- -------------- -------- --------
DB2PM 'BLANK' 08:23:00.002444 0 0 0 0.006732 61 4
KO2PLAN RRSAF NORM STALENESS 16 0 28 0.102024 4 2
'BLANK' ALLIED 19 16 12 0.102582 0.006182 6 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 87 0.090618 0.005381 0.081550 24!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 08:34:34.992242 0 0 0 0.015087 158 6
KO2PLAN RRSAF NORM END USER 20 0 24 0.154202 4 8
'BLANK' ALLIED 24 20 4 0.154867 0.014433 24 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 88 0.136917 0.013381 0.107816 43!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 08:48:00.000711 0 0 0 0.006748 48 0
KO2PLAN RRSAF NORM STALENESS 20 0 24 0.022597 4 0
'BLANK' ALLIED 24 20 4 0.024144 0.006154 2 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 88 0.012017 0.005398 0.004213 6!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 09:00:05.776454 0 0 0 0.008613 48 0
KO2PLAN RRSAF NORM END USER 20 0 24 1.973761 4 0
'BLANK' ALLIED 24 20 4 1.975112 0.008037 0 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 88 1.955239 0.007001 0.006194 5!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 09:01:17.301765 6 116 0 1.718414 1688 105
KO2PLAN RRSAF NORM END USER 143 2 417 14.540830 7 313
'BLANK' ALLIED 150 7010 159 15:55:47.22613 1.007260 260 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRPA PACKAGE 6 0.028750 0.005713 0.021168 34!
!FPEVWR2C PACKAGE 1074 2.603366 0.334003 2.221136 349!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 09:08:41.190051 0 0 0 0.006396 24 2
KO2PLAN RRSAF NORM END USER 10 0 12 0.008825 2 0
'BLANK' ALLIED 12 10 2 2:39:52.254519 0.001893 0 0
LOCATION: OMPDBZ2 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 5-4
GROUP: DBZ2 ACCOUNTING TRACE - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: SZ22 TO: NOT SPECIFIED
SUBSYSTEM: SZ22 ACTUAL FROM: 08/24/16 07:05:32.04
DB2 VERSION: V10 PAGE DATE: 08/24/16
PRIMAUTH CORRNMBR ACCT TIMESTAMP SELECTS DELETES MERGES CPU TIME(CL1) GETPAGES TOT.PREF
PLANNAME CONNECT TERM. CONDITION OPENS INSERTS PREPARE EL. TIME(CL2) BUF.UPDT LOCK SUS
CORRNAME THR.TYPE COMMITS FETCHES UPDATES EL. TIME(CL1) CPU TIME(CL2) SYN.READ LOCKOUTS
-------- -------- --------------- ------- ------- -------------- -------------- -------- --------
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 22 0.003711 0.001575 0.001184 1!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 09:16:57.977947 0 0 0 0.006567 36 0
KO2PLAN RRSAF NORM END USER 15 0 18 8.951616 3 0
'BLANK' ALLIED 18 15 3 8.952266 0.006007 3 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 66 0.011289 0.004584 0.003497 6!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 09:20:20.463379 1 7 0 0.075596 615 0
'BLANK' RRSAF NORM END USER 11 3 40 0.046847 13 4
'BLANK' ALLIED 24 11 19 50:18.999124 0.011520 8 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 22 0.002090 0.001043 0.000762 1!
!FPEVWRPA PACKAGE 6 0.002059 0.000846 0.000857 1!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 09:21:35.932180 5 40 0 0.233125 624 74
KO2PLAN RRSAF NORM END USER 56 0 151 0.317623 1 31
'BLANK' ALLIED 61 6924 58 1:08:00.424742 0.126415 368 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWR2C PACKAGE 384 0.312202 0.125676 0.157372 58!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 09:29:38.911662 1 7 0 0.027651 119 2
KO2PLAN RRSAF NORM END USER 11 5 35 0.025847 13 4
OMEGAMON ALLIED 25 11 11 15:54.241370 0.007946 16 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRP2 PACKAGE 44 0.004898 0.002263 0.001772 3!
!FPEVWRPA PACKAGE 6 0.003549 0.000959 0.002030 2!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 09:41:00.009472 5 20 0 0.135941 524 71
'BLANK' RRSAF NORM STALENESS 27 0 73 0.139852 0 14
'BLANK' ALLIED 31 6895 29 40:45.211259 0.048907 379 0
LOCATION: OMPDBZ2 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 5-5
GROUP: DBZ2 ACCOUNTING TRACE - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: SZ22 TO: NOT SPECIFIED
SUBSYSTEM: SZ22 ACTUAL FROM: 08/24/16 07:05:32.04
DB2 VERSION: V10 PAGE DATE: 08/24/16
PRIMAUTH CORRNMBR ACCT TIMESTAMP SELECTS DELETES MERGES CPU TIME(CL1) GETPAGES TOT.PREF
PLANNAME CONNECT TERM. CONDITION OPENS INSERTS PREPARE EL. TIME(CL2) BUF.UPDT LOCK SUS
CORRNAME THR.TYPE COMMITS FETCHES UPDATES EL. TIME(CL1) CPU TIME(CL2) SYN.READ LOCKOUTS
-------- -------- --------------- ------- ------- -------------- -------------- -------- --------
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWR2C PACKAGE 192 0.131928 0.047971 0.075986 26!
----------------------------------------------------------------------------------------------
LOCATION: OMPDB51 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 6-1
GROUP: N/P ACCOUNTING TRACE - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DB51 ACTUAL FROM: 08/24/16 08:17:26.37
DB2 VERSION: V11 PAGE DATE: 08/24/16
PRIMAUTH CORRNMBR ACCT TIMESTAMP SELECTS DELETES MERGES CPU TIME(CL1) GETPAGES TOT.PREF
PLANNAME CONNECT TERM. CONDITION OPENS INSERTS PREPARE EL. TIME(CL2) BUF.UPDT LOCK SUS
CORRNAME THR.TYPE COMMITS FETCHES UPDATES EL. TIME(CL1) CPU TIME(CL2) SYN.READ LOCKOUTS
-------- -------- --------------- ------- ------- -------------- -------------- -------- --------
MIS 'BLANK' 08:17:26.378658 0 0 0 0.006609 50 0
ADB TSO NORM DEALLOC 1 0 1 0.185417 0 0
MIS ALLIED 4 2 0 1:14.207272 0.004468 19 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ADB2GET PACKAGE 6 0.025304 0.000534 0.024807 6!
!ADB2CON PACKAGE 1 0.000044 0.000041 0.000000 0!
!ADBPARM PACKAGE 2 0.042306 0.000784 0.041570 5!
!ADBMAIN PACKAGE 6 0.090362 0.002854 0.087072 8!
----------------------------------------------------------------------------------------------
MIS 'BLANK' 08:29:58.397531 0 0 0 0.003583 3 0
ADB TSO NORM DEALLOC 1 0 1 0.008132 0 0
MIS ALLIED 4 2 0 7:23.793696 0.001618 0 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!ADB2GET PACKAGE 6 0.000196 0.000195 0.000000 0!
!ADB2CON PACKAGE 1 0.000036 0.000035 0.000000 0!
!ADBPARM PACKAGE 2 0.000213 0.000210 0.000000 0!
!ADBMAIN PACKAGE 6 0.007628 0.001119 0.006307 3!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 09:00:54.937191 0 1 0 0.000482 1 0
KO2PLAN RRSAF NORM DEALLOC 0 0 1 0.000546 0 0
'BLANK' ALLIED 1 0 0 0.000593 0.000450 0 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRPA PACKAGE 2 0.000453 0.000377 0.000000 0!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 09:00:54.938142 1 213 0 1.610971 14448 0
KO2PLAN RRSAF NORM DEALLOC 608 614 2057 1.781883 2466 0
'BLANK' ALLIED 628 608 14 2:39:31.437986 1.407663 10 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRPA PACKAGE 30 0.012983 0.007400 0.005191 8!
!DGOVEXCP PACKAGE 5270 1.728788 1.364789 0.336860 1065!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 09:00:55.933113 N/P N/P N/P 0.291987 0 0
KO2PLAN RRSAF NORM DEALLOC N/P N/P N/P 0.107605 0 N/P
OMEGAMON ALLIED 0 N/P N/P 2:38:29.497214 0.086618 0 N/P
LOCATION: OMPDB51 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 6-2
GROUP: N/P ACCOUNTING TRACE - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DB51 ACTUAL FROM: 08/24/16 08:17:26.37
DB2 VERSION: V11 PAGE DATE: 08/24/16
PRIMAUTH CORRNMBR ACCT TIMESTAMP SELECTS DELETES MERGES CPU TIME(CL1) GETPAGES TOT.PREF
PLANNAME CONNECT TERM. CONDITION OPENS INSERTS PREPARE EL. TIME(CL2) BUF.UPDT LOCK SUS
CORRNAME THR.TYPE COMMITS FETCHES UPDATES EL. TIME(CL1) CPU TIME(CL2) SYN.READ LOCKOUTS
-------- -------- --------------- ------- ------- -------------- -------------- -------- --------
DB2PM 09:01:01.273194 N/P N/P N/P 0.033621 0 0
'BLANK' RRSAF NORM DEALLOC N/P N/P N/P 0.005422 0 N/P
ALLIED 0 N/P N/P 2:39:25.826397 0.004804 0 N/P
DB2PM 'BLANK' 09:01:01.282988 0 375 0 1.338272 1654 0
KO2PLAN RRSAF NORM DEALLOC 450 0 1350 0.948122 0 0
'BLANK' ALLIED 450 450 525 2:38:56.063826 0.834451 2 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWR2C PACKAGE 3600 0.918044 0.808205 0.022958 136!
----------------------------------------------------------------------------------------------
DB2PM 09:01:02.290690 N/P N/P N/P 0.015337 0 0
'BLANK' RRSAF NORM DEALLOC N/P N/P N/P 0.003183 0 N/P
ALLIED 0 N/P N/P 2:39:38.701405 0.003003 0 N/P
DB2PM 'BLANK' 09:01:02.294862 5 0 0 0.037518 166 11
KO2PLAN RRSAF NORM DEALLOC 3 0 1 N/P 0 0
'BLANK' ALLIED 7 1346 1 2:39:38.496557 N/P 17 0
DB2PM 'BLANK' 09:01:02.298891 1508 1 0 2.026617 16692 6
DB2PM RRSAF NORM DEALLOC 7538 0 0 1.700051 0 0
'BLANK' ALLIED 10553 7538 1509 2:31:55.283518 1.591929 6 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!DGOZCHKB PACKAGE 2 0.001980 0.000899 0.000302 1!
!DGOZPC1 PACKAGE 15089 0.758987 0.685829 0.055789 3018!
!DGOZPC2 PACKAGE 4518 0.720223 0.693819 0.000570 2!
!DGOZPC4 PACKAGE 6024 0.220871 0.211337 N/P N/P!
----------------------------------------------------------------------------------------------
DB2PM 09:01:02.303557 N/P N/P N/P 0.002149 0 0
'BLANK' RRSAF NORM DEALLOC N/P N/P N/P N/P 0 N/P
ALLIED 0 N/P N/P 2:39:38.679996 N/P 0 N/P
DB2PM 'BLANK' 09:03:22.798518 N/P N/P N/P 0.000231 0 0
KO2PLAN RRSAF NORM DEALLOC N/P N/P N/P N/P 0 N/P
'BLANK' ALLIED 0 N/P N/P 0.001199 N/P 0 N/P
DB2PM 'BLANK' 09:03:23.096869 N/P N/P N/P 0.000151 0 0
KO2PLAN RRSAF NORM DEALLOC N/P N/P N/P N/P 0 N/P
'BLANK' ALLIED 0 N/P N/P 0.001020 N/P 0 N/P
DB2PM 'BLANK' 09:03:23.387349 2 0 0 0.000442 10 0
KO2PLAN RRSAF NORM DEALLOC 0 0 0 N/P 0 0
'BLANK' ALLIED 2 0 0 0.001107 N/P 2 0
LOCATION: OMPDB51 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 6-3
GROUP: N/P ACCOUNTING TRACE - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DB51 ACTUAL FROM: 08/24/16 08:17:26.37
DB2 VERSION: V11 PAGE DATE: 08/24/16
PRIMAUTH CORRNMBR ACCT TIMESTAMP SELECTS DELETES MERGES CPU TIME(CL1) GETPAGES TOT.PREF
PLANNAME CONNECT TERM. CONDITION OPENS INSERTS PREPARE EL. TIME(CL2) BUF.UPDT LOCK SUS
CORRNAME THR.TYPE COMMITS FETCHES UPDATES EL. TIME(CL1) CPU TIME(CL2) SYN.READ LOCKOUTS
-------- -------- --------------- ------- ------- -------------- -------------- -------- --------
DB2PM 'BLANK' 09:20:14.841489 0 1 0 0.000897 1 0
KO2PLAN RRSAF NORM DEALLOC 0 0 1 0.001088 0 0
'BLANK' ALLIED 1 0 0 0.001402 0.000852 0 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRPA PACKAGE 2 0.000997 0.000775 0.000000 0!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 09:20:14.842659 1 10 0 0.014480 58 0
KO2PLAN RRSAF NORM DEALLOC 0 6 30 0.008863 12 0
'BLANK' ALLIED 20 0 14 16:51.755312 0.004627 0 0
DB2PM 'BLANK' 09:20:18.837902 N/P N/P N/P 0.026753 0 0
KO2PLAN RRSAF NORM DEALLOC N/P N/P N/P 0.011812 0 N/P
OMEGAMON ALLIED 0 N/P N/P 16:30.332151 0.007462 0 N/P
DB2PM 09:20:20.448310 N/P N/P N/P 0.012308 0 0
'BLANK' RRSAF NORM DEALLOC N/P N/P N/P 0.000974 0 N/P
ALLIED 0 N/P N/P 16:52.816014 0.000477 0 N/P
DB2PM 'BLANK' 09:20:20.516633 0 40 0 0.160746 176 0
KO2PLAN RRSAF NORM DEALLOC 48 0 144 0.102730 0 1
'BLANK' ALLIED 48 48 56 16:52.872497 0.090561 0 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWR2C PACKAGE 384 0.101724 0.090195 0.003082 15!
----------------------------------------------------------------------------------------------
DB2PM 09:20:21.538346 N/P N/P N/P 0.003592 0 0
'BLANK' RRSAF NORM DEALLOC N/P N/P N/P 0.000522 0 N/P
ALLIED 0 N/P N/P 16:58.406758 0.000209 0 N/P
DB2PM 'BLANK' 09:20:24.628107 5 0 0 0.013441 140 11
KO2PLAN RRSAF NORM DEALLOC 3 0 1 N/P 0 0
'BLANK' ALLIED 7 1346 1 17:01.224622 N/P 16 0
DB2PM 'BLANK' 09:20:24.641596 214 1 0 0.336412 4563 565
DB2PM RRSAF NORM DEALLOC 823 0 0 0.183445 0 0
'BLANK' ALLIED 1182 823 166 17:01.251885 0.172190 2 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!DGOZPC2 PACKAGE 480 0.079168 0.076249 N/P N/P!
!DGOZPC1 PACKAGE 1620 0.080401 0.072883 0.005707 320!
!DGOZPC4 PACKAGE 640 0.023896 0.022949 N/P N/P!
----------------------------------------------------------------------------------------------
LOCATION: OMPDB51 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 6-4
GROUP: N/P ACCOUNTING TRACE - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DB51 ACTUAL FROM: 08/24/16 08:17:26.37
DB2 VERSION: V11 PAGE DATE: 08/24/16
PRIMAUTH CORRNMBR ACCT TIMESTAMP SELECTS DELETES MERGES CPU TIME(CL1) GETPAGES TOT.PREF
PLANNAME CONNECT TERM. CONDITION OPENS INSERTS PREPARE EL. TIME(CL2) BUF.UPDT LOCK SUS
CORRNAME THR.TYPE COMMITS FETCHES UPDATES EL. TIME(CL1) CPU TIME(CL2) SYN.READ LOCKOUTS
-------- -------- --------------- ------- ------- -------------- -------------- -------- --------
DB2PM 09:20:24.648777 N/P N/P N/P 0.002095 0 0
'BLANK' RRSAF NORM DEALLOC N/P N/P N/P N/P 0 N/P
ALLIED 0 N/P N/P 17:01.486915 N/P 0 N/P
DB2PM 'BLANK' 09:21:29.036287 N/P N/P N/P 0.000237 0 0
KO2PLAN RRSAF NORM DEALLOC N/P N/P N/P N/P 0 N/P
'BLANK' ALLIED 0 N/P N/P 0.001063 N/P 0 N/P
DB2PM 'BLANK' 09:21:29.297557 N/P N/P N/P 0.000113 0 0
KO2PLAN RRSAF NORM DEALLOC N/P N/P N/P N/P 0 N/P
'BLANK' ALLIED 0 N/P N/P 0.000643 N/P 0 N/P
DB2PM 'BLANK' 09:21:29.493685 2 0 0 0.000467 10 0
KO2PLAN RRSAF NORM DEALLOC 0 0 0 N/P 0 0
'BLANK' ALLIED 2 0 0 0.000919 N/P 0 0
DB2PM 'BLANK' 09:29:37.918291 0 1 0 0.000523 1 0
KO2PLAN RRSAF NORM DEALLOC 0 0 1 0.001244 0 0
'BLANK' ALLIED 1 0 0 0.001297 0.000488 0 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWRPA PACKAGE 2 0.001179 0.000425 0.000000 0!
----------------------------------------------------------------------------------------------
DB2PM 'BLANK' 09:29:37.920130 0 5 0 0.005740 28 0
KO2PLAN RRSAF NORM DEALLOC 0 3 15 0.002639 6 0
'BLANK' ALLIED 11 0 7 8:08.632225 0.001135 0 0
DB2PM 'BLANK' 09:29:38.912971 N/P N/P N/P 0.015120 0 0
KO2PLAN RRSAF NORM DEALLOC N/P N/P N/P 0.007384 0 N/P
OMEGAMON ALLIED 0 N/P N/P 7:45.553500 0.004561 0 N/P
DB2PM 09:29:38.994436 N/P N/P N/P 0.011091 0 0
'BLANK' RRSAF NORM DEALLOC N/P N/P N/P 0.001393 0 N/P
ALLIED 0 N/P N/P 8:08.929165 0.000412 0 N/P
DB2PM 'BLANK' 09:29:39.043549 0 20 0 0.065866 88 0
KO2PLAN RRSAF NORM DEALLOC 24 0 72 0.039692 0 0
'BLANK' ALLIED 24 24 28 8:04.675107 0.037410 0 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!FPEVWR2C PACKAGE 192 0.038658 0.037060 0.001159 6!
----------------------------------------------------------------------------------------------
DB2PM 09:29:43.051345 N/P N/P N/P 0.003222 0 0
'BLANK' RRSAF NORM DEALLOC N/P N/P N/P 0.000315 0 N/P
ALLIED 0 N/P N/P 8:13.720151 0.000107 0 N/P
LOCATION: OMPDB51 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 6-5
GROUP: N/P ACCOUNTING TRACE - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: DB51 ACTUAL FROM: 08/24/16 08:17:26.37
DB2 VERSION: V11 PAGE DATE: 08/24/16
PRIMAUTH CORRNMBR ACCT TIMESTAMP SELECTS DELETES MERGES CPU TIME(CL1) GETPAGES TOT.PREF
PLANNAME CONNECT TERM. CONDITION OPENS INSERTS PREPARE EL. TIME(CL2) BUF.UPDT LOCK SUS
CORRNAME THR.TYPE COMMITS FETCHES UPDATES EL. TIME(CL1) CPU TIME(CL2) SYN.READ LOCKOUTS
-------- -------- --------------- ------- ------- -------------- -------------- -------- --------
DB2PM 'BLANK' 09:29:43.087422 5 0 0 0.009636 140 3
KO2PLAN RRSAF NORM DEALLOC 3 0 1 N/P 0 0
'BLANK' ALLIED 7 1346 1 8:13.488041 N/P 0 0
DB2PM 'BLANK' 09:29:43.094462 131 1 0 0.220749 3650 565
DB2PM RRSAF NORM DEALLOC 408 0 0 0.086587 0 0
'BLANK' ALLIED 601 408 83 8:13.595642 0.078985 0 0
----------------------------------------------------------------------------------------------
!PROGRAM NAME TYPE SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP!
!DGOZPC2 PACKAGE 231 0.035085 0.033960 N/P N/P!
!DGOZPC1 PACKAGE 790 0.039408 0.034138 0.004084 154!
!DGOZPC4 PACKAGE 308 0.012025 0.010751 N/P N/P!
----------------------------------------------------------------------------------------------
DB2PM 09:29:43.100470 N/P N/P N/P 0.001877 0 0
'BLANK' RRSAF NORM DEALLOC N/P N/P N/P N/P 0 N/P
ALLIED 0 N/P N/P 8:13.763022 N/P 0 N/P
ACCOUNTING TRACE COMPLETE