You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by sa...@apache.org on 2016/03/30 18:44:37 UTC
[1/4] incubator-trafodion git commit: [TRAFODION-1823] ESP idle
timeout does not kick in, leading to too many ESPs on the system
Repository: incubator-trafodion
Updated Branches:
refs/heads/master f918a261e -> 7b04f91e6
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/87eb0347/core/sql/regress/core/FILTERRTS
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/FILTERRTS b/core/sql/regress/core/FILTERRTS
index 129f204..7589b3d 100755
--- a/core/sql/regress/core/FILTERRTS
+++ b/core/sql/regress/core/FILTERRTS
@@ -78,6 +78,8 @@ s/SSCP Request Message Bytes[ ]*[0-9,]*/SSCP Request Message Bytes @sscpRequestM
s/SSCP Reply Message Count[ ]*[0-9,]*/SSCP Reply Message Count @sscpReplytMessageCount@/
s/SSCP Reply Message Bytes[ ]*[0-9,]*/SSCP Reply Message Bytes @sscpReplyMessageBytes@/
s/No. Query Invalidation Keys[ ]*[0-9]*/No. Query Invalidation Keys/
+s/EXE Memory[ ]*[A-z]*[0-9]*/@exeMemory@/
+s/IPC Memory[ ]*[A-z]*[0-9]*/@exeMemory@/
s/RMS Stats Reset Timestamp[ ]*[0-9]*\/[0-9]*\/[0-9]* [0-9]*:[0-9]*:[0-9]*.[0-9]*/RMS Stats Reset Timestamp @rmsStatsResetTimestamp@/
/8 EX_HASH_GRBY[A-Z ]*/{N
s/8 EX_HASH_GRBY[A-Z ]*\n[0-9, -]*/8 #ex_hash_grby bmoStats/
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/87eb0347/core/sql/regress/core/TESTRTS
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/TESTRTS b/core/sql/regress/core/TESTRTS
index d2ac392..9a97213 100755
--- a/core/sql/regress/core/TESTRTS
+++ b/core/sql/regress/core/TESTRTS
@@ -26,10 +26,18 @@
-- @@@ END COPYRIGHT @@@
--
+obey TESTRTS(clean_up);
+obey TESTRTS(create_insert);
+obey TESTRTS(test_rts);
+obey TESTRTS(esp_idle_timeout);
+obey TESTRTS(clean_up);
+log ;
+exit;
+
?section create_insert
cqd hist_on_demand_stats_size '10000';
-obey TESTRTS(clean_up);
+?section test_rts
sh chmod 777 $scriptsdir/tools/run_rts.ksh ;
log LOGRTS clear ;
@@ -250,9 +258,6 @@ get statistics for pid a;
-- Test to determine if invalid token is taken as stmt name
select * from table (statistics(null, 'AAA='));
-obey TESTRTS(clean_up);
-log;
-exit;
?section compare_current_qid
prepare s1 from select count(*) from
@@ -276,3 +281,14 @@ log LOGRTS;
?section clean_up
drop table tstat;
+?section esp_idle_timeout
+get process statistics for current ;
+set session default esp_idle_timeout '60' ;
+cqd esp_idle_timeout '60' ;
+control query shape esp_exchange(hash_groupby(esp_exchange(scan)));
+select distinct d from tstat ;
+get process statistics for current ;
+sh sleep 70;
+select distinct d from tstat ;
+get process statistics for current ;
+
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/87eb0347/core/sql/sqlcomp/nadefaults.cpp
----------------------------------------------------------------------
diff --git a/core/sql/sqlcomp/nadefaults.cpp b/core/sql/sqlcomp/nadefaults.cpp
index 5d3d08b..45880c0 100644
--- a/core/sql/sqlcomp/nadefaults.cpp
+++ b/core/sql/sqlcomp/nadefaults.cpp
@@ -1293,7 +1293,7 @@ SDDui___(CYCLIC_ESP_PLACEMENT, "1"),
DDSint__(ESP_ASSIGN_DEPTH, "0"),
DDSint__(ESP_FIXUP_PRIORITY_DELTA, "0"),
- DDSint__(ESP_IDLE_TIMEOUT, "0"),
+ DDint__(ESP_IDLE_TIMEOUT, "1800"), // To match with set session defaults value
DDkwd__(ESP_MULTI_FRAGMENTS, "ON"),
DDkwd__(ESP_MULTI_FRAGMENT_QUOTAS, "ON"),
DDui1500_4000(ESP_MULTI_FRAGMENT_QUOTA_VM, "4000"),
[2/4] incubator-trafodion git commit: [TRAFODION-1823] ESP idle
timeout does not kick in, leading to too many ESPs on the system
Posted by sa...@apache.org.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/87eb0347/core/sql/regress/core/EXPECTEDRTS
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/EXPECTEDRTS b/core/sql/regress/core/EXPECTEDRTS
index 73875e8..025145b 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 MXID11000021046212322113714480769000000000206U3333300_445_S1
-Compile Start Time 2016/02/13 08:55:29.335897
-Compile End Time 2016/02/13 08:55:29.396212
-Compile Elapsed Time 0:00:00.060315
+Qid MXID11000023543212326038273788301000000000206U3333300_446_S1
+Compile Start Time 2016/03/29 19:04:46.352730
+Compile End Time 2016/03/29 19:04:46.388296
+Compile Elapsed Time 0:00:00.035566
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 MXID11000021046212322113714480769000000000206U3333300_445_S1 ;
-Qid MXID11000021046212322113714480769000000000206U3333300_445_S1
-Compile Start Time 2016/02/13 08:55:29.335897
-Compile End Time 2016/02/13 08:55:29.396212
-Compile Elapsed Time 0:00:00.060315
+>>display statistics for QID MXID11000023543212326038273788301000000000206U3333300_446_S1 ;
+Qid MXID11000023543212326038273788301000000000206U3333300_446_S1
+Compile Start Time 2016/03/29 19:04:46.352730
+Compile End Time 2016/03/29 19:04:46.388296
+Compile Elapsed Time 0:00:00.035566
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 MXID11000021046212322113714480769000000000206U3333300_445_S1 ;
-Qid MXID11000021046212322113714480769000000000206U3333300_445_S1
-Compile Start Time 2016/02/13 08:55:29.335897
-Compile End Time 2016/02/13 08:55:29.396212
-Compile Elapsed Time 0:00:00.060315
+>>get statistics for QID MXID11000023543212326038273788301000000000206U3333300_446_S1 ;
+Qid MXID11000023543212326038273788301000000000206U3333300_446_S1
+Compile Start Time 2016/03/29 19:04:46.352730
+Compile End Time 2016/03/29 19:04:46.388296
+Compile Elapsed Time 0:00:00.035566
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 MXID11000021046212322113714480769000000000206U3333300_445_S1
-Compile Start Time 2016/02/13 08:55:29.335897
-Compile End Time 2016/02/13 08:55:29.396212
-Compile Elapsed Time 0:00:00.060315
+Qid MXID11000023543212326038273788301000000000206U3333300_446_S1
+Compile Start Time 2016/03/29 19:04:46.352730
+Compile End Time 2016/03/29 19:04:46.388296
+Compile Elapsed Time 0:00:00.035566
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 MXID11000021046212322113714480769000000000206U3333300_445_S1
-Compile Start Time 2016/02/13 08:55:29.335897
-Compile End Time 2016/02/13 08:55:29.396212
-Compile Elapsed Time 0:00:00.060315
+Qid MXID11000023543212326038273788301000000000206U3333300_446_S1
+Compile Start Time 2016/03/29 19:04:46.352730
+Compile End Time 2016/03/29 19:04:46.388296
+Compile Elapsed Time 0:00:00.035566
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 MXID11000021046212322113714480769000000000206U3333300_445_S1 ;
-Qid MXID11000021046212322113714480769000000000206U3333300_445_S1
-Compile Start Time 2016/02/13 08:55:29.335897
-Compile End Time 2016/02/13 08:55:29.396212
-Compile Elapsed Time 0:00:00.060315
-Execute Start Time 2016/02/13 08:55:36.218864
-Execute End Time 2016/02/13 08:55:39.743985
-Execute Elapsed Time 0:00:03.525121
+>>display statistics for QID MXID11000023543212326038273788301000000000206U3333300_446_S1 ;
+Qid MXID11000023543212326038273788301000000000206U3333300_446_S1
+Compile Start Time 2016/03/29 19:04:46.352730
+Compile End Time 2016/03/29 19:04:46.388296
+Compile Elapsed Time 0:00:00.035566
+Execute Start Time 2016/03/29 19:04:50.476910
+Execute End Time 2016/03/29 19:04:54.690590
+Execute Elapsed Time 0:00:04.213680
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 2016/02/13 08:55:39.742164
+First Row Returned Time 2016/03/29 19:04:54.687376
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 207,230
-SQL Process Busy Time 5,479,777
+Disk Process Busy Time 224,136
+SQL Process Busy Time 5,364,928
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 143 KB
-SQL Heap Used 26 KB
+SQL Heap Used 25 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 172,303
+Process Create Time 177,020
Request Message Count 26
-Request Message Bytes 40,144
-Reply Message Count 14
-Reply Message Bytes 32,440
+Request Message Bytes 40,176
+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 MXID11000021046212322113714480769000000000206U3333300_445_S1 ;
-Qid MXID11000021046212322113714480769000000000206U3333300_445_S1
-Compile Start Time 2016/02/13 08:55:29.335897
-Compile End Time 2016/02/13 08:55:29.396212
-Compile Elapsed Time 0:00:00.060315
-Execute Start Time 2016/02/13 08:55:36.218864
-Execute End Time 2016/02/13 08:55:39.743985
-Execute Elapsed Time 0:00:03.525121
+>>get statistics for QID MXID11000023543212326038273788301000000000206U3333300_446_S1 ;
+Qid MXID11000023543212326038273788301000000000206U3333300_446_S1
+Compile Start Time 2016/03/29 19:04:46.352730
+Compile End Time 2016/03/29 19:04:46.388296
+Compile Elapsed Time 0:00:00.035566
+Execute Start Time 2016/03/29 19:04:50.476910
+Execute End Time 2016/03/29 19:04:54.690590
+Execute Elapsed Time 0:00:04.213680
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 2016/02/13 08:55:39.742164
+First Row Returned Time 2016/03/29 19:04:54.687376
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 207,230
-SQL Process Busy Time 5,479,777
+Disk Process Busy Time 224,136
+SQL Process Busy Time 5,364,928
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 143 KB
-SQL Heap Used 26 KB
+SQL Heap Used 25 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 172,303
+Process Create Time 177,020
Request Message Count 26
-Request Message Bytes 40,144
-Reply Message Count 14
-Reply Message Bytes 32,440
+Request Message Bytes 40,176
+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 MXID11000021046212322113714480769000000000206U3333300_445_S1
-Compile Start Time 2016/02/13 08:55:29.335897
-Compile End Time 2016/02/13 08:55:29.396212
-Compile Elapsed Time 0:00:00.060315
-Execute Start Time 2016/02/13 08:55:36.218864
-Execute End Time 2016/02/13 08:55:39.743985
-Execute Elapsed Time 0:00:03.525121
+Qid MXID11000023543212326038273788301000000000206U3333300_446_S1
+Compile Start Time 2016/03/29 19:04:46.352730
+Compile End Time 2016/03/29 19:04:46.388296
+Compile Elapsed Time 0:00:00.035566
+Execute Start Time 2016/03/29 19:04:50.476910
+Execute End Time 2016/03/29 19:04:54.690590
+Execute Elapsed Time 0:00:04.213680
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 2016/02/13 08:55:39.742164
+First Row Returned Time 2016/03/29 19:04:54.687376
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 207,230
-SQL Process Busy Time 5,479,777
+Disk Process Busy Time 224,136
+SQL Process Busy Time 5,364,928
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 143 KB
-SQL Heap Used 26 KB
+SQL Heap Used 25 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 172,303
+Process Create Time 177,020
Request Message Count 26
-Request Message Bytes 40,144
-Reply Message Count 14
-Reply Message Bytes 32,440
+Request Message Bytes 40,176
+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 MXID11000021046212322113714480769000000000206U3333300_445_S1
-Compile Start Time 2016/02/13 08:55:29.335897
-Compile End Time 2016/02/13 08:55:29.396212
-Compile Elapsed Time 0:00:00.060315
-Execute Start Time 2016/02/13 08:55:36.218864
-Execute End Time 2016/02/13 08:55:39.743985
-Execute Elapsed Time 0:00:03.525121
+Qid MXID11000023543212326038273788301000000000206U3333300_446_S1
+Compile Start Time 2016/03/29 19:04:46.352730
+Compile End Time 2016/03/29 19:04:46.388296
+Compile Elapsed Time 0:00:00.035566
+Execute Start Time 2016/03/29 19:04:50.476910
+Execute End Time 2016/03/29 19:04:54.690590
+Execute Elapsed Time 0:00:04.213680
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 2016/02/13 08:55:39.742164
+First Row Returned Time 2016/03/29 19:04:54.687376
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 207,230
-SQL Process Busy Time 5,479,777
+Disk Process Busy Time 224,136
+SQL Process Busy Time 5,364,928
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 143 KB
-SQL Heap Used 26 KB
+SQL Heap Used 25 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 172,303
+Process Create Time 177,020
Request Message Count 26
-Request Message Bytes 40,144
-Reply Message Count 14
-Reply Message Bytes 32,440
+Request Message Bytes 40,176
+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 MXID11000021046212322113714480769000000000206U3333300_445_S1 ;
+>>display statistics for QID MXID11000023543212326038273788301000000000206U3333300_446_S1 ;
-*** ERROR[8923] The given Query Id MXID11000021046212322113714480769000000000206U3333300_445_S1 is not found.
+*** ERROR[8923] The given Query Id MXID11000023543212326038273788301000000000206U3333300_446_S1 is not found.
--- SQL operation failed with errors.
->>get statistics for QID MXID11000021046212322113714480769000000000206U3333300_445_S1 ;
+>>get statistics for QID MXID11000023543212326038273788301000000000206U3333300_446_S1 ;
-*** ERROR[8923] The given Query Id MXID11000021046212322113714480769000000000206U3333300_445_S1 is not found.
+*** ERROR[8923] The given Query Id MXID11000023543212326038273788301000000000206U3333300_446_S1 is not found.
--- SQL operation failed with errors.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000021046212322113714480769000000000206U3333300_454_S1 ;
-Qid MXID11000021046212322113714480769000000000206U3333300_454_S1
-Compile Start Time 2016/02/13 08:55:43.466062
-Compile End Time 2016/02/13 08:55:43.468584
-Compile Elapsed Time 0:00:00.002522
+>>display statistics for QID MXID11000023543212326038273788301000000000206U3333300_455_S1 ;
+Qid MXID11000023543212326038273788301000000000206U3333300_455_S1
+Compile Start Time 2016/03/29 19:05:01.679083
+Compile End Time 2016/03/29 19:05:01.679688
+Compile Elapsed Time 0:00:00.000605
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 MXID11000021046212322113714480769000000000206U3333300_454_S1 ;
-Qid MXID11000021046212322113714480769000000000206U3333300_454_S1
-Compile Start Time 2016/02/13 08:55:43.466062
-Compile End Time 2016/02/13 08:55:43.468584
-Compile Elapsed Time 0:00:00.002522
+>>get statistics for QID MXID11000023543212326038273788301000000000206U3333300_455_S1 ;
+Qid MXID11000023543212326038273788301000000000206U3333300_455_S1
+Compile Start Time 2016/03/29 19:05:01.679083
+Compile End Time 2016/03/29 19:05:01.679688
+Compile Elapsed Time 0:00:00.000605
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 MXID11000021046212322113714480769000000000206U3333300_454_S1
-Compile Start Time 2016/02/13 08:55:43.466062
-Compile End Time 2016/02/13 08:55:43.468584
-Compile Elapsed Time 0:00:00.002522
+Qid MXID11000023543212326038273788301000000000206U3333300_455_S1
+Compile Start Time 2016/03/29 19:05:01.679083
+Compile End Time 2016/03/29 19:05:01.679688
+Compile Elapsed Time 0:00:00.000605
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 MXID11000021046212322113714480769000000000206U3333300_454_S1
-Compile Start Time 2016/02/13 08:55:43.466062
-Compile End Time 2016/02/13 08:55:43.468584
-Compile Elapsed Time 0:00:00.002522
+Qid MXID11000023543212326038273788301000000000206U3333300_455_S1
+Compile Start Time 2016/03/29 19:05:01.679083
+Compile End Time 2016/03/29 19:05:01.679688
+Compile Elapsed Time 0:00:00.000605
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 MXID11000021046212322113714480769000000000206U3333300_459_S1
-Compile Start Time 2016/02/13 08:55:53.799045
-Compile End Time 2016/02/13 08:55:53.855653
-Compile Elapsed Time 0:00:00.056608
+Qid MXID11000023543212326038273788301000000000206U3333300_460_S1
+Compile Start Time 2016/03/29 19:05:09.150838
+Compile End Time 2016/03/29 19:05:09.182550
+Compile Elapsed Time 0:00:00.031712
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 MXID11000021046212322113714480769000000000206U3333300_459_S1 ;
-Qid MXID11000021046212322113714480769000000000206U3333300_459_S1
-Compile Start Time 2016/02/13 08:55:53.799045
-Compile End Time 2016/02/13 08:55:53.855653
-Compile Elapsed Time 0:00:00.056608
+>>display statistics for QID MXID11000023543212326038273788301000000000206U3333300_460_S1 ;
+Qid MXID11000023543212326038273788301000000000206U3333300_460_S1
+Compile Start Time 2016/03/29 19:05:09.150838
+Compile End Time 2016/03/29 19:05:09.182550
+Compile Elapsed Time 0:00:00.031712
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 MXID11000021046212322113714480769000000000206U3333300_459_S1 ;
-Qid MXID11000021046212322113714480769000000000206U3333300_459_S1
-Compile Start Time 2016/02/13 08:55:53.799045
-Compile End Time 2016/02/13 08:55:53.855653
-Compile Elapsed Time 0:00:00.056608
+>>get statistics for QID MXID11000023543212326038273788301000000000206U3333300_460_S1 ;
+Qid MXID11000023543212326038273788301000000000206U3333300_460_S1
+Compile Start Time 2016/03/29 19:05:09.150838
+Compile End Time 2016/03/29 19:05:09.182550
+Compile Elapsed Time 0:00:00.031712
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 MXID11000021046212322113714480769000000000206U3333300_459_S1 ACCUMULATED;
-Qid MXID11000021046212322113714480769000000000206U3333300_459_S1
-Compile Start Time 2016/02/13 08:55:53.799045
-Compile End Time 2016/02/13 08:55:53.855653
-Compile Elapsed Time 0:00:00.056608
+>>display statistics for QID MXID11000023543212326038273788301000000000206U3333300_460_S1 ACCUMULATED;
+Qid MXID11000023543212326038273788301000000000206U3333300_460_S1
+Compile Start Time 2016/03/29 19:05:09.150838
+Compile End Time 2016/03/29 19:05:09.182550
+Compile Elapsed Time 0:00:00.031712
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 MXID11000021046212322113714480769000000000206U3333300_459_S1 ACCUMULATED;
-Qid MXID11000021046212322113714480769000000000206U3333300_459_S1
-Compile Start Time 2016/02/13 08:55:53.799045
-Compile End Time 2016/02/13 08:55:53.855653
-Compile Elapsed Time 0:00:00.056608
+>>get statistics for QID MXID11000023543212326038273788301000000000206U3333300_460_S1 ACCUMULATED;
+Qid MXID11000023543212326038273788301000000000206U3333300_460_S1
+Compile Start Time 2016/03/29 19:05:09.150838
+Compile End Time 2016/03/29 19:05:09.182550
+Compile Elapsed Time 0:00:00.031712
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 MXID11000021046212322113714480769000000000206U3333300_459_S1
-Compile Start Time 2016/02/13 08:55:53.799045
-Compile End Time 2016/02/13 08:55:53.855653
-Compile Elapsed Time 0:00:00.056608
+Qid MXID11000023543212326038273788301000000000206U3333300_460_S1
+Compile Start Time 2016/03/29 19:05:09.150838
+Compile End Time 2016/03/29 19:05:09.182550
+Compile Elapsed Time 0:00:00.031712
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 MXID11000021046212322113714480769000000000206U3333300_459_S1
-Compile Start Time 2016/02/13 08:55:53.799045
-Compile End Time 2016/02/13 08:55:53.855653
-Compile Elapsed Time 0:00:00.056608
+Qid MXID11000023543212326038273788301000000000206U3333300_460_S1
+Compile Start Time 2016/03/29 19:05:09.150838
+Compile End Time 2016/03/29 19:05:09.182550
+Compile Elapsed Time 0:00:00.031712
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 MXID11000021046212322113714480769000000000206U3333300_459_S1
-Compile Start Time 2016/02/13 08:55:53.799045
-Compile End Time 2016/02/13 08:55:53.855653
-Compile Elapsed Time 0:00:00.056608
+Qid MXID11000023543212326038273788301000000000206U3333300_460_S1
+Compile Start Time 2016/03/29 19:05:09.150838
+Compile End Time 2016/03/29 19:05:09.182550
+Compile Elapsed Time 0:00:00.031712
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 MXID11000021046212322113714480769000000000206U3333300_459_S1
-Compile Start Time 2016/02/13 08:55:53.799045
-Compile End Time 2016/02/13 08:55:53.855653
-Compile Elapsed Time 0:00:00.056608
+Qid MXID11000023543212326038273788301000000000206U3333300_460_S1
+Compile Start Time 2016/03/29 19:05:09.150838
+Compile End Time 2016/03/29 19:05:09.182550
+Compile Elapsed Time 0:00:00.031712
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 MXID11000021046212322113714480769000000000206U3333300_459_S1 ;
-Qid MXID11000021046212322113714480769000000000206U3333300_459_S1
-Compile Start Time 2016/02/13 08:55:53.799045
-Compile End Time 2016/02/13 08:55:53.855653
-Compile Elapsed Time 0:00:00.056608
-Execute Start Time 2016/02/13 08:56:04.589547
-Execute End Time 2016/02/13 08:56:04.605014
-Execute Elapsed Time 0:00:00.015467
+>>display statistics for QID MXID11000023543212326038273788301000000000206U3333300_460_S1 ;
+Qid MXID11000023543212326038273788301000000000206U3333300_460_S1
+Compile Start Time 2016/03/29 19:05:09.150838
+Compile End Time 2016/03/29 19:05:09.182550
+Compile Elapsed Time 0:00:00.031712
+Execute Start Time 2016/03/29 19:05:23.337178
+Execute End Time 2016/03/29 19:05:23.348722
+Execute Elapsed Time 0:00:00.011544
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 2016/02/13 08:56:04.602678
+First Row Returned Time 2016/03/29 19:05:23.346805
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 8,412
+SQL Process Busy Time 5,701
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 143 KB
-SQL Heap Used 22 KB
+SQL Heap Used 21 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 40,304
-Reply Message Count 14
-Reply Message Bytes 32,664
+Request Message Bytes 40,336
+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,837 4,918
+ 4 4 4 0 5,605 3,209
--- SQL operation complete.
->>get statistics for QID MXID11000021046212322113714480769000000000206U3333300_459_S1 ;
-Qid MXID11000021046212322113714480769000000000206U3333300_459_S1
-Compile Start Time 2016/02/13 08:55:53.799045
-Compile End Time 2016/02/13 08:55:53.855653
-Compile Elapsed Time 0:00:00.056608
-Execute Start Time 2016/02/13 08:56:04.589547
-Execute End Time 2016/02/13 08:56:04.605014
-Execute Elapsed Time 0:00:00.015467
+>>get statistics for QID MXID11000023543212326038273788301000000000206U3333300_460_S1 ;
+Qid MXID11000023543212326038273788301000000000206U3333300_460_S1
+Compile Start Time 2016/03/29 19:05:09.150838
+Compile End Time 2016/03/29 19:05:09.182550
+Compile Elapsed Time 0:00:00.031712
+Execute Start Time 2016/03/29 19:05:23.337178
+Execute End Time 2016/03/29 19:05:23.348722
+Execute Elapsed Time 0:00:00.011544
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 2016/02/13 08:56:04.602678
+First Row Returned Time 2016/03/29 19:05:23.346805
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 8,412
+SQL Process Busy Time 5,701
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 143 KB
-SQL Heap Used 22 KB
+SQL Heap Used 21 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 40,304
-Reply Message Count 14
-Reply Message Bytes 32,664
+Request Message Bytes 40,336
+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,837 4,918
+ 4 4 4 0 5,605 3,209
--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000021046212322113714480769000000000206U3333300_459_S1 ACCUMULATED;
-Qid MXID11000021046212322113714480769000000000206U3333300_459_S1
-Compile Start Time 2016/02/13 08:55:53.799045
-Compile End Time 2016/02/13 08:55:53.855653
-Compile Elapsed Time 0:00:00.056608
-Execute Start Time 2016/02/13 08:56:04.589547
-Execute End Time 2016/02/13 08:56:04.605014
-Execute Elapsed Time 0:00:00.015467
+>>display statistics for QID MXID11000023543212326038273788301000000000206U3333300_460_S1 ACCUMULATED;
+Qid MXID11000023543212326038273788301000000000206U3333300_460_S1
+Compile Start Time 2016/03/29 19:05:09.150838
+Compile End Time 2016/03/29 19:05:09.182550
+Compile Elapsed Time 0:00:00.031712
+Execute Start Time 2016/03/29 19:05:23.337178
+Execute End Time 2016/03/29 19:05:23.348722
+Execute Elapsed Time 0:00:00.011544
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 2016/02/13 08:56:04.602678
+First Row Returned Time 2016/03/29 19:05:23.346805
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,837
-SQL Process Busy Time 8,412
+Disk Process Busy Time 5,605
+SQL Process Busy Time 5,701
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 143 KB
-SQL Heap Used 22 KB
+SQL Heap Used 21 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 40,304
-Reply Message Count 14
-Reply Message Bytes 32,664
+Request Message Bytes 40,336
+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 MXID11000021046212322113714480769000000000206U3333300_459_S1 ACCUMULATED;
-Qid MXID11000021046212322113714480769000000000206U3333300_459_S1
-Compile Start Time 2016/02/13 08:55:53.799045
-Compile End Time 2016/02/13 08:55:53.855653
-Compile Elapsed Time 0:00:00.056608
-Execute Start Time 2016/02/13 08:56:04.589547
-Execute End Time 2016/02/13 08:56:04.605014
-Execute Elapsed Time 0:00:00.015467
+>>get statistics for QID MXID11000023543212326038273788301000000000206U3333300_460_S1 ACCUMULATED;
+Qid MXID11000023543212326038273788301000000000206U3333300_460_S1
+Compile Start Time 2016/03/29 19:05:09.150838
+Compile End Time 2016/03/29 19:05:09.182550
+Compile Elapsed Time 0:00:00.031712
+Execute Start Time 2016/03/29 19:05:23.337178
+Execute End Time 2016/03/29 19:05:23.348722
+Execute Elapsed Time 0:00:00.011544
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 2016/02/13 08:56:04.602678
+First Row Returned Time 2016/03/29 19:05:23.346805
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,837
-SQL Process Busy Time 8,412
+Disk Process Busy Time 5,605
+SQL Process Busy Time 5,701
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 143 KB
-SQL Heap Used 22 KB
+SQL Heap Used 21 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 40,304
-Reply Message Count 14
-Reply Message Bytes 32,664
+Request Message Bytes 40,336
+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 MXID11000021046212322113714480769000000000206U3333300_459_S1
-Compile Start Time 2016/02/13 08:55:53.799045
-Compile End Time 2016/02/13 08:55:53.855653
-Compile Elapsed Time 0:00:00.056608
-Execute Start Time 2016/02/13 08:56:04.589547
-Execute End Time 2016/02/13 08:56:04.605014
-Execute Elapsed Time 0:00:00.015467
+Qid MXID11000023543212326038273788301000000000206U3333300_460_S1
+Compile Start Time 2016/03/29 19:05:09.150838
+Compile End Time 2016/03/29 19:05:09.182550
+Compile Elapsed Time 0:00:00.031712
+Execute Start Time 2016/03/29 19:05:23.337178
+Execute End Time 2016/03/29 19:05:23.348722
+Execute Elapsed Time 0:00:00.011544
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 2016/02/13 08:56:04.602678
+First Row Returned Time 2016/03/29 19:05:23.346805
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 8,412
+SQL Process Busy Time 5,701
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 143 KB
-SQL Heap Used 22 KB
+SQL Heap Used 21 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 40,304
-Reply Message Count 14
-Reply Message Bytes 32,664
+Request Message Bytes 40,336
+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,837 4,918
+ 4 4 4 0 5,605 3,209
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000021046212322113714480769000000000206U3333300_459_S1
-Compile Start Time 2016/02/13 08:55:53.799045
-Compile End Time 2016/02/13 08:55:53.855653
-Compile Elapsed Time 0:00:00.056608
-Execute Start Time 2016/02/13 08:56:04.589547
-Execute End Time 2016/02/13 08:56:04.605014
-Execute Elapsed Time 0:00:00.015467
+Qid MXID11000023543212326038273788301000000000206U3333300_460_S1
+Compile Start Time 2016/03/29 19:05:09.150838
+Compile End Time 2016/03/29 19:05:09.182550
+Compile Elapsed Time 0:00:00.031712
+Execute Start Time 2016/03/29 19:05:23.337178
+Execute End Time 2016/03/29 19:05:23.348722
+Execute Elapsed Time 0:00:00.011544
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 2016/02/13 08:56:04.602678
+First Row Returned Time 2016/03/29 19:05:23.346805
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 8,412
+SQL Process Busy Time 5,701
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 143 KB
-SQL Heap Used 22 KB
+SQL Heap Used 21 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 40,304
-Reply Message Count 14
-Reply Message Bytes 32,664
+Request Message Bytes 40,336
+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,837 4,918
+ 4 4 4 0 5,605 3,209
--- SQL operation complete.
>>display statistics for qid current accumulated;
-Qid MXID11000021046212322113714480769000000000206U3333300_459_S1
-Compile Start Time 2016/02/13 08:55:53.799045
-Compile End Time 2016/02/13 08:55:53.855653
-Compile Elapsed Time 0:00:00.056608
-Execute Start Time 2016/02/13 08:56:04.589547
-Execute End Time 2016/02/13 08:56:04.605014
-Execute Elapsed Time 0:00:00.015467
+Qid MXID11000023543212326038273788301000000000206U3333300_460_S1
+Compile Start Time 2016/03/29 19:05:09.150838
+Compile End Time 2016/03/29 19:05:09.182550
+Compile Elapsed Time 0:00:00.031712
+Execute Start Time 2016/03/29 19:05:23.337178
+Execute End Time 2016/03/29 19:05:23.348722
+Execute Elapsed Time 0:00:00.011544
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 2016/02/13 08:56:04.602678
+First Row Returned Time 2016/03/29 19:05:23.346805
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,837
-SQL Process Busy Time 8,412
+Disk Process Busy Time 5,605
+SQL Process Busy Time 5,701
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 143 KB
-SQL Heap Used 22 KB
+SQL Heap Used 21 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 40,304
-Reply Message Count 14
-Reply Message Bytes 32,664
+Request Message Bytes 40,336
+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 MXID11000021046212322113714480769000000000206U3333300_459_S1
-Compile Start Time 2016/02/13 08:55:53.799045
-Compile End Time 2016/02/13 08:55:53.855653
-Compile Elapsed Time 0:00:00.056608
-Execute Start Time 2016/02/13 08:56:04.589547
-Execute End Time 2016/02/13 08:56:04.605014
-Execute Elapsed Time 0:00:00.015467
+Qid MXID11000023543212326038273788301000000000206U3333300_460_S1
+Compile Start Time 2016/03/29 19:05:09.150838
+Compile End Time 2016/03/29 19:05:09.182550
+Compile Elapsed Time 0:00:00.031712
+Execute Start Time 2016/03/29 19:05:23.337178
+Execute End Time 2016/03/29 19:05:23.348722
+Execute Elapsed Time 0:00:00.011544
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 2016/02/13 08:56:04.602678
+First Row Returned Time 2016/03/29 19:05:23.346805
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,837
-SQL Process Busy Time 8,412
+Disk Process Busy Time 5,605
+SQL Process Busy Time 5,701
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 143 KB
-SQL Heap Used 22 KB
+SQL Heap Used 21 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 40,304
-Reply Message Count 14
-Reply Message Bytes 32,664
+Request Message Bytes 40,336
+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 'MXID11000021046212322113714480769000000000206U3333300_459_S1';
+>>SET SESSION DEFAULT PARENT_QID 'MXID11000023543212326038273788301000000000206U3333300_460_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 MXID11000021046212322113714480769000000000206U3333300_473_S1 ;
-Qid MXID11000021046212322113714480769000000000206U3333300_473_S1
-Compile Start Time 2016/02/13 08:56:11.748730
-Compile End Time 2016/02/13 08:56:11.750133
-Compile Elapsed Time 0:00:00.001403
+>>display statistics for QID MXID11000023543212326038273788301000000000206U3333300_474_S1 ;
+Qid MXID11000023543212326038273788301000000000206U3333300_474_S1
+Compile Start Time 2016/03/29 19:05:31.159659
+Compile End Time 2016/03/29 19:05:31.160586
+Compile Elapsed Time 0:00:00.000927
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 MXID11000021046212322113714480769000000000206U3333300_459_S1
+Parent Qid MXID11000023543212326038273788301000000000206U3333300_460_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 MXID11000021046212322113714480769000000000206U3333300_473_S1 ;
-Qid MXID11000021046212322113714480769000000000206U3333300_473_S1
-Compile Start Time 2016/02/13 08:56:11.748730
-Compile End Time 2016/02/13 08:56:11.750133
-Compile Elapsed Time 0:00:00.001403
+>>get statistics for QID MXID11000023543212326038273788301000000000206U3333300_474_S1 ;
+Qid MXID11000023543212326038273788301000000000206U3333300_474_S1
+Compile Start Time 2016/03/29 19:05:31.159659
+Compile End Time 2016/03/29 19:05:31.160586
+Compile Elapsed Time 0:00:00.000927
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 MXID11000021046212322113714480769000000000206U3333300_459_S1
+Parent Qid MXID11000023543212326038273788301000000000206U3333300_460_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 MXID11000021046212322113714480769000000000206U3333300_475_S1 ;
-Qid MXID11000021046212322113714480769000000000206U3333300_475_S1
-Compile Start Time 2016/02/13 08:56:18.478607
-Compile End Time 2016/02/13 08:56:18.480250
-Compile Elapsed Time 0:00:00.001643
+>>display statistics for QID MXID11000023543212326038273788301000000000206U3333300_476_S1 ;
+Qid MXID11000023543212326038273788301000000000206U3333300_476_S1
+Compile Start Time 2016/03/29 19:05:38.066099
+Compile End Time 2016/03/29 19:05:38.066679
+Compile Elapsed Time 0:00:00.000580
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 MXID11000021046212322113714480769000000000206U3333300_475_S1 ;
-Qid MXID11000021046212322113714480769000000000206U3333300_475_S1
-Compile Start Time 2016/02/13 08:56:18.478607
-Compile End Time 2016/02/13 08:56:18.480250
-Compile Elapsed Time 0:00:00.001643
+>>get statistics for QID MXID11000023543212326038273788301000000000206U3333300_476_S1 ;
+Qid MXID11000023543212326038273788301000000000206U3333300_476_S1
+Compile Start Time 2016/03/29 19:05:38.066099
+Compile End Time 2016/03/29 19:05:38.066679
+Compile Elapsed Time 0:00:00.000580
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 MXID11000021046212322113714480769000000000206U3333300_478_S1 ;
-Qid MXID11000021046212322113714480769000000000206U3333300_478_S1
-Compile Start Time 2016/02/13 08:56:22.370826
-Compile End Time 2016/02/13 08:56:22.440735
-Compile Elapsed Time 0:00:00.069909
+>>display statistics for QID MXID11000023543212326038273788301000000000206U3333300_479_S1 ;
+Qid MXID11000023543212326038273788301000000000206U3333300_479_S1
+Compile Start Time 2016/03/29 19:06:45.102116
+Compile End Time 2016/03/29 19:06:45.134712
+Compile Elapsed Time 0:00:00.032596
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 MXID11000021046212322113714480769000000000206U3333300_478_S1 ;
-Qid MXID11000021046212322113714480769000000000206U3333300_478_S1
-Compile Start Time 2016/02/13 08:56:22.370826
-Compile End Time 2016/02/13 08:56:22.440735
-Compile Elapsed Time 0:00:00.069909
+>>get statistics for QID MXID11000023543212326038273788301000000000206U3333300_479_S1 ;
+Qid MXID11000023543212326038273788301000000000206U3333300_479_S1
+Compile Start Time 2016/03/29 19:06:45.102116
+Compile End Time 2016/03/29 19:06:45.134712
+Compile Elapsed Time 0:00:00.032596
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 MXID11000021046212322113714480769000000000206U3333300_478_S1 ;
-Qid MXID11000021046212322113714480769000000000206U3333300_478_S1
-Compile Start Time 2016/02/13 08:56:22.370826
-Compile End Time 2016/02/13 08:56:22.440735
-Compile Elapsed Time 0:00:00.069909
-Execute Start Time 2016/02/13 08:56:26.087988
-Execute End Time 2016/02/13 08:56:26.099855
-Execute Elapsed Time 0:00:00.011867
+>>display statistics for QID MXID11000023543212326038273788301000000000206U3333300_479_S1 ;
+Qid MXID11000023543212326038273788301000000000206U3333300_479_S1
+Compile Start Time 2016/03/29 19:06:45.102116
+Compile End Time 2016/03/29 19:06:45.134712
+Compile Elapsed Time 0:00:00.032596
+Execute Start Time 2016/03/29 19:06:50.244737
+Execute End Time 2016/03/29 19:06:50.260504
+Execute Elapsed Time 0:00:00.015767
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 2016/02/13 08:56:26.097742
+First Row Returned Time 2016/03/29 19:06:50.257871
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 14 0 4 1193
-9 . 10 11 4 0 EX_SPLIT_TOP 1 5 21 2 4
-8 . 9 10 4 0 EX_SEND_TOP 2 10 1,158 2 4
-7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 167 2 4
-6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 18 2 4 3185
-5 . 6 7 3 2 EX_HASH_GRBY 2 6 2,097 1 4 0|0|0
-4 . 5 6 2 2 EX_SPLIT_TOP 2 9 32 100 4
-3 . 4 5 2 2 EX_SEND_TOP 4 18 871 100 4
-2 . 3 4 2 3 EX_SEND_BOTTOM 4 30 241 100 4
-1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 29 100 4 1720
-. . 1 2 1 3 EX_TRAF_KEY_SELECT 6 12 4,350 100 4 TRAFODION.SCH.TSTAT|4|120
-
---- SQL operation complete.
->>get statistics for QID MXID11000021046212322113714480769000000000206U3333300_478_S1 ;
-Qid MXID11000021046212322113714480769000000000206U3333300_478_S1
-Compile Start Time 2016/02/13 08:56:22.370826
-Compile End Time 2016/02/13 08:56:22.440735
-Compile Elapsed Time 0:00:00.069909
-Execute Start Time 2016/02/13 08:56:26.087988
-Execute End Time 2016/02/13 08:56:26.099855
-Execute Elapsed Time 0:00:00.011867
+10 . 11 . 5 0 EX_ROOT 1 5 7 0 4 897
+9 . 10 11 4 0 EX_SPLIT_TOP 1 5 7 2 4
+8 . 9 10 4 0 EX_SEND_TOP 2 10 883 2 4
+7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 90 2 4
+6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 7 2 4 2849
+5 . 6 7 3 2 EX_HASH_GRBY 2 6 2,043 1 4 0|0|0
+4 . 5 6 2 2 EX_SPLIT_TOP 2 11 11 100 4
+3 . 4 5 2 2 EX_SEND_TOP 4 18 698 100 4
+2 . 3 4 2 3 EX_SEND_BOTTOM 4 31 125 100 4
+1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 16 100 4 1632
+. . 1 2 1 3 EX_TRAF_KEY_SELECT 6 12 4,473 100 4 TRAFODION.SCH.TSTAT|4|120
+
+--- SQL operation complete.
+>>get statistics for QID MXID11000023543212326038273788301000000000206U3333300_479_S1 ;
+Qid MXID11000023543212326038273788301000000000206U3333300_479_S1
+Compile Start Time 2016/03/29 19:06:45.102116
+Compile End Time 2016/03/29 19:06:45.134712
+Compile Elapsed Time 0:00:00.032596
+Execute Start Time 2016/03/29 19:06:50.244737
+Execute End Time 2016/03/29 19:06:50.260504
+Execute Elapsed Time 0:00:00.015767
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 2016/02/13 08:56:26.097742
+First Row Returned Time 2016/03/29 19:06:50.257871
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 14 0 4 1193
-9 . 10 11 4 0 EX_SPLIT_TOP 1 5 21 2 4
-8 . 9 10 4 0 EX_SEND_TOP 2 10 1,158 2 4
-7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 167 2 4
-6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 18 2 4 3185
-5 . 6 7 3 2 EX_HASH_GRBY 2 6 2,097 1 4 0|0|0
-4 . 5 6 2 2 EX_SPLIT_TOP 2 9 32 100 4
-3 . 4 5 2 2 EX_SEND_TOP 4 18 871 100 4
-2 . 3 4 2 3 EX_SEND_BOTTOM 4 30 241 100 4
-1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 29 100 4 1720
-. . 1 2 1 3 EX_TRAF_KEY_SELECT 6 12 4,350 100 4 TRAFODION.SCH.TSTAT|4|120
+10 . 11 . 5 0 EX_ROOT 1 5 7 0 4 897
+9 . 10 11 4 0 EX_SPLIT_TOP 1 5 7 2 4
+8 . 9 10 4 0 EX_SEND_TOP 2 10 883 2 4
+7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 90 2 4
+6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 7 2 4 2849
+5 . 6 7 3 2 EX_HASH_GRBY 2 6 2,043 1 4 0|0|0
+4 . 5 6 2 2 EX_SPLIT_TOP 2 11 11 100 4
+3 . 4 5 2 2 EX_SEND_TOP 4 18 698 100 4
+2 . 3 4 2 3 EX_SEND_BOTTOM 4 31 125 100 4
+1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 16 100 4 1632
+. . 1 2 1 3 EX_TRAF_KEY_SELECT 6 12 4,473 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 MXID11000021046212322113714480769000000000206U3333300_478_S1 ACCUMULATED;
-Qid MXID11000021046212322113714480769000000000206U3333300_478_S1
-Compile Start Time 2016/02/13 08:56:22.370826
-Compile End Time 2016/02/13 08:56:22.440735
-Compile Elapsed Time 0:00:00.069909
-Execute Start Time 2016/02/13 08:56:26.087988
-Execute End Time 2016/02/13 08:56:26.099855
-Execute Elapsed Time 0:00:00.011867
+>>display statistics for QID MXID11000023543212326038273788301000000000206U3333300_479_S1 ACCUMULATED;
+Qid MXID11000023543212326038273788301000000000206U3333300_479_S1
+Compile Start Time 2016/03/29 19:06:45.102116
+Compile End Time 2016/03/29 19:06:45.134712
+Compile Elapsed Time 0:00:00.032596
+Execute Start Time 2016/03/29 19:06:50.244737
+Execute End Time 2016/03/29 19:06:50.260504
+Execute Elapsed Time 0:00:00.015767
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 2016/02/13 08:56:26.097742
+First Row Returned Time 2016/03/29 19:06:50.257871
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1998,13 +1998,13 @@ Disk IOs 4
Lock Waits 0
Lock Escalations 0
Message Redrive Attempts 0
-Disk Process Busy Time 5,711
-SQL Process Busy Time 6,098
+Disk Process Busy Time 9,490
+SQL Process Busy Time 5,378
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 143 KB
-SQL Heap Used 22 KB
+SQL Heap Used 21 KB
EID Space Allocated 0 KB
EID Space Used 0 KB
EID Heap Allocated 0 KB
@@ -2014,7 +2014,7 @@ Open Time 0
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 40,464
+Request Message Bytes 40,496
Reply Message Count 15
Reply Message Bytes 42,360
Scr. Overflow Mode MMAP
@@ -2026,14 +2026,14 @@ Scr. Read Count 0
Scr. Write Count 0
--- SQL operation complete.
->>get statistics for QID MXID11000021046212322113714480769000000000206U3333300_478_S1 ACCUMULATED;
-Qid MXID11000021046212322113714480769000000000206U3333300_478_S1
-Compile Start Time 2016/02/13 08:56:22.370826
-Compile End Time 2016/02/13 08:56:22.440735
-Compile Elapsed Time 0:00:00.069909
-Execute Start Time 2016/02/13 08:56:26.087988
-Execute End Time 2016/02/13 08:56:26.099855
-Execute Elapsed Time 0:00:00.011867
+>>get statistics for QID MXID11000023543212326038273788301000000000206U3333300_479_S1 ACCUMULATED;
+Qid MXID11000023543212326038273788301000000000206U3333300_479_S1
+Compile Start Time 2016/03/29 19:06:45.102116
+Compile End Time 2016/03/29 19:06:45.134712
+Compile Elapsed Time 0:00:00.032596
+Execute Start Time 2016/03/29 19:06:50.244737
+Execute End Time 2016/03/29 19:06:50.260504
+Execute Elapsed Time 0:00:00.015767
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 2016/02/13 08:56:26.097742
+First Row Returned Time 2016/03/29 19:06:50.257871
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2068,13 +2068,13 @@ Disk IOs 4
Lock Waits 0
Lock Escalations 0
Message Redrive Attempts 0
-Disk Process Busy Time 5,711
-SQL Process Busy Time 6,098
+Disk Process Busy Time 9,490
+SQL Process Busy Time 5,378
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 143 KB
-SQL Heap Used 22 KB
+SQL Heap Used 21 KB
EID Space Allocated 0 KB
EID Space Used 0 KB
EID Heap Allocated 0 KB
@@ -2084,7 +2084,7 @@ Open Time 0
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 40,464
+Request Message Bytes 40,496
Reply Message Count 15
Reply Message Bytes 42,360
Scr. Overflow Mode MMAP
@@ -2100,14 +2100,14 @@ Scr. Write Count 0
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000021046212322113714480769000000000206U3333300_478_S1 PERTABLE;
-Qid MXID11000021046212322113714480769000000000206U3333300_478_S1
-Compile Start Time 2016/02/13 08:56:22.370826
-Compile End Time 2016/02/13 08:56:22.440735
-Compile Elapsed Time 0:00:00.069909
-Execute Start Time 2016/02/13 08:56:26.087988
-Execute End Time 2016/02/13 08:56:26.099855
-Execute Elapsed Time 0:00:00.011867
+>>display statistics for QID MXID11000023543212326038273788301000000000206U3333300_479_S1 PERTABLE;
+Qid MXID11000023543212326038273788301000000000206U3333300_479_S1
+Compile Start Time 2016/03/29 19:06:45.102116
+Compile End Time 2016/03/29 19:06:45.134712
+Compile Elapsed Time 0:00:00.032596
+Execute Start Time 2016/03/29 19:06:50.244737
+Execute End Time 2016/03/29 19:06:50.260504
+Execute Elapsed Time 0:00:00.015767
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 2016/02/13 08:56:26.097742
+First Row Returned Time 2016/03/29 19:06:50.257871
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2133,12 +2133,12 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 6,098
+SQL Process Busy Time 5,378
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 143 KB
-SQL Heap Used 22 KB
+SQL Heap Used 21 KB
EID Space Allocated 0 KB
EID Space Used 0 KB
EID Heap Allocated 0 KB
@@ -2146,7 +2146,7 @@ EID Heap Used 0 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 40,464
+Request Message Bytes 40,496
Reply Message Count 15
Reply Message Bytes 42,360
Scr. Overflow Mode MMAP
@@ -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 5,711 3,029
+ 4 4 4 0 9,490 5,576
--- SQL operation complete.
->>get statistics for QID MXID11000021046212322113714480769000000000206U3333300_478_S1 PERTABLE;
-Qid MXID11000021046212322113714480769000000000206U3333300_478_S1
-Compile Start Time 2016/02/13 08:56:22.370826
-Compile End Time 2016/02/13 08:56:22.440735
-Compile Elapsed Time 0:00:00.069909
-Execute Start Time 2016/02/13 08:56:26.087988
-Execute End Time 2016/02/13 08:56:26.099855
-Execute Elapsed Time 0:00:00.011867
+>>get statistics for QID MXID11000023543212326038273788301000000000206U3333300_479_S1 PERTABLE;
+Qid MXID11000023543212326038273788301000000000206U3333300_479_S1
+Compile Start Time 2016/03/29 19:06:45.102116
+Compile End Time 2016/03/29 19:06:45.134712
+Compile Elapsed Time 0:00:00.032596
+Execute Start Time 2016/03/29 19:06:50.244737
+Execute End Time 2016/03/29 19:06:50.260504
+Execute Elapsed Time 0:00:00.015767
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 2016/02/13 08:56:26.097742
+First Row Returned Time 2016/03/29 19:06:50.257871
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2198,12 +2198,12 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 6,098
+SQL Process Busy Time 5,378
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 143 KB
-SQL Heap Used 22 KB
+SQL Heap Used 21 KB
EID Space Allocated 0 KB
EID Space Used 0 KB
EID Heap Allocated 0 KB
@@ -2211,7 +2211,7 @@ EID Heap Used 0 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 40,464
+Request Message Bytes 40,496
Reply Message Count 15
Reply Message Bytes 42,360
Scr. Overflow Mode MMAP
@@ -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 5,711 3,029
+ 4 4 4 0 9,490 5,576
--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000021046212322113714480769000000000206U3333300_478_S1 PROGRESS;
-Qid MXID11000021046212322113714480769000000000206U3333300_478_S1
-Compile Start Time 2016/02/13 08:56:22.370826
-Compile End Time 2016/02/13 08:56:22.440735
-Compile Elapsed Time 0:00:00.069909
-Execute Start Time 2016/02/13 08:56:26.087988
-Execute End Time 2016/02/13 08:56:26.099855
-Execute Elapsed Time 0:00:00.011867
+>>display statistics for QID MXID11000023543212326038273788301000000000206U3333300_479_S1 PROGRESS;
+Qid MXID11000023543212326038273788301000000000206U3333300_479_S1
+Compile Start Time 2016/03/29 19:06:45.102116
+Compile End Time 2016/03/29 19:06:45.134712
+Compile Elapsed Time 0:00:00.032596
+Execute Start Time 2016/03/29 19:06:50.244737
+Execute End Time 2016/03/29 19:06:50.260504
+Execute Elapsed Time 0:00:00.015767
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 2016/02/13 08:56:26.097742
+First Row Returned Time 2016/03/29 19:06:50.257871
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2267,11 +2267,11 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 6,098
+SQL Process Busy Time 5,378
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 143 KB
-SQL Heap Used 22 KB
+SQL Heap Used 21 KB
EID Space Allocated 0 KB
EID Space Used 0 KB
EID Heap Allocated 0 KB
@@ -2279,7 +2279,7 @@ EID Heap Used 0 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 40,464
+Request Message Bytes 40,496
Reply Message Count 15
Reply Message Bytes 42,360
@@ -2288,20 +2288,20 @@ Table Name
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 5,711 3,029
+ 4 4 4 0 9,490 5,576
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 2,097 4 1,024 7,687 256 0 0 -1 0 0 0 0
+ 6 EX_HASH_GRBY MMAP 2,043 4 1,024 7,687 256 0 0 -1 0 0 0 0
--- SQL operation complete.
->>get statistics for QID MXID11000021046212322113714480769000000000206U3333300_478_S1 PROGRESS;
-Qid MXID11000021046212322113714480769000000000206U3333300_478_S1
-Compile Start Time 2016/02/13 08:56:22.370826
-Compile End Time 2016/02/13 08:56:22.440735
-Compile Elapsed Time 0:00:00.069909
-Execute Start Time 2016/02/13 08:56:26.087988
-Execute End Time 2016/02/13 08:56:26.099855
-Execute Elapsed Time 0:00:00.011867
+>>get statistics for QID MXID11000023543212326038273788301000000000206U3333300_479_S1 PROGRESS;
+Qid MXID11000023543212326038273788301000000000206U3333300_479_S1
+Compile Start Time 2016/03/29 19:06:45.102116
+Compile End Time 2016/03/29 19:06:45.134712
+Compile Elapsed Time 0:00:00.032596
+Execute Start Time 2016/03/29 19:06:50.244737
+Execute End Time 2016/03/29 19:06:50.260504
+Execute Elapsed Time 0:00:00.015767
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 2016/02/13 08:56:26.097742
+First Row Returned Time 2016/03/29 19:06:50.257871
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2327,11 +2327,11 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 6,098
+SQL Process Busy Time 5,378
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 143 KB
-SQL Heap Used 22 KB
+SQL Heap Used 21 KB
EID Space Allocated 0 KB
EID Space Used 0 KB
EID Heap Allocated 0 KB
@@ -2339,7 +2339,7 @@ EID Heap Used 0 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 40,464
+Request Message Bytes 40,496
Reply Message Count 15
Reply Message Bytes 42,360
@@ -2348,24 +2348,24 @@ Table Name
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 5,711 3,029
+ 4 4 4 0 9,490 5,576
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 2,097 4 1,024 7,687 256 0 0 -1 0 0 0 0
+ 6 EX_HASH_GRBY MMAP 2,043 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 MXID11000021046212322113714480769000000000206U3333300_478_S1 DEFAULT;
-Qid MXID11000021046212322113714480769000000000206U3333300_478_S1
-Compile Start Time 2016/02/13 08:56:22.370826
-Compile End Time 2016/02/13 08:56:22.440735
-Compile Elapsed Time 0:00:00.069909
-Execute Start Time 2016/02/13 08:56:26.087988
-Execute End Time 2016/02/13 08:56:26.099855
-Execute Elapsed Time 0:00:00.011867
+>>display statistics for QID MXID11000023543212326038273788301000000000206U3333300_479_S1 DEFAULT;
+Qid MXID11000023543212326038273788301000000000206U3333300_479_S1
+Compile Start Time 2016/03/29 19:06:45.102116
+Compile End Time 2016/03/29 19:06:45.134712
+Compile Elapsed Time 0:00:00.032596
+Execute Start Time 2016/03/29 19:06:50.244737
+Execute End Time 2016/03/29 19:06:50.260504
+Execute Elapsed Time 0:00:00.015767
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 2016/02/13 08:56:26.097742
+First Row Returned Time 2016/03/29 19:06:50.257871
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 14 0 4 1193
-9 . 10 11 4 0 EX_SPLIT_TOP 1 5 21 2 4
-8 . 9 10 4 0 EX_SEND_TOP 2 10 1,158 2 4
-7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 167 2 4
-6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 18 2 4 3185
-5 . 6 7 3 2 EX_HASH_GRBY 2 6 2,097 1 4 0|0|0
-4 . 5 6 2 2 EX_SPLIT_TOP 2 9 32 100 4
-3 . 4 5 2 2 EX_SEND_TOP 4 18 871 100 4
-2 . 3 4 2 3 EX_SEND_BOTTOM 4 30 241 100 4
-1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 29 100 4 1720
-. . 1 2 1 3 EX_TRAF_KEY_SELECT 6 12 4,350 100 4 TRAFODION.SCH.TSTAT|4|120
-
---- SQL operation complete.
->>get statistics for QID MXID11000021046212322113714480769000000000206U3333300_478_S1 DEFAULT;
-Qid MXID11000021046212322113714480769000000000206U3333300_478_S1
-Compile Start Time 2016/02/13 08:56:22.370826
-Compile End Time 2016/02/13 08:56:22.440735
-Compile Elapsed Time 0:00:00.069909
-Execute Start Time 2016/02/13 08:56:26.087988
-Execute End Time 2016/02/13 08:56:26.099855
-Execute Elapsed Time 0:00:00.011867
+10 . 11 . 5 0 EX_ROOT 1 5 7 0 4 897
+9 . 10 11 4 0 EX_SPLIT_TOP 1 5 7 2 4
+8 . 9 10 4 0 EX_SEND_TOP 2 10 883 2 4
+7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 90 2 4
+6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 7 2 4 2849
+5 . 6 7 3 2 EX_HASH_GRBY 2 6 2,043 1 4 0|0|0
+4 . 5 6 2 2 EX_SPLIT_TOP 2 11 11 100 4
+3 . 4 5 2 2 EX_SEND_TOP 4 18 698 100 4
+2 . 3 4 2 3 EX_SEND_BOTTOM 4 31 125 100 4
+1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 16 100 4 1632
+. . 1 2 1 3 EX_TRAF_KEY_SELECT 6 12 4,473 100 4 TRAFODION.SCH.TSTAT|4|120
+
+--- SQL operation complete.
+>>get statistics for QID MXID11000023543212326038273788301000000000206U3333300_479_S1 DEFAULT;
+Qid MXID1100002354321232603827378830
<TRUNCATED>
[4/4] incubator-trafodion git commit: Merge remote branch
'origin/pr/406/head' into merge_406
Posted by sa...@apache.org.
Merge remote branch 'origin/pr/406/head' into merge_406
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/7b04f91e
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/7b04f91e
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/7b04f91e
Branch: refs/heads/master
Commit: 7b04f91e6b4ddb92ac4feeaf44a3ac08b1b90f8c
Parents: f918a26 87eb034
Author: Sandhya Sundaresan <sa...@apache.org>
Authored: Wed Mar 30 16:43:47 2016 +0000
Committer: Sandhya Sundaresan <sa...@apache.org>
Committed: Wed Mar 30 16:43:47 2016 +0000
----------------------------------------------------------------------
core/sqf/src/seabed/src/fs.cpp | 3 +-
core/sql/executor/ex_control.cpp | 6 +
core/sql/regress/core/EXPECTEDRTS | 1436 +++++++++++++++++---------------
core/sql/regress/core/FILTERRTS | 2 +
core/sql/regress/core/TESTRTS | 24 +-
core/sql/sqlcomp/nadefaults.cpp | 2 +-
6 files changed, 804 insertions(+), 669 deletions(-)
----------------------------------------------------------------------
[3/4] incubator-trafodion git commit: [TRAFODION-1823] ESP idle
timeout does not kick in, leading to too many ESPs on the system
Posted by sa...@apache.org.
[TRAFODION-1823] ESP idle timeout does not kick in, leading to too many ESPs on the system
Close message from the master was not sent to ESP by the platform
agnostic messaging layer in Trafodion. Fixed this bug and then ESP idle time
works as expected.
ESP_IDLE_TIMEOUT can now be given as a CQD. Internally, it would be
changed to SET SESSION DEFAULT and used by the IPC layer of Trafodion.
ESP_IDLE_TIMEOUT is set to 30 minutes by default in the CQD too.
Added test in core/TESTRTS to test ESP_IDLE_TIMEOUT
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/87eb0347
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/87eb0347
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/87eb0347
Branch: refs/heads/master
Commit: 87eb03471199117c6f6585b255d430ef1325dcc7
Parents: 4dda119
Author: selvaganesang <se...@esgyn.com>
Authored: Tue Mar 29 21:37:05 2016 +0000
Committer: selvaganesang <se...@esgyn.com>
Committed: Tue Mar 29 21:37:05 2016 +0000
----------------------------------------------------------------------
core/sqf/src/seabed/src/fs.cpp | 3 +-
core/sql/executor/ex_control.cpp | 6 +
core/sql/regress/core/EXPECTEDRTS | 1436 +++++++++++++++++---------------
core/sql/regress/core/FILTERRTS | 2 +
core/sql/regress/core/TESTRTS | 24 +-
core/sql/sqlcomp/nadefaults.cpp | 2 +-
6 files changed, 804 insertions(+), 669 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/87eb0347/core/sqf/src/seabed/src/fs.cpp
----------------------------------------------------------------------
diff --git a/core/sqf/src/seabed/src/fs.cpp b/core/sqf/src/seabed/src/fs.cpp
index 50ee423..88e1290 100644
--- a/core/sqf/src/seabed/src/fs.cpp
+++ b/core/sqf/src/seabed/src/fs.cpp
@@ -737,6 +737,7 @@ SB_Export short BFILE_CLOSE_(short pv_filenum, short pv_tapedisposition) {
FS_Fd_Type *lp_fd;
short lv_fserr;
int lv_status;
+ int lv_refcount;
SB_API_CTR (lv_zctr, BFILE_CLOSE_);
SB_UTRACE_API_ADD2(SB_UTRACE_API_OP_FS_CLOSE, pv_filenum);
@@ -756,7 +757,7 @@ SB_Export short BFILE_CLOSE_(short pv_filenum, short pv_tapedisposition) {
if (pv_filenum == gv_fs_receive_fn)
gv_fs_receive_fn = -1;
else {
- if (msg_mon_get_ref_count(&lp_fd->iv_phandle) > 1) {
+ if ((lv_refcount = msg_mon_get_ref_count(&lp_fd->iv_phandle)) > 1 || (lv_refcount == 0)) {
// send close message to remote
fs_int_fs_file_close(lp_fd);
}
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/87eb0347/core/sql/executor/ex_control.cpp
----------------------------------------------------------------------
diff --git a/core/sql/executor/ex_control.cpp b/core/sql/executor/ex_control.cpp
index d8e62b0..8d99ea5 100644
--- a/core/sql/executor/ex_control.cpp
+++ b/core/sql/executor/ex_control.cpp
@@ -433,6 +433,12 @@ short ExControlTcb::work()
currContext->getSessionDefaults()->setCallEmbeddedArkcmp(FALSE);
}
}
+ else if (strcmp(value[1], "ESP_IDLE_TIMEOUT") == 0)
+ {
+ int lvl = (int) strtoul(value[2], NULL, 10);
+ currContext->getSessionDefaults()->
+ setEspIdleTimeout(lvl);
+ }
}
}
}