trafodion-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hzel...@apache.org
Subject [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
Date Fri, 22 Jan 2016 01:08:25 GMT
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>


Mime
View raw message