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>
