trafodion-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From se...@apache.org
Subject [2/7] incubator-trafodion git commit: [TRAFODION-2420] RMS enhancements
Date Wed, 10 May 2017 22:49:40 GMT
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/e7719015/core/sql/regress/core/EXPECTEDRTS
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/EXPECTEDRTS b/core/sql/regress/core/EXPECTEDRTS
index bff1d37..1ea5583 100755
--- 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                      MXID11000009156212358279905535000000000000206U3333300_272_S1
-Compile Start Time       2017/04/06 23:05:20.156375
-Compile End Time         2017/04/06 23:05:20.204717
-Compile Elapsed Time                 0:00:00.048342
+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       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -94,11 +94,11 @@ Stats Collection Type    ACCUMULATED_STATS
 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
 
 --- SQL operation complete.
->>display statistics for QID MXID11000009156212358279905535000000000000206U3333300_272_S1 ;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_272_S1
-Compile Start Time       2017/04/06 23:05:20.156375
-Compile End Time         2017/04/06 23:05:20.204717
-Compile Elapsed Time                 0:00:00.048342
+>>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       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -129,11 +129,11 @@ Last Suspend Time        -1
 Stats Collection Type    ACCUMULATED_STATS
 
 --- SQL operation complete.
->>get statistics for QID MXID11000009156212358279905535000000000000206U3333300_272_S1 ;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_272_S1
-Compile Start Time       2017/04/06 23:05:20.156375
-Compile End Time         2017/04/06 23:05:20.204717
-Compile Elapsed Time                 0:00:00.048342
+>>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       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -166,10 +166,10 @@ Stats Collection Type    ACCUMULATED_STATS
 --- SQL operation complete.
 >>log;
 >>display statistics for qid current;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_272_S1
-Compile Start Time       2017/04/06 23:05:20.156375
-Compile End Time         2017/04/06 23:05:20.204717
-Compile Elapsed Time                 0:00:00.048342
+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       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -201,10 +201,10 @@ Stats Collection Type    ACCUMULATED_STATS
 
 --- SQL operation complete.
 >>get statistics for qid current ;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_272_S1
-Compile Start Time       2017/04/06 23:05:20.156375
-Compile End Time         2017/04/06 23:05:20.204717
-Compile Elapsed Time                 0:00:00.048342
+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       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -240,24 +240,24 @@ Stats Collection Type    ACCUMULATED_STATS
 D          
 -----------
 
+         12
+         11
          21
          22
-         11
-         12
 
 --- 4 row(s) selected.
 >>log;
 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
 
 --- SQL operation complete.
->>display statistics for QID MXID11000009156212358279905535000000000000206U3333300_272_S1 ;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_272_S1
-Compile Start Time       2017/04/06 23:05:20.156375
-Compile End Time         2017/04/06 23:05:20.204717
-Compile Elapsed Time                 0:00:00.048342
-Execute Start Time       2017/04/06 23:05:26.507000
-Execute End Time         2017/04/06 23:05:30.219438
-Execute Elapsed Time                 0:00:03.712438
+>>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
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -275,7 +275,7 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/04/06 23:05:30.217591
+First Row Returned Time  2017/05/07 05:40:34.139345
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
@@ -287,37 +287,40 @@ Accessed Rows            4
 Used Rows                4
 SE IOs                   4
 SE IO Bytes              176
-SE IO MAX Time           765,673
-SQL Process Busy Time    3,750,747
+SE IO MAX Time           725,870
+SQL Process Busy Time    5,717,075
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
-SQL Heap Allocated       10,471                    KB
+SQL Heap Allocated       10,472                    KB
 SQL Heap Used            80                        KB
 SQL Heap WM              67                        KB
 Processes Created        2
-Process Create Time      142,012
+Process Create Time      150,942
 Request Message Count    26
-Request Message Bytes    39,392
+Request Message Bytes    39,808
 Reply Message Count      15
-Reply Message Bytes      38,760
+Reply Message Bytes      38,840
+BMO Space Buffer Size    0
+BMO Space Buffer Count   0
+BMO Interim Row Count    0
 Scr. Overflow Mode       DISK
 Scr. File Count          0
-Scr. Buffer Blk Size     0
-Scr. Buffer Blks Read    0
-Scr. Buffer Blks Written 0
+Scr. IO Size             0
 Scr. Read Count          0
 Scr. Write Count         0
+Scr. IO Max Time         0
+Sort TopN                -1
 
 --- SQL operation complete.
->>get statistics for QID MXID11000009156212358279905535000000000000206U3333300_272_S1 ;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_272_S1
-Compile Start Time       2017/04/06 23:05:20.156375
-Compile End Time         2017/04/06 23:05:20.204717
-Compile Elapsed Time                 0:00:00.048342
-Execute Start Time       2017/04/06 23:05:26.507000
-Execute End Time         2017/04/06 23:05:30.219438
-Execute Elapsed Time                 0:00:03.712438
+>>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
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -335,7 +338,7 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/04/06 23:05:30.217591
+First Row Returned Time  2017/05/07 05:40:34.139345
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
@@ -347,38 +350,41 @@ Accessed Rows            4
 Used Rows                4
 SE IOs                   4
 SE IO Bytes              176
-SE IO MAX Time           765,673
-SQL Process Busy Time    3,750,747
+SE IO MAX Time           725,870
+SQL Process Busy Time    5,717,075
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
-SQL Heap Allocated       10,471                    KB
+SQL Heap Allocated       10,472                    KB
 SQL Heap Used            80                        KB
 SQL Heap WM              67                        KB
 Processes Created        2
-Process Create Time      142,012
+Process Create Time      150,942
 Request Message Count    26
-Request Message Bytes    39,392
+Request Message Bytes    39,808
 Reply Message Count      15
-Reply Message Bytes      38,760
+Reply Message Bytes      38,840
+BMO Space Buffer Size    0
+BMO Space Buffer Count   0
+BMO Interim Row Count    0
 Scr. Overflow Mode       DISK
 Scr. File Count          0
-Scr. Buffer Blk Size     0
-Scr. Buffer Blks Read    0
-Scr. Buffer Blks Written 0
+Scr. IO Size             0
 Scr. Read Count          0
 Scr. Write Count         0
+Scr. IO Max Time         0
+Sort TopN                -1
 
 --- SQL operation complete.
 >>log;
 >>display statistics for qid current;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_272_S1
-Compile Start Time       2017/04/06 23:05:20.156375
-Compile End Time         2017/04/06 23:05:20.204717
-Compile Elapsed Time                 0:00:00.048342
-Execute Start Time       2017/04/06 23:05:26.507000
-Execute End Time         2017/04/06 23:05:30.219438
-Execute Elapsed Time                 0:00:03.712438
+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
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -396,7 +402,7 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/04/06 23:05:30.217591
+First Row Returned Time  2017/05/07 05:40:34.139345
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
@@ -408,37 +414,40 @@ Accessed Rows            4
 Used Rows                4
 SE IOs                   4
 SE IO Bytes              176
-SE IO MAX Time           765,673
-SQL Process Busy Time    3,750,747
+SE IO MAX Time           725,870
+SQL Process Busy Time    5,717,075
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
-SQL Heap Allocated       10,471                    KB
+SQL Heap Allocated       10,472                    KB
 SQL Heap Used            80                        KB
 SQL Heap WM              67                        KB
 Processes Created        2
-Process Create Time      142,012
+Process Create Time      150,942
 Request Message Count    26
-Request Message Bytes    39,392
+Request Message Bytes    39,808
 Reply Message Count      15
-Reply Message Bytes      38,760
+Reply Message Bytes      38,840
+BMO Space Buffer Size    0
+BMO Space Buffer Count   0
+BMO Interim Row Count    0
 Scr. Overflow Mode       DISK
 Scr. File Count          0
-Scr. Buffer Blk Size     0
-Scr. Buffer Blks Read    0
-Scr. Buffer Blks Written 0
+Scr. IO Size             0
 Scr. Read Count          0
 Scr. Write Count         0
+Scr. IO Max Time         0
+Sort TopN                -1
 
 --- SQL operation complete.
 >>get statistics for qid current ;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_272_S1
-Compile Start Time       2017/04/06 23:05:20.156375
-Compile End Time         2017/04/06 23:05:20.204717
-Compile Elapsed Time                 0:00:00.048342
-Execute Start Time       2017/04/06 23:05:26.507000
-Execute End Time         2017/04/06 23:05:30.219438
-Execute Elapsed Time                 0:00:03.712438
+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
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -456,7 +465,7 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/04/06 23:05:30.217591
+First Row Returned Time  2017/05/07 05:40:34.139345
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
@@ -468,27 +477,30 @@ Accessed Rows            4
 Used Rows                4
 SE IOs                   4
 SE IO Bytes              176
-SE IO MAX Time           765,673
-SQL Process Busy Time    3,750,747
+SE IO MAX Time           725,870
+SQL Process Busy Time    5,717,075
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
-SQL Heap Allocated       10,471                    KB
+SQL Heap Allocated       10,472                    KB
 SQL Heap Used            80                        KB
 SQL Heap WM              67                        KB
 Processes Created        2
-Process Create Time      142,012
+Process Create Time      150,942
 Request Message Count    26
-Request Message Bytes    39,392
+Request Message Bytes    39,808
 Reply Message Count      15
-Reply Message Bytes      38,760
+Reply Message Bytes      38,840
+BMO Space Buffer Size    0
+BMO Space Buffer Count   0
+BMO Interim Row Count    0
 Scr. Overflow Mode       DISK
 Scr. File Count          0
-Scr. Buffer Blk Size     0
-Scr. Buffer Blks Read    0
-Scr. Buffer Blks Written 0
+Scr. IO Size             0
 Scr. Read Count          0
 Scr. Write Count         0
+Scr. IO Max Time         0
+Sort TopN                -1
 
 --- SQL operation complete.
 >>prepare s1 from select distinct d from tstat ;
@@ -498,25 +510,25 @@ Scr. Write Count         0
 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
 
 --- SQL operation complete.
->>display statistics for QID MXID11000009156212358279905535000000000000206U3333300_272_S1 ;
+>>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_279_S1 ;
 
-*** ERROR[8923] The given Query Id MXID11000009156212358279905535000000000000206U3333300_272_S1 is not found.
+*** ERROR[8923] The given Query Id MXID11000004343212360895605883001000000000206U3333300_279_S1 is not found.
 
 --- SQL operation failed with errors.
->>get statistics for QID MXID11000009156212358279905535000000000000206U3333300_272_S1 ;
+>>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_279_S1 ;
 
-*** ERROR[8923] The given Query Id MXID11000009156212358279905535000000000000206U3333300_272_S1 is not found.
+*** ERROR[8923] The given Query Id MXID11000004343212360895605883001000000000206U3333300_279_S1 is not found.
 
 --- SQL operation failed with errors.
 >>log;
 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
 
 --- SQL operation complete.
->>display statistics for QID MXID11000009156212358279905535000000000000206U3333300_281_S1 ;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_281_S1
-Compile Start Time       2017/04/06 23:05:33.259103
-Compile End Time         2017/04/06 23:05:33.259721
-Compile Elapsed Time                 0:00:00.000618
+>>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
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -547,11 +559,11 @@ Last Suspend Time        -1
 Stats Collection Type    ACCUMULATED_STATS
 
 --- SQL operation complete.
->>get statistics for QID MXID11000009156212358279905535000000000000206U3333300_281_S1 ;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_281_S1
-Compile Start Time       2017/04/06 23:05:33.259103
-Compile End Time         2017/04/06 23:05:33.259721
-Compile Elapsed Time                 0:00:00.000618
+>>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
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -584,10 +596,10 @@ Stats Collection Type    ACCUMULATED_STATS
 --- SQL operation complete.
 >>log;
 >>display statistics for qid current;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_281_S1
-Compile Start Time       2017/04/06 23:05:33.259103
-Compile End Time         2017/04/06 23:05:33.259721
-Compile Elapsed Time                 0:00:00.000618
+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
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -619,10 +631,10 @@ Stats Collection Type    ACCUMULATED_STATS
 
 --- SQL operation complete.
 >>get statistics for qid current ;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_281_S1
-Compile Start Time       2017/04/06 23:05:33.259103
-Compile End Time         2017/04/06 23:05:33.259721
-Compile Elapsed Time                 0:00:00.000618
+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
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -666,10 +678,10 @@ Stats Collection Type    ACCUMULATED_STATS
 --- SQL command prepared.
 >>log;
 >>get statistics for qid current ;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_286_S1
-Compile Start Time       2017/04/06 23:05:39.345617
-Compile End Time         2017/04/06 23:05:39.388433
-Compile Elapsed Time                 0:00:00.042816
+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       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -704,11 +716,11 @@ Stats Collection Type    PERTABLE_STATS
 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
 
 --- SQL operation complete.
->>display statistics for QID MXID11000009156212358279905535000000000000206U3333300_286_S1 ;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_286_S1
-Compile Start Time       2017/04/06 23:05:39.345617
-Compile End Time         2017/04/06 23:05:39.388433
-Compile Elapsed Time                 0:00:00.042816
+>>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       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -739,11 +751,11 @@ Last Suspend Time        -1
 Stats Collection Type    PERTABLE_STATS
 
 --- SQL operation complete.
->>get statistics for QID MXID11000009156212358279905535000000000000206U3333300_286_S1 ;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_286_S1
-Compile Start Time       2017/04/06 23:05:39.345617
-Compile End Time         2017/04/06 23:05:39.388433
-Compile Elapsed Time                 0:00:00.042816
+>>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       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -778,11 +790,11 @@ Stats Collection Type    PERTABLE_STATS
 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
 
 --- SQL operation complete.
->>display statistics for QID MXID11000009156212358279905535000000000000206U3333300_286_S1 ACCUMULATED;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_286_S1
-Compile Start Time       2017/04/06 23:05:39.345617
-Compile End Time         2017/04/06 23:05:39.388433
-Compile Elapsed Time                 0:00:00.042816
+>>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       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -813,11 +825,11 @@ Last Suspend Time        -1
 Stats Collection Type    PERTABLE_STATS
 
 --- SQL operation complete.
->>get statistics for QID MXID11000009156212358279905535000000000000206U3333300_286_S1 ACCUMULATED;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_286_S1
-Compile Start Time       2017/04/06 23:05:39.345617
-Compile End Time         2017/04/06 23:05:39.388433
-Compile Elapsed Time                 0:00:00.042816
+>>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       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -850,10 +862,10 @@ Stats Collection Type    PERTABLE_STATS
 --- SQL operation complete.
 >>log;
 >>display statistics for qid current;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_286_S1
-Compile Start Time       2017/04/06 23:05:39.345617
-Compile End Time         2017/04/06 23:05:39.388433
-Compile Elapsed Time                 0:00:00.042816
+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       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -885,10 +897,10 @@ Stats Collection Type    PERTABLE_STATS
 
 --- SQL operation complete.
 >>get statistics for qid current ;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_286_S1
-Compile Start Time       2017/04/06 23:05:39.345617
-Compile End Time         2017/04/06 23:05:39.388433
-Compile Elapsed Time                 0:00:00.042816
+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       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -920,10 +932,10 @@ Stats Collection Type    PERTABLE_STATS
 
 --- SQL operation complete.
 >>display statistics for qid current accumulated ;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_286_S1
-Compile Start Time       2017/04/06 23:05:39.345617
-Compile End Time         2017/04/06 23:05:39.388433
-Compile Elapsed Time                 0:00:00.042816
+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       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -955,10 +967,10 @@ Stats Collection Type    PERTABLE_STATS
 
 --- SQL operation complete.
 >>get statistics for qid current accumulated ;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_286_S1
-Compile Start Time       2017/04/06 23:05:39.345617
-Compile End Time         2017/04/06 23:05:39.388433
-Compile Elapsed Time                 0:00:00.042816
+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       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -994,24 +1006,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 MXID11000009156212358279905535000000000000206U3333300_286_S1 ;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_286_S1
-Compile Start Time       2017/04/06 23:05:39.345617
-Compile End Time         2017/04/06 23:05:39.388433
-Compile Elapsed Time                 0:00:00.042816
-Execute Start Time       2017/04/06 23:05:45.596219
-Execute End Time         2017/04/06 23:05:45.609391
-Execute Elapsed Time                 0:00:00.013172
+>>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
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -1029,7 +1041,7 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/04/06 23:05:45.606884
+First Row Returned Time  2017/05/07 05:40:58.520309
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
@@ -1037,7 +1049,7 @@ No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
 Stats Collection Type    PERTABLE_STATS
-SQL Process Busy Time    5,884
+SQL Process Busy Time    15,419
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
@@ -1047,34 +1059,34 @@ SQL Heap WM              10,338                    KB
 Processes Created        0
 Process Create Time      0
 Request Message Count    27
-Request Message Bytes    39,552
+Request Message Bytes    39,968
 Reply Message Count      15
-Reply Message Bytes      39,144
+Reply Message Bytes      39,264
+BMO Space Buffer Size    0
+BMO Space Buffer Count   0
+BMO Interim Row Count    0
 Scr. Overflow Mode       UNKNOWN
 Scr. File Count          0
-Scr. Buffer Blk Size     0
-Scr. Buffer Blks Read    0
-Scr. Buffer Blks Written 0
+Scr. IO Size             0
 Scr. Read Count          0
 Scr. Write Count         0
+Scr. IO Max Time         0
 Sort TopN                -1
 
-       ID       DOP         Table Name
-   Records Accessed       Records Used   HBase/Hive   HBase/Hive      HBase/Hive IO      HBase/Hive IO
-   Estimated/Actual   Estimated/Actual          IOs    IO MBytes           Sum Time           Max Time
-        1         2   TRAFODION.SCH.TSTAT
-                  0                100
-                  4                  4            4            0              7,088              4,227
+   Id       DOP          Table Name
+  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs         SE_IO_Bytes       SE_IO_SumTime       SE_IO_MaxTime
+    1         2   TRAFODION.SCH.TSTAT
+              0                   4            100                   4                   4                   0              20,398              10,610
 
 --- SQL operation complete.
->>get statistics for QID MXID11000009156212358279905535000000000000206U3333300_286_S1 ;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_286_S1
-Compile Start Time       2017/04/06 23:05:39.345617
-Compile End Time         2017/04/06 23:05:39.388433
-Compile Elapsed Time                 0:00:00.042816
-Execute Start Time       2017/04/06 23:05:45.596219
-Execute End Time         2017/04/06 23:05:45.609391
-Execute Elapsed Time                 0:00:00.013172
+>>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
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -1092,7 +1104,7 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/04/06 23:05:45.606884
+First Row Returned Time  2017/05/07 05:40:58.520309
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
@@ -1100,7 +1112,7 @@ No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
 Stats Collection Type    PERTABLE_STATS
-SQL Process Busy Time    5,884
+SQL Process Busy Time    15,419
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
@@ -1110,38 +1122,38 @@ SQL Heap WM              10,338                    KB
 Processes Created        0
 Process Create Time      0
 Request Message Count    27
-Request Message Bytes    39,552
+Request Message Bytes    39,968
 Reply Message Count      15
-Reply Message Bytes      39,144
+Reply Message Bytes      39,264
+BMO Space Buffer Size    0
+BMO Space Buffer Count   0
+BMO Interim Row Count    0
 Scr. Overflow Mode       UNKNOWN
 Scr. File Count          0
-Scr. Buffer Blk Size     0
-Scr. Buffer Blks Read    0
-Scr. Buffer Blks Written 0
+Scr. IO Size             0
 Scr. Read Count          0
 Scr. Write Count         0
+Scr. IO Max Time         0
 Sort TopN                -1
 
-       ID       DOP         Table Name
-   Records Accessed       Records Used   HBase/Hive   HBase/Hive      HBase/Hive IO      HBase/Hive IO
-   Estimated/Actual   Estimated/Actual          IOs    IO MBytes           Sum Time           Max Time
-        1         2   TRAFODION.SCH.TSTAT
-                  0                100
-                  4                  4            4            0              7,088              4,227
+   Id       DOP          Table Name
+  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs         SE_IO_Bytes       SE_IO_SumTime       SE_IO_MaxTime
+    1         2   TRAFODION.SCH.TSTAT
+              0                   4            100                   4                   4                   0              20,398              10,610
 
 --- SQL operation complete.
 >>log;
 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
 
 --- SQL operation complete.
->>display statistics for QID MXID11000009156212358279905535000000000000206U3333300_286_S1 ACCUMULATED;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_286_S1
-Compile Start Time       2017/04/06 23:05:39.345617
-Compile End Time         2017/04/06 23:05:39.388433
-Compile Elapsed Time                 0:00:00.042816
-Execute Start Time       2017/04/06 23:05:45.596219
-Execute End Time         2017/04/06 23:05:45.609391
-Execute Elapsed Time                 0:00:00.013172
+>>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
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -1159,7 +1171,7 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/04/06 23:05:45.606884
+First Row Returned Time  2017/05/07 05:40:58.520309
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
@@ -1171,8 +1183,8 @@ Accessed Rows            4
 Used Rows                4
 SE IOs                   4
 SE IO Bytes              176
-SE IO MAX Time           4,227
-SQL Process Busy Time    5,884
+SE IO MAX Time           10,610
+SQL Process Busy Time    15,419
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
@@ -1182,26 +1194,29 @@ SQL Heap WM              10,338                    KB
 Processes Created        0
 Process Create Time      0
 Request Message Count    27
-Request Message Bytes    39,552
+Request Message Bytes    39,968
 Reply Message Count      15
-Reply Message Bytes      39,144
+Reply Message Bytes      39,264
+BMO Space Buffer Size    0
+BMO Space Buffer Count   0
+BMO Interim Row Count    0
 Scr. Overflow Mode       UNKNOWN
 Scr. File Count          0
-Scr. Buffer Blk Size     0
-Scr. Buffer Blks Read    0
-Scr. Buffer Blks Written 0
+Scr. IO Size             0
 Scr. Read Count          0
 Scr. Write Count         0
+Scr. IO Max Time         0
+Sort TopN                -1
 
 --- SQL operation complete.
->>get statistics for QID MXID11000009156212358279905535000000000000206U3333300_286_S1 ACCUMULATED;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_286_S1
-Compile Start Time       2017/04/06 23:05:39.345617
-Compile End Time         2017/04/06 23:05:39.388433
-Compile Elapsed Time                 0:00:00.042816
-Execute Start Time       2017/04/06 23:05:45.596219
-Execute End Time         2017/04/06 23:05:45.609391
-Execute Elapsed Time                 0:00:00.013172
+>>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
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -1219,7 +1234,7 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/04/06 23:05:45.606884
+First Row Returned Time  2017/05/07 05:40:58.520309
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
@@ -1231,8 +1246,8 @@ Accessed Rows            4
 Used Rows                4
 SE IOs                   4
 SE IO Bytes              176
-SE IO MAX Time           4,227
-SQL Process Busy Time    5,884
+SE IO MAX Time           10,610
+SQL Process Busy Time    15,419
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
@@ -1242,27 +1257,30 @@ SQL Heap WM              10,338                    KB
 Processes Created        0
 Process Create Time      0
 Request Message Count    27
-Request Message Bytes    39,552
+Request Message Bytes    39,968
 Reply Message Count      15
-Reply Message Bytes      39,144
+Reply Message Bytes      39,264
+BMO Space Buffer Size    0
+BMO Space Buffer Count   0
+BMO Interim Row Count    0
 Scr. Overflow Mode       UNKNOWN
 Scr. File Count          0
-Scr. Buffer Blk Size     0
-Scr. Buffer Blks Read    0
-Scr. Buffer Blks Written 0
+Scr. IO Size             0
 Scr. Read Count          0
 Scr. Write Count         0
+Scr. IO Max Time         0
+Sort TopN                -1
 
 --- SQL operation complete.
 >>log;
 >>display statistics for qid current;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_286_S1
-Compile Start Time       2017/04/06 23:05:39.345617
-Compile End Time         2017/04/06 23:05:39.388433
-Compile Elapsed Time                 0:00:00.042816
-Execute Start Time       2017/04/06 23:05:45.596219
-Execute End Time         2017/04/06 23:05:45.609391
-Execute Elapsed Time                 0:00:00.013172
+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
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -1280,7 +1298,7 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/04/06 23:05:45.606884
+First Row Returned Time  2017/05/07 05:40:58.520309
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
@@ -1288,7 +1306,7 @@ No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
 Stats Collection Type    PERTABLE_STATS
-SQL Process Busy Time    5,884
+SQL Process Busy Time    15,419
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
@@ -1298,34 +1316,34 @@ SQL Heap WM              10,338                    KB
 Processes Created        0
 Process Create Time      0
 Request Message Count    27
-Request Message Bytes    39,552
+Request Message Bytes    39,968
 Reply Message Count      15
-Reply Message Bytes      39,144
+Reply Message Bytes      39,264
+BMO Space Buffer Size    0
+BMO Space Buffer Count   0
+BMO Interim Row Count    0
 Scr. Overflow Mode       UNKNOWN
 Scr. File Count          0
-Scr. Buffer Blk Size     0
-Scr. Buffer Blks Read    0
-Scr. Buffer Blks Written 0
+Scr. IO Size             0
 Scr. Read Count          0
 Scr. Write Count         0
+Scr. IO Max Time         0
 Sort TopN                -1
 
-       ID       DOP         Table Name
-   Records Accessed       Records Used   HBase/Hive   HBase/Hive      HBase/Hive IO      HBase/Hive IO
-   Estimated/Actual   Estimated/Actual          IOs    IO MBytes           Sum Time           Max Time
-        1         2   TRAFODION.SCH.TSTAT
-                  0                100
-                  4                  4            4            0              7,088              4,227
+   Id       DOP          Table Name
+  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs         SE_IO_Bytes       SE_IO_SumTime       SE_IO_MaxTime
+    1         2   TRAFODION.SCH.TSTAT
+              0                   4            100                   4                   4                   0              20,398              10,610
 
 --- SQL operation complete.
 >>get statistics for qid current ;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_286_S1
-Compile Start Time       2017/04/06 23:05:39.345617
-Compile End Time         2017/04/06 23:05:39.388433
-Compile Elapsed Time                 0:00:00.042816
-Execute Start Time       2017/04/06 23:05:45.596219
-Execute End Time         2017/04/06 23:05:45.609391
-Execute Elapsed Time                 0:00:00.013172
+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
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -1343,7 +1361,7 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/04/06 23:05:45.606884
+First Row Returned Time  2017/05/07 05:40:58.520309
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
@@ -1351,7 +1369,7 @@ No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
 Stats Collection Type    PERTABLE_STATS
-SQL Process Busy Time    5,884
+SQL Process Busy Time    15,419
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
@@ -1361,34 +1379,34 @@ SQL Heap WM              10,338                    KB
 Processes Created        0
 Process Create Time      0
 Request Message Count    27
-Request Message Bytes    39,552
+Request Message Bytes    39,968
 Reply Message Count      15
-Reply Message Bytes      39,144
+Reply Message Bytes      39,264
+BMO Space Buffer Size    0
+BMO Space Buffer Count   0
+BMO Interim Row Count    0
 Scr. Overflow Mode       UNKNOWN
 Scr. File Count          0
-Scr. Buffer Blk Size     0
-Scr. Buffer Blks Read    0
-Scr. Buffer Blks Written 0
+Scr. IO Size             0
 Scr. Read Count          0
 Scr. Write Count         0
+Scr. IO Max Time         0
 Sort TopN                -1
 
-       ID       DOP         Table Name
-   Records Accessed       Records Used   HBase/Hive   HBase/Hive      HBase/Hive IO      HBase/Hive IO
-   Estimated/Actual   Estimated/Actual          IOs    IO MBytes           Sum Time           Max Time
-        1         2   TRAFODION.SCH.TSTAT
-                  0                100
-                  4                  4            4            0              7,088              4,227
+   Id       DOP          Table Name
+  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs         SE_IO_Bytes       SE_IO_SumTime       SE_IO_MaxTime
+    1         2   TRAFODION.SCH.TSTAT
+              0                   4            100                   4                   4                   0              20,398              10,610
 
 --- SQL operation complete.
 >>display statistics for qid current accumulated;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_286_S1
-Compile Start Time       2017/04/06 23:05:39.345617
-Compile End Time         2017/04/06 23:05:39.388433
-Compile Elapsed Time                 0:00:00.042816
-Execute Start Time       2017/04/06 23:05:45.596219
-Execute End Time         2017/04/06 23:05:45.609391
-Execute Elapsed Time                 0:00:00.013172
+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
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -1406,7 +1424,7 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/04/06 23:05:45.606884
+First Row Returned Time  2017/05/07 05:40:58.520309
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
@@ -1418,8 +1436,8 @@ Accessed Rows            4
 Used Rows                4
 SE IOs                   4
 SE IO Bytes              176
-SE IO MAX Time           4,227
-SQL Process Busy Time    5,884
+SE IO MAX Time           10,610
+SQL Process Busy Time    15,419
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
@@ -1429,26 +1447,29 @@ SQL Heap WM              10,338                    KB
 Processes Created        0
 Process Create Time      0
 Request Message Count    27
-Request Message Bytes    39,552
+Request Message Bytes    39,968
 Reply Message Count      15
-Reply Message Bytes      39,144
+Reply Message Bytes      39,264
+BMO Space Buffer Size    0
+BMO Space Buffer Count   0
+BMO Interim Row Count    0
 Scr. Overflow Mode       UNKNOWN
 Scr. File Count          0
-Scr. Buffer Blk Size     0
-Scr. Buffer Blks Read    0
-Scr. Buffer Blks Written 0
+Scr. IO Size             0
 Scr. Read Count          0
 Scr. Write Count         0
+Scr. IO Max Time         0
+Sort TopN                -1
 
 --- SQL operation complete.
 >>get statistics for qid current accumulated;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_286_S1
-Compile Start Time       2017/04/06 23:05:39.345617
-Compile End Time         2017/04/06 23:05:39.388433
-Compile Elapsed Time                 0:00:00.042816
-Execute Start Time       2017/04/06 23:05:45.596219
-Execute End Time         2017/04/06 23:05:45.609391
-Execute Elapsed Time                 0:00:00.013172
+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
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -1466,7 +1487,7 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/04/06 23:05:45.606884
+First Row Returned Time  2017/05/07 05:40:58.520309
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
@@ -1478,8 +1499,8 @@ Accessed Rows            4
 Used Rows                4
 SE IOs                   4
 SE IO Bytes              176
-SE IO MAX Time           4,227
-SQL Process Busy Time    5,884
+SE IO MAX Time           10,610
+SQL Process Busy Time    15,419
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
@@ -1489,21 +1510,24 @@ SQL Heap WM              10,338                    KB
 Processes Created        0
 Process Create Time      0
 Request Message Count    27
-Request Message Bytes    39,552
+Request Message Bytes    39,968
 Reply Message Count      15
-Reply Message Bytes      39,144
+Reply Message Bytes      39,264
+BMO Space Buffer Size    0
+BMO Space Buffer Count   0
+BMO Interim Row Count    0
 Scr. Overflow Mode       UNKNOWN
 Scr. File Count          0
-Scr. Buffer Blk Size     0
-Scr. Buffer Blks Read    0
-Scr. Buffer Blks Written 0
+Scr. IO Size             0
 Scr. Read Count          0
 Scr. Write Count         0
+Scr. IO Max Time         0
+Sort TopN                -1
 
 --- SQL operation complete.
 >>log;
 >>obey PQIDOUT;
->>SET SESSION DEFAULT PARENT_QID 'MXID11000009156212358279905535000000000000206U3333300_286_S1';
+>>SET SESSION DEFAULT PARENT_QID 'MXID11000004343212360895605883001000000000206U3333300_293_S1';
 
 --- SQL operation complete.
 >>prepare s1 from select distinct d from tstat ;
@@ -1513,11 +1537,11 @@ Scr. Write Count         0
 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
 
 --- SQL operation complete.
->>display statistics for QID MXID11000009156212358279905535000000000000206U3333300_300_S1 ;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_300_S1
-Compile Start Time       2017/04/06 23:05:54.780156
-Compile End Time         2017/04/06 23:05:54.780786
-Compile Elapsed Time                 0:00:00.000630
+>>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
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -1529,7 +1553,7 @@ Query Type               SQL_SELECT_NON_UNIQUE
 Sub Query Type           SQL_STMT_NA
 Estimated Accessed Rows  0
 Estimated Used Rows      0
-Parent Qid               MXID11000009156212358279905535000000000000206U3333300_286_S1
+Parent Qid               MXID11000004343212360895605883001000000000206U3333300_293_S1
 Parent Query System      SAME
 Child Qid                NONE
 Number of SQL Processes  1
@@ -1548,11 +1572,11 @@ Last Suspend Time        -1
 Stats Collection Type    PERTABLE_STATS
 
 --- SQL operation complete.
->>get statistics for QID MXID11000009156212358279905535000000000000206U3333300_300_S1 ;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_300_S1
-Compile Start Time       2017/04/06 23:05:54.780156
-Compile End Time         2017/04/06 23:05:54.780786
-Compile Elapsed Time                 0:00:00.000630
+>>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
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -1564,7 +1588,7 @@ Query Type               SQL_SELECT_NON_UNIQUE
 Sub Query Type           SQL_STMT_NA
 Estimated Accessed Rows  0
 Estimated Used Rows      0
-Parent Qid               MXID11000009156212358279905535000000000000206U3333300_286_S1
+Parent Qid               MXID11000004343212360895605883001000000000206U3333300_293_S1
 Parent Query System      SAME
 Child Qid                NONE
 Number of SQL Processes  1
@@ -1594,11 +1618,11 @@ Stats Collection Type    PERTABLE_STATS
 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
 
 --- SQL operation complete.
->>display statistics for QID MXID11000009156212358279905535000000000000206U3333300_302_S1 ;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_302_S1
-Compile Start Time       2017/04/06 23:05:57.786576
-Compile End Time         2017/04/06 23:05:57.787052
-Compile Elapsed Time                 0:00:00.000476
+>>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
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -1629,11 +1653,11 @@ Last Suspend Time        -1
 Stats Collection Type    PERTABLE_STATS
 
 --- SQL operation complete.
->>get statistics for QID MXID11000009156212358279905535000000000000206U3333300_302_S1 ;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_302_S1
-Compile Start Time       2017/04/06 23:05:57.786576
-Compile End Time         2017/04/06 23:05:57.787052
-Compile Elapsed Time                 0:00:00.000476
+>>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
 Execute Start Time       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -1680,11 +1704,11 @@ Stats Collection Type    PERTABLE_STATS
 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
 
 --- SQL operation complete.
->>display statistics for QID MXID11000009156212358279905535000000000000206U3333300_305_S1 ;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_305_S1
-Compile Start Time       2017/04/06 23:06:00.886062
-Compile End Time         2017/04/06 23:06:00.933429
-Compile Elapsed Time                 0:00:00.047367
+>>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       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -1715,11 +1739,11 @@ Last Suspend Time        -1
 Stats Collection Type    OPERATOR_STATS
 
 --- SQL operation complete.
->>get statistics for QID MXID11000009156212358279905535000000000000206U3333300_305_S1 ;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_305_S1
-Compile Start Time       2017/04/06 23:06:00.886062
-Compile End Time         2017/04/06 23:06:00.933429
-Compile Elapsed Time                 0:00:00.047367
+>>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       -1
 Execute End Time         -1
 Execute Elapsed Time                 0:00:00.000000
@@ -1766,14 +1790,14 @@ D
 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
 
 --- SQL operation complete.
->>display statistics for QID MXID11000009156212358279905535000000000000206U3333300_305_S1 ;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_305_S1
-Compile Start Time       2017/04/06 23:06:00.886062
-Compile End Time         2017/04/06 23:06:00.933429
-Compile Elapsed Time                 0:00:00.047367
-Execute Start Time       2017/04/06 23:06:06.989107
-Execute End Time         2017/04/06 23:06:07.002116
-Execute Elapsed Time                 0:00:00.013009
+>>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
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -1791,7 +1815,7 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/04/06 23:06:07.000444
+First Row Returned Time  2017/05/07 05:41:26.564755
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
@@ -1802,27 +1826,27 @@ 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                  8                  0                  4              24 815
-9    .    10   11   4    0    EX_SPLIT_TOP             1                5                  7                  2                  4              24
-8    .    9    10   4    0    EX_SEND_TOP              2               10                800                  2                  4              32
-7    .    8    9    4    2    EX_SEND_BOTTOM           2               17                144                  2                  4              32
-6    .    7    8    4    2    EX_SPLIT_BOTTOM          2                7                 14                  2                  4              24 3583
-5    .    6    7    3    2    EX_HASH_GRBY             2                6              2,638                  1                  4              24 0|0|0
-4    .    5    6    2    2    EX_SPLIT_TOP             2               11                 13                100                  4              24
-3    .    4    5    2    2    EX_SEND_TOP              4               18                774                100                  4              32
-2    .    3    4    2    3    EX_SEND_BOTTOM           4               35                176                100                  4              32
-1    .    2    3    2    3    EX_SPLIT_BOTTOM          2                8                 22                100                  4              24 1983
-.    .    1    2    1    3    EX_TRAF_KEY_SELECT       2               12              5,355                100                  4              24 TRAFODION.SCH.TSTAT|4|176
-
---- SQL operation complete.
->>get statistics for QID MXID11000009156212358279905535000000000000206U3333300_305_S1 ;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_305_S1
-Compile Start Time       2017/04/06 23:06:00.886062
-Compile End Time         2017/04/06 23:06:00.933429
-Compile Elapsed Time                 0:00:00.047367
-Execute Start Time       2017/04/06 23:06:06.989107
-Execute End Time         2017/04/06 23:06:07.002116
-Execute Elapsed Time                 0:00:00.013009
+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
+
+--- 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
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -1840,7 +1864,7 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/04/06 23:06:07.000444
+First Row Returned Time  2017/05/07 05:41:26.564755
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
@@ -1851,31 +1875,31 @@ 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                  8                  0                  4              24 815
-9    .    10   11   4    0    EX_SPLIT_TOP             1                5                  7                  2                  4              24
-8    .    9    10   4    0    EX_SEND_TOP              2               10                800                  2                  4              32
-7    .    8    9    4    2    EX_SEND_BOTTOM           2               17                144                  2                  4              32
-6    .    7    8    4    2    EX_SPLIT_BOTTOM          2                7                 14                  2                  4              24 3583
-5    .    6    7    3    2    EX_HASH_GRBY             2                6              2,638                  1                  4              24 0|0|0
-4    .    5    6    2    2    EX_SPLIT_TOP             2               11                 13                100                  4              24
-3    .    4    5    2    2    EX_SEND_TOP              4               18                774                100                  4              32
-2    .    3    4    2    3    EX_SEND_BOTTOM           4               35                176                100                  4              32
-1    .    2    3    2    3    EX_SPLIT_BOTTOM          2                8                 22                100                  4              24 1983
-.    .    1    2    1    3    EX_TRAF_KEY_SELECT       2               12              5,355                100                  4              24 TRAFODION.SCH.TSTAT|4|176
+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
 
 --- SQL operation complete.
 >>log;
 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
 
 --- SQL operation complete.
->>display statistics for QID MXID11000009156212358279905535000000000000206U3333300_305_S1 ACCUMULATED;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_305_S1
-Compile Start Time       2017/04/06 23:06:00.886062
-Compile End Time         2017/04/06 23:06:00.933429
-Compile Elapsed Time                 0:00:00.047367
-Execute Start Time       2017/04/06 23:06:06.989107
-Execute End Time         2017/04/06 23:06:07.002116
-Execute Elapsed Time                 0:00:00.013009
+>>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
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -1893,7 +1917,7 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/04/06 23:06:07.000444
+First Row Returned Time  2017/05/07 05:41:26.564755
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
@@ -1905,8 +1929,8 @@ Accessed Rows            4
 Used Rows                4
 SE IOs                   4
 SE IO Bytes              176
-SE IO MAX Time           3,572
-SQL Process Busy Time    6,381
+SE IO MAX Time           12,163
+SQL Process Busy Time    18,938
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
@@ -1916,26 +1940,29 @@ SQL Heap WM              10,341                    KB
 Processes Created        0
 Process Create Time      0
 Request Message Count    28
-Request Message Bytes    39,712
+Request Message Bytes    40,128
 Reply Message Count      15
-Reply Message Bytes      42,416
+Reply Message Bytes      42,696
+BMO Space Buffer Size    256
+BMO Space Buffer Count   0
+BMO Interim Row Count    0
 Scr. Overflow Mode       DISK
 Scr. File Count          0
-Scr. Buffer Blk Size     0
-Scr. Buffer Blks Read    0
-Scr. Buffer Blks Written 0
+Scr. IO Size             0
 Scr. Read Count          0
 Scr. Write Count         0
+Scr. IO Max Time         0
+Sort TopN                -1
 
 --- SQL operation complete.
->>get statistics for QID MXID11000009156212358279905535000000000000206U3333300_305_S1 ACCUMULATED;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_305_S1
-Compile Start Time       2017/04/06 23:06:00.886062
-Compile End Time         2017/04/06 23:06:00.933429
-Compile Elapsed Time                 0:00:00.047367
-Execute Start Time       2017/04/06 23:06:06.989107
-Execute End Time         2017/04/06 23:06:07.002116
-Execute Elapsed Time                 0:00:00.013009
+>>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
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -1953,7 +1980,7 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/04/06 23:06:07.000444
+First Row Returned Time  2017/05/07 05:41:26.564755
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
@@ -1965,8 +1992,8 @@ Accessed Rows            4
 Used Rows                4
 SE IOs                   4
 SE IO Bytes              176
-SE IO MAX Time           3,572
-SQL Process Busy Time    6,381
+SE IO MAX Time           12,163
+SQL Process Busy Time    18,938
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
@@ -1976,30 +2003,33 @@ SQL Heap WM              10,341                    KB
 Processes Created        0
 Process Create Time      0
 Request Message Count    28
-Request Message Bytes    39,712
+Request Message Bytes    40,128
 Reply Message Count      15
-Reply Message Bytes      42,416
+Reply Message Bytes      42,696
+BMO Space Buffer Size    256
+BMO Space Buffer Count   0
+BMO Interim Row Count    0
 Scr. Overflow Mode       DISK
 Scr. File Count          0
-Scr. Buffer Blk Size     0
-Scr. Buffer Blks Read    0
-Scr. Buffer Blks Written 0
+Scr. IO Size             0
 Scr. Read Count          0
 Scr. Write Count         0
+Scr. IO Max Time         0
+Sort TopN                -1
 
 --- SQL operation complete.
 >>log;
 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
 
 --- SQL operation complete.
->>display statistics for QID MXID11000009156212358279905535000000000000206U3333300_305_S1 PERTABLE;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_305_S1
-Compile Start Time       2017/04/06 23:06:00.886062
-Compile End Time         2017/04/06 23:06:00.933429
-Compile Elapsed Time                 0:00:00.047367
-Execute Start Time       2017/04/06 23:06:06.989107
-Execute End Time         2017/04/06 23:06:07.002116
-Execute Elapsed Time                 0:00:00.013009
+>>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
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -2017,7 +2047,7 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/04/06 23:06:07.000444
+First Row Returned Time  2017/05/07 05:41:26.564755
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
@@ -2025,7 +2055,7 @@ No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
 Stats Collection Type    OPERATOR_STATS
-SQL Process Busy Time    6,381
+SQL Process Busy Time    18,938
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
@@ -2035,34 +2065,34 @@ SQL Heap WM              10,341                    KB
 Processes Created        0
 Process Create Time      0
 Request Message Count    28
-Request Message Bytes    39,712
+Request Message Bytes    40,128
 Reply Message Count      15
-Reply Message Bytes      42,416
+Reply Message Bytes      42,696
+BMO Space Buffer Size    256
+BMO Space Buffer Count   0
+BMO Interim Row Count    0
 Scr. Overflow Mode       DISK
 Scr. File Count          0
-Scr. Buffer Blk Size     0
-Scr. Buffer Blks Read    0
-Scr. Buffer Blks Written 0
+Scr. IO Size             0
 Scr. Read Count          0
 Scr. Write Count         0
+Scr. IO Max Time         0
 Sort TopN                -1
 
-       ID       DOP         Table Name
-   Records Accessed       Records Used   HBase/Hive   HBase/Hive      HBase/Hive IO      HBase/Hive IO
-   Estimated/Actual   Estimated/Actual          IOs    IO MBytes           Sum Time           Max Time
-        1         2   TRAFODION.SCH.TSTAT
-                  0                100
-                  4                  4            4            0              6,690              3,572
+   Id       DOP          Table Name
+  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs         SE_IO_Bytes       SE_IO_SumTime       SE_IO_MaxTime
+    1         2   TRAFODION.SCH.TSTAT
+              0                   4            100                   4                   4                   0              22,124              12,163
 
 --- SQL operation complete.
->>get statistics for QID MXID11000009156212358279905535000000000000206U3333300_305_S1 PERTABLE;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_305_S1
-Compile Start Time       2017/04/06 23:06:00.886062
-Compile End Time         2017/04/06 23:06:00.933429
-Compile Elapsed Time                 0:00:00.047367
-Execute Start Time       2017/04/06 23:06:06.989107
-Execute End Time         2017/04/06 23:06:07.002116
-Execute Elapsed Time                 0:00:00.013009
+>>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
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -2080,7 +2110,7 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/04/06 23:06:07.000444
+First Row Returned Time  2017/05/07 05:41:26.564755
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
@@ -2088,7 +2118,7 @@ No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
 Stats Collection Type    OPERATOR_STATS
-SQL Process Busy Time    6,381
+SQL Process Busy Time    18,938
 UDR Process Busy Time    0
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
@@ -2098,38 +2128,38 @@ SQL Heap WM              10,341                    KB
 Processes Created        0
 Process Create Time      0
 Request Message Count    28
-Request Message Bytes    39,712
+Request Message Bytes    40,128
 Reply Message Count      15
-Reply Message Bytes      42,416
+Reply Message Bytes      42,696
+BMO Space Buffer Size    256
+BMO Space Buffer Count   0
+BMO Interim Row Count    0
 Scr. Overflow Mode       DISK
 Scr. File Count          0
-Scr. Buffer Blk Size     0
-Scr. Buffer Blks Read    0
-Scr. Buffer Blks Written 0
+Scr. IO Size             0
 Scr. Read Count          0
 Scr. Write Count         0
+Scr. IO Max Time         0
 Sort TopN                -1
 
-       ID       DOP         Table Name
-   Records Accessed       Records Used   HBase/Hive   HBase/Hive      HBase/Hive IO      HBase/Hive IO
-   Estimated/Actual   Estimated/Actual          IOs    IO MBytes           Sum Time           Max Time
-        1         2   TRAFODION.SCH.TSTAT
-                  0                100
-                  4                  4            4            0              6,690              3,572
+   Id       DOP          Table Name
+  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs         SE_IO_Bytes       SE_IO_SumTime       SE_IO_MaxTime
+    1         2   TRAFODION.SCH.TSTAT
+              0                   4            100                   4                   4                   0              22,124              12,163
 
 --- SQL operation complete.
 >>log;
 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
 
 --- SQL operation complete.
->>display statistics for QID MXID11000009156212358279905535000000000000206U3333300_305_S1 PROGRESS;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_305_S1
-Compile Start Time       2017/04/06 23:06:00.886062
-Compile End Time         2017/04/06 23:06:00.933429
-Compile Elapsed Time                 0:00:00.047367
-Execute Start Time       2017/04/06 23:06:06.989107
-Execute End Time         2017/04/06 23:06:07.002116
-Execute Elapsed Time                 0:00:00.013009
+>>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
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -2147,7 +2177,7 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/04/06 23:06:07.000444
+First Row Returned Time  2017/05/07 05:41:26.564755
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
@@ -2155,7 +2185,7 @@ No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
 Stats Collection Type    OPERATOR_STATS
-SQL Process Busy Time    6,381
+SQL Process Busy Time    18,938
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
 SQL Heap Allocated       200                       KB
@@ -2164,33 +2194,31 @@ SQL Heap WM              10,341                    KB
 Processes Created        0
 Process Create Time      0
 Request Message Count    28
-Request Message Bytes    39,712
+Request Message Bytes    40,128
 Reply Message Count      15
-Reply Message Bytes      42,416
-
-       ID       DOP         Table Name
-   Records Accessed       Records Used   HBase/Hive   HBase/Hive      HBase/Hive IO      HBase/Hive IO
-   Estimated/Actual   Estimated/Actual          IOs    IO MBytes           Sum Time           Max Time
-        1         2   TRAFODION.SCH.TSTAT
-                  0                100
-                  4                  4            4            0              6,690              3,572
-
-   Id            TDBName               Mode       DOP     TopN             CPUTime
-             BMOHeapUsed   BMOHeapAllocated          BMOHeapWM       BMOSpaceBufSz      BMOSpaceBufCnt
- ScrFileCnt    ScrIOSize          ScrIORead       ScrIOWritten           ScrIOTime        ScrIOMaxTime
-    6       EX_HASH_GRBY               DISK         2       -1               2,638
-                       0                  0                  0                 256                   0
-    0                 -1                  0                  0                   0                   0
-
---- SQL operation complete.
->>get statistics for QID MXID11000009156212358279905535000000000000206U3333300_305_S1 PROGRESS;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_305_S1
-Compile Start Time       2017/04/06 23:06:00.886062
-Compile End Time         2017/04/06 23:06:00.933429
-Compile Elapsed Time                 0:00:00.047367
-Execute Start Time       2017/04/06 23:06:06.989107
-Execute End Time         2017/04/06 23:06:07.002116
-Execute Elapsed Time                 0:00:00.013009
+Reply Message Bytes      42,696
+
+   Id       DOP          Table Name
+  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs         SE_IO_Bytes       SE_IO_SumTime       SE_IO_MaxTime
+    1         2   TRAFODION.SCH.TSTAT
+              0                   4            100                   4                   4                   0              22,124              12,163
+
+   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
+                        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
+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
 State                    CLOSE
 Rows Affected            0
 SQL Error Code           100
@@ -2208,7 +2236,7 @@ Transaction Id           -1
 Source String            select distinct d from tstat ;
 SQL Source Length        30
 Rows Returned            4
-First Row Returned Time  2017/04/06 23:06:07.000444
+First Row Returned Time  2017/05/07 05:41:26.564755
 Last Error before AQR    0
 Number of AQR retries    0
 Delay before AQR         0
@@ -2216,7 +2244,7 @@ No. of times reclaimed   0
 Cancel Time              -1
 Last Suspend Time        -1
 Stats Collection Type    OPERATOR_STATS
-SQL Process Busy Time    6,381
+SQL Process Busy Time    18,938
 SQL Space Allocated      896                       KB
 SQL Space Used           766                       KB
 SQL Heap Allocated       200                       KB
@@ -2225,37 +2253,35 @@ SQL Heap WM              10,341                    KB
 Processes Created        0
 Process Create Time      0
 Request Message Count    28
-Request Message Bytes    39,712
+Request Message Bytes    40,128
 Reply Message Count      15
-Reply Message Bytes      42,416
+Reply Message Bytes      42,696
 
-       ID       DOP         Table Name
-   Records Accessed       Records Used   HBase/Hive   HBase/Hive      HBase/Hive IO      HBase/Hive IO
-   Estimated/Actual   Estimated/Actual          IOs    IO MBytes           Sum Time           Max Time
-        1         2   TRAFODION.SCH.TSTAT
-                  0                100
-                  4                  4            4            0              6,690              3,572
+   Id       DOP          Table Name
+  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs         SE_IO_Bytes       SE_IO_SumTime       SE_IO_MaxTime
+    1         2   TRAFODION.SCH.TSTAT
+              0                   4            100                   4                   4                   0              22,124              12,163
 
-   Id            TDBName               Mode       DOP     TopN             CPUTime
-             BMOHeapUsed   BMOHeapAllocated          BMOHeapWM       BMOSpaceBufSz      BMOSpaceBufCnt
- ScrFileCnt    ScrIOSize          ScrIORead       ScrIOWritten           ScrIOTime        ScrIOMaxTime
-    6       EX_HASH_GRBY               DISK         2       -1               2,638
-                       0                  0                  0                 256                   0
-    0                 -1                  0                  0                   0                   0
+   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
+                        4               1,024               7,687                 256                   0
+                        0                  -1                   0                   0                   0                   0
 
 --- SQL operation complete.
 >>log;
 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
 
 --- SQL operation complete.
->>display statistics for QID MXID11000009156212358279905535000000000000206U3333300_305_S1 DEFAULT;
-Qid                      MXID11000009156212358279905535000000000000206U3333300_305_S1
-Compile Start Time       2017/04/06 23:06:00.886062
-Compile End Time         2017/04/06 23:06:00.933429
-Compile Elapsed Time                 0:00:00.047367
-Execute Start Time       2017/04/06 23:06:06.989107
-Execute End Time         2017/04/06 23:06:07.002116
-Execute Elapsed Time                 0:00:00.013009
+>>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 DEFAULT;
+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                

<TRUNCATED>


Mime
View raw message