You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by hz...@apache.org on 2016/01/22 02:08:25 UTC
[06/15] incubator-trafodion git commit: Fix issue where optimization
on key column addition should be turned off for MDAM scans,
and update EXPECTEDTESTRTS to showcase the new value expected as byte read
showing a 53% improvement over previous code
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/90795250/core/sql/regress/core/EXPECTEDRTS
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/EXPECTEDRTS b/core/sql/regress/core/EXPECTEDRTS
index 0c1ea27..c0334eb 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 MXID11000023719212302371786368792000000000206U3333300_220_S1
-Compile Start Time 2015/06/29 21:03:20.275901
-Compile End Time 2015/06/29 21:03:20.318928
-Compile Elapsed Time 0:00:00.043027
+Qid MXID11000031097212318976647061576000000000206U3333300_444_S1
+Compile Start Time 2016/01/08 01:31:04.062381
+Compile End Time 2016/01/08 01:31:04.151506
+Compile Elapsed Time 0:00:00.089125
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 MXID11000023719212302371786368792000000000206U3333300_220_S1 ;
-Qid MXID11000023719212302371786368792000000000206U3333300_220_S1
-Compile Start Time 2015/06/29 21:03:20.275901
-Compile End Time 2015/06/29 21:03:20.318928
-Compile Elapsed Time 0:00:00.043027
+>>display statistics for QID MXID11000031097212318976647061576000000000206U3333300_444_S1 ;
+Qid MXID11000031097212318976647061576000000000206U3333300_444_S1
+Compile Start Time 2016/01/08 01:31:04.062381
+Compile End Time 2016/01/08 01:31:04.151506
+Compile Elapsed Time 0:00:00.089125
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 MXID11000023719212302371786368792000000000206U3333300_220_S1 ;
-Qid MXID11000023719212302371786368792000000000206U3333300_220_S1
-Compile Start Time 2015/06/29 21:03:20.275901
-Compile End Time 2015/06/29 21:03:20.318928
-Compile Elapsed Time 0:00:00.043027
+>>get statistics for QID MXID11000031097212318976647061576000000000206U3333300_444_S1 ;
+Qid MXID11000031097212318976647061576000000000206U3333300_444_S1
+Compile Start Time 2016/01/08 01:31:04.062381
+Compile End Time 2016/01/08 01:31:04.151506
+Compile Elapsed Time 0:00:00.089125
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 MXID11000023719212302371786368792000000000206U3333300_220_S1
-Compile Start Time 2015/06/29 21:03:20.275901
-Compile End Time 2015/06/29 21:03:20.318928
-Compile Elapsed Time 0:00:00.043027
+Qid MXID11000031097212318976647061576000000000206U3333300_444_S1
+Compile Start Time 2016/01/08 01:31:04.062381
+Compile End Time 2016/01/08 01:31:04.151506
+Compile Elapsed Time 0:00:00.089125
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 MXID11000023719212302371786368792000000000206U3333300_220_S1
-Compile Start Time 2015/06/29 21:03:20.275901
-Compile End Time 2015/06/29 21:03:20.318928
-Compile Elapsed Time 0:00:00.043027
+Qid MXID11000031097212318976647061576000000000206U3333300_444_S1
+Compile Start Time 2016/01/08 01:31:04.062381
+Compile End Time 2016/01/08 01:31:04.151506
+Compile Elapsed Time 0:00:00.089125
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -250,14 +250,14 @@ D
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000023719212302371786368792000000000206U3333300_220_S1 ;
-Qid MXID11000023719212302371786368792000000000206U3333300_220_S1
-Compile Start Time 2015/06/29 21:03:20.275901
-Compile End Time 2015/06/29 21:03:20.318928
-Compile Elapsed Time 0:00:00.043027
-Execute Start Time 2015/06/29 21:03:29.314777
-Execute End Time 2015/06/29 21:03:31.300478
-Execute Elapsed Time 0:00:01.985701
+>>display statistics for QID MXID11000031097212318976647061576000000000206U3333300_444_S1 ;
+Qid MXID11000031097212318976647061576000000000206U3333300_444_S1
+Compile Start Time 2016/01/08 01:31:04.062381
+Compile End Time 2016/01/08 01:31:04.151506
+Compile Elapsed Time 0:00:00.089125
+Execute Start Time 2016/01/08 01:31:11.223626
+Execute End Time 2016/01/08 01:31:14.341083
+Execute Elapsed Time 0:00:03.117457
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 2015/06/29 21:03:31.298606
+First Row Returned Time 2016/01/08 01:31:14.338521
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -292,13 +292,13 @@ Disk IOs 4
Lock Waits 0
Lock Escalations 0
Message Redrive Attempts 0
-Disk Process Busy Time 131,374
-SQL Process Busy Time 2,248
+Disk Process Busy Time 213,348
+SQL Process Busy Time 5,218,153
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 143 KB
-SQL Heap Used 30 KB
+SQL Heap Used 26 KB
EID Space Allocated 0 KB
EID Space Used 0 KB
EID Heap Allocated 0 KB
@@ -306,11 +306,11 @@ EID Heap Used 0 KB
Opens 0
Open Time 0
Processes Created 2
-Process Create Time 126,890
+Process Create Time 179,531
Request Message Count 26
-Request Message Bytes 42,176
-Reply Message Count 7
-Reply Message Bytes 36,136
+Request Message Bytes 40,144
+Reply Message Count 15
+Reply Message Bytes 38,952
Scr. Overflow Mode MMAP
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -320,14 +320,14 @@ Scr. Read Count 0
Scr. Write Count 0
--- SQL operation complete.
->>get statistics for QID MXID11000023719212302371786368792000000000206U3333300_220_S1 ;
-Qid MXID11000023719212302371786368792000000000206U3333300_220_S1
-Compile Start Time 2015/06/29 21:03:20.275901
-Compile End Time 2015/06/29 21:03:20.318928
-Compile Elapsed Time 0:00:00.043027
-Execute Start Time 2015/06/29 21:03:29.314777
-Execute End Time 2015/06/29 21:03:31.300478
-Execute Elapsed Time 0:00:01.985701
+>>get statistics for QID MXID11000031097212318976647061576000000000206U3333300_444_S1 ;
+Qid MXID11000031097212318976647061576000000000206U3333300_444_S1
+Compile Start Time 2016/01/08 01:31:04.062381
+Compile End Time 2016/01/08 01:31:04.151506
+Compile Elapsed Time 0:00:00.089125
+Execute Start Time 2016/01/08 01:31:11.223626
+Execute End Time 2016/01/08 01:31:14.341083
+Execute Elapsed Time 0:00:03.117457
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -345,7 +345,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2015/06/29 21:03:31.298606
+First Row Returned Time 2016/01/08 01:31:14.338521
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -362,13 +362,13 @@ Disk IOs 4
Lock Waits 0
Lock Escalations 0
Message Redrive Attempts 0
-Disk Process Busy Time 131,374
-SQL Process Busy Time 2,248
+Disk Process Busy Time 213,348
+SQL Process Busy Time 5,218,153
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 143 KB
-SQL Heap Used 30 KB
+SQL Heap Used 26 KB
EID Space Allocated 0 KB
EID Space Used 0 KB
EID Heap Allocated 0 KB
@@ -376,11 +376,11 @@ EID Heap Used 0 KB
Opens 0
Open Time 0
Processes Created 2
-Process Create Time 126,890
+Process Create Time 179,531
Request Message Count 26
-Request Message Bytes 42,176
-Reply Message Count 7
-Reply Message Bytes 36,136
+Request Message Bytes 40,144
+Reply Message Count 15
+Reply Message Bytes 38,952
Scr. Overflow Mode MMAP
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -392,13 +392,13 @@ Scr. Write Count 0
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000023719212302371786368792000000000206U3333300_220_S1
-Compile Start Time 2015/06/29 21:03:20.275901
-Compile End Time 2015/06/29 21:03:20.318928
-Compile Elapsed Time 0:00:00.043027
-Execute Start Time 2015/06/29 21:03:29.314777
-Execute End Time 2015/06/29 21:03:31.300478
-Execute Elapsed Time 0:00:01.985701
+Qid MXID11000031097212318976647061576000000000206U3333300_444_S1
+Compile Start Time 2016/01/08 01:31:04.062381
+Compile End Time 2016/01/08 01:31:04.151506
+Compile Elapsed Time 0:00:00.089125
+Execute Start Time 2016/01/08 01:31:11.223626
+Execute End Time 2016/01/08 01:31:14.341083
+Execute Elapsed Time 0:00:03.117457
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -416,7 +416,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2015/06/29 21:03:31.298606
+First Row Returned Time 2016/01/08 01:31:14.338521
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -433,13 +433,13 @@ Disk IOs 4
Lock Waits 0
Lock Escalations 0
Message Redrive Attempts 0
-Disk Process Busy Time 131,374
-SQL Process Busy Time 2,248
+Disk Process Busy Time 213,348
+SQL Process Busy Time 5,218,153
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 143 KB
-SQL Heap Used 30 KB
+SQL Heap Used 26 KB
EID Space Allocated 0 KB
EID Space Used 0 KB
EID Heap Allocated 0 KB
@@ -447,11 +447,11 @@ EID Heap Used 0 KB
Opens 0
Open Time 0
Processes Created 2
-Process Create Time 126,890
+Process Create Time 179,531
Request Message Count 26
-Request Message Bytes 42,176
-Reply Message Count 7
-Reply Message Bytes 36,136
+Request Message Bytes 40,144
+Reply Message Count 15
+Reply Message Bytes 38,952
Scr. Overflow Mode MMAP
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -462,13 +462,13 @@ Scr. Write Count 0
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000023719212302371786368792000000000206U3333300_220_S1
-Compile Start Time 2015/06/29 21:03:20.275901
-Compile End Time 2015/06/29 21:03:20.318928
-Compile Elapsed Time 0:00:00.043027
-Execute Start Time 2015/06/29 21:03:29.314777
-Execute End Time 2015/06/29 21:03:31.300478
-Execute Elapsed Time 0:00:01.985701
+Qid MXID11000031097212318976647061576000000000206U3333300_444_S1
+Compile Start Time 2016/01/08 01:31:04.062381
+Compile End Time 2016/01/08 01:31:04.151506
+Compile Elapsed Time 0:00:00.089125
+Execute Start Time 2016/01/08 01:31:11.223626
+Execute End Time 2016/01/08 01:31:14.341083
+Execute Elapsed Time 0:00:03.117457
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -486,7 +486,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2015/06/29 21:03:31.298606
+First Row Returned Time 2016/01/08 01:31:14.338521
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -503,13 +503,13 @@ Disk IOs 4
Lock Waits 0
Lock Escalations 0
Message Redrive Attempts 0
-Disk Process Busy Time 131,374
-SQL Process Busy Time 2,248
+Disk Process Busy Time 213,348
+SQL Process Busy Time 5,218,153
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 143 KB
-SQL Heap Used 30 KB
+SQL Heap Used 26 KB
EID Space Allocated 0 KB
EID Space Used 0 KB
EID Heap Allocated 0 KB
@@ -517,11 +517,11 @@ EID Heap Used 0 KB
Opens 0
Open Time 0
Processes Created 2
-Process Create Time 126,890
+Process Create Time 179,531
Request Message Count 26
-Request Message Bytes 42,176
-Reply Message Count 7
-Reply Message Bytes 36,136
+Request Message Bytes 40,144
+Reply Message Count 15
+Reply Message Bytes 38,952
Scr. Overflow Mode MMAP
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -538,25 +538,25 @@ Scr. Write Count 0
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000023719212302371786368792000000000206U3333300_220_S1 ;
+>>display statistics for QID MXID11000031097212318976647061576000000000206U3333300_444_S1 ;
-*** ERROR[8923] The given Query Id MXID11000023719212302371786368792000000000206U3333300_220_S1 is not found.
+*** ERROR[8923] The given Query Id MXID11000031097212318976647061576000000000206U3333300_444_S1 is not found.
--- SQL operation failed with errors.
->>get statistics for QID MXID11000023719212302371786368792000000000206U3333300_220_S1 ;
+>>get statistics for QID MXID11000031097212318976647061576000000000206U3333300_444_S1 ;
-*** ERROR[8923] The given Query Id MXID11000023719212302371786368792000000000206U3333300_220_S1 is not found.
+*** ERROR[8923] The given Query Id MXID11000031097212318976647061576000000000206U3333300_444_S1 is not found.
--- SQL operation failed with errors.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000023719212302371786368792000000000206U3333300_229_S1 ;
-Qid MXID11000023719212302371786368792000000000206U3333300_229_S1
-Compile Start Time 2015/06/29 21:03:34.274759
-Compile End Time 2015/06/29 21:03:34.275766
-Compile Elapsed Time 0:00:00.001007
+>>display statistics for QID MXID11000031097212318976647061576000000000206U3333300_453_S1 ;
+Qid MXID11000031097212318976647061576000000000206U3333300_453_S1
+Compile Start Time 2016/01/08 01:31:21.610286
+Compile End Time 2016/01/08 01:31:21.611885
+Compile Elapsed Time 0:00:00.001599
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -587,11 +587,11 @@ Last Suspend Time -1
Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000023719212302371786368792000000000206U3333300_229_S1 ;
-Qid MXID11000023719212302371786368792000000000206U3333300_229_S1
-Compile Start Time 2015/06/29 21:03:34.274759
-Compile End Time 2015/06/29 21:03:34.275766
-Compile Elapsed Time 0:00:00.001007
+>>get statistics for QID MXID11000031097212318976647061576000000000206U3333300_453_S1 ;
+Qid MXID11000031097212318976647061576000000000206U3333300_453_S1
+Compile Start Time 2016/01/08 01:31:21.610286
+Compile End Time 2016/01/08 01:31:21.611885
+Compile Elapsed Time 0:00:00.001599
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -624,10 +624,10 @@ Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000023719212302371786368792000000000206U3333300_229_S1
-Compile Start Time 2015/06/29 21:03:34.274759
-Compile End Time 2015/06/29 21:03:34.275766
-Compile Elapsed Time 0:00:00.001007
+Qid MXID11000031097212318976647061576000000000206U3333300_453_S1
+Compile Start Time 2016/01/08 01:31:21.610286
+Compile End Time 2016/01/08 01:31:21.611885
+Compile Elapsed Time 0:00:00.001599
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -659,10 +659,10 @@ Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000023719212302371786368792000000000206U3333300_229_S1
-Compile Start Time 2015/06/29 21:03:34.274759
-Compile End Time 2015/06/29 21:03:34.275766
-Compile Elapsed Time 0:00:00.001007
+Qid MXID11000031097212318976647061576000000000206U3333300_453_S1
+Compile Start Time 2016/01/08 01:31:21.610286
+Compile End Time 2016/01/08 01:31:21.611885
+Compile Elapsed Time 0:00:00.001599
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -706,10 +706,10 @@ Stats Collection Type ACCUMULATED_STATS
--- SQL command prepared.
>>log;
>>get statistics for qid current ;
-Qid MXID11000023719212302371786368792000000000206U3333300_234_S1
-Compile Start Time 2015/06/29 21:03:43.120306
-Compile End Time 2015/06/29 21:03:43.162576
-Compile Elapsed Time 0:00:00.042270
+Qid MXID11000031097212318976647061576000000000206U3333300_458_S1
+Compile Start Time 2016/01/08 01:31:29.965462
+Compile End Time 2016/01/08 01:31:30.025241
+Compile Elapsed Time 0:00:00.059779
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -744,11 +744,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000023719212302371786368792000000000206U3333300_234_S1 ;
-Qid MXID11000023719212302371786368792000000000206U3333300_234_S1
-Compile Start Time 2015/06/29 21:03:43.120306
-Compile End Time 2015/06/29 21:03:43.162576
-Compile Elapsed Time 0:00:00.042270
+>>display statistics for QID MXID11000031097212318976647061576000000000206U3333300_458_S1 ;
+Qid MXID11000031097212318976647061576000000000206U3333300_458_S1
+Compile Start Time 2016/01/08 01:31:29.965462
+Compile End Time 2016/01/08 01:31:30.025241
+Compile Elapsed Time 0:00:00.059779
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -779,11 +779,11 @@ Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000023719212302371786368792000000000206U3333300_234_S1 ;
-Qid MXID11000023719212302371786368792000000000206U3333300_234_S1
-Compile Start Time 2015/06/29 21:03:43.120306
-Compile End Time 2015/06/29 21:03:43.162576
-Compile Elapsed Time 0:00:00.042270
+>>get statistics for QID MXID11000031097212318976647061576000000000206U3333300_458_S1 ;
+Qid MXID11000031097212318976647061576000000000206U3333300_458_S1
+Compile Start Time 2016/01/08 01:31:29.965462
+Compile End Time 2016/01/08 01:31:30.025241
+Compile Elapsed Time 0:00:00.059779
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -818,11 +818,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000023719212302371786368792000000000206U3333300_234_S1 ACCUMULATED;
-Qid MXID11000023719212302371786368792000000000206U3333300_234_S1
-Compile Start Time 2015/06/29 21:03:43.120306
-Compile End Time 2015/06/29 21:03:43.162576
-Compile Elapsed Time 0:00:00.042270
+>>display statistics for QID MXID11000031097212318976647061576000000000206U3333300_458_S1 ACCUMULATED;
+Qid MXID11000031097212318976647061576000000000206U3333300_458_S1
+Compile Start Time 2016/01/08 01:31:29.965462
+Compile End Time 2016/01/08 01:31:30.025241
+Compile Elapsed Time 0:00:00.059779
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -853,11 +853,11 @@ Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000023719212302371786368792000000000206U3333300_234_S1 ACCUMULATED;
-Qid MXID11000023719212302371786368792000000000206U3333300_234_S1
-Compile Start Time 2015/06/29 21:03:43.120306
-Compile End Time 2015/06/29 21:03:43.162576
-Compile Elapsed Time 0:00:00.042270
+>>get statistics for QID MXID11000031097212318976647061576000000000206U3333300_458_S1 ACCUMULATED;
+Qid MXID11000031097212318976647061576000000000206U3333300_458_S1
+Compile Start Time 2016/01/08 01:31:29.965462
+Compile End Time 2016/01/08 01:31:30.025241
+Compile Elapsed Time 0:00:00.059779
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -890,10 +890,10 @@ Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000023719212302371786368792000000000206U3333300_234_S1
-Compile Start Time 2015/06/29 21:03:43.120306
-Compile End Time 2015/06/29 21:03:43.162576
-Compile Elapsed Time 0:00:00.042270
+Qid MXID11000031097212318976647061576000000000206U3333300_458_S1
+Compile Start Time 2016/01/08 01:31:29.965462
+Compile End Time 2016/01/08 01:31:30.025241
+Compile Elapsed Time 0:00:00.059779
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -925,10 +925,10 @@ Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000023719212302371786368792000000000206U3333300_234_S1
-Compile Start Time 2015/06/29 21:03:43.120306
-Compile End Time 2015/06/29 21:03:43.162576
-Compile Elapsed Time 0:00:00.042270
+Qid MXID11000031097212318976647061576000000000206U3333300_458_S1
+Compile Start Time 2016/01/08 01:31:29.965462
+Compile End Time 2016/01/08 01:31:30.025241
+Compile Elapsed Time 0:00:00.059779
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -960,10 +960,10 @@ Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>display statistics for qid current accumulated ;
-Qid MXID11000023719212302371786368792000000000206U3333300_234_S1
-Compile Start Time 2015/06/29 21:03:43.120306
-Compile End Time 2015/06/29 21:03:43.162576
-Compile Elapsed Time 0:00:00.042270
+Qid MXID11000031097212318976647061576000000000206U3333300_458_S1
+Compile Start Time 2016/01/08 01:31:29.965462
+Compile End Time 2016/01/08 01:31:30.025241
+Compile Elapsed Time 0:00:00.059779
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -995,10 +995,10 @@ Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>get statistics for qid current accumulated ;
-Qid MXID11000023719212302371786368792000000000206U3333300_234_S1
-Compile Start Time 2015/06/29 21:03:43.120306
-Compile End Time 2015/06/29 21:03:43.162576
-Compile Elapsed Time 0:00:00.042270
+Qid MXID11000031097212318976647061576000000000206U3333300_458_S1
+Compile Start Time 2016/01/08 01:31:29.965462
+Compile End Time 2016/01/08 01:31:30.025241
+Compile Elapsed Time 0:00:00.059779
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1044,14 +1044,14 @@ D
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000023719212302371786368792000000000206U3333300_234_S1 ;
-Qid MXID11000023719212302371786368792000000000206U3333300_234_S1
-Compile Start Time 2015/06/29 21:03:43.120306
-Compile End Time 2015/06/29 21:03:43.162576
-Compile Elapsed Time 0:00:00.042270
-Execute Start Time 2015/06/29 21:03:52.099382
-Execute End Time 2015/06/29 21:03:52.111671
-Execute Elapsed Time 0:00:00.012289
+>>display statistics for QID MXID11000031097212318976647061576000000000206U3333300_458_S1 ;
+Qid MXID11000031097212318976647061576000000000206U3333300_458_S1
+Compile Start Time 2016/01/08 01:31:29.965462
+Compile End Time 2016/01/08 01:31:30.025241
+Compile Elapsed Time 0:00:00.059779
+Execute Start Time 2016/01/08 01:31:44.250011
+Execute End Time 2016/01/08 01:31:44.265892
+Execute Elapsed Time 0:00:00.015881
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1069,7 +1069,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2015/06/29 21:03:52.109209
+First Row Returned Time 2016/01/08 01:31:44.264238
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1077,12 +1077,12 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 2,186
+SQL Process Busy Time 10,270
UDR Process Busy Time 0
-SQL Space Allocated 832 KB
-SQL Space Used 721 KB
-SQL Heap Allocated 111 KB
-SQL Heap Used 19 KB
+SQL Space Allocated 896 KB
+SQL Space Used 766 KB
+SQL Heap Allocated 143 KB
+SQL Heap Used 22 KB
EID Space Allocated 0 KB
EID Space Used 0 KB
EID Heap Allocated 0 KB
@@ -1090,9 +1090,9 @@ EID Heap Used 0 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 42,336
-Reply Message Count 7
-Reply Message Bytes 36,360
+Request Message Bytes 40,304
+Reply Message Count 15
+Reply Message Bytes 39,176
Scr. Overflow Mode UNKNOWN
Scr File Count 0
Scr. Buffer Blk Size 0
@@ -1106,17 +1106,17 @@ Table Name
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 8,560 4,334
+ 4 4 4 0 10,676 5,701
--- SQL operation complete.
->>get statistics for QID MXID11000023719212302371786368792000000000206U3333300_234_S1 ;
-Qid MXID11000023719212302371786368792000000000206U3333300_234_S1
-Compile Start Time 2015/06/29 21:03:43.120306
-Compile End Time 2015/06/29 21:03:43.162576
-Compile Elapsed Time 0:00:00.042270
-Execute Start Time 2015/06/29 21:03:52.099382
-Execute End Time 2015/06/29 21:03:52.111671
-Execute Elapsed Time 0:00:00.012289
+>>get statistics for QID MXID11000031097212318976647061576000000000206U3333300_458_S1 ;
+Qid MXID11000031097212318976647061576000000000206U3333300_458_S1
+Compile Start Time 2016/01/08 01:31:29.965462
+Compile End Time 2016/01/08 01:31:30.025241
+Compile Elapsed Time 0:00:00.059779
+Execute Start Time 2016/01/08 01:31:44.250011
+Execute End Time 2016/01/08 01:31:44.265892
+Execute Elapsed Time 0:00:00.015881
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1134,7 +1134,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2015/06/29 21:03:52.109209
+First Row Returned Time 2016/01/08 01:31:44.264238
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1142,12 +1142,12 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 2,186
+SQL Process Busy Time 10,270
UDR Process Busy Time 0
-SQL Space Allocated 832 KB
-SQL Space Used 721 KB
-SQL Heap Allocated 111 KB
-SQL Heap Used 19 KB
+SQL Space Allocated 896 KB
+SQL Space Used 766 KB
+SQL Heap Allocated 143 KB
+SQL Heap Used 22 KB
EID Space Allocated 0 KB
EID Space Used 0 KB
EID Heap Allocated 0 KB
@@ -1155,9 +1155,9 @@ EID Heap Used 0 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 42,336
-Reply Message Count 7
-Reply Message Bytes 36,360
+Request Message Bytes 40,304
+Reply Message Count 15
+Reply Message Bytes 39,176
Scr. Overflow Mode UNKNOWN
Scr File Count 0
Scr. Buffer Blk Size 0
@@ -1171,21 +1171,21 @@ Table Name
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 8,560 4,334
+ 4 4 4 0 10,676 5,701
--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000023719212302371786368792000000000206U3333300_234_S1 ACCUMULATED;
-Qid MXID11000023719212302371786368792000000000206U3333300_234_S1
-Compile Start Time 2015/06/29 21:03:43.120306
-Compile End Time 2015/06/29 21:03:43.162576
-Compile Elapsed Time 0:00:00.042270
-Execute Start Time 2015/06/29 21:03:52.099382
-Execute End Time 2015/06/29 21:03:52.111671
-Execute Elapsed Time 0:00:00.012289
+>>display statistics for QID MXID11000031097212318976647061576000000000206U3333300_458_S1 ACCUMULATED;
+Qid MXID11000031097212318976647061576000000000206U3333300_458_S1
+Compile Start Time 2016/01/08 01:31:29.965462
+Compile End Time 2016/01/08 01:31:30.025241
+Compile Elapsed Time 0:00:00.059779
+Execute Start Time 2016/01/08 01:31:44.250011
+Execute End Time 2016/01/08 01:31:44.265892
+Execute Elapsed Time 0:00:00.015881
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1203,7 +1203,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2015/06/29 21:03:52.109209
+First Row Returned Time 2016/01/08 01:31:44.264238
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1220,13 +1220,13 @@ Disk IOs 4
Lock Waits 0
Lock Escalations 0
Message Redrive Attempts 0
-Disk Process Busy Time 8,560
-SQL Process Busy Time 2,186
+Disk Process Busy Time 10,676
+SQL Process Busy Time 10,270
UDR Process Busy Time 0
-SQL Space Allocated 832 KB
-SQL Space Used 721 KB
-SQL Heap Allocated 111 KB
-SQL Heap Used 19 KB
+SQL Space Allocated 896 KB
+SQL Space Used 766 KB
+SQL Heap Allocated 143 KB
+SQL Heap Used 22 KB
EID Space Allocated 0 KB
EID Space Used 0 KB
EID Heap Allocated 0 KB
@@ -1236,9 +1236,9 @@ Open Time 0
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 42,336
-Reply Message Count 7
-Reply Message Bytes 36,360
+Request Message Bytes 40,304
+Reply Message Count 15
+Reply Message Bytes 39,176
Scr. Overflow Mode UNKNOWN
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -1248,14 +1248,14 @@ Scr. Read Count 0
Scr. Write Count 0
--- SQL operation complete.
->>get statistics for QID MXID11000023719212302371786368792000000000206U3333300_234_S1 ACCUMULATED;
-Qid MXID11000023719212302371786368792000000000206U3333300_234_S1
-Compile Start Time 2015/06/29 21:03:43.120306
-Compile End Time 2015/06/29 21:03:43.162576
-Compile Elapsed Time 0:00:00.042270
-Execute Start Time 2015/06/29 21:03:52.099382
-Execute End Time 2015/06/29 21:03:52.111671
-Execute Elapsed Time 0:00:00.012289
+>>get statistics for QID MXID11000031097212318976647061576000000000206U3333300_458_S1 ACCUMULATED;
+Qid MXID11000031097212318976647061576000000000206U3333300_458_S1
+Compile Start Time 2016/01/08 01:31:29.965462
+Compile End Time 2016/01/08 01:31:30.025241
+Compile Elapsed Time 0:00:00.059779
+Execute Start Time 2016/01/08 01:31:44.250011
+Execute End Time 2016/01/08 01:31:44.265892
+Execute Elapsed Time 0:00:00.015881
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1273,7 +1273,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2015/06/29 21:03:52.109209
+First Row Returned Time 2016/01/08 01:31:44.264238
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1290,13 +1290,13 @@ Disk IOs 4
Lock Waits 0
Lock Escalations 0
Message Redrive Attempts 0
-Disk Process Busy Time 8,560
-SQL Process Busy Time 2,186
+Disk Process Busy Time 10,676
+SQL Process Busy Time 10,270
UDR Process Busy Time 0
-SQL Space Allocated 832 KB
-SQL Space Used 721 KB
-SQL Heap Allocated 111 KB
-SQL Heap Used 19 KB
+SQL Space Allocated 896 KB
+SQL Space Used 766 KB
+SQL Heap Allocated 143 KB
+SQL Heap Used 22 KB
EID Space Allocated 0 KB
EID Space Used 0 KB
EID Heap Allocated 0 KB
@@ -1306,9 +1306,9 @@ Open Time 0
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 42,336
-Reply Message Count 7
-Reply Message Bytes 36,360
+Request Message Bytes 40,304
+Reply Message Count 15
+Reply Message Bytes 39,176
Scr. Overflow Mode UNKNOWN
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -1320,13 +1320,13 @@ Scr. Write Count 0
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000023719212302371786368792000000000206U3333300_234_S1
-Compile Start Time 2015/06/29 21:03:43.120306
-Compile End Time 2015/06/29 21:03:43.162576
-Compile Elapsed Time 0:00:00.042270
-Execute Start Time 2015/06/29 21:03:52.099382
-Execute End Time 2015/06/29 21:03:52.111671
-Execute Elapsed Time 0:00:00.012289
+Qid MXID11000031097212318976647061576000000000206U3333300_458_S1
+Compile Start Time 2016/01/08 01:31:29.965462
+Compile End Time 2016/01/08 01:31:30.025241
+Compile Elapsed Time 0:00:00.059779
+Execute Start Time 2016/01/08 01:31:44.250011
+Execute End Time 2016/01/08 01:31:44.265892
+Execute Elapsed Time 0:00:00.015881
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1344,7 +1344,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2015/06/29 21:03:52.109209
+First Row Returned Time 2016/01/08 01:31:44.264238
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1352,12 +1352,12 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 2,186
+SQL Process Busy Time 10,270
UDR Process Busy Time 0
-SQL Space Allocated 832 KB
-SQL Space Used 721 KB
-SQL Heap Allocated 111 KB
-SQL Heap Used 19 KB
+SQL Space Allocated 896 KB
+SQL Space Used 766 KB
+SQL Heap Allocated 143 KB
+SQL Heap Used 22 KB
EID Space Allocated 0 KB
EID Space Used 0 KB
EID Heap Allocated 0 KB
@@ -1365,9 +1365,9 @@ EID Heap Used 0 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 42,336
-Reply Message Count 7
-Reply Message Bytes 36,360
+Request Message Bytes 40,304
+Reply Message Count 15
+Reply Message Bytes 39,176
Scr. Overflow Mode UNKNOWN
Scr File Count 0
Scr. Buffer Blk Size 0
@@ -1381,17 +1381,17 @@ Table Name
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 8,560 4,334
+ 4 4 4 0 10,676 5,701
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000023719212302371786368792000000000206U3333300_234_S1
-Compile Start Time 2015/06/29 21:03:43.120306
-Compile End Time 2015/06/29 21:03:43.162576
-Compile Elapsed Time 0:00:00.042270
-Execute Start Time 2015/06/29 21:03:52.099382
-Execute End Time 2015/06/29 21:03:52.111671
-Execute Elapsed Time 0:00:00.012289
+Qid MXID11000031097212318976647061576000000000206U3333300_458_S1
+Compile Start Time 2016/01/08 01:31:29.965462
+Compile End Time 2016/01/08 01:31:30.025241
+Compile Elapsed Time 0:00:00.059779
+Execute Start Time 2016/01/08 01:31:44.250011
+Execute End Time 2016/01/08 01:31:44.265892
+Execute Elapsed Time 0:00:00.015881
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1409,7 +1409,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2015/06/29 21:03:52.109209
+First Row Returned Time 2016/01/08 01:31:44.264238
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1417,12 +1417,12 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 2,186
+SQL Process Busy Time 10,270
UDR Process Busy Time 0
-SQL Space Allocated 832 KB
-SQL Space Used 721 KB
-SQL Heap Allocated 111 KB
-SQL Heap Used 19 KB
+SQL Space Allocated 896 KB
+SQL Space Used 766 KB
+SQL Heap Allocated 143 KB
+SQL Heap Used 22 KB
EID Space Allocated 0 KB
EID Space Used 0 KB
EID Heap Allocated 0 KB
@@ -1430,9 +1430,9 @@ EID Heap Used 0 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 42,336
-Reply Message Count 7
-Reply Message Bytes 36,360
+Request Message Bytes 40,304
+Reply Message Count 15
+Reply Message Bytes 39,176
Scr. Overflow Mode UNKNOWN
Scr File Count 0
Scr. Buffer Blk Size 0
@@ -1446,17 +1446,17 @@ Table Name
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 8,560 4,334
+ 4 4 4 0 10,676 5,701
--- SQL operation complete.
>>display statistics for qid current accumulated;
-Qid MXID11000023719212302371786368792000000000206U3333300_234_S1
-Compile Start Time 2015/06/29 21:03:43.120306
-Compile End Time 2015/06/29 21:03:43.162576
-Compile Elapsed Time 0:00:00.042270
-Execute Start Time 2015/06/29 21:03:52.099382
-Execute End Time 2015/06/29 21:03:52.111671
-Execute Elapsed Time 0:00:00.012289
+Qid MXID11000031097212318976647061576000000000206U3333300_458_S1
+Compile Start Time 2016/01/08 01:31:29.965462
+Compile End Time 2016/01/08 01:31:30.025241
+Compile Elapsed Time 0:00:00.059779
+Execute Start Time 2016/01/08 01:31:44.250011
+Execute End Time 2016/01/08 01:31:44.265892
+Execute Elapsed Time 0:00:00.015881
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1474,7 +1474,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2015/06/29 21:03:52.109209
+First Row Returned Time 2016/01/08 01:31:44.264238
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1491,13 +1491,13 @@ Disk IOs 4
Lock Waits 0
Lock Escalations 0
Message Redrive Attempts 0
-Disk Process Busy Time 8,560
-SQL Process Busy Time 2,186
+Disk Process Busy Time 10,676
+SQL Process Busy Time 10,270
UDR Process Busy Time 0
-SQL Space Allocated 832 KB
-SQL Space Used 721 KB
-SQL Heap Allocated 111 KB
-SQL Heap Used 19 KB
+SQL Space Allocated 896 KB
+SQL Space Used 766 KB
+SQL Heap Allocated 143 KB
+SQL Heap Used 22 KB
EID Space Allocated 0 KB
EID Space Used 0 KB
EID Heap Allocated 0 KB
@@ -1507,9 +1507,9 @@ Open Time 0
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 42,336
-Reply Message Count 7
-Reply Message Bytes 36,360
+Request Message Bytes 40,304
+Reply Message Count 15
+Reply Message Bytes 39,176
Scr. Overflow Mode UNKNOWN
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -1520,13 +1520,13 @@ Scr. Write Count 0
--- SQL operation complete.
>>get statistics for qid current accumulated;
-Qid MXID11000023719212302371786368792000000000206U3333300_234_S1
-Compile Start Time 2015/06/29 21:03:43.120306
-Compile End Time 2015/06/29 21:03:43.162576
-Compile Elapsed Time 0:00:00.042270
-Execute Start Time 2015/06/29 21:03:52.099382
-Execute End Time 2015/06/29 21:03:52.111671
-Execute Elapsed Time 0:00:00.012289
+Qid MXID11000031097212318976647061576000000000206U3333300_458_S1
+Compile Start Time 2016/01/08 01:31:29.965462
+Compile End Time 2016/01/08 01:31:30.025241
+Compile Elapsed Time 0:00:00.059779
+Execute Start Time 2016/01/08 01:31:44.250011
+Execute End Time 2016/01/08 01:31:44.265892
+Execute Elapsed Time 0:00:00.015881
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1544,7 +1544,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2015/06/29 21:03:52.109209
+First Row Returned Time 2016/01/08 01:31:44.264238
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1561,13 +1561,13 @@ Disk IOs 4
Lock Waits 0
Lock Escalations 0
Message Redrive Attempts 0
-Disk Process Busy Time 8,560
-SQL Process Busy Time 2,186
+Disk Process Busy Time 10,676
+SQL Process Busy Time 10,270
UDR Process Busy Time 0
-SQL Space Allocated 832 KB
-SQL Space Used 721 KB
-SQL Heap Allocated 111 KB
-SQL Heap Used 19 KB
+SQL Space Allocated 896 KB
+SQL Space Used 766 KB
+SQL Heap Allocated 143 KB
+SQL Heap Used 22 KB
EID Space Allocated 0 KB
EID Space Used 0 KB
EID Heap Allocated 0 KB
@@ -1577,9 +1577,9 @@ Open Time 0
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 42,336
-Reply Message Count 7
-Reply Message Bytes 36,360
+Request Message Bytes 40,304
+Reply Message Count 15
+Reply Message Bytes 39,176
Scr. Overflow Mode UNKNOWN
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -1591,7 +1591,7 @@ Scr. Write Count 0
--- SQL operation complete.
>>log;
>>obey PQIDOUT;
->>SET SESSION DEFAULT PARENT_QID 'MXID11000023719212302371786368792000000000206U3333300_234_S1';
+>>SET SESSION DEFAULT PARENT_QID 'MXID11000031097212318976647061576000000000206U3333300_458_S1';
--- SQL operation complete.
>>prepare s1 from select distinct d from tstat ;
@@ -1601,11 +1601,11 @@ Scr. Write Count 0
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000023719212302371786368792000000000206U3333300_248_S1 ;
-Qid MXID11000023719212302371786368792000000000206U3333300_248_S1
-Compile Start Time 2015/06/29 21:03:58.083972
-Compile End Time 2015/06/29 21:03:58.085171
-Compile Elapsed Time 0:00:00.001199
+>>display statistics for QID MXID11000031097212318976647061576000000000206U3333300_472_S1 ;
+Qid MXID11000031097212318976647061576000000000206U3333300_472_S1
+Compile Start Time 2016/01/08 01:31:52.476042
+Compile End Time 2016/01/08 01:31:52.478312
+Compile Elapsed Time 0:00:00.002270
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1617,7 +1617,7 @@ Query Type SQL_SELECT_NON_UNIQUE
Sub Query Type SQL_STMT_NA
Estimated Accessed Rows 0
Estimated Used Rows 0
-Parent Qid MXID11000023719212302371786368792000000000206U3333300_234_S1
+Parent Qid MXID11000031097212318976647061576000000000206U3333300_458_S1
Parent Query System SAME
Child Qid NONE
Number of SQL Processes 0
@@ -1636,11 +1636,11 @@ Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000023719212302371786368792000000000206U3333300_248_S1 ;
-Qid MXID11000023719212302371786368792000000000206U3333300_248_S1
-Compile Start Time 2015/06/29 21:03:58.083972
-Compile End Time 2015/06/29 21:03:58.085171
-Compile Elapsed Time 0:00:00.001199
+>>get statistics for QID MXID11000031097212318976647061576000000000206U3333300_472_S1 ;
+Qid MXID11000031097212318976647061576000000000206U3333300_472_S1
+Compile Start Time 2016/01/08 01:31:52.476042
+Compile End Time 2016/01/08 01:31:52.478312
+Compile Elapsed Time 0:00:00.002270
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1652,7 +1652,7 @@ Query Type SQL_SELECT_NON_UNIQUE
Sub Query Type SQL_STMT_NA
Estimated Accessed Rows 0
Estimated Used Rows 0
-Parent Qid MXID11000023719212302371786368792000000000206U3333300_234_S1
+Parent Qid MXID11000031097212318976647061576000000000206U3333300_458_S1
Parent Query System SAME
Child Qid NONE
Number of SQL Processes 0
@@ -1682,11 +1682,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000023719212302371786368792000000000206U3333300_250_S1 ;
-Qid MXID11000023719212302371786368792000000000206U3333300_250_S1
-Compile Start Time 2015/06/29 21:04:01.018963
-Compile End Time 2015/06/29 21:04:01.020001
-Compile Elapsed Time 0:00:00.001038
+>>display statistics for QID MXID11000031097212318976647061576000000000206U3333300_474_S1 ;
+Qid MXID11000031097212318976647061576000000000206U3333300_474_S1
+Compile Start Time 2016/01/08 01:31:56.339516
+Compile End Time 2016/01/08 01:31:56.341298
+Compile Elapsed Time 0:00:00.001782
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1717,11 +1717,11 @@ Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000023719212302371786368792000000000206U3333300_250_S1 ;
-Qid MXID11000023719212302371786368792000000000206U3333300_250_S1
-Compile Start Time 2015/06/29 21:04:01.018963
-Compile End Time 2015/06/29 21:04:01.020001
-Compile Elapsed Time 0:00:00.001038
+>>get statistics for QID MXID11000031097212318976647061576000000000206U3333300_474_S1 ;
+Qid MXID11000031097212318976647061576000000000206U3333300_474_S1
+Compile Start Time 2016/01/08 01:31:56.339516
+Compile End Time 2016/01/08 01:31:56.341298
+Compile Elapsed Time 0:00:00.001782
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1768,11 +1768,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000023719212302371786368792000000000206U3333300_253_S1 ;
-Qid MXID11000023719212302371786368792000000000206U3333300_253_S1
-Compile Start Time 2015/06/29 21:04:06.927371
-Compile End Time 2015/06/29 21:04:06.970327
-Compile Elapsed Time 0:00:00.042956
+>>display statistics for QID MXID11000031097212318976647061576000000000206U3333300_477_S1 ;
+Qid MXID11000031097212318976647061576000000000206U3333300_477_S1
+Compile Start Time 2016/01/08 01:32:06.677868
+Compile End Time 2016/01/08 01:32:06.755083
+Compile Elapsed Time 0:00:00.077215
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1803,11 +1803,11 @@ Last Suspend Time -1
Stats Collection Type OPERATOR_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000023719212302371786368792000000000206U3333300_253_S1 ;
-Qid MXID11000023719212302371786368792000000000206U3333300_253_S1
-Compile Start Time 2015/06/29 21:04:06.927371
-Compile End Time 2015/06/29 21:04:06.970327
-Compile Elapsed Time 0:00:00.042956
+>>get statistics for QID MXID11000031097212318976647061576000000000206U3333300_477_S1 ;
+Qid MXID11000031097212318976647061576000000000206U3333300_477_S1
+Compile Start Time 2016/01/08 01:32:06.677868
+Compile End Time 2016/01/08 01:32:06.755083
+Compile Elapsed Time 0:00:00.077215
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1854,14 +1854,14 @@ D
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000023719212302371786368792000000000206U3333300_253_S1 ;
-Qid MXID11000023719212302371786368792000000000206U3333300_253_S1
-Compile Start Time 2015/06/29 21:04:06.927371
-Compile End Time 2015/06/29 21:04:06.970327
-Compile Elapsed Time 0:00:00.042956
-Execute Start Time 2015/06/29 21:04:12.877393
-Execute End Time 2015/06/29 21:04:12.889066
-Execute Elapsed Time 0:00:00.011673
+>>display statistics for QID MXID11000031097212318976647061576000000000206U3333300_477_S1 ;
+Qid MXID11000031097212318976647061576000000000206U3333300_477_S1
+Compile Start Time 2016/01/08 01:32:06.677868
+Compile End Time 2016/01/08 01:32:06.755083
+Compile Elapsed Time 0:00:00.077215
+Execute Start Time 2016/01/08 01:32:10.706683
+Execute End Time 2016/01/08 01:32:10.727612
+Execute Elapsed Time 0:00:00.020929
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1879,7 +1879,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2015/06/29 21:04:12.887469
+First Row Returned Time 2016/01/08 01:32:10.724514
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1890,27 +1890,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 10 0 4 837
-9 . 10 11 4 0 EX_SPLIT_TOP 1 5 18 2 4
-8 . 9 10 4 0 EX_SEND_TOP 2 10 809 2 4
-7 . 8 9 4 2 EX_SEND_BOTTOM 2 15 13 2 4
-6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 9 2 4 1375
-5 . 6 7 3 2 EX_HASH_GRBY 2 6 853 1 4 0|0|0
-4 . 5 6 2 2 EX_SPLIT_TOP 2 11 19 100 4
-3 . 4 5 2 2 EX_SEND_TOP 4 18 481 100 4
-2 . 3 4 2 3 EX_SEND_BOTTOM 4 22 126 100 4
-1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 16 100 4 142
-. . 1 2 1 3 EX_TRAF_KEY_SELECT 6 12 0 100 4 TRAFODION.SCH.TSTAT|4|252
-
---- SQL operation complete.
->>get statistics for QID MXID11000023719212302371786368792000000000206U3333300_253_S1 ;
-Qid MXID11000023719212302371786368792000000000206U3333300_253_S1
-Compile Start Time 2015/06/29 21:04:06.927371
-Compile End Time 2015/06/29 21:04:06.970327
-Compile Elapsed Time 0:00:00.042956
-Execute Start Time 2015/06/29 21:04:12.877393
-Execute End Time 2015/06/29 21:04:12.889066
-Execute Elapsed Time 0:00:00.011673
+10 . 11 . 5 0 EX_ROOT 1 5 21 0 4 1772
+9 . 10 11 4 0 EX_SPLIT_TOP 1 5 37 2 4
+8 . 9 10 4 0 EX_SEND_TOP 2 10 1,714 2 4
+7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 304 2 4
+6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 54 2 4 5738
+5 . 6 7 3 2 EX_HASH_GRBY 2 6 3,746 1 4 0|0|0
+4 . 5 6 2 2 EX_SPLIT_TOP 2 11 65 100 4
+3 . 4 5 2 2 EX_SEND_TOP 4 18 1,569 100 4
+2 . 3 4 2 3 EX_SEND_BOTTOM 4 24 408 100 4
+1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 64 100 4 7585
+. . 1 2 1 3 EX_TRAF_KEY_SELECT 6 12 21,339 100 4 TRAFODION.SCH.TSTAT|4|120
+
+--- SQL operation complete.
+>>get statistics for QID MXID11000031097212318976647061576000000000206U3333300_477_S1 ;
+Qid MXID11000031097212318976647061576000000000206U3333300_477_S1
+Compile Start Time 2016/01/08 01:32:06.677868
+Compile End Time 2016/01/08 01:32:06.755083
+Compile Elapsed Time 0:00:00.077215
+Execute Start Time 2016/01/08 01:32:10.706683
+Execute End Time 2016/01/08 01:32:10.727612
+Execute Elapsed Time 0:00:00.020929
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1928,7 +1928,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2015/06/29 21:04:12.887469
+First Row Returned Time 2016/01/08 01:32:10.724514
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1939,31 +1939,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 10 0 4 837
-9 . 10 11 4 0 EX_SPLIT_TOP 1 5 18 2 4
-8 . 9 10 4 0 EX_SEND_TOP 2 10 809 2 4
-7 . 8 9 4 2 EX_SEND_BOTTOM 2 15 13 2 4
-6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 9 2 4 1375
-5 . 6 7 3 2 EX_HASH_GRBY 2 6 853 1 4 0|0|0
-4 . 5 6 2 2 EX_SPLIT_TOP 2 11 19 100 4
-3 . 4 5 2 2 EX_SEND_TOP 4 18 481 100 4
-2 . 3 4 2 3 EX_SEND_BOTTOM 4 22 126 100 4
-1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 16 100 4 142
-. . 1 2 1 3 EX_TRAF_KEY_SELECT 6 12 0 100 4 TRAFODION.SCH.TSTAT|4|252
+10 . 11 . 5 0 EX_ROOT 1 5 21 0 4 1772
+9 . 10 11 4 0 EX_SPLIT_TOP 1 5 37 2 4
+8 . 9 10 4 0 EX_SEND_TOP 2 10 1,714 2 4
+7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 304 2 4
+6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 54 2 4 5738
+5 . 6 7 3 2 EX_HASH_GRBY 2 6 3,746 1 4 0|0|0
+4 . 5 6 2 2 EX_SPLIT_TOP 2 11 65 100 4
+3 . 4 5 2 2 EX_SEND_TOP 4 18 1,569 100 4
+2 . 3 4 2 3 EX_SEND_BOTTOM 4 24 408 100 4
+1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 64 100 4 7585
+. . 1 2 1 3 EX_TRAF_KEY_SELECT 6 12 21,339 100 4 TRAFODION.SCH.TSTAT|4|120
--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000023719212302371786368792000000000206U3333300_253_S1 ACCUMULATED;
-Qid MXID11000023719212302371786368792000000000206U3333300_253_S1
-Compile Start Time 2015/06/29 21:04:06.927371
-Compile End Time 2015/06/29 21:04:06.970327
-Compile Elapsed Time 0:00:00.042956
-Execute Start Time 2015/06/29 21:04:12.877393
-Execute End Time 2015/06/29 21:04:12.889066
-Execute Elapsed Time 0:00:00.011673
+>>display statistics for QID MXID11000031097212318976647061576000000000206U3333300_477_S1 ACCUMULATED;
+Qid MXID11000031097212318976647061576000000000206U3333300_477_S1
+Compile Start Time 2016/01/08 01:32:06.677868
+Compile End Time 2016/01/08 01:32:06.755083
+Compile Elapsed Time 0:00:00.077215
+Execute Start Time 2016/01/08 01:32:10.706683
+Execute End Time 2016/01/08 01:32:10.727612
+Execute Elapsed Time 0:00:00.020929
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1981,7 +1981,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2015/06/29 21:04:12.887469
+First Row Returned Time 2016/01/08 01:32:10.724514
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1998,8 +1998,8 @@ Disk IOs 4
Lock Waits 0
Lock Escalations 0
Message Redrive Attempts 0
-Disk Process Busy Time 8,239
-SQL Process Busy Time 2,354
+Disk Process Busy Time 13,460
+SQL Process Busy Time 15,095
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
@@ -2014,9 +2014,9 @@ Open Time 0
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 42,496
-Reply Message Count 7
-Reply Message Bytes 39,544
+Request Message Bytes 40,464
+Reply Message Count 15
+Reply Message Bytes 42,360
Scr. Overflow Mode MMAP
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -2026,14 +2026,14 @@ Scr. Read Count 0
Scr. Write Count 0
--- SQL operation complete.
->>get statistics for QID MXID11000023719212302371786368792000000000206U3333300_253_S1 ACCUMULATED;
-Qid MXID11000023719212302371786368792000000000206U3333300_253_S1
-Compile Start Time 2015/06/29 21:04:06.927371
-Compile End Time 2015/06/29 21:04:06.970327
-Compile Elapsed Time 0:00:00.042956
-Execute Start Time 2015/06/29 21:04:12.877393
-Execute End Time 2015/06/29 21:04:12.889066
-Execute Elapsed Time 0:00:00.011673
+>>get statistics for QID MXID11000031097212318976647061576000000000206U3333300_477_S1 ACCUMULATED;
+Qid MXID11000031097212318976647061576000000000206U3333300_477_S1
+Compile Start Time 2016/01/08 01:32:06.677868
+Compile End Time 2016/01/08 01:32:06.755083
+Compile Elapsed Time 0:00:00.077215
+Execute Start Time 2016/01/08 01:32:10.706683
+Execute End Time 2016/01/08 01:32:10.727612
+Execute Elapsed Time 0:00:00.020929
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2051,7 +2051,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2015/06/29 21:04:12.887469
+First Row Returned Time 2016/01/08 01:32:10.724514
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2068,8 +2068,8 @@ Disk IOs 4
Lock Waits 0
Lock Escalations 0
Message Redrive Attempts 0
-Disk Process Busy Time 8,239
-SQL Process Busy Time 2,354
+Disk Process Busy Time 13,460
+SQL Process Busy Time 15,095
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
@@ -2084,9 +2084,9 @@ Open Time 0
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 42,496
-Reply Message Count 7
-Reply Message Bytes 39,544
+Request Message Bytes 40,464
+Reply Message Count 15
+Reply Message Bytes 42,360
Scr. Overflow Mode MMAP
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -2100,14 +2100,14 @@ Scr. Write Count 0
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000023719212302371786368792000000000206U3333300_253_S1 PERTABLE;
-Qid MXID11000023719212302371786368792000000000206U3333300_253_S1
-Compile Start Time 2015/06/29 21:04:06.927371
-Compile End Time 2015/06/29 21:04:06.970327
-Compile Elapsed Time 0:00:00.042956
-Execute Start Time 2015/06/29 21:04:12.877393
-Execute End Time 2015/06/29 21:04:12.889066
-Execute Elapsed Time 0:00:00.011673
+>>display statistics for QID MXID11000031097212318976647061576000000000206U3333300_477_S1 PERTABLE;
+Qid MXID11000031097212318976647061576000000000206U3333300_477_S1
+Compile Start Time 2016/01/08 01:32:06.677868
+Compile End Time 2016/01/08 01:32:06.755083
+Compile Elapsed Time 0:00:00.077215
+Execute Start Time 2016/01/08 01:32:10.706683
+Execute End Time 2016/01/08 01:32:10.727612
+Execute Elapsed Time 0:00:00.020929
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2125,7 +2125,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2015/06/29 21:04:12.887469
+First Row Returned Time 2016/01/08 01:32:10.724514
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2133,7 +2133,7 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 2,354
+SQL Process Busy Time 15,095
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
@@ -2146,9 +2146,9 @@ EID Heap Used 0 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 42,496
-Reply Message Count 7
-Reply Message Bytes 39,544
+Request Message Bytes 40,464
+Reply Message Count 15
+Reply Message Bytes 42,360
Scr. Overflow Mode MMAP
Scr File Count 0
Scr. Buffer Blk Size 0
@@ -2162,17 +2162,17 @@ Table Name
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 8,239 4,278
+ 4 4 4 0 13,460 7,041
--- SQL operation complete.
->>get statistics for QID MXID11000023719212302371786368792000000000206U3333300_253_S1 PERTABLE;
-Qid MXID11000023719212302371786368792000000000206U3333300_253_S1
-Compile Start Time 2015/06/29 21:04:06.927371
-Compile End Time 2015/06/29 21:04:06.970327
-Compile Elapsed Time 0:00:00.042956
-Execute Start Time 2015/06/29 21:04:12.877393
-Execute End Time 2015/06/29 21:04:12.889066
-Execute Elapsed Time 0:00:00.011673
+>>get statistics for QID MXID11000031097212318976647061576000000000206U3333300_477_S1 PERTABLE;
+Qid MXID11000031097212318976647061576000000000206U3333300_477_S1
+Compile Start Time 2016/01/08 01:32:06.677868
+Compile End Time 2016/01/08 01:32:06.755083
+Compile Elapsed Time 0:00:00.077215
+Execute Start Time 2016/01/08 01:32:10.706683
+Execute End Time 2016/01/08 01:32:10.727612
+Execute Elapsed Time 0:00:00.020929
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2190,7 +2190,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2015/06/29 21:04:12.887469
+First Row Returned Time 2016/01/08 01:32:10.724514
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2198,7 +2198,7 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 2,354
+SQL Process Busy Time 15,095
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
@@ -2211,9 +2211,9 @@ EID Heap Used 0 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 42,496
-Reply Message Count 7
-Reply Message Bytes 39,544
+Request Message Bytes 40,464
+Reply Message Count 15
+Reply Message Bytes 42,360
Scr. Overflow Mode MMAP
Scr File Count 0
Scr. Buffer Blk Size 0
@@ -2227,21 +2227,21 @@ Table Name
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 8,239 4,278
+ 4 4 4 0 13,460 7,041
--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000023719212302371786368792000000000206U3333300_253_S1 PROGRESS;
-Qid MXID11000023719212302371786368792000000000206U3333300_253_S1
-Compile Start Time 2015/06/29 21:04:06.927371
-Compile End Time 2015/06/29 21:04:06.970327
-Compile Elapsed Time 0:00:00.042956
-Execute Start Time 2015/06/29 21:04:12.877393
-Execute End Time 2015/06/29 21:04:12.889066
-Execute Elapsed Time 0:00:00.011673
+>>display statistics for QID MXID11000031097212318976647061576000000000206U3333300_477_S1 PROGRESS;
+Qid MXID11000031097212318976647061576000000000206U3333300_477_S1
+Compile Start Time 2016/01/08 01:32:06.677868
+Compile End Time 2016/01/08 01:32:06.755083
+Compile Elapsed Time 0:00:00.077215
+Execute Start Time 2016/01/08 01:32:10.706683
+Execute End Time 2016/01/08 01:32:10.727612
+Execute Elapsed Time 0:00:00.020929
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2259,7 +2259,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2015/06/29 21:04:12.887469
+First Row Returned Time 2016/01/08 01:32:10.724514
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2267,7 +2267,7 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 2,354
+SQL Process Busy Time 15,095
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 143 KB
@@ -2279,29 +2279,29 @@ EID Heap Used 0 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 42,496
-Reply Message Count 7
-Reply Message Bytes 39,544
+Request Message Bytes 40,464
+Reply Message Count 15
+Reply Message Bytes 42,360
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
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 8,239 4,278
+ 4 4 4 0 13,460 7,041
Id TDB Name Mode CPU Time BMO Heap Used BMO Heap Total BMO Heap WM BMO Space BufSz BMO Space BufCnt File Count Scratch Buffer Block Size/Read/Written Scratch IO Count Read/Written
- 6 EX_HASH_GRBY MMAP 853 4 1,024 7,687 256 0 0 -1 0 0 0 0
+ 6 EX_HASH_GRBY MMAP 3,746 4 1,024 7,687 256 0 0 -1 0 0 0 0
--- SQL operation complete.
->>get statistics for QID MXID11000023719212302371786368792000000000206U3333300_253_S1 PROGRESS;
-Qid MXID11000023719212302371786368792000000000206U3333300_253_S1
-Compile Start Time 2015/06/29 21:04:06.927371
-Compile End Time 2015/06/29 21:04:06.970327
-Compile Elapsed Time 0:00:00.042956
-Execute Start Time 2015/06/29 21:04:12.877393
-Execute End Time 2015/06/29 21:04:12.889066
-Execute Elapsed Time 0:00:00.011673
+>>get statistics for QID MXID11000031097212318976647061576000000000206U3333300_477_S1 PROGRESS;
+Qid MXID11000031097212318976647061576000000000206U3333300_477_S1
+Compile Start Time 2016/01/08 01:32:06.677868
+Compile End Time 2016/01/08 01:32:06.755083
+Compile Elapsed Time 0:00:00.077215
+Execute Start Time 2016/01/08 01:32:10.706683
+Execute End Time 2016/01/08 01:32:10.727612
+Execute Elapsed Time 0:00:00.020929
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2319,7 +2319,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2015/06/29 21:04:12.887469
+First Row Returned Time 2016/01/08 01:32:10.724514
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2327,7 +2327,7 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 2,354
+SQL Process Busy Time 15,095
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 143 KB
@@ -2339,33 +2339,33 @@ EID Heap Used 0 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 42,496
-Reply Message Count 7
-Reply Message Bytes 39,544
+Request Message Bytes 40,464
+Reply Message Count 15
+Reply Message Bytes 42,360
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
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 8,239 4,278
+ 4 4 4 0 13,460 7,041
Id TDB Name Mode CPU Time BMO Heap Used BMO Heap Total BMO Heap WM BMO Space BufSz BMO Space BufCnt File Count Scratch Buffer Block Size/Read/Written Scratch IO Count Read/Written
- 6 EX_HASH_GRBY MMAP 853 4 1,024 7,687 256 0 0 -1 0 0 0 0
+ 6 EX_HASH_GRBY MMAP 3,746 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 MXID11000023719212302371786368792000000000206U3333300_253_S1 DEFAULT;
-Qid MXID11000023719212302371786368792000000000206U3333300_253_S1
-Compile Start Time 2015/06/29 21:04:06.927371
-Compile End Time 2015/06/29 21:04:06.970327
-Compile Elapsed Time 0:00:00.042956
-Execute Start Time 2015/06/29 21:04:12.877393
-Execute End Time 2015/06/29 21:04:12.889066
-Execute Elapsed Time 0:00:00.011673
+>>display statistics for QID MXID11000031097212318976647061576000000000206U3333300_477_S1 DEFAULT;
+Qid MXID11000031097212318976647061576000000000206U3333300_477_S1
+Compile Start Time 2016/01/08 01:32:06.677868
+Compile End Time 2016/01/08 01:32:06.755083
+Compile Elapsed Time 0:00:00.077215
+Execute Start Time 2016/01/08 01:32:10.706683
+Execute End Time 2016/01/08 01:32:10.727612
+Execute Elapsed Time 0:00:00.020929
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2383,7 +2383,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2015/06/29 21:04:12.887469
+First Row Returned Time 2016/01/08 01:32:10.724514
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2394,27 +2394,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 10 0 4 837
-9 . 10 11 4 0 EX_SPLIT_TOP 1 5 18 2 4
-8 . 9 10 4 0 EX_SEND_TOP 2 10 809 2 4
-7 . 8 9 4 2 EX_SEND_BOTTOM 2 15 13 2 4
-6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 9 2 4 1375
-5 . 6 7 3 2 EX_HASH_GRBY 2 6 853 1 4 0|0|0
-4 . 5 6 2 2 EX_SPLIT_TOP 2 11 19 100 4
-3 . 4 5 2 2 EX_SEND_TOP 4 18 481 100 4
-2 . 3 4 2 3 EX_SEND_BOTTOM 4 22 126 100 4
-1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 16 100 4 142
-. . 1 2 1 3 EX_TRAF_KEY_SELECT 6 12 0 100 4 TRAFODION.SCH.TSTAT|4|252
-
---- SQL operation complete.
->>get statistics for QID MXID11000023719212302371786368792000000000206U3333300_253_S1 DEFAULT;
-Qid MXID11000023719212302371786368792000000000206U3333300_253_S1
-Compile Start Time 2015/06/29 21:04:06.927371
-Compile End Time 2015/06/29 21:04:06.970327
-Compile Elapsed Time 0:00:00.042956
-Execute Start Time 2015/06/29 21:04:12.877393
-Execute End Time 2015/06/29 21:04:12.889066
-Execute Elapsed Time 0:00:00.011673
+10 . 11 . 5 0 EX_ROOT 1 5 21 0 4 1772
+9 . 10 11 4 0 EX_SPLIT_TOP 1 5 37 2 4
+8 . 9 10 4 0 EX_SEND_TOP 2 10 1,714 2 4
+7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 304 2 4
+6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 54 2 4 5738
+5 . 6 7 3 2 EX_HASH_GRBY 2 6 3,746 1 4 0|0|0
+4 . 5 6 2 2 EX_SPLIT_TOP 2 11 65 100 4
+3 . 4 5 2 2 EX_SEND_TOP 4 18 1,569 100 4
+2 . 3 4 2 3 EX_SEND_BOTTOM 4 24 408 100 4
+1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 64 100 4 7585
+. . 1 2 1 3 EX_TRAF_KEY_SELECT 6 12 21,339 100 4 TRAFODION.SCH.TSTAT|4|120
+
<TRUNCATED>