trafodion-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From se...@apache.org
Subject [2/4] incubator-trafodion git commit: [TRAFODION-2420] RMS enhancements
Date Tue, 18 Jul 2017 18:06:55 GMT
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/419c843a/core/sql/regress/core/EXPECTEDRTS
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/EXPECTEDRTS b/core/sql/regress/core/EXPECTEDRTS
old mode 100755
new mode 100644
index b6273bb..a12f581
--- a/core/sql/regress/core/EXPECTEDRTS
+++ b/core/sql/regress/core/EXPECTEDRTS
@@ -56,10 +56,10 @@ LC   RC   OP   OPERATOR              OPT       DESCRIPTION           CARD
 --- SQL operation complete.
 >>log LOGRTS;
 >>get statistics for qid current ;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_279_S1
-Compile Start Time       2017/05/07 05:40:25.200093
-Compile End Time         2017/05/07 05:40:25.230566
-Compile Elapsed Time                 0:00:00.030473
+Qid                      MXID11000024709212367027407408000000000000206U3333300_302_S1
+Compile Start Time       2017/07/17 04:57:16.975498
+Compile End Time         2017/07/17 04:57:17.007581
+Compile Elapsed Time                 0:00:00.032083
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -87,6 +87,10 @@ Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    0
+Min. Execute Time        0.000000 secs
+Max. Execute Time        0.000000 secs
+Avg. Execute Time        0.000000 secs
 Stats Collection Type    ACCUMULATED_STATS
 
 --- SQL operation complete.
@@ -94,11 +98,11 @@ Stats Collection Type    ACCUMULATED_STATS
 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
 
 --- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_279_S1 ;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_279_S1
-Compile Start Time       2017/05/07 05:40:25.200093
-Compile End Time         2017/05/07 05:40:25.230566
-Compile Elapsed Time                 0:00:00.030473
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_302_S1 ;
+Qid                      MXID11000024709212367027407408000000000000206U3333300_302_S1
+Compile Start Time       2017/07/17 04:57:16.975498
+Compile End Time         2017/07/17 04:57:17.007581
+Compile Elapsed Time                 0:00:00.032083
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -126,14 +130,18 @@ Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    0
+Min. Execute Time        0.000000 secs
+Max. Execute Time        0.000000 secs
+Avg. Execute Time        0.000000 secs
 Stats Collection Type    ACCUMULATED_STATS
 
 --- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_279_S1 ;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_279_S1
-Compile Start Time       2017/05/07 05:40:25.200093
-Compile End Time         2017/05/07 05:40:25.230566
-Compile Elapsed Time                 0:00:00.030473
+>>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_302_S1 ;
+Qid                      MXID11000024709212367027407408000000000000206U3333300_302_S1
+Compile Start Time       2017/07/17 04:57:16.975498
+Compile End Time         2017/07/17 04:57:17.007581
+Compile Elapsed Time                 0:00:00.032083
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -161,15 +169,19 @@ Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    0
+Min. Execute Time        0.000000 secs
+Max. Execute Time        0.000000 secs
+Avg. Execute Time        0.000000 secs
 Stats Collection Type    ACCUMULATED_STATS
 
 --- SQL operation complete.
 >>log;
 >>display statistics for qid current;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_279_S1
-Compile Start Time       2017/05/07 05:40:25.200093
-Compile End Time         2017/05/07 05:40:25.230566
-Compile Elapsed Time                 0:00:00.030473
+Qid                      MXID11000024709212367027407408000000000000206U3333300_302_S1
+Compile Start Time       2017/07/17 04:57:16.975498
+Compile End Time         2017/07/17 04:57:17.007581
+Compile Elapsed Time                 0:00:00.032083
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -197,14 +209,18 @@ Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    0
+Min. Execute Time        0.000000 secs
+Max. Execute Time        0.000000 secs
+Avg. Execute Time        0.000000 secs
 Stats Collection Type    ACCUMULATED_STATS
 
 --- SQL operation complete.
 >>get statistics for qid current ;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_279_S1
-Compile Start Time       2017/05/07 05:40:25.200093
-Compile End Time         2017/05/07 05:40:25.230566
-Compile Elapsed Time                 0:00:00.030473
+Qid                      MXID11000024709212367027407408000000000000206U3333300_302_S1
+Compile Start Time       2017/07/17 04:57:16.975498
+Compile End Time         2017/07/17 04:57:17.007581
+Compile Elapsed Time                 0:00:00.032083
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -232,6 +248,10 @@ Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    0
+Min. Execute Time        0.000000 secs
+Max. Execute Time        0.000000 secs
+Avg. Execute Time        0.000000 secs
 Stats Collection Type    ACCUMULATED_STATS
 
 --- SQL operation complete.
@@ -250,14 +270,14 @@ D
 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
 
 --- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_279_S1 ;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_279_S1
-Compile Start Time       2017/05/07 05:40:25.200093
-Compile End Time         2017/05/07 05:40:25.230566
-Compile Elapsed Time                 0:00:00.030473
-Execute Start Time       2017/05/07 05:40:29.596727
-Execute End Time         2017/05/07 05:40:34.141843
-Execute Elapsed Time                 0:00:04.545116
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_302_S1 ;
+Qid                      MXID11000024709212367027407408000000000000206U3333300_302_S1
+Compile Start Time       2017/07/17 04:57:16.975498
+Compile End Time         2017/07/17 04:57:17.007581
+Compile Elapsed Time                 0:00:00.032083
+Execute Start Time       2017/07/17 04:57:23.613254
+Execute End Time         2017/07/17 04:57:26.843039
+Execute Elapsed Time                 0:00:03.229785
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -275,32 +295,36 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/05/07 05:40:34.139345
+First Row Returned Time  2017/07/17 04:57:26.841272
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    1
+Min. Execute Time        3.229785 secs
+Max. Execute Time        3.229785 secs
+Avg. Execute Time        3.229785 secs
 Stats Collection Type    ACCUMULATED_STATS
 Accessed Rows            4
 Used Rows                4
 SE IOs                   4
 SE IO Bytes              176
-SE IO MAX Time           725,870
-SQL Process Busy Time    5,717,075
+SE IO MAX Time           689,510
+SQL Process Busy Time    4,385,817
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
-SQL Heap Allocated       10,472                    KB
+SQL Heap Allocated       10,471                    KB
 SQL Heap Used            80                        KB
 SQL Heap WM              67                        KB
 Processes Created        2
-Process Create Time      150,942
+Process Create Time      141,744
 Request Message Count    26
-Request Message Bytes    39,808
+Request Message Bytes    39,392
 Reply Message Count      15
-Reply Message Bytes      38,840
+Reply Message Bytes      38,792
 BMO Space Buffer Size    0
 BMO Space Buffer Count   0
 BMO Interim Row Count    0
@@ -313,14 +337,14 @@ Scr. IO Max Time         0
 Sort TopN                -1
 
 --- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_279_S1 ;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_279_S1
-Compile Start Time       2017/05/07 05:40:25.200093
-Compile End Time         2017/05/07 05:40:25.230566
-Compile Elapsed Time                 0:00:00.030473
-Execute Start Time       2017/05/07 05:40:29.596727
-Execute End Time         2017/05/07 05:40:34.141843
-Execute Elapsed Time                 0:00:04.545116
+>>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_302_S1 ;
+Qid                      MXID11000024709212367027407408000000000000206U3333300_302_S1
+Compile Start Time       2017/07/17 04:57:16.975498
+Compile End Time         2017/07/17 04:57:17.007581
+Compile Elapsed Time                 0:00:00.032083
+Execute Start Time       2017/07/17 04:57:23.613254
+Execute End Time         2017/07/17 04:57:26.843039
+Execute Elapsed Time                 0:00:03.229785
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -338,32 +362,36 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/05/07 05:40:34.139345
+First Row Returned Time  2017/07/17 04:57:26.841272
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    1
+Min. Execute Time        3.229785 secs
+Max. Execute Time        3.229785 secs
+Avg. Execute Time        3.229785 secs
 Stats Collection Type    ACCUMULATED_STATS
 Accessed Rows            4
 Used Rows                4
 SE IOs                   4
 SE IO Bytes              176
-SE IO MAX Time           725,870
-SQL Process Busy Time    5,717,075
+SE IO MAX Time           689,510
+SQL Process Busy Time    4,385,817
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
-SQL Heap Allocated       10,472                    KB
+SQL Heap Allocated       10,471                    KB
 SQL Heap Used            80                        KB
 SQL Heap WM              67                        KB
 Processes Created        2
-Process Create Time      150,942
+Process Create Time      141,744
 Request Message Count    26
-Request Message Bytes    39,808
+Request Message Bytes    39,392
 Reply Message Count      15
-Reply Message Bytes      38,840
+Reply Message Bytes      38,792
 BMO Space Buffer Size    0
 BMO Space Buffer Count   0
 BMO Interim Row Count    0
@@ -378,13 +406,13 @@ Sort TopN                -1
 --- SQL operation complete.
 >>log;
 >>display statistics for qid current;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_279_S1
-Compile Start Time       2017/05/07 05:40:25.200093
-Compile End Time         2017/05/07 05:40:25.230566
-Compile Elapsed Time                 0:00:00.030473
-Execute Start Time       2017/05/07 05:40:29.596727
-Execute End Time         2017/05/07 05:40:34.141843
-Execute Elapsed Time                 0:00:04.545116
+Qid                      MXID11000024709212367027407408000000000000206U3333300_302_S1
+Compile Start Time       2017/07/17 04:57:16.975498
+Compile End Time         2017/07/17 04:57:17.007581
+Compile Elapsed Time                 0:00:00.032083
+Execute Start Time       2017/07/17 04:57:23.613254
+Execute End Time         2017/07/17 04:57:26.843039
+Execute Elapsed Time                 0:00:03.229785
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -402,32 +430,36 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/05/07 05:40:34.139345
+First Row Returned Time  2017/07/17 04:57:26.841272
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    1
+Min. Execute Time        3.229785 secs
+Max. Execute Time        3.229785 secs
+Avg. Execute Time        3.229785 secs
 Stats Collection Type    ACCUMULATED_STATS
 Accessed Rows            4
 Used Rows                4
 SE IOs                   4
 SE IO Bytes              176
-SE IO MAX Time           725,870
-SQL Process Busy Time    5,717,075
+SE IO MAX Time           689,510
+SQL Process Busy Time    4,385,817
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
-SQL Heap Allocated       10,472                    KB
+SQL Heap Allocated       10,471                    KB
 SQL Heap Used            80                        KB
 SQL Heap WM              67                        KB
 Processes Created        2
-Process Create Time      150,942
+Process Create Time      141,744
 Request Message Count    26
-Request Message Bytes    39,808
+Request Message Bytes    39,392
 Reply Message Count      15
-Reply Message Bytes      38,840
+Reply Message Bytes      38,792
 BMO Space Buffer Size    0
 BMO Space Buffer Count   0
 BMO Interim Row Count    0
@@ -441,13 +473,13 @@ Sort TopN                -1
 
 --- SQL operation complete.
 >>get statistics for qid current ;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_279_S1
-Compile Start Time       2017/05/07 05:40:25.200093
-Compile End Time         2017/05/07 05:40:25.230566
-Compile Elapsed Time                 0:00:00.030473
-Execute Start Time       2017/05/07 05:40:29.596727
-Execute End Time         2017/05/07 05:40:34.141843
-Execute Elapsed Time                 0:00:04.545116
+Qid                      MXID11000024709212367027407408000000000000206U3333300_302_S1
+Compile Start Time       2017/07/17 04:57:16.975498
+Compile End Time         2017/07/17 04:57:17.007581
+Compile Elapsed Time                 0:00:00.032083
+Execute Start Time       2017/07/17 04:57:23.613254
+Execute End Time         2017/07/17 04:57:26.843039
+Execute Elapsed Time                 0:00:03.229785
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -465,32 +497,36 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/05/07 05:40:34.139345
+First Row Returned Time  2017/07/17 04:57:26.841272
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    1
+Min. Execute Time        3.229785 secs
+Max. Execute Time        3.229785 secs
+Avg. Execute Time        3.229785 secs
 Stats Collection Type    ACCUMULATED_STATS
 Accessed Rows            4
 Used Rows                4
 SE IOs                   4
 SE IO Bytes              176
-SE IO MAX Time           725,870
-SQL Process Busy Time    5,717,075
+SE IO MAX Time           689,510
+SQL Process Busy Time    4,385,817
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
-SQL Heap Allocated       10,472                    KB
+SQL Heap Allocated       10,471                    KB
 SQL Heap Used            80                        KB
 SQL Heap WM              67                        KB
 Processes Created        2
-Process Create Time      150,942
+Process Create Time      141,744
 Request Message Count    26
-Request Message Bytes    39,808
+Request Message Bytes    39,392
 Reply Message Count      15
-Reply Message Bytes      38,840
+Reply Message Bytes      38,792
 BMO Space Buffer Size    0
 BMO Space Buffer Count   0
 BMO Interim Row Count    0
@@ -510,25 +546,25 @@ Sort TopN                -1
 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
 
 --- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_279_S1 ;
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_302_S1 ;
 
-*** ERROR[8923] The given Query Id MXID11000004343212360895605883001000000000206U3333300_279_S1 is not found.
+*** ERROR[8923] The given Query Id MXID11000024709212367027407408000000000000206U3333300_302_S1 is not found.
 
 --- SQL operation failed with errors.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_279_S1 ;
+>>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_302_S1 ;
 
-*** ERROR[8923] The given Query Id MXID11000004343212360895605883001000000000206U3333300_279_S1 is not found.
+*** ERROR[8923] The given Query Id MXID11000024709212367027407408000000000000206U3333300_302_S1 is not found.
 
 --- SQL operation failed with errors.
 >>log;
 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
 
 --- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_288_S1 ;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_288_S1
-Compile Start Time       2017/05/07 05:40:41.529514
-Compile End Time         2017/05/07 05:40:41.530838
-Compile Elapsed Time                 0:00:00.001324
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_311_S1 ;
+Qid                      MXID11000024709212367027407408000000000000206U3333300_311_S1
+Compile Start Time       2017/07/17 04:57:33.096199
+Compile End Time         2017/07/17 04:57:33.096764
+Compile Elapsed Time                 0:00:00.000565
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -556,14 +592,18 @@ Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    0
+Min. Execute Time        0.000000 secs
+Max. Execute Time        0.000000 secs
+Avg. Execute Time        0.000000 secs
 Stats Collection Type    ACCUMULATED_STATS
 
 --- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_288_S1 ;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_288_S1
-Compile Start Time       2017/05/07 05:40:41.529514
-Compile End Time         2017/05/07 05:40:41.530838
-Compile Elapsed Time                 0:00:00.001324
+>>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_311_S1 ;
+Qid                      MXID11000024709212367027407408000000000000206U3333300_311_S1
+Compile Start Time       2017/07/17 04:57:33.096199
+Compile End Time         2017/07/17 04:57:33.096764
+Compile Elapsed Time                 0:00:00.000565
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -591,15 +631,19 @@ Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    0
+Min. Execute Time        0.000000 secs
+Max. Execute Time        0.000000 secs
+Avg. Execute Time        0.000000 secs
 Stats Collection Type    ACCUMULATED_STATS
 
 --- SQL operation complete.
 >>log;
 >>display statistics for qid current;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_288_S1
-Compile Start Time       2017/05/07 05:40:41.529514
-Compile End Time         2017/05/07 05:40:41.530838
-Compile Elapsed Time                 0:00:00.001324
+Qid                      MXID11000024709212367027407408000000000000206U3333300_311_S1
+Compile Start Time       2017/07/17 04:57:33.096199
+Compile End Time         2017/07/17 04:57:33.096764
+Compile Elapsed Time                 0:00:00.000565
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -627,14 +671,18 @@ Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    0
+Min. Execute Time        0.000000 secs
+Max. Execute Time        0.000000 secs
+Avg. Execute Time        0.000000 secs
 Stats Collection Type    ACCUMULATED_STATS
 
 --- SQL operation complete.
 >>get statistics for qid current ;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_288_S1
-Compile Start Time       2017/05/07 05:40:41.529514
-Compile End Time         2017/05/07 05:40:41.530838
-Compile Elapsed Time                 0:00:00.001324
+Qid                      MXID11000024709212367027407408000000000000206U3333300_311_S1
+Compile Start Time       2017/07/17 04:57:33.096199
+Compile End Time         2017/07/17 04:57:33.096764
+Compile Elapsed Time                 0:00:00.000565
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -662,6 +710,10 @@ Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    0
+Min. Execute Time        0.000000 secs
+Max. Execute Time        0.000000 secs
+Avg. Execute Time        0.000000 secs
 Stats Collection Type    ACCUMULATED_STATS
 
 --- SQL operation complete.
@@ -678,10 +730,10 @@ Stats Collection Type    ACCUMULATED_STATS
 --- SQL command prepared.
 >>log;
 >>get statistics for qid current ;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time       2017/05/07 05:40:49.935790
-Compile End Time         2017/05/07 05:40:49.977030
-Compile Elapsed Time                 0:00:00.041240
+Qid                      MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time       2017/07/17 04:57:39.632898
+Compile End Time         2017/07/17 04:57:39.665467
+Compile Elapsed Time                 0:00:00.032569
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -709,6 +761,10 @@ Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    0
+Min. Execute Time        0.000000 secs
+Max. Execute Time        0.000000 secs
+Avg. Execute Time        0.000000 secs
 Stats Collection Type    PERTABLE_STATS
 
 --- SQL operation complete.
@@ -716,11 +772,11 @@ Stats Collection Type    PERTABLE_STATS
 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
 
 --- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_293_S1 ;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time       2017/05/07 05:40:49.935790
-Compile End Time         2017/05/07 05:40:49.977030
-Compile Elapsed Time                 0:00:00.041240
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_316_S1 ;
+Qid                      MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time       2017/07/17 04:57:39.632898
+Compile End Time         2017/07/17 04:57:39.665467
+Compile Elapsed Time                 0:00:00.032569
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -748,14 +804,18 @@ Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    0
+Min. Execute Time        0.000000 secs
+Max. Execute Time        0.000000 secs
+Avg. Execute Time        0.000000 secs
 Stats Collection Type    PERTABLE_STATS
 
 --- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_293_S1 ;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time       2017/05/07 05:40:49.935790
-Compile End Time         2017/05/07 05:40:49.977030
-Compile Elapsed Time                 0:00:00.041240
+>>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_316_S1 ;
+Qid                      MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time       2017/07/17 04:57:39.632898
+Compile End Time         2017/07/17 04:57:39.665467
+Compile Elapsed Time                 0:00:00.032569
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -783,6 +843,10 @@ Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    0
+Min. Execute Time        0.000000 secs
+Max. Execute Time        0.000000 secs
+Avg. Execute Time        0.000000 secs
 Stats Collection Type    PERTABLE_STATS
 
 --- SQL operation complete.
@@ -790,11 +854,11 @@ Stats Collection Type    PERTABLE_STATS
 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
 
 --- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_293_S1 ACCUMULATED;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time       2017/05/07 05:40:49.935790
-Compile End Time         2017/05/07 05:40:49.977030
-Compile Elapsed Time                 0:00:00.041240
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_316_S1 ACCUMULATED;
+Qid                      MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time       2017/07/17 04:57:39.632898
+Compile End Time         2017/07/17 04:57:39.665467
+Compile Elapsed Time                 0:00:00.032569
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -822,14 +886,18 @@ Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    0
+Min. Execute Time        0.000000 secs
+Max. Execute Time        0.000000 secs
+Avg. Execute Time        0.000000 secs
 Stats Collection Type    PERTABLE_STATS
 
 --- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_293_S1 ACCUMULATED;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time       2017/05/07 05:40:49.935790
-Compile End Time         2017/05/07 05:40:49.977030
-Compile Elapsed Time                 0:00:00.041240
+>>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_316_S1 ACCUMULATED;
+Qid                      MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time       2017/07/17 04:57:39.632898
+Compile End Time         2017/07/17 04:57:39.665467
+Compile Elapsed Time                 0:00:00.032569
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -857,15 +925,19 @@ Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    0
+Min. Execute Time        0.000000 secs
+Max. Execute Time        0.000000 secs
+Avg. Execute Time        0.000000 secs
 Stats Collection Type    PERTABLE_STATS
 
 --- SQL operation complete.
 >>log;
 >>display statistics for qid current;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time       2017/05/07 05:40:49.935790
-Compile End Time         2017/05/07 05:40:49.977030
-Compile Elapsed Time                 0:00:00.041240
+Qid                      MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time       2017/07/17 04:57:39.632898
+Compile End Time         2017/07/17 04:57:39.665467
+Compile Elapsed Time                 0:00:00.032569
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -893,14 +965,18 @@ Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    0
+Min. Execute Time        0.000000 secs
+Max. Execute Time        0.000000 secs
+Avg. Execute Time        0.000000 secs
 Stats Collection Type    PERTABLE_STATS
 
 --- SQL operation complete.
 >>get statistics for qid current ;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time       2017/05/07 05:40:49.935790
-Compile End Time         2017/05/07 05:40:49.977030
-Compile Elapsed Time                 0:00:00.041240
+Qid                      MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time       2017/07/17 04:57:39.632898
+Compile End Time         2017/07/17 04:57:39.665467
+Compile Elapsed Time                 0:00:00.032569
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -928,14 +1004,18 @@ Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    0
+Min. Execute Time        0.000000 secs
+Max. Execute Time        0.000000 secs
+Avg. Execute Time        0.000000 secs
 Stats Collection Type    PERTABLE_STATS
 
 --- SQL operation complete.
 >>display statistics for qid current accumulated ;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time       2017/05/07 05:40:49.935790
-Compile End Time         2017/05/07 05:40:49.977030
-Compile Elapsed Time                 0:00:00.041240
+Qid                      MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time       2017/07/17 04:57:39.632898
+Compile End Time         2017/07/17 04:57:39.665467
+Compile Elapsed Time                 0:00:00.032569
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -963,14 +1043,18 @@ Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    0
+Min. Execute Time        0.000000 secs
+Max. Execute Time        0.000000 secs
+Avg. Execute Time        0.000000 secs
 Stats Collection Type    PERTABLE_STATS
 
 --- SQL operation complete.
 >>get statistics for qid current accumulated ;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time       2017/05/07 05:40:49.935790
-Compile End Time         2017/05/07 05:40:49.977030
-Compile Elapsed Time                 0:00:00.041240
+Qid                      MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time       2017/07/17 04:57:39.632898
+Compile End Time         2017/07/17 04:57:39.665467
+Compile Elapsed Time                 0:00:00.032569
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -998,6 +1082,10 @@ Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    0
+Min. Execute Time        0.000000 secs
+Max. Execute Time        0.000000 secs
+Avg. Execute Time        0.000000 secs
 Stats Collection Type    PERTABLE_STATS
 
 --- SQL operation complete.
@@ -1006,24 +1094,24 @@ Stats Collection Type    PERTABLE_STATS
 D          
 -----------
 
+         12
          11
          21
          22
-         12
 
 --- 4 row(s) selected.
 >>log;
 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
 
 --- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_293_S1 ;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time       2017/05/07 05:40:49.935790
-Compile End Time         2017/05/07 05:40:49.977030
-Compile Elapsed Time                 0:00:00.041240
-Execute Start Time       2017/05/07 05:40:58.496745
-Execute End Time         2017/05/07 05:40:58.522185
-Execute Elapsed Time                 0:00:00.025440
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_316_S1 ;
+Qid                      MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time       2017/07/17 04:57:39.632898
+Compile End Time         2017/07/17 04:57:39.665467
+Compile Elapsed Time                 0:00:00.032569
+Execute Start Time       2017/07/17 04:57:49.683630
+Execute End Time         2017/07/17 04:57:49.695340
+Execute Elapsed Time                 0:00:00.011710
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -1041,15 +1129,19 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/05/07 05:40:58.520309
+First Row Returned Time  2017/07/17 04:57:49.693689
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    1
+Min. Execute Time        0.011710 secs
+Max. Execute Time        0.011710 secs
+Avg. Execute Time        0.011710 secs
 Stats Collection Type    PERTABLE_STATS
-SQL Process Busy Time    15,419
+SQL Process Busy Time    5,776
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
@@ -1059,9 +1151,9 @@ SQL Heap WM              10,338                    KB
 Processes Created        0
 Process Create Time      0
 Request Message Count    27
-Request Message Bytes    39,968
+Request Message Bytes    39,552
 Reply Message Count      15
-Reply Message Bytes      39,264
+Reply Message Bytes      39,208
 BMO Space Buffer Size    0
 BMO Space Buffer Count   0
 BMO Interim Row Count    0
@@ -1074,19 +1166,19 @@ Scr. IO Max Time         0
 Sort TopN                -1
 
    Id       DOP          Table Name
-  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs         SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
+  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs        SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
     1         2   TRAFODION.SCH.TSTAT
-              0                   4            100                   4                   4                   0              20,398              10,610
+              0                   4            100                   4                   4                   0               5,738               2,914
 
 --- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_293_S1 ;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time       2017/05/07 05:40:49.935790
-Compile End Time         2017/05/07 05:40:49.977030
-Compile Elapsed Time                 0:00:00.041240
-Execute Start Time       2017/05/07 05:40:58.496745
-Execute End Time         2017/05/07 05:40:58.522185
-Execute Elapsed Time                 0:00:00.025440
+>>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_316_S1 ;
+Qid                      MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time       2017/07/17 04:57:39.632898
+Compile End Time         2017/07/17 04:57:39.665467
+Compile Elapsed Time                 0:00:00.032569
+Execute Start Time       2017/07/17 04:57:49.683630
+Execute End Time         2017/07/17 04:57:49.695340
+Execute Elapsed Time                 0:00:00.011710
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -1104,15 +1196,19 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/05/07 05:40:58.520309
+First Row Returned Time  2017/07/17 04:57:49.693689
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    1
+Min. Execute Time        0.011710 secs
+Max. Execute Time        0.011710 secs
+Avg. Execute Time        0.011710 secs
 Stats Collection Type    PERTABLE_STATS
-SQL Process Busy Time    15,419
+SQL Process Busy Time    5,776
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
@@ -1122,9 +1218,9 @@ SQL Heap WM              10,338                    KB
 Processes Created        0
 Process Create Time      0
 Request Message Count    27
-Request Message Bytes    39,968
+Request Message Bytes    39,552
 Reply Message Count      15
-Reply Message Bytes      39,264
+Reply Message Bytes      39,208
 BMO Space Buffer Size    0
 BMO Space Buffer Count   0
 BMO Interim Row Count    0
@@ -1137,23 +1233,23 @@ Scr. IO Max Time         0
 Sort TopN                -1
 
    Id       DOP          Table Name
-  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs         SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
+  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs        SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
     1         2   TRAFODION.SCH.TSTAT
-              0                   4            100                   4                   4                   0              20,398              10,610
+              0                   4            100                   4                   4                   0               5,738               2,914
 
 --- SQL operation complete.
 >>log;
 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
 
 --- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_293_S1 ACCUMULATED;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time       2017/05/07 05:40:49.935790
-Compile End Time         2017/05/07 05:40:49.977030
-Compile Elapsed Time                 0:00:00.041240
-Execute Start Time       2017/05/07 05:40:58.496745
-Execute End Time         2017/05/07 05:40:58.522185
-Execute Elapsed Time                 0:00:00.025440
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_316_S1 ACCUMULATED;
+Qid                      MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time       2017/07/17 04:57:39.632898
+Compile End Time         2017/07/17 04:57:39.665467
+Compile Elapsed Time                 0:00:00.032569
+Execute Start Time       2017/07/17 04:57:49.683630
+Execute End Time         2017/07/17 04:57:49.695340
+Execute Elapsed Time                 0:00:00.011710
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -1171,20 +1267,24 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/05/07 05:40:58.520309
+First Row Returned Time  2017/07/17 04:57:49.693689
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    1
+Min. Execute Time        0.011710 secs
+Max. Execute Time        0.011710 secs
+Avg. Execute Time        0.011710 secs
 Stats Collection Type    PERTABLE_STATS
 Accessed Rows            4
 Used Rows                4
 SE IOs                   4
 SE IO Bytes              176
-SE IO MAX Time           10,610
-SQL Process Busy Time    15,419
+SE IO MAX Time           2,914
+SQL Process Busy Time    5,776
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
@@ -1194,9 +1294,9 @@ SQL Heap WM              10,338                    KB
 Processes Created        0
 Process Create Time      0
 Request Message Count    27
-Request Message Bytes    39,968
+Request Message Bytes    39,552
 Reply Message Count      15
-Reply Message Bytes      39,264
+Reply Message Bytes      39,208
 BMO Space Buffer Size    0
 BMO Space Buffer Count   0
 BMO Interim Row Count    0
@@ -1209,14 +1309,14 @@ Scr. IO Max Time         0
 Sort TopN                -1
 
 --- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_293_S1 ACCUMULATED;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time       2017/05/07 05:40:49.935790
-Compile End Time         2017/05/07 05:40:49.977030
-Compile Elapsed Time                 0:00:00.041240
-Execute Start Time       2017/05/07 05:40:58.496745
-Execute End Time         2017/05/07 05:40:58.522185
-Execute Elapsed Time                 0:00:00.025440
+>>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_316_S1 ACCUMULATED;
+Qid                      MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time       2017/07/17 04:57:39.632898
+Compile End Time         2017/07/17 04:57:39.665467
+Compile Elapsed Time                 0:00:00.032569
+Execute Start Time       2017/07/17 04:57:49.683630
+Execute End Time         2017/07/17 04:57:49.695340
+Execute Elapsed Time                 0:00:00.011710
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -1234,20 +1334,24 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/05/07 05:40:58.520309
+First Row Returned Time  2017/07/17 04:57:49.693689
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    1
+Min. Execute Time        0.011710 secs
+Max. Execute Time        0.011710 secs
+Avg. Execute Time        0.011710 secs
 Stats Collection Type    PERTABLE_STATS
 Accessed Rows            4
 Used Rows                4
 SE IOs                   4
 SE IO Bytes              176
-SE IO MAX Time           10,610
-SQL Process Busy Time    15,419
+SE IO MAX Time           2,914
+SQL Process Busy Time    5,776
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
@@ -1257,9 +1361,9 @@ SQL Heap WM              10,338                    KB
 Processes Created        0
 Process Create Time      0
 Request Message Count    27
-Request Message Bytes    39,968
+Request Message Bytes    39,552
 Reply Message Count      15
-Reply Message Bytes      39,264
+Reply Message Bytes      39,208
 BMO Space Buffer Size    0
 BMO Space Buffer Count   0
 BMO Interim Row Count    0
@@ -1274,13 +1378,13 @@ Sort TopN                -1
 --- SQL operation complete.
 >>log;
 >>display statistics for qid current;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time       2017/05/07 05:40:49.935790
-Compile End Time         2017/05/07 05:40:49.977030
-Compile Elapsed Time                 0:00:00.041240
-Execute Start Time       2017/05/07 05:40:58.496745
-Execute End Time         2017/05/07 05:40:58.522185
-Execute Elapsed Time                 0:00:00.025440
+Qid                      MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time       2017/07/17 04:57:39.632898
+Compile End Time         2017/07/17 04:57:39.665467
+Compile Elapsed Time                 0:00:00.032569
+Execute Start Time       2017/07/17 04:57:49.683630
+Execute End Time         2017/07/17 04:57:49.695340
+Execute Elapsed Time                 0:00:00.011710
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -1298,15 +1402,19 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/05/07 05:40:58.520309
+First Row Returned Time  2017/07/17 04:57:49.693689
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    1
+Min. Execute Time        0.011710 secs
+Max. Execute Time        0.011710 secs
+Avg. Execute Time        0.011710 secs
 Stats Collection Type    PERTABLE_STATS
-SQL Process Busy Time    15,419
+SQL Process Busy Time    5,776
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
@@ -1316,9 +1424,9 @@ SQL Heap WM              10,338                    KB
 Processes Created        0
 Process Create Time      0
 Request Message Count    27
-Request Message Bytes    39,968
+Request Message Bytes    39,552
 Reply Message Count      15
-Reply Message Bytes      39,264
+Reply Message Bytes      39,208
 BMO Space Buffer Size    0
 BMO Space Buffer Count   0
 BMO Interim Row Count    0
@@ -1331,19 +1439,19 @@ Scr. IO Max Time         0
 Sort TopN                -1
 
    Id       DOP          Table Name
-  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs         SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
+  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs        SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
     1         2   TRAFODION.SCH.TSTAT
-              0                   4            100                   4                   4                   0              20,398              10,610
+              0                   4            100                   4                   4                   0               5,738               2,914
 
 --- SQL operation complete.
 >>get statistics for qid current ;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time       2017/05/07 05:40:49.935790
-Compile End Time         2017/05/07 05:40:49.977030
-Compile Elapsed Time                 0:00:00.041240
-Execute Start Time       2017/05/07 05:40:58.496745
-Execute End Time         2017/05/07 05:40:58.522185
-Execute Elapsed Time                 0:00:00.025440
+Qid                      MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time       2017/07/17 04:57:39.632898
+Compile End Time         2017/07/17 04:57:39.665467
+Compile Elapsed Time                 0:00:00.032569
+Execute Start Time       2017/07/17 04:57:49.683630
+Execute End Time         2017/07/17 04:57:49.695340
+Execute Elapsed Time                 0:00:00.011710
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -1361,15 +1469,19 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/05/07 05:40:58.520309
+First Row Returned Time  2017/07/17 04:57:49.693689
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    1
+Min. Execute Time        0.011710 secs
+Max. Execute Time        0.011710 secs
+Avg. Execute Time        0.011710 secs
 Stats Collection Type    PERTABLE_STATS
-SQL Process Busy Time    15,419
+SQL Process Busy Time    5,776
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
@@ -1379,9 +1491,9 @@ SQL Heap WM              10,338                    KB
 Processes Created        0
 Process Create Time      0
 Request Message Count    27
-Request Message Bytes    39,968
+Request Message Bytes    39,552
 Reply Message Count      15
-Reply Message Bytes      39,264
+Reply Message Bytes      39,208
 BMO Space Buffer Size    0
 BMO Space Buffer Count   0
 BMO Interim Row Count    0
@@ -1394,19 +1506,19 @@ Scr. IO Max Time         0
 Sort TopN                -1
 
    Id       DOP          Table Name
-  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs         SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
+  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs        SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
     1         2   TRAFODION.SCH.TSTAT
-              0                   4            100                   4                   4                   0              20,398              10,610
+              0                   4            100                   4                   4                   0               5,738               2,914
 
 --- SQL operation complete.
 >>display statistics for qid current accumulated;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time       2017/05/07 05:40:49.935790
-Compile End Time         2017/05/07 05:40:49.977030
-Compile Elapsed Time                 0:00:00.041240
-Execute Start Time       2017/05/07 05:40:58.496745
-Execute End Time         2017/05/07 05:40:58.522185
-Execute Elapsed Time                 0:00:00.025440
+Qid                      MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time       2017/07/17 04:57:39.632898
+Compile End Time         2017/07/17 04:57:39.665467
+Compile Elapsed Time                 0:00:00.032569
+Execute Start Time       2017/07/17 04:57:49.683630
+Execute End Time         2017/07/17 04:57:49.695340
+Execute Elapsed Time                 0:00:00.011710
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -1424,20 +1536,24 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/05/07 05:40:58.520309
+First Row Returned Time  2017/07/17 04:57:49.693689
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    1
+Min. Execute Time        0.011710 secs
+Max. Execute Time        0.011710 secs
+Avg. Execute Time        0.011710 secs
 Stats Collection Type    PERTABLE_STATS
 Accessed Rows            4
 Used Rows                4
 SE IOs                   4
 SE IO Bytes              176
-SE IO MAX Time           10,610
-SQL Process Busy Time    15,419
+SE IO MAX Time           2,914
+SQL Process Busy Time    5,776
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
@@ -1447,9 +1563,9 @@ SQL Heap WM              10,338                    KB
 Processes Created        0
 Process Create Time      0
 Request Message Count    27
-Request Message Bytes    39,968
+Request Message Bytes    39,552
 Reply Message Count      15
-Reply Message Bytes      39,264
+Reply Message Bytes      39,208
 BMO Space Buffer Size    0
 BMO Space Buffer Count   0
 BMO Interim Row Count    0
@@ -1463,13 +1579,13 @@ Sort TopN                -1
 
 --- SQL operation complete.
 >>get statistics for qid current accumulated;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time       2017/05/07 05:40:49.935790
-Compile End Time         2017/05/07 05:40:49.977030
-Compile Elapsed Time                 0:00:00.041240
-Execute Start Time       2017/05/07 05:40:58.496745
-Execute End Time         2017/05/07 05:40:58.522185
-Execute Elapsed Time                 0:00:00.025440
+Qid                      MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time       2017/07/17 04:57:39.632898
+Compile End Time         2017/07/17 04:57:39.665467
+Compile Elapsed Time                 0:00:00.032569
+Execute Start Time       2017/07/17 04:57:49.683630
+Execute End Time         2017/07/17 04:57:49.695340
+Execute Elapsed Time                 0:00:00.011710
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -1487,20 +1603,24 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/05/07 05:40:58.520309
+First Row Returned Time  2017/07/17 04:57:49.693689
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    1
+Min. Execute Time        0.011710 secs
+Max. Execute Time        0.011710 secs
+Avg. Execute Time        0.011710 secs
 Stats Collection Type    PERTABLE_STATS
 Accessed Rows            4
 Used Rows                4
 SE IOs                   4
 SE IO Bytes              176
-SE IO MAX Time           10,610
-SQL Process Busy Time    15,419
+SE IO MAX Time           2,914
+SQL Process Busy Time    5,776
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
@@ -1510,9 +1630,9 @@ SQL Heap WM              10,338                    KB
 Processes Created        0
 Process Create Time      0
 Request Message Count    27
-Request Message Bytes    39,968
+Request Message Bytes    39,552
 Reply Message Count      15
-Reply Message Bytes      39,264
+Reply Message Bytes      39,208
 BMO Space Buffer Size    0
 BMO Space Buffer Count   0
 BMO Interim Row Count    0
@@ -1527,7 +1647,7 @@ Sort TopN                -1
 --- SQL operation complete.
 >>log;
 >>obey PQIDOUT;
->>SET SESSION DEFAULT PARENT_QID 'MXID11000004343212360895605883001000000000206U3333300_293_S1';
+>>SET SESSION DEFAULT PARENT_QID 'MXID11000024709212367027407408000000000000206U3333300_316_S1';
 
 --- SQL operation complete.
 >>prepare s1 from select distinct d from tstat ;
@@ -1537,11 +1657,11 @@ Sort TopN                -1
 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
 
 --- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_307_S1 ;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_307_S1
-Compile Start Time       2017/05/07 05:41:07.096980
-Compile End Time         2017/05/07 05:41:07.097700
-Compile Elapsed Time                 0:00:00.000720
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_330_S1 ;
+Qid                      MXID11000024709212367027407408000000000000206U3333300_330_S1
+Compile Start Time       2017/07/17 04:57:56.670883
+Compile End Time         2017/07/17 04:57:56.671315
+Compile Elapsed Time                 0:00:00.000432
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -1553,7 +1673,7 @@ Query Type               SQL_SELECT_NON_UNIQUE
 Sub Query Type           SQL_STMT_NA
 Estimated Accessed Rows  0
 Estimated Used Rows      0
-Parent Qid               MXID11000004343212360895605883001000000000206U3333300_293_S1
+Parent Qid               MXID11000024709212367027407408000000000000206U3333300_316_S1
 Parent Query System      SAME
 Child Qid                NONE
 Number of SQL Processes  1
@@ -1569,14 +1689,18 @@ Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    0
+Min. Execute Time        0.000000 secs
+Max. Execute Time        0.000000 secs
+Avg. Execute Time        0.000000 secs
 Stats Collection Type    PERTABLE_STATS
 
 --- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_307_S1 ;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_307_S1
-Compile Start Time       2017/05/07 05:41:07.096980
-Compile End Time         2017/05/07 05:41:07.097700
-Compile Elapsed Time                 0:00:00.000720
+>>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_330_S1 ;
+Qid                      MXID11000024709212367027407408000000000000206U3333300_330_S1
+Compile Start Time       2017/07/17 04:57:56.670883
+Compile End Time         2017/07/17 04:57:56.671315
+Compile Elapsed Time                 0:00:00.000432
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -1588,7 +1712,7 @@ Query Type               SQL_SELECT_NON_UNIQUE
 Sub Query Type           SQL_STMT_NA
 Estimated Accessed Rows  0
 Estimated Used Rows      0
-Parent Qid               MXID11000004343212360895605883001000000000206U3333300_293_S1
+Parent Qid               MXID11000024709212367027407408000000000000206U3333300_316_S1
 Parent Query System      SAME
 Child Qid                NONE
 Number of SQL Processes  1
@@ -1604,6 +1728,10 @@ Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    0
+Min. Execute Time        0.000000 secs
+Max. Execute Time        0.000000 secs
+Avg. Execute Time        0.000000 secs
 Stats Collection Type    PERTABLE_STATS
 
 --- SQL operation complete.
@@ -1618,11 +1746,11 @@ Stats Collection Type    PERTABLE_STATS
 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
 
 --- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_309_S1 ;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_309_S1
-Compile Start Time       2017/05/07 05:41:17.587174
-Compile End Time         2017/05/07 05:41:17.588229
-Compile Elapsed Time                 0:00:00.001055
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_332_S1 ;
+Qid                      MXID11000024709212367027407408000000000000206U3333300_332_S1
+Compile Start Time       2017/07/17 04:57:59.906249
+Compile End Time         2017/07/17 04:57:59.906902
+Compile Elapsed Time                 0:00:00.000653
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -1650,14 +1778,18 @@ Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    0
+Min. Execute Time        0.000000 secs
+Max. Execute Time        0.000000 secs
+Avg. Execute Time        0.000000 secs
 Stats Collection Type    PERTABLE_STATS
 
 --- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_309_S1 ;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_309_S1
-Compile Start Time       2017/05/07 05:41:17.587174
-Compile End Time         2017/05/07 05:41:17.588229
-Compile Elapsed Time                 0:00:00.001055
+>>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_332_S1 ;
+Qid                      MXID11000024709212367027407408000000000000206U3333300_332_S1
+Compile Start Time       2017/07/17 04:57:59.906249
+Compile End Time         2017/07/17 04:57:59.906902
+Compile Elapsed Time                 0:00:00.000653
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -1685,6 +1817,10 @@ Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    0
+Min. Execute Time        0.000000 secs
+Max. Execute Time        0.000000 secs
+Avg. Execute Time        0.000000 secs
 Stats Collection Type    PERTABLE_STATS
 
 --- SQL operation complete.
@@ -1704,11 +1840,11 @@ Stats Collection Type    PERTABLE_STATS
 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
 
 --- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 ;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_312_S1
-Compile Start Time       2017/05/07 05:41:21.930615
-Compile End Time         2017/05/07 05:41:21.967829
-Compile Elapsed Time                 0:00:00.037214
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_335_S1 ;
+Qid                      MXID11000024709212367027407408000000000000206U3333300_335_S1
+Compile Start Time       2017/07/17 04:58:06.342753
+Compile End Time         2017/07/17 04:58:06.391558
+Compile Elapsed Time                 0:00:00.048805
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -1736,14 +1872,18 @@ Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    0
+Min. Execute Time        0.000000 secs
+Max. Execute Time        0.000000 secs
+Avg. Execute Time        0.000000 secs
 Stats Collection Type    OPERATOR_STATS
 
 --- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 ;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_312_S1
-Compile Start Time       2017/05/07 05:41:21.930615
-Compile End Time         2017/05/07 05:41:21.967829
-Compile Elapsed Time                 0:00:00.037214
+>>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_335_S1 ;
+Qid                      MXID11000024709212367027407408000000000000206U3333300_335_S1
+Compile Start Time       2017/07/17 04:58:06.342753
+Compile End Time         2017/07/17 04:58:06.391558
+Compile Elapsed Time                 0:00:00.048805
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -1771,6 +1911,10 @@ Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    0
+Min. Execute Time        0.000000 secs
+Max. Execute Time        0.000000 secs
+Avg. Execute Time        0.000000 secs
 Stats Collection Type    OPERATOR_STATS
 
 --- SQL operation complete.
@@ -1790,14 +1934,14 @@ D
 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
 
 --- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 ;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_312_S1
-Compile Start Time       2017/05/07 05:41:21.930615
-Compile End Time         2017/05/07 05:41:21.967829
-Compile Elapsed Time                 0:00:00.037214
-Execute Start Time       2017/05/07 05:41:26.529910
-Execute End Time         2017/05/07 05:41:26.567047
-Execute Elapsed Time                 0:00:00.037137
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_335_S1 ;
+Qid                      MXID11000024709212367027407408000000000000206U3333300_335_S1
+Compile Start Time       2017/07/17 04:58:06.342753
+Compile End Time         2017/07/17 04:58:06.391558
+Compile Elapsed Time                 0:00:00.048805
+Execute Start Time       2017/07/17 04:58:09.741408
+Execute End Time         2017/07/17 04:58:09.757985
+Execute Elapsed Time                 0:00:00.016577
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -1815,38 +1959,42 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/05/07 05:41:26.564755
+First Row Returned Time  2017/07/17 04:58:09.756320
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    1
+Min. Execute Time        0.016577 secs
+Max. Execute Time        0.016577 secs
+Avg. Execute Time        0.016577 secs
 Stats Collection Type    OPERATOR_STATS
 
 LC   RC   Id   PaId ExId Frag TDB Name                 DOP     Dispatches      Oper CPU Time  Est. Records Used  Act. Records Used    Details
 
-10   .    11   .    5    0    EX_ROOT                  1                5                 10                  0                  4              24 1975
-9    .    10   11   4    0    EX_SPLIT_TOP             1                5                 19                  2                  4              24
-8    .    9    10   4    0    EX_SEND_TOP              2               10              1,946                  2                  4              32
-7    .    8    9    4    2    EX_SEND_BOTTOM           2               21                135                  2                  4              32
-6    .    7    8    4    2    EX_SPLIT_BOTTOM          2                7                  9                  2                  4              24 5956
-5    .    6    7    3    2    EX_HASH_GRBY             2                6              3,978                  1                  4              24 0|0|0
-4    .    5    6    2    2    EX_SPLIT_TOP             2               11                 22                100                  4              24
-3    .    4    5    2    2    EX_SEND_TOP              4               18              1,812                100                  4              32
-2    .    3    4    2    3    EX_SEND_BOTTOM           4               42                237                100                  4              32
-1    .    2    3    2    3    EX_SPLIT_BOTTOM          2                8                 60                100                  4              24 11007
-.    .    1    2    1    3    EX_TRAF_KEY_SELECT       2                4             10,710                100                  4              24 TRAFODION.SCH.TSTAT|4|176
+10   .    11   .    5    0    EX_ROOT                  1                5                 10                  0                  4 1694
+9    .    10   11   4    0    EX_SPLIT_TOP             1                5                 10                  2                  4
+8    .    9    10   4    0    EX_SEND_TOP              2               10              1,674                  2                  4
+7    .    8    9    4    2    EX_SEND_BOTTOM           2               17                119                  2                  4
+6    .    7    8    4    2    EX_SPLIT_BOTTOM          2                7                  7                  2                  4 3201
+5    .    6    7    3    2    EX_HASH_GRBY             2                6              2,283                  1                  4 0|0|0
+4    .    5    6    2    2    EX_SPLIT_TOP             2               11                 11                100                  4
+3    .    4    5    2    2    EX_SEND_TOP              4               18                781                100                  4
+2    .    3    4    2    3    EX_SEND_BOTTOM           4               31                154                100                  4
+1    .    2    3    2    3    EX_SPLIT_BOTTOM          2                8                 13                100                  4 3346
+.    .    1    2    1    3    EX_TRAF_KEY_SELECT       2                4              3,179                100                  4 TRAFODION.SCH.TSTAT|4|176
 
 --- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 ;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_312_S1
-Compile Start Time       2017/05/07 05:41:21.930615
-Compile End Time         2017/05/07 05:41:21.967829
-Compile Elapsed Time                 0:00:00.037214
-Execute Start Time       2017/05/07 05:41:26.529910
-Execute End Time         2017/05/07 05:41:26.567047
-Execute Elapsed Time                 0:00:00.037137
+>>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_335_S1 ;
+Qid                      MXID11000024709212367027407408000000000000206U3333300_335_S1
+Compile Start Time       2017/07/17 04:58:06.342753
+Compile End Time         2017/07/17 04:58:06.391558
+Compile Elapsed Time                 0:00:00.048805
+Execute Start Time       2017/07/17 04:58:09.741408
+Execute End Time         2017/07/17 04:58:09.757985
+Execute Elapsed Time                 0:00:00.016577
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -1864,42 +2012,46 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/05/07 05:41:26.564755
+First Row Returned Time  2017/07/17 04:58:09.756320
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    1
+Min. Execute Time        0.016577 secs
+Max. Execute Time        0.016577 secs
+Avg. Execute Time        0.016577 secs
 Stats Collection Type    OPERATOR_STATS
 
 LC   RC   Id   PaId ExId Frag TDB Name                 DOP     Dispatches      Oper CPU Time  Est. Records Used  Act. Records Used    Details
 
-10   .    11   .    5    0    EX_ROOT                  1                5                 10                  0                  4              24 1975
-9    .    10   11   4    0    EX_SPLIT_TOP             1                5                 19                  2                  4              24
-8    .    9    10   4    0    EX_SEND_TOP              2               10              1,946                  2                  4              32
-7    .    8    9    4    2    EX_SEND_BOTTOM           2               21                135                  2                  4              32
-6    .    7    8    4    2    EX_SPLIT_BOTTOM          2                7                  9                  2                  4              24 5956
-5    .    6    7    3    2    EX_HASH_GRBY             2                6              3,978                  1                  4              24 0|0|0
-4    .    5    6    2    2    EX_SPLIT_TOP             2               11                 22                100                  4              24
-3    .    4    5    2    2    EX_SEND_TOP              4               18              1,812                100                  4              32
-2    .    3    4    2    3    EX_SEND_BOTTOM           4               42                237                100                  4              32
-1    .    2    3    2    3    EX_SPLIT_BOTTOM          2                8                 60                100                  4              24 11007
-.    .    1    2    1    3    EX_TRAF_KEY_SELECT       2                4             10,710                100                  4              24 TRAFODION.SCH.TSTAT|4|176
+10   .    11   .    5    0    EX_ROOT                  1                5                 10                  0                  4 1694
+9    .    10   11   4    0    EX_SPLIT_TOP             1                5                 10                  2                  4
+8    .    9    10   4    0    EX_SEND_TOP              2               10              1,674                  2                  4
+7    .    8    9    4    2    EX_SEND_BOTTOM           2               17                119                  2                  4
+6    .    7    8    4    2    EX_SPLIT_BOTTOM          2                7                  7                  2                  4 3201
+5    .    6    7    3    2    EX_HASH_GRBY             2                6              2,283                  1                  4 0|0|0
+4    .    5    6    2    2    EX_SPLIT_TOP             2               11                 11                100                  4
+3    .    4    5    2    2    EX_SEND_TOP              4               18                781                100                  4
+2    .    3    4    2    3    EX_SEND_BOTTOM           4               31                154                100                  4
+1    .    2    3    2    3    EX_SPLIT_BOTTOM          2                8                 13                100                  4 3346
+.    .    1    2    1    3    EX_TRAF_KEY_SELECT       2                4              3,179                100                  4 TRAFODION.SCH.TSTAT|4|176
 
 --- SQL operation complete.
 >>log;
 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
 
 --- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 ACCUMULATED;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_312_S1
-Compile Start Time       2017/05/07 05:41:21.930615
-Compile End Time         2017/05/07 05:41:21.967829
-Compile Elapsed Time                 0:00:00.037214
-Execute Start Time       2017/05/07 05:41:26.529910
-Execute End Time         2017/05/07 05:41:26.567047
-Execute Elapsed Time                 0:00:00.037137
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_335_S1 ACCUMULATED;
+Qid                      MXID11000024709212367027407408000000000000206U3333300_335_S1
+Compile Start Time       2017/07/17 04:58:06.342753
+Compile End Time         2017/07/17 04:58:06.391558
+Compile Elapsed Time                 0:00:00.048805
+Execute Start Time       2017/07/17 04:58:09.741408
+Execute End Time         2017/07/17 04:58:09.757985
+Execute Elapsed Time                 0:00:00.016577
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -1917,20 +2069,24 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/05/07 05:41:26.564755
+First Row Returned Time  2017/07/17 04:58:09.756320
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    1
+Min. Execute Time        0.016577 secs
+Max. Execute Time        0.016577 secs
+Avg. Execute Time        0.016577 secs
 Stats Collection Type    OPERATOR_STATS
 Accessed Rows            4
 Used Rows                4
 SE IOs                   4
 SE IO Bytes              176
-SE IO MAX Time           12,163
-SQL Process Busy Time    18,938
+SE IO MAX Time           5,606
+SQL Process Busy Time    8,241
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
@@ -1940,9 +2096,9 @@ SQL Heap WM              10,341                    KB
 Processes Created        0
 Process Create Time      0
 Request Message Count    28
-Request Message Bytes    40,128
+Request Message Bytes    39,712
 Reply Message Count      15
-Reply Message Bytes      42,696
+Reply Message Bytes      42,528
 BMO Space Buffer Size    256
 BMO Space Buffer Count   0
 BMO Interim Row Count    0
@@ -1955,14 +2111,14 @@ Scr. IO Max Time         0
 Sort TopN                -1
 
 --- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 ACCUMULATED;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_312_S1
-Compile Start Time       2017/05/07 05:41:21.930615
-Compile End Time         2017/05/07 05:41:21.967829
-Compile Elapsed Time                 0:00:00.037214
-Execute Start Time       2017/05/07 05:41:26.529910
-Execute End Time         2017/05/07 05:41:26.567047
-Execute Elapsed Time                 0:00:00.037137
+>>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_335_S1 ACCUMULATED;
+Qid                      MXID11000024709212367027407408000000000000206U3333300_335_S1
+Compile Start Time       2017/07/17 04:58:06.342753
+Compile End Time         2017/07/17 04:58:06.391558
+Compile Elapsed Time                 0:00:00.048805
+Execute Start Time       2017/07/17 04:58:09.741408
+Execute End Time         2017/07/17 04:58:09.757985
+Execute Elapsed Time                 0:00:00.016577
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -1980,20 +2136,24 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/05/07 05:41:26.564755
+First Row Returned Time  2017/07/17 04:58:09.756320
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    1
+Min. Execute Time        0.016577 secs
+Max. Execute Time        0.016577 secs
+Avg. Execute Time        0.016577 secs
 Stats Collection Type    OPERATOR_STATS
 Accessed Rows            4
 Used Rows                4
 SE IOs                   4
 SE IO Bytes              176
-SE IO MAX Time           12,163
-SQL Process Busy Time    18,938
+SE IO MAX Time           5,606
+SQL Process Busy Time    8,241
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
@@ -2003,9 +2163,9 @@ SQL Heap WM              10,341                    KB
 Processes Created        0
 Process Create Time      0
 Request Message Count    28
-Request Message Bytes    40,128
+Request Message Bytes    39,712
 Reply Message Count      15
-Reply Message Bytes      42,696
+Reply Message Bytes      42,528
 BMO Space Buffer Size    256
 BMO Space Buffer Count   0
 BMO Interim Row Count    0
@@ -2022,14 +2182,14 @@ Sort TopN                -1
 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
 
 --- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 PERTABLE;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_312_S1
-Compile Start Time       2017/05/07 05:41:21.930615
-Compile End Time         2017/05/07 05:41:21.967829
-Compile Elapsed Time                 0:00:00.037214
-Execute Start Time       2017/05/07 05:41:26.529910
-Execute End Time         2017/05/07 05:41:26.567047
-Execute Elapsed Time                 0:00:00.037137
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_335_S1 PERTABLE;
+Qid                      MXID11000024709212367027407408000000000000206U3333300_335_S1
+Compile Start Time       2017/07/17 04:58:06.342753
+Compile End Time         2017/07/17 04:58:06.391558
+Compile Elapsed Time                 0:00:00.048805
+Execute Start Time       2017/07/17 04:58:09.741408
+Execute End Time         2017/07/17 04:58:09.757985
+Execute Elapsed Time                 0:00:00.016577
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -2047,15 +2207,19 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/05/07 05:41:26.564755
+First Row Returned Time  2017/07/17 04:58:09.756320
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    1
+Min. Execute Time        0.016577 secs
+Max. Execute Time        0.016577 secs
+Avg. Execute Time        0.016577 secs
 Stats Collection Type    OPERATOR_STATS
-SQL Process Busy Time    18,938
+SQL Process Busy Time    8,241
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
@@ -2065,9 +2229,9 @@ SQL Heap WM              10,341                    KB
 Processes Created        0
 Process Create Time      0
 Request Message Count    28
-Request Message Bytes    40,128
+Request Message Bytes    39,712
 Reply Message Count      15
-Reply Message Bytes      42,696
+Reply Message Bytes      42,528
 BMO Space Buffer Size    256
 BMO Space Buffer Count   0
 BMO Interim Row Count    0
@@ -2080,19 +2244,19 @@ Scr. IO Max Time         0
 Sort TopN                -1
 
    Id       DOP          Table Name
-  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs         SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
+  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs        SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
     1         2   TRAFODION.SCH.TSTAT
-              0                   4            100                   4                   4                   0              22,124              12,163
+              0                   4            100                   4                   4                   0               9,682               5,606
 
 --- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 PERTABLE;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_312_S1
-Compile Start Time       2017/05/07 05:41:21.930615
-Compile End Time         2017/05/07 05:41:21.967829
-Compile Elapsed Time                 0:00:00.037214
-Execute Start Time       2017/05/07 05:41:26.529910
-Execute End Time         2017/05/07 05:41:26.567047
-Execute Elapsed Time                 0:00:00.037137
+>>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_335_S1 PERTABLE;
+Qid                      MXID11000024709212367027407408000000000000206U3333300_335_S1
+Compile Start Time       2017/07/17 04:58:06.342753
+Compile End Time         2017/07/17 04:58:06.391558
+Compile Elapsed Time                 0:00:00.048805
+Execute Start Time       2017/07/17 04:58:09.741408
+Execute End Time         2017/07/17 04:58:09.757985
+Execute Elapsed Time                 0:00:00.016577
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -2110,15 +2274,19 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/05/07 05:41:26.564755
+First Row Returned Time  2017/07/17 04:58:09.756320
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    1
+Min. Execute Time        0.016577 secs
+Max. Execute Time        0.016577 secs
+Avg. Execute Time        0.016577 secs
 Stats Collection Type    OPERATOR_STATS
-SQL Process Busy Time    18,938
+SQL Process Busy Time    8,241
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
@@ -2128,9 +2296,9 @@ SQL Heap WM              10,341                    KB
 Processes Created        0
 Process Create Time      0
 Request Message Count    28
-Request Message Bytes    40,128
+Request Message Bytes    39,712
 Reply Message Count      15
-Reply Message Bytes      42,696
+Reply Message Bytes      42,528
 BMO Space Buffer Size    256
 BMO Space Buffer Count   0
 BMO Interim Row Count    0
@@ -2143,23 +2311,23 @@ Scr. IO Max Time         0
 Sort TopN                -1
 
    Id       DOP          Table Name
-  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs         SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
+  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs        SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
     1         2   TRAFODION.SCH.TSTAT
-              0                   4            100                   4                   4                   0              22,124              12,163
+              0                   4            100                   4                   4                   0               9,682               5,606
 
 --- SQL operation complete.
 >>log;
 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
 
 --- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 PROGRESS;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_312_S1
-Compile Start Time       2017/05/07 05:41:21.930615
-Compile End Time         2017/05/07 05:41:21.967829
-Compile Elapsed Time                 0:00:00.037214
-Execute Start Time       2017/05/07 05:41:26.529910
-Execute End Time         2017/05/07 05:41:26.567047
-Execute Elapsed Time                 0:00:00.037137
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_335_S1 PROGRESS;
+Qid                      MXID11000024709212367027407408000000000000206U3333300_335_S1
+Compile Start Time       2017/07/17 04:58:06.342753
+Compile End Time         2017/07/17 04:58:06.391558
+Compile Elapsed Time                 0:00:00.048805
+Execute Start Time       2017/07/17 04:58:09.741408
+Execute End Time         2017/07/17 04:58:09.757985
+Execute Elapsed Time                 0:00:00.016577
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -2177,15 +2345,19 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/05/07 05:41:26.564755
+First Row Returned Time  2017/07/17 04:58:09.756320
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
 No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
+No. of times executed    1
+Min. Execute Time        0.016577 secs
+Max. Execute Time        0.016577 secs
+Avg. Execute Time        0.016577 secs
 Stats Collection Type    OPERATOR_STATS
-SQL Process Busy Time    18,938
+SQL Process Busy Time    8,241
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
 SQL Heap Allocated       200                       KB
@@ -2194,31 +2366,31 @@ SQL Heap WM              10,341                    KB
 Processes Created        0
 Process Create Time      0
 Request Message Count    28
-Request Message Bytes    40,128
+Request Message Bytes    39,712
 Reply Message Count      15
-Reply Message Bytes      42,696
+Reply Message Bytes      42,528
 
    Id       DOP          Table Name
-  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs         SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
+  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs        SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
     1         2   TRAFODION.SCH.TSTAT
-              0                   4            100                   4                   4                   0              22,124              12,163
+              0                   4            100                   4                   4                   0               9,682               5,606
 
    Id             TDBName                Mode       DOP      TopN            BMOPhase     InterimRowCount             CPUTime
               BMOHeapUsed    BMOHeapAllocated           BMOHeapWM       BMOSpaceBufSz      BMOSpaceBufCnt
                ScrFileCnt           ScrIOSize           ScrIORead        ScrIOWritten           ScrIOTime        ScrIOMaxTime
-    6        EX_HASH_GRBY                DISK         2        -1           READ_ROWS                   0               3,978
+    6        EX_HASH_GRBY                DISK         2        -1           READ_ROWS                   0               2,283
                         4               1,024               7,687                 256                   0
                         0                  -1                   0                   0                   0                   0
 
 --- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 PROGRESS;
-Qid                      MXID11000004343212360895605883001000000000206U3333300_312_S1
-Comp

<TRUNCATED>


Mime
View raw message