You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by an...@apache.org on 2017/11/30 22:54:07 UTC
[3/6] incubator-trafodion git commit: JIRA TRAFODION-2731
CodeCleanup: Phase 6. Cleanup of obsolete/unused cqds.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/665def4f/core/sql/regress/core/EXPECTEDRTS
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/EXPECTEDRTS b/core/sql/regress/core/EXPECTEDRTS
index f9adf52..95af9ad 100644
--- 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 MXID11000031882212373144360231001000000000206U3333300_303_S1
-Compile Start Time 2017/09/26 00:06:16.558838
-Compile End Time 2017/09/26 00:06:16.588403
-Compile Elapsed Time 0:00:00.029565
+Qid MXID11000011701212378219753251307000000000206U3333300_303_S1
+Compile Start Time 2017/11/23 17:56:10.510027
+Compile End Time 2017/11/23 17:56:10.581329
+Compile Elapsed Time 0:00:00.071302
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -98,11 +98,11 @@ Stats Collection Type ACCUMULATED_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000031882212373144360231001000000000206U3333300_303_S1 ;
-Qid MXID11000031882212373144360231001000000000206U3333300_303_S1
-Compile Start Time 2017/09/26 00:06:16.558838
-Compile End Time 2017/09/26 00:06:16.588403
-Compile Elapsed Time 0:00:00.029565
+>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_303_S1 ;
+Qid MXID11000011701212378219753251307000000000206U3333300_303_S1
+Compile Start Time 2017/11/23 17:56:10.510027
+Compile End Time 2017/11/23 17:56:10.581329
+Compile Elapsed Time 0:00:00.071302
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -137,11 +137,11 @@ Avg. Execute Time 0.000000 secs
Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000031882212373144360231001000000000206U3333300_303_S1 ;
-Qid MXID11000031882212373144360231001000000000206U3333300_303_S1
-Compile Start Time 2017/09/26 00:06:16.558838
-Compile End Time 2017/09/26 00:06:16.588403
-Compile Elapsed Time 0:00:00.029565
+>>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_303_S1 ;
+Qid MXID11000011701212378219753251307000000000206U3333300_303_S1
+Compile Start Time 2017/11/23 17:56:10.510027
+Compile End Time 2017/11/23 17:56:10.581329
+Compile Elapsed Time 0:00:00.071302
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -178,10 +178,10 @@ Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000031882212373144360231001000000000206U3333300_303_S1
-Compile Start Time 2017/09/26 00:06:16.558838
-Compile End Time 2017/09/26 00:06:16.588403
-Compile Elapsed Time 0:00:00.029565
+Qid MXID11000011701212378219753251307000000000206U3333300_303_S1
+Compile Start Time 2017/11/23 17:56:10.510027
+Compile End Time 2017/11/23 17:56:10.581329
+Compile Elapsed Time 0:00:00.071302
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -217,10 +217,10 @@ Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000031882212373144360231001000000000206U3333300_303_S1
-Compile Start Time 2017/09/26 00:06:16.558838
-Compile End Time 2017/09/26 00:06:16.588403
-Compile Elapsed Time 0:00:00.029565
+Qid MXID11000011701212378219753251307000000000206U3333300_303_S1
+Compile Start Time 2017/11/23 17:56:10.510027
+Compile End Time 2017/11/23 17:56:10.581329
+Compile Elapsed Time 0:00:00.071302
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -260,24 +260,24 @@ Stats Collection Type ACCUMULATED_STATS
D
-----------
+ 12
11
21
22
- 12
--- 4 row(s) selected.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000031882212373144360231001000000000206U3333300_303_S1 ;
-Qid MXID11000031882212373144360231001000000000206U3333300_303_S1
-Compile Start Time 2017/09/26 00:06:16.558838
-Compile End Time 2017/09/26 00:06:16.588403
-Compile Elapsed Time 0:00:00.029565
-Execute Start Time 2017/09/26 00:06:23.683457
-Execute End Time 2017/09/26 00:06:27.513095
-Execute Elapsed Time 0:00:03.829638
+>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_303_S1 ;
+Qid MXID11000011701212378219753251307000000000206U3333300_303_S1
+Compile Start Time 2017/11/23 17:56:10.510027
+Compile End Time 2017/11/23 17:56:10.581329
+Compile Elapsed Time 0:00:00.071302
+Execute Start Time 2017/11/23 17:56:18.062665
+Execute End Time 2017/11/23 17:56:21.535598
+Execute Elapsed Time 0:00:03.472933
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -295,7 +295,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/09/26 00:06:27.511111
+First Row Returned Time 2017/11/23 17:56:21.533164
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -303,28 +303,28 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
No. of times executed 1
-Min. Execute Time 3.829638 secs
-Max. Execute Time 3.829638 secs
-Avg. Execute Time 3.829638 secs
+Min. Execute Time 3.472933 secs
+Max. Execute Time 3.472933 secs
+Avg. Execute Time 3.472933 secs
Stats Collection Type ACCUMULATED_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 789,718
-SQL Process Busy Time 5,000,157
+SE IO MAX Time 699,617
+SQL Process Busy Time 4,836,770
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 10,471 KB
-SQL Heap Used 80 KB
-SQL Heap WM 67 KB
+SQL Heap Allocated 12,138 KB
+SQL Heap Used 917 KB
+SQL Heap WM 68 KB
Processes Created 2
-Process Create Time 161,427
+Process Create Time 203,095
Request Message Count 26
-Request Message Bytes 39,408
-Reply Message Count 14
-Reply Message Bytes 32,280
+Request Message Bytes 39,696
+Reply Message Count 15
+Reply Message Bytes 38,792
BMO Space Buffer Size 0
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -337,14 +337,14 @@ Scr. IO Max Time 0
Sort TopN -1
--- SQL operation complete.
->>get statistics for QID MXID11000031882212373144360231001000000000206U3333300_303_S1 ;
-Qid MXID11000031882212373144360231001000000000206U3333300_303_S1
-Compile Start Time 2017/09/26 00:06:16.558838
-Compile End Time 2017/09/26 00:06:16.588403
-Compile Elapsed Time 0:00:00.029565
-Execute Start Time 2017/09/26 00:06:23.683457
-Execute End Time 2017/09/26 00:06:27.513095
-Execute Elapsed Time 0:00:03.829638
+>>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_303_S1 ;
+Qid MXID11000011701212378219753251307000000000206U3333300_303_S1
+Compile Start Time 2017/11/23 17:56:10.510027
+Compile End Time 2017/11/23 17:56:10.581329
+Compile Elapsed Time 0:00:00.071302
+Execute Start Time 2017/11/23 17:56:18.062665
+Execute End Time 2017/11/23 17:56:21.535598
+Execute Elapsed Time 0:00:03.472933
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -362,7 +362,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/09/26 00:06:27.511111
+First Row Returned Time 2017/11/23 17:56:21.533164
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -370,28 +370,28 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
No. of times executed 1
-Min. Execute Time 3.829638 secs
-Max. Execute Time 3.829638 secs
-Avg. Execute Time 3.829638 secs
+Min. Execute Time 3.472933 secs
+Max. Execute Time 3.472933 secs
+Avg. Execute Time 3.472933 secs
Stats Collection Type ACCUMULATED_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 789,718
-SQL Process Busy Time 5,000,157
+SE IO MAX Time 699,617
+SQL Process Busy Time 4,836,770
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 10,471 KB
-SQL Heap Used 80 KB
-SQL Heap WM 67 KB
+SQL Heap Allocated 12,138 KB
+SQL Heap Used 917 KB
+SQL Heap WM 68 KB
Processes Created 2
-Process Create Time 161,427
+Process Create Time 203,095
Request Message Count 26
-Request Message Bytes 39,408
-Reply Message Count 14
-Reply Message Bytes 32,280
+Request Message Bytes 39,696
+Reply Message Count 15
+Reply Message Bytes 38,792
BMO Space Buffer Size 0
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -406,13 +406,13 @@ Sort TopN -1
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000031882212373144360231001000000000206U3333300_303_S1
-Compile Start Time 2017/09/26 00:06:16.558838
-Compile End Time 2017/09/26 00:06:16.588403
-Compile Elapsed Time 0:00:00.029565
-Execute Start Time 2017/09/26 00:06:23.683457
-Execute End Time 2017/09/26 00:06:27.513095
-Execute Elapsed Time 0:00:03.829638
+Qid MXID11000011701212378219753251307000000000206U3333300_303_S1
+Compile Start Time 2017/11/23 17:56:10.510027
+Compile End Time 2017/11/23 17:56:10.581329
+Compile Elapsed Time 0:00:00.071302
+Execute Start Time 2017/11/23 17:56:18.062665
+Execute End Time 2017/11/23 17:56:21.535598
+Execute Elapsed Time 0:00:03.472933
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -430,7 +430,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/09/26 00:06:27.511111
+First Row Returned Time 2017/11/23 17:56:21.533164
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -438,28 +438,28 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
No. of times executed 1
-Min. Execute Time 3.829638 secs
-Max. Execute Time 3.829638 secs
-Avg. Execute Time 3.829638 secs
+Min. Execute Time 3.472933 secs
+Max. Execute Time 3.472933 secs
+Avg. Execute Time 3.472933 secs
Stats Collection Type ACCUMULATED_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 789,718
-SQL Process Busy Time 5,000,157
+SE IO MAX Time 699,617
+SQL Process Busy Time 4,836,770
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 10,471 KB
-SQL Heap Used 80 KB
-SQL Heap WM 67 KB
+SQL Heap Allocated 12,138 KB
+SQL Heap Used 917 KB
+SQL Heap WM 68 KB
Processes Created 2
-Process Create Time 161,427
+Process Create Time 203,095
Request Message Count 26
-Request Message Bytes 39,408
-Reply Message Count 14
-Reply Message Bytes 32,280
+Request Message Bytes 39,696
+Reply Message Count 15
+Reply Message Bytes 38,792
BMO Space Buffer Size 0
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -473,13 +473,13 @@ Sort TopN -1
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000031882212373144360231001000000000206U3333300_303_S1
-Compile Start Time 2017/09/26 00:06:16.558838
-Compile End Time 2017/09/26 00:06:16.588403
-Compile Elapsed Time 0:00:00.029565
-Execute Start Time 2017/09/26 00:06:23.683457
-Execute End Time 2017/09/26 00:06:27.513095
-Execute Elapsed Time 0:00:03.829638
+Qid MXID11000011701212378219753251307000000000206U3333300_303_S1
+Compile Start Time 2017/11/23 17:56:10.510027
+Compile End Time 2017/11/23 17:56:10.581329
+Compile Elapsed Time 0:00:00.071302
+Execute Start Time 2017/11/23 17:56:18.062665
+Execute End Time 2017/11/23 17:56:21.535598
+Execute Elapsed Time 0:00:03.472933
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -497,7 +497,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/09/26 00:06:27.511111
+First Row Returned Time 2017/11/23 17:56:21.533164
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -505,28 +505,28 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
No. of times executed 1
-Min. Execute Time 3.829638 secs
-Max. Execute Time 3.829638 secs
-Avg. Execute Time 3.829638 secs
+Min. Execute Time 3.472933 secs
+Max. Execute Time 3.472933 secs
+Avg. Execute Time 3.472933 secs
Stats Collection Type ACCUMULATED_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 789,718
-SQL Process Busy Time 5,000,157
+SE IO MAX Time 699,617
+SQL Process Busy Time 4,836,770
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 10,471 KB
-SQL Heap Used 80 KB
-SQL Heap WM 67 KB
+SQL Heap Allocated 12,138 KB
+SQL Heap Used 917 KB
+SQL Heap WM 68 KB
Processes Created 2
-Process Create Time 161,427
+Process Create Time 203,095
Request Message Count 26
-Request Message Bytes 39,408
-Reply Message Count 14
-Reply Message Bytes 32,280
+Request Message Bytes 39,696
+Reply Message Count 15
+Reply Message Bytes 38,792
BMO Space Buffer Size 0
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -546,25 +546,25 @@ Sort TopN -1
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000031882212373144360231001000000000206U3333300_303_S1 ;
+>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_303_S1 ;
-*** ERROR[8923] The given Query Id MXID11000031882212373144360231001000000000206U3333300_303_S1 is not found.
+*** ERROR[8923] The given Query Id MXID11000011701212378219753251307000000000206U3333300_303_S1 is not found.
--- SQL operation failed with errors.
->>get statistics for QID MXID11000031882212373144360231001000000000206U3333300_303_S1 ;
+>>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_303_S1 ;
-*** ERROR[8923] The given Query Id MXID11000031882212373144360231001000000000206U3333300_303_S1 is not found.
+*** ERROR[8923] The given Query Id MXID11000011701212378219753251307000000000206U3333300_303_S1 is not found.
--- SQL operation failed with errors.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000031882212373144360231001000000000206U3333300_312_S1 ;
-Qid MXID11000031882212373144360231001000000000206U3333300_312_S1
-Compile Start Time 2017/09/26 00:06:31.359957
-Compile End Time 2017/09/26 00:06:31.360855
-Compile Elapsed Time 0:00:00.000898
+>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_312_S1 ;
+Qid MXID11000011701212378219753251307000000000206U3333300_312_S1
+Compile Start Time 2017/11/23 17:56:25.831881
+Compile End Time 2017/11/23 17:56:25.834511
+Compile Elapsed Time 0:00:00.002630
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -599,11 +599,11 @@ Avg. Execute Time 0.000000 secs
Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000031882212373144360231001000000000206U3333300_312_S1 ;
-Qid MXID11000031882212373144360231001000000000206U3333300_312_S1
-Compile Start Time 2017/09/26 00:06:31.359957
-Compile End Time 2017/09/26 00:06:31.360855
-Compile Elapsed Time 0:00:00.000898
+>>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_312_S1 ;
+Qid MXID11000011701212378219753251307000000000206U3333300_312_S1
+Compile Start Time 2017/11/23 17:56:25.831881
+Compile End Time 2017/11/23 17:56:25.834511
+Compile Elapsed Time 0:00:00.002630
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -640,10 +640,10 @@ Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000031882212373144360231001000000000206U3333300_312_S1
-Compile Start Time 2017/09/26 00:06:31.359957
-Compile End Time 2017/09/26 00:06:31.360855
-Compile Elapsed Time 0:00:00.000898
+Qid MXID11000011701212378219753251307000000000206U3333300_312_S1
+Compile Start Time 2017/11/23 17:56:25.831881
+Compile End Time 2017/11/23 17:56:25.834511
+Compile Elapsed Time 0:00:00.002630
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -679,10 +679,10 @@ Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000031882212373144360231001000000000206U3333300_312_S1
-Compile Start Time 2017/09/26 00:06:31.359957
-Compile End Time 2017/09/26 00:06:31.360855
-Compile Elapsed Time 0:00:00.000898
+Qid MXID11000011701212378219753251307000000000206U3333300_312_S1
+Compile Start Time 2017/11/23 17:56:25.831881
+Compile End Time 2017/11/23 17:56:25.834511
+Compile Elapsed Time 0:00:00.002630
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -730,10 +730,10 @@ Stats Collection Type ACCUMULATED_STATS
--- SQL command prepared.
>>log;
>>get statistics for qid current ;
-Qid MXID11000031882212373144360231001000000000206U3333300_317_S1
-Compile Start Time 2017/09/26 00:06:38.742687
-Compile End Time 2017/09/26 00:06:38.781655
-Compile Elapsed Time 0:00:00.038968
+Qid MXID11000011701212378219753251307000000000206U3333300_317_S1
+Compile Start Time 2017/11/23 17:56:33.591183
+Compile End Time 2017/11/23 17:56:33.657895
+Compile Elapsed Time 0:00:00.066712
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -772,11 +772,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000031882212373144360231001000000000206U3333300_317_S1 ;
-Qid MXID11000031882212373144360231001000000000206U3333300_317_S1
-Compile Start Time 2017/09/26 00:06:38.742687
-Compile End Time 2017/09/26 00:06:38.781655
-Compile Elapsed Time 0:00:00.038968
+>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_317_S1 ;
+Qid MXID11000011701212378219753251307000000000206U3333300_317_S1
+Compile Start Time 2017/11/23 17:56:33.591183
+Compile End Time 2017/11/23 17:56:33.657895
+Compile Elapsed Time 0:00:00.066712
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -811,11 +811,11 @@ Avg. Execute Time 0.000000 secs
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000031882212373144360231001000000000206U3333300_317_S1 ;
-Qid MXID11000031882212373144360231001000000000206U3333300_317_S1
-Compile Start Time 2017/09/26 00:06:38.742687
-Compile End Time 2017/09/26 00:06:38.781655
-Compile Elapsed Time 0:00:00.038968
+>>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_317_S1 ;
+Qid MXID11000011701212378219753251307000000000206U3333300_317_S1
+Compile Start Time 2017/11/23 17:56:33.591183
+Compile End Time 2017/11/23 17:56:33.657895
+Compile Elapsed Time 0:00:00.066712
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -854,11 +854,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000031882212373144360231001000000000206U3333300_317_S1 ACCUMULATED;
-Qid MXID11000031882212373144360231001000000000206U3333300_317_S1
-Compile Start Time 2017/09/26 00:06:38.742687
-Compile End Time 2017/09/26 00:06:38.781655
-Compile Elapsed Time 0:00:00.038968
+>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_317_S1 ACCUMULATED;
+Qid MXID11000011701212378219753251307000000000206U3333300_317_S1
+Compile Start Time 2017/11/23 17:56:33.591183
+Compile End Time 2017/11/23 17:56:33.657895
+Compile Elapsed Time 0:00:00.066712
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -893,11 +893,11 @@ Avg. Execute Time 0.000000 secs
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000031882212373144360231001000000000206U3333300_317_S1 ACCUMULATED;
-Qid MXID11000031882212373144360231001000000000206U3333300_317_S1
-Compile Start Time 2017/09/26 00:06:38.742687
-Compile End Time 2017/09/26 00:06:38.781655
-Compile Elapsed Time 0:00:00.038968
+>>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_317_S1 ACCUMULATED;
+Qid MXID11000011701212378219753251307000000000206U3333300_317_S1
+Compile Start Time 2017/11/23 17:56:33.591183
+Compile End Time 2017/11/23 17:56:33.657895
+Compile Elapsed Time 0:00:00.066712
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -934,10 +934,10 @@ Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000031882212373144360231001000000000206U3333300_317_S1
-Compile Start Time 2017/09/26 00:06:38.742687
-Compile End Time 2017/09/26 00:06:38.781655
-Compile Elapsed Time 0:00:00.038968
+Qid MXID11000011701212378219753251307000000000206U3333300_317_S1
+Compile Start Time 2017/11/23 17:56:33.591183
+Compile End Time 2017/11/23 17:56:33.657895
+Compile Elapsed Time 0:00:00.066712
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -973,10 +973,10 @@ Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000031882212373144360231001000000000206U3333300_317_S1
-Compile Start Time 2017/09/26 00:06:38.742687
-Compile End Time 2017/09/26 00:06:38.781655
-Compile Elapsed Time 0:00:00.038968
+Qid MXID11000011701212378219753251307000000000206U3333300_317_S1
+Compile Start Time 2017/11/23 17:56:33.591183
+Compile End Time 2017/11/23 17:56:33.657895
+Compile Elapsed Time 0:00:00.066712
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1012,10 +1012,10 @@ Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>display statistics for qid current accumulated ;
-Qid MXID11000031882212373144360231001000000000206U3333300_317_S1
-Compile Start Time 2017/09/26 00:06:38.742687
-Compile End Time 2017/09/26 00:06:38.781655
-Compile Elapsed Time 0:00:00.038968
+Qid MXID11000011701212378219753251307000000000206U3333300_317_S1
+Compile Start Time 2017/11/23 17:56:33.591183
+Compile End Time 2017/11/23 17:56:33.657895
+Compile Elapsed Time 0:00:00.066712
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1051,10 +1051,10 @@ Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>get statistics for qid current accumulated ;
-Qid MXID11000031882212373144360231001000000000206U3333300_317_S1
-Compile Start Time 2017/09/26 00:06:38.742687
-Compile End Time 2017/09/26 00:06:38.781655
-Compile Elapsed Time 0:00:00.038968
+Qid MXID11000011701212378219753251307000000000206U3333300_317_S1
+Compile Start Time 2017/11/23 17:56:33.591183
+Compile End Time 2017/11/23 17:56:33.657895
+Compile Elapsed Time 0:00:00.066712
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1104,14 +1104,14 @@ D
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000031882212373144360231001000000000206U3333300_317_S1 ;
-Qid MXID11000031882212373144360231001000000000206U3333300_317_S1
-Compile Start Time 2017/09/26 00:06:38.742687
-Compile End Time 2017/09/26 00:06:38.781655
-Compile Elapsed Time 0:00:00.038968
-Execute Start Time 2017/09/26 00:06:46.574348
-Execute End Time 2017/09/26 00:06:46.638206
-Execute Elapsed Time 0:00:00.063858
+>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_317_S1 ;
+Qid MXID11000011701212378219753251307000000000206U3333300_317_S1
+Compile Start Time 2017/11/23 17:56:33.591183
+Compile End Time 2017/11/23 17:56:33.657895
+Compile Elapsed Time 0:00:00.066712
+Execute Start Time 2017/11/23 17:56:41.333784
+Execute End Time 2017/11/23 17:56:41.377591
+Execute Elapsed Time 0:00:00.043807
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1129,7 +1129,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/09/26 00:06:46.636794
+First Row Returned Time 2017/11/23 17:56:41.375158
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1137,21 +1137,21 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
No. of times executed 1
-Min. Execute Time 0.063858 secs
-Max. Execute Time 0.063858 secs
-Avg. Execute Time 0.063858 secs
+Min. Execute Time 0.043807 secs
+Max. Execute Time 0.043807 secs
+Avg. Execute Time 0.043807 secs
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 16,866
+SQL Process Busy Time 23,792
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 200 KB
-SQL Heap Used 78 KB
-SQL Heap WM 10,338 KB
+SQL Heap Allocated 1,032 KB
+SQL Heap Used 913 KB
+SQL Heap WM 11,171 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,568
+Request Message Bytes 39,856
Reply Message Count 15
Reply Message Bytes 39,208
BMO Space Buffer Size 0
@@ -1168,17 +1168,17 @@ Sort TopN -1
Id DOP Table Name
EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime
1 2 TRAFODION.SCH.TSTAT
- 0 4 100 4 4 0 53,929 46,340
+ 0 4 100 4 4 0 13,543 7,340
--- SQL operation complete.
->>get statistics for QID MXID11000031882212373144360231001000000000206U3333300_317_S1 ;
-Qid MXID11000031882212373144360231001000000000206U3333300_317_S1
-Compile Start Time 2017/09/26 00:06:38.742687
-Compile End Time 2017/09/26 00:06:38.781655
-Compile Elapsed Time 0:00:00.038968
-Execute Start Time 2017/09/26 00:06:46.574348
-Execute End Time 2017/09/26 00:06:46.638206
-Execute Elapsed Time 0:00:00.063858
+>>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_317_S1 ;
+Qid MXID11000011701212378219753251307000000000206U3333300_317_S1
+Compile Start Time 2017/11/23 17:56:33.591183
+Compile End Time 2017/11/23 17:56:33.657895
+Compile Elapsed Time 0:00:00.066712
+Execute Start Time 2017/11/23 17:56:41.333784
+Execute End Time 2017/11/23 17:56:41.377591
+Execute Elapsed Time 0:00:00.043807
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1196,7 +1196,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/09/26 00:06:46.636794
+First Row Returned Time 2017/11/23 17:56:41.375158
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1204,21 +1204,21 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
No. of times executed 1
-Min. Execute Time 0.063858 secs
-Max. Execute Time 0.063858 secs
-Avg. Execute Time 0.063858 secs
+Min. Execute Time 0.043807 secs
+Max. Execute Time 0.043807 secs
+Avg. Execute Time 0.043807 secs
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 16,866
+SQL Process Busy Time 23,792
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 200 KB
-SQL Heap Used 78 KB
-SQL Heap WM 10,338 KB
+SQL Heap Allocated 1,032 KB
+SQL Heap Used 913 KB
+SQL Heap WM 11,171 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,568
+Request Message Bytes 39,856
Reply Message Count 15
Reply Message Bytes 39,208
BMO Space Buffer Size 0
@@ -1235,21 +1235,21 @@ Sort TopN -1
Id DOP Table Name
EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime
1 2 TRAFODION.SCH.TSTAT
- 0 4 100 4 4 0 53,929 46,340
+ 0 4 100 4 4 0 13,543 7,340
--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000031882212373144360231001000000000206U3333300_317_S1 ACCUMULATED;
-Qid MXID11000031882212373144360231001000000000206U3333300_317_S1
-Compile Start Time 2017/09/26 00:06:38.742687
-Compile End Time 2017/09/26 00:06:38.781655
-Compile Elapsed Time 0:00:00.038968
-Execute Start Time 2017/09/26 00:06:46.574348
-Execute End Time 2017/09/26 00:06:46.638206
-Execute Elapsed Time 0:00:00.063858
+>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_317_S1 ACCUMULATED;
+Qid MXID11000011701212378219753251307000000000206U3333300_317_S1
+Compile Start Time 2017/11/23 17:56:33.591183
+Compile End Time 2017/11/23 17:56:33.657895
+Compile Elapsed Time 0:00:00.066712
+Execute Start Time 2017/11/23 17:56:41.333784
+Execute End Time 2017/11/23 17:56:41.377591
+Execute Elapsed Time 0:00:00.043807
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1267,7 +1267,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/09/26 00:06:46.636794
+First Row Returned Time 2017/11/23 17:56:41.375158
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1275,26 +1275,26 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
No. of times executed 1
-Min. Execute Time 0.063858 secs
-Max. Execute Time 0.063858 secs
-Avg. Execute Time 0.063858 secs
+Min. Execute Time 0.043807 secs
+Max. Execute Time 0.043807 secs
+Avg. Execute Time 0.043807 secs
Stats Collection Type PERTABLE_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 46,340
-SQL Process Busy Time 16,866
+SE IO MAX Time 7,340
+SQL Process Busy Time 23,792
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 200 KB
-SQL Heap Used 78 KB
-SQL Heap WM 10,338 KB
+SQL Heap Allocated 1,032 KB
+SQL Heap Used 913 KB
+SQL Heap WM 11,171 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,568
+Request Message Bytes 39,856
Reply Message Count 15
Reply Message Bytes 39,208
BMO Space Buffer Size 0
@@ -1309,14 +1309,14 @@ Scr. IO Max Time 0
Sort TopN -1
--- SQL operation complete.
->>get statistics for QID MXID11000031882212373144360231001000000000206U3333300_317_S1 ACCUMULATED;
-Qid MXID11000031882212373144360231001000000000206U3333300_317_S1
-Compile Start Time 2017/09/26 00:06:38.742687
-Compile End Time 2017/09/26 00:06:38.781655
-Compile Elapsed Time 0:00:00.038968
-Execute Start Time 2017/09/26 00:06:46.574348
-Execute End Time 2017/09/26 00:06:46.638206
-Execute Elapsed Time 0:00:00.063858
+>>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_317_S1 ACCUMULATED;
+Qid MXID11000011701212378219753251307000000000206U3333300_317_S1
+Compile Start Time 2017/11/23 17:56:33.591183
+Compile End Time 2017/11/23 17:56:33.657895
+Compile Elapsed Time 0:00:00.066712
+Execute Start Time 2017/11/23 17:56:41.333784
+Execute End Time 2017/11/23 17:56:41.377591
+Execute Elapsed Time 0:00:00.043807
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1334,7 +1334,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/09/26 00:06:46.636794
+First Row Returned Time 2017/11/23 17:56:41.375158
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1342,26 +1342,26 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
No. of times executed 1
-Min. Execute Time 0.063858 secs
-Max. Execute Time 0.063858 secs
-Avg. Execute Time 0.063858 secs
+Min. Execute Time 0.043807 secs
+Max. Execute Time 0.043807 secs
+Avg. Execute Time 0.043807 secs
Stats Collection Type PERTABLE_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 46,340
-SQL Process Busy Time 16,866
+SE IO MAX Time 7,340
+SQL Process Busy Time 23,792
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 200 KB
-SQL Heap Used 78 KB
-SQL Heap WM 10,338 KB
+SQL Heap Allocated 1,032 KB
+SQL Heap Used 913 KB
+SQL Heap WM 11,171 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,568
+Request Message Bytes 39,856
Reply Message Count 15
Reply Message Bytes 39,208
BMO Space Buffer Size 0
@@ -1378,13 +1378,13 @@ Sort TopN -1
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000031882212373144360231001000000000206U3333300_317_S1
-Compile Start Time 2017/09/26 00:06:38.742687
-Compile End Time 2017/09/26 00:06:38.781655
-Compile Elapsed Time 0:00:00.038968
-Execute Start Time 2017/09/26 00:06:46.574348
-Execute End Time 2017/09/26 00:06:46.638206
-Execute Elapsed Time 0:00:00.063858
+Qid MXID11000011701212378219753251307000000000206U3333300_317_S1
+Compile Start Time 2017/11/23 17:56:33.591183
+Compile End Time 2017/11/23 17:56:33.657895
+Compile Elapsed Time 0:00:00.066712
+Execute Start Time 2017/11/23 17:56:41.333784
+Execute End Time 2017/11/23 17:56:41.377591
+Execute Elapsed Time 0:00:00.043807
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1402,7 +1402,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/09/26 00:06:46.636794
+First Row Returned Time 2017/11/23 17:56:41.375158
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1410,21 +1410,21 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
No. of times executed 1
-Min. Execute Time 0.063858 secs
-Max. Execute Time 0.063858 secs
-Avg. Execute Time 0.063858 secs
+Min. Execute Time 0.043807 secs
+Max. Execute Time 0.043807 secs
+Avg. Execute Time 0.043807 secs
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 16,866
+SQL Process Busy Time 23,792
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 200 KB
-SQL Heap Used 78 KB
-SQL Heap WM 10,338 KB
+SQL Heap Allocated 1,032 KB
+SQL Heap Used 913 KB
+SQL Heap WM 11,171 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,568
+Request Message Bytes 39,856
Reply Message Count 15
Reply Message Bytes 39,208
BMO Space Buffer Size 0
@@ -1441,17 +1441,17 @@ Sort TopN -1
Id DOP Table Name
EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime
1 2 TRAFODION.SCH.TSTAT
- 0 4 100 4 4 0 53,929 46,340
+ 0 4 100 4 4 0 13,543 7,340
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000031882212373144360231001000000000206U3333300_317_S1
-Compile Start Time 2017/09/26 00:06:38.742687
-Compile End Time 2017/09/26 00:06:38.781655
-Compile Elapsed Time 0:00:00.038968
-Execute Start Time 2017/09/26 00:06:46.574348
-Execute End Time 2017/09/26 00:06:46.638206
-Execute Elapsed Time 0:00:00.063858
+Qid MXID11000011701212378219753251307000000000206U3333300_317_S1
+Compile Start Time 2017/11/23 17:56:33.591183
+Compile End Time 2017/11/23 17:56:33.657895
+Compile Elapsed Time 0:00:00.066712
+Execute Start Time 2017/11/23 17:56:41.333784
+Execute End Time 2017/11/23 17:56:41.377591
+Execute Elapsed Time 0:00:00.043807
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1469,7 +1469,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/09/26 00:06:46.636794
+First Row Returned Time 2017/11/23 17:56:41.375158
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1477,21 +1477,21 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
No. of times executed 1
-Min. Execute Time 0.063858 secs
-Max. Execute Time 0.063858 secs
-Avg. Execute Time 0.063858 secs
+Min. Execute Time 0.043807 secs
+Max. Execute Time 0.043807 secs
+Avg. Execute Time 0.043807 secs
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 16,866
+SQL Process Busy Time 23,792
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 200 KB
-SQL Heap Used 78 KB
-SQL Heap WM 10,338 KB
+SQL Heap Allocated 1,032 KB
+SQL Heap Used 913 KB
+SQL Heap WM 11,171 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,568
+Request Message Bytes 39,856
Reply Message Count 15
Reply Message Bytes 39,208
BMO Space Buffer Size 0
@@ -1508,17 +1508,17 @@ Sort TopN -1
Id DOP Table Name
EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime
1 2 TRAFODION.SCH.TSTAT
- 0 4 100 4 4 0 53,929 46,340
+ 0 4 100 4 4 0 13,543 7,340
--- SQL operation complete.
>>display statistics for qid current accumulated;
-Qid MXID11000031882212373144360231001000000000206U3333300_317_S1
-Compile Start Time 2017/09/26 00:06:38.742687
-Compile End Time 2017/09/26 00:06:38.781655
-Compile Elapsed Time 0:00:00.038968
-Execute Start Time 2017/09/26 00:06:46.574348
-Execute End Time 2017/09/26 00:06:46.638206
-Execute Elapsed Time 0:00:00.063858
+Qid MXID11000011701212378219753251307000000000206U3333300_317_S1
+Compile Start Time 2017/11/23 17:56:33.591183
+Compile End Time 2017/11/23 17:56:33.657895
+Compile Elapsed Time 0:00:00.066712
+Execute Start Time 2017/11/23 17:56:41.333784
+Execute End Time 2017/11/23 17:56:41.377591
+Execute Elapsed Time 0:00:00.043807
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1536,7 +1536,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/09/26 00:06:46.636794
+First Row Returned Time 2017/11/23 17:56:41.375158
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1544,26 +1544,26 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
No. of times executed 1
-Min. Execute Time 0.063858 secs
-Max. Execute Time 0.063858 secs
-Avg. Execute Time 0.063858 secs
+Min. Execute Time 0.043807 secs
+Max. Execute Time 0.043807 secs
+Avg. Execute Time 0.043807 secs
Stats Collection Type PERTABLE_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 46,340
-SQL Process Busy Time 16,866
+SE IO MAX Time 7,340
+SQL Process Busy Time 23,792
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 200 KB
-SQL Heap Used 78 KB
-SQL Heap WM 10,338 KB
+SQL Heap Allocated 1,032 KB
+SQL Heap Used 913 KB
+SQL Heap WM 11,171 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,568
+Request Message Bytes 39,856
Reply Message Count 15
Reply Message Bytes 39,208
BMO Space Buffer Size 0
@@ -1579,13 +1579,13 @@ Sort TopN -1
--- SQL operation complete.
>>get statistics for qid current accumulated;
-Qid MXID11000031882212373144360231001000000000206U3333300_317_S1
-Compile Start Time 2017/09/26 00:06:38.742687
-Compile End Time 2017/09/26 00:06:38.781655
-Compile Elapsed Time 0:00:00.038968
-Execute Start Time 2017/09/26 00:06:46.574348
-Execute End Time 2017/09/26 00:06:46.638206
-Execute Elapsed Time 0:00:00.063858
+Qid MXID11000011701212378219753251307000000000206U3333300_317_S1
+Compile Start Time 2017/11/23 17:56:33.591183
+Compile End Time 2017/11/23 17:56:33.657895
+Compile Elapsed Time 0:00:00.066712
+Execute Start Time 2017/11/23 17:56:41.333784
+Execute End Time 2017/11/23 17:56:41.377591
+Execute Elapsed Time 0:00:00.043807
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1603,7 +1603,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/09/26 00:06:46.636794
+First Row Returned Time 2017/11/23 17:56:41.375158
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1611,26 +1611,26 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
No. of times executed 1
-Min. Execute Time 0.063858 secs
-Max. Execute Time 0.063858 secs
-Avg. Execute Time 0.063858 secs
+Min. Execute Time 0.043807 secs
+Max. Execute Time 0.043807 secs
+Avg. Execute Time 0.043807 secs
Stats Collection Type PERTABLE_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 46,340
-SQL Process Busy Time 16,866
+SE IO MAX Time 7,340
+SQL Process Busy Time 23,792
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 200 KB
-SQL Heap Used 78 KB
-SQL Heap WM 10,338 KB
+SQL Heap Allocated 1,032 KB
+SQL Heap Used 913 KB
+SQL Heap WM 11,171 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,568
+Request Message Bytes 39,856
Reply Message Count 15
Reply Message Bytes 39,208
BMO Space Buffer Size 0
@@ -1647,7 +1647,7 @@ Sort TopN -1
--- SQL operation complete.
>>log;
>>obey PQIDOUT;
->>SET SESSION DEFAULT PARENT_QID 'MXID11000031882212373144360231001000000000206U3333300_317_S1';
+>>SET SESSION DEFAULT PARENT_QID 'MXID11000011701212378219753251307000000000206U3333300_317_S1';
--- SQL operation complete.
>>prepare s1 from select distinct d from tstat ;
@@ -1657,11 +1657,11 @@ Sort TopN -1
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000031882212373144360231001000000000206U3333300_331_S1 ;
-Qid MXID11000031882212373144360231001000000000206U3333300_331_S1
-Compile Start Time 2017/09/26 00:06:54.034555
-Compile End Time 2017/09/26 00:06:54.035229
-Compile Elapsed Time 0:00:00.000674
+>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_331_S1 ;
+Qid MXID11000011701212378219753251307000000000206U3333300_331_S1
+Compile Start Time 2017/11/23 17:56:49.393860
+Compile End Time 2017/11/23 17:56:49.395625
+Compile Elapsed Time 0:00:00.001765
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1673,7 +1673,7 @@ Query Type SQL_SELECT_NON_UNIQUE
Sub Query Type SQL_STMT_NA
Estimated Accessed Rows 0
Estimated Used Rows 0
-Parent Qid MXID11000031882212373144360231001000000000206U3333300_317_S1
+Parent Qid MXID11000011701212378219753251307000000000206U3333300_317_S1
Parent Query System SAME
Child Qid NONE
Number of SQL Processes 1
@@ -1696,11 +1696,11 @@ Avg. Execute Time 0.000000 secs
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000031882212373144360231001000000000206U3333300_331_S1 ;
-Qid MXID11000031882212373144360231001000000000206U3333300_331_S1
-Compile Start Time 2017/09/26 00:06:54.034555
-Compile End Time 2017/09/26 00:06:54.035229
-Compile Elapsed Time 0:00:00.000674
+>>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_331_S1 ;
+Qid MXID11000011701212378219753251307000000000206U3333300_331_S1
+Compile Start Time 2017/11/23 17:56:49.393860
+Compile End Time 2017/11/23 17:56:49.395625
+Compile Elapsed Time 0:00:00.001765
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1712,7 +1712,7 @@ Query Type SQL_SELECT_NON_UNIQUE
Sub Query Type SQL_STMT_NA
Estimated Accessed Rows 0
Estimated Used Rows 0
-Parent Qid MXID11000031882212373144360231001000000000206U3333300_317_S1
+Parent Qid MXID11000011701212378219753251307000000000206U3333300_317_S1
Parent Query System SAME
Child Qid NONE
Number of SQL Processes 1
@@ -1746,11 +1746,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000031882212373144360231001000000000206U3333300_333_S1 ;
-Qid MXID11000031882212373144360231001000000000206U3333300_333_S1
-Compile Start Time 2017/09/26 00:06:57.730975
-Compile End Time 2017/09/26 00:06:57.731618
-Compile Elapsed Time 0:00:00.000643
+>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_333_S1 ;
+Qid MXID11000011701212378219753251307000000000206U3333300_333_S1
+Compile Start Time 2017/11/23 17:56:53.100908
+Compile End Time 2017/11/23 17:56:53.102456
+Compile Elapsed Time 0:00:00.001548
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1785,11 +1785,11 @@ Avg. Execute Time 0.000000 secs
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000031882212373144360231001000000000206U3333300_333_S1 ;
-Qid MXID11000031882212373144360231001000000000206U3333300_333_S1
-Compile Start Time 2017/09/26 00:06:57.730975
-Compile End Time 2017/09/26 00:06:57.731618
-Compile Elapsed Time 0:00:00.000643
+>>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_333_S1 ;
+Qid MXID11000011701212378219753251307000000000206U3333300_333_S1
+Compile Start Time 2017/11/23 17:56:53.100908
+Compile End Time 2017/11/23 17:56:53.102456
+Compile Elapsed Time 0:00:00.001548
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1840,11 +1840,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000031882212373144360231001000000000206U3333300_336_S1 ;
-Qid MXID11000031882212373144360231001000000000206U3333300_336_S1
-Compile Start Time 2017/09/26 00:07:04.432712
-Compile End Time 2017/09/26 00:07:04.478608
-Compile Elapsed Time 0:00:00.045896
+>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_336_S1 ;
+Qid MXID11000011701212378219753251307000000000206U3333300_336_S1
+Compile Start Time 2017/11/23 17:56:56.513528
+Compile End Time 2017/11/23 17:56:56.575220
+Compile Elapsed Time 0:00:00.061692
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1879,11 +1879,11 @@ Avg. Execute Time 0.000000 secs
Stats Collection Type OPERATOR_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000031882212373144360231001000000000206U3333300_336_S1 ;
-Qid MXID11000031882212373144360231001000000000206U3333300_336_S1
-Compile Start Time 2017/09/26 00:07:04.432712
-Compile End Time 2017/09/26 00:07:04.478608
-Compile Elapsed Time 0:00:00.045896
+>>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_336_S1 ;
+Qid MXID11000011701212378219753251307000000000206U3333300_336_S1
+Compile Start Time 2017/11/23 17:56:56.513528
+Compile End Time 2017/11/23 17:56:56.575220
+Compile Elapsed Time 0:00:00.061692
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1934,14 +1934,14 @@ D
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000031882212373144360231001000000000206U3333300_336_S1 ;
-Qid MXID11000031882212373144360231001000000000206U3333300_336_S1
-Compile Start Time 2017/09/26 00:07:04.432712
-Compile End Time 2017/09/26 00:07:04.478608
-Compile Elapsed Time 0:00:00.045896
-Execute Start Time 2017/09/26 00:07:11.341441
-Execute End Time 2017/09/26 00:07:11.375178
-Execute Elapsed Time 0:00:00.033737
+>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_336_S1 ;
+Qid MXID11000011701212378219753251307000000000206U3333300_336_S1
+Compile Start Time 2017/11/23 17:56:56.513528
+Compile End Time 2017/11/23 17:56:56.575220
+Compile Elapsed Time 0:00:00.061692
+Execute Start Time 2017/11/23 17:57:00.313805
+Execute End Time 2017/11/23 17:57:00.341117
+Execute Elapsed Time 0:00:00.027312
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1959,7 +1959,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/09/26 00:07:11.366701
+First Row Returned Time 2017/11/23 17:57:00.337861
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1967,34 +1967,34 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
No. of times executed 1
-Min. Execute Time 0.033737 secs
-Max. Execute Time 0.033737 secs
-Avg. Execute Time 0.033737 secs
+Min. Execute Time 0.027312 secs
+Max. Execute Time 0.027312 secs
+Avg. Execute Time 0.027312 secs
Stats Collection Type OPERATOR_STATS
LC RC Id PaId ExId Frag TDBName DOP Dispatches OperCPUTime EstRowsUsed ActRowsUsed Details
- 10 . 11 . 5 0 EX_ROOT 1 5 9 0 4 1821
- 9 . 10 11 4 0 EX_SPLIT_TOP 1 5 40 2 4
- 8 . 9 10 4 0 EX_SEND_TOP 2 10 1,772 2 4
- 7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 190 2 4
- 6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 11 2 4 6457
- 5 . 6 7 3 2 EX_HASH_GRBY 2 6 4,263 1 4 0|0|0
- 4 . 5 6 2 2 EX_SPLIT_TOP 2 11 17 100 4
- 3 . 4 5 2 2 EX_SEND_TOP 4 18 1,976 100 4
- 2 . 3 4 2 3 EX_SEND_BOTTOM 4 24 260 100 4
- 1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 30 100 4 6063
- . . 1 2 1 3 EX_TRAF_KEY_SELECT 2 4 5,773 100 4 TRAFODION.SCH.TSTAT|4|176
+ 10 . 11 . 5 0 EX_ROOT 1 5 16 0 4 1683
+ 9 . 10 11 4 0 EX_SPLIT_TOP 1 5 46 2 4
+ 8 . 9 10 4 0 EX_SEND_TOP 2 10 1,621 2 4
+ 7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 240 2 4
+ 6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 52 2 4 5674
+ 5 . 6 7 3 2 EX_HASH_GRBY 2 6 3,392 1 4 0|0|0
+ 4 . 5 6 2 2 EX_SPLIT_TOP 2 9 52 100 4
+ 3 . 4 5 2 2 EX_SEND_TOP 4 18 1,938 100 4
+ 2 . 3 4 2 3 EX_SEND_BOTTOM 4 26 395 100 4
+ 1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 80 100 4 8565
+ . . 1 2 1 3 EX_TRAF_KEY_SELECT 2 4 8,090 100 4 TRAFODION.SCH.TSTAT|4|176
--- SQL operation complete.
->>get statistics for QID MXID11000031882212373144360231001000000000206U3333300_336_S1 ;
-Qid MXID11000031882212373144360231001000000000206U3333300_336_S1
-Compile Start Time 2017/09/26 00:07:04.432712
-Compile End Time 2017/09/26 00:07:04.478608
-Compile Elapsed Time 0:00:00.045896
-Execute Start Time 2017/09/26 00:07:11.341441
-Execute End Time 2017/09/26 00:07:11.375178
-Execute Elapsed Time 0:00:00.033737
+>>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_336_S1 ;
+Qid MXID11000011701212378219753251307000000000206U3333300_336_S1
+Compile Start Time 2017/11/23 17:56:56.513528
+Compile End Time 2017/11/23 17:56:56.575220
+Compile Elapsed Time 0:00:00.061692
+Execute Start Time 2017/11/23 17:57:00.313805
+Execute End Time 2017/11/23 17:57:00.341117
+Execute Elapsed Time 0:00:00.027312
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2012,7 +2012,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/09/26 00:07:11.366701
+First Row Returned Time 2017/11/23 17:57:00.337861
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2020,38 +2020,38 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
No. of times executed 1
-Min. Execute Time 0.033737 secs
-Max. Execute Time 0.033737 secs
-Avg. Execute Time 0.033737 secs
+Min. Execute Time 0.027312 secs
+Max. Execute Time 0.027312 secs
+Avg. Execute Time 0.027312 secs
Stats Collection Type OPERATOR_STATS
LC RC Id PaId ExId Frag TDBName DOP Dispatches OperCPUTime EstRowsUsed ActRowsUsed Details
- 10 . 11 . 5 0 EX_ROOT 1 5 9 0 4 1821
- 9 . 10 11 4 0 EX_SPLIT_TOP 1 5 40 2 4
- 8 . 9 10 4 0 EX_SEND_TOP 2 10 1,772 2 4
- 7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 190 2 4
- 6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 11 2 4 6457
- 5 . 6 7 3 2 EX_HASH_GRBY 2 6 4,263 1 4 0|0|0
- 4 . 5 6 2 2 EX_SPLIT_TOP 2 11 17 100 4
- 3 . 4 5 2 2 EX_SEND_TOP 4 18 1,976 100 4
- 2 . 3 4 2 3 EX_SEND_BOTTOM 4 24 260 100 4
- 1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 30 100 4 6063
- . . 1 2 1 3 EX_TRAF_KEY_SELECT 2 4 5,773 100 4 TRAFODION.SCH.TSTAT|4|176
+ 10 . 11 . 5 0 EX_ROOT 1 5 16 0 4 1683
+ 9 . 10 11 4 0 EX_SPLIT_TOP 1 5 46 2 4
+ 8 . 9 10 4 0 EX_SEND_TOP 2 10 1,621 2 4
+ 7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 240 2 4
+ 6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 52 2 4 5674
+ 5 . 6 7 3 2 EX_HASH_GRBY 2 6 3,392 1 4 0|0|0
+ 4 . 5 6 2 2 EX_SPLIT_TOP 2 9 52 100 4
+ 3 . 4 5 2 2 EX_SEND_TOP 4 18 1,938 100 4
+ 2 . 3 4 2 3 EX_SEND_BOTTOM 4 26 395 100 4
+ 1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 80 100 4 8565
+ . . 1 2 1 3 EX_TRAF_KEY_SELECT 2 4 8,090 100 4 TRAFODION.SCH.TSTAT|4|176
--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000031882212373144360231001000000000206U3333300_336_S1 ACCUMULATED;
-Qid MXID11000031882212373144360231001000000000206U3333300_336_S1
-Compile Start Time 2017/09/26 00:07:04.432712
-Compile End Time 2017/09/26 00:07:04.478608
-Compile Elapsed Time 0:00:00.045896
-Execute Start Time 2017/09/26 00:07:11.341441
-Execute End Time 2017/09/26 00:07:11.375178
-Execute Elapsed Time 0:00:00.033737
+>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_336_S1 ACCUMULATED;
+Qid MXID11000011701212378219753251307000000000206U3333300_336_S1
+Compile Start Time 2017/11/23 17:56:56.513528
+Compile End Time 2017/11/23 17:56:56.575220
+Compile Elapsed Time 0:00:00.061692
+Execute Start Time 2017/11/23 17:57:00.313805
+Execute End Time 2017/11/23 17:57:00.341117
+Execute Elapsed Time 0:00:00.027312
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2069,7 +2069,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/09/26 00:07:11.366701
+First Row Returned Time 2017/11/23 17:57:00.337861
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2077,26 +2077,26 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
No. of times executed 1
-Min. Execute Time 0.033737 secs
-Max. Execute Time 0.033737 secs
-Avg. Execute Time 0.033737 secs
+Min. Execute Time 0.027312 secs
+Max. Execute Time 0.027312 secs
+Avg. Execute Time 0.027312 secs
Stats Collection Type OPERATOR_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 12,577
-SQL Process Busy Time 14,341
+SE IO MAX Time 9,595
+SQL Process Busy Time 15,922
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 200 KB
-SQL Heap Used 78 KB
-SQL Heap WM 10,341 KB
+SQL Heap Allocated 1,032 KB
+SQL Heap Used 913 KB
+SQL Heap WM 11,175 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 39,728
+Request Message Bytes 40,016
Reply Message Count 15
Reply Message Bytes 42,528
BMO Space Buffer Size 256
@@ -2111,14 +2111,14 @@ Scr. IO Max Time 0
Sort TopN -1
--- SQL operation complete.
->>get statistics for QID MXID11000031882212373144360231001000000000206U3333300_336_S1 ACCUMULATED;
-Qid MXID11000031882212373144360231001000000000206U3333300_336_S1
-Compile Start Time 2017/09/26 00:07:04.432712
-Compile End Time 2017/09/26 00:07:04.478608
-Compile Elapsed Time 0:00:00.045896
-Execute Start Time 2017/09/26 00:07:11.341441
-Execute End Time 2017/09/26 00:07:11.375178
-Execute Elapsed Time 0:00:00.033737
+>>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_336_S1 ACCUMULATED;
+Qid MXID11000011701212378219753251307000000000206U3333300_336_S1
+Compile Start Time 2017/11/23 17:56:56.513528
+Compile End Time 2017/11/23 17:56:56.575220
+Compile Elapsed Time 0:00:00.061692
+Execute Start Time 2017/11/23 17:57:00.313805
+Execute End Time 2017/11/23 17:57:00.341117
+Execute Elapsed Time 0:00:00.027312
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2136,7 +2136,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/09/26 00:07:11.366701
+First Row Returned Time 2017/11/23 17:57:00.337861
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2144,26 +2144,26 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
No. of times executed 1
-Min. Execute Time 0.033737 secs
-Max. Execute Time 0.033737 secs
-Avg. Execute Time 0.033737 secs
+Min. Execute Time 0.027312 secs
+Max. Execute Time 0.027312 secs
+Avg. Execute Time 0.027312 secs
Stats Collection Type OPERATOR_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 12,577
-SQL Process Busy Time 14,341
+SE IO MAX Time 9,595
+SQL Process Busy Time 15,922
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 200 KB
-SQL Heap Used 78 KB
-SQL Heap WM 10,341 KB
+SQL Heap Allocated 1,032 KB
+SQL Heap Used 913 KB
+SQL Heap WM 11,175 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 39,728
+Request Message Bytes 40,016
Reply Message Count 15
Reply Message Bytes 42,528
BMO Space Buffer Size 256
@@ -2182,14 +2182,14 @@ Sort TopN -1
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000031882212373144360231001000000000206U3333300_336_S1 PERTABLE;
-Qid MXID11000031882212373144360231001000000000206U3333300_336_S1
-Compile Start Time 2017/09/26 00:07:04.432712
-Compile End Time 2017/09/26 00:07:04.478608
-Compile Elapsed Time 0:00:00.045896
-Execute Start Time 2017/09/26 00:07:11.341441
-Execute End Time 2017/09/26 00:07:11.375178
-Execute Elapsed Time 0:00:00.033737
+>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_336_S1 PERTABLE;
+Qid MXID11000011701212378219753251307000000000206U3333300_336_S1
+Compile Start Time 2017/11/23 17:56:56.513528
+Compile End Time 2017/11/23 17:56:56.575220
+Compile Elapsed Time 0:00:00.061692
+Execute Start Time 2017/11/23 17:57:00.313805
+Execute End Time 2017/11/23 17:57:00.341117
+Execute Elapsed Time 0:00:00.027312
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2207,7 +2207,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/09/26 00:07:11.366701
+First Row Returned Time 2017/11/23 17:57:00.337861
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2215,21 +2215,21 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
No. of times executed 1
-Min. Execute Time 0.033737 secs
-Max. Execute Time 0.033737 secs
-Avg. Execute Time 0.033737 secs
+Min. Execute Time 0.027312 secs
+Max. Execute Time 0.027312 secs
+Avg. Execute Time 0.027312 secs
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 14,341
+SQL Process Busy Time 15,922
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 200 KB
-SQL Heap Used 78 KB
-SQL Heap WM 10,341 KB
+SQL Heap Allocated 1,032 KB
+SQL Heap Used 913 KB
+SQL Heap WM 11,175 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 39,728
+Request Message Bytes 40,016
Reply Message Count 15
Reply Message Bytes 42,528
BMO Space Buffer Size 256
@@ -2246,17 +2246,17 @@ Sort TopN -1
Id DOP Table Name
EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime
1 2 TRAFODION.SCH.TSTAT
- 0 4 100 4 4 0 22,752 12,577
+ 0 4 100 4 4 0 17,013 9,595
--- SQL operation complete.
->>get statistics for QID MXID11000031882212373144360231001000000000206U3333300_336_S1 PERTABLE;
-Qid MXID11000031882212373144360231001000000000206U3333300_336_S1
-Compile Start Time 2017/09/26 00:07:04.432712
-Compile End Time 2017/09/26 00:07:04.478608
-Compile Elapsed Time 0:00:00.045896
-Execute Start Time 2017/09/26 00:07:11.341441
-Execute End Time 2017/09/26 00:07:11.375178
-Execute Elapsed Time 0:00:00.033737
+>>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_336_S1 PERTABLE;
+Qid MXID11000011701212378219753251307000000000206U3333300_336_S1
+Compile Start Time 2017/11/23 17:56:56.513528
+Compile End Time 2017/11/23 17:56:56.575220
+Compile Elapsed Time 0:00:00.061692
+Execute Start Time 2017/11/23 17:57:00.313805
+Execute End Time 2017/11/23 17:57:00.341117
+Execute Elapsed Time 0:00:00.027312
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2274,7 +2274,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/09/26 00:07:11.366701
+First Row Returned Time 2017/11/23 17:57:00.337861
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2282,21 +2282,21 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
No. of times executed 1
-Min. Execute Time 0.033737 secs
-Max. Execute Time 0.033737 secs
-Avg. Execute Time 0.033737 secs
+Min. Execute Time 0.027312 secs
+Max. Execute Time 0.027312 secs
+Avg. Execute Time 0.027312 secs
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 14,341
+SQL Process Busy Time 15,922
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 200 KB
-SQL Heap Used 78 KB
-SQL Heap WM 10,341 KB
+SQL Heap Allocated 1,032 KB
+SQL Heap Used 913 KB
+SQL Heap WM 11,175 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 39,728
+Request Message Bytes 40,016
Reply Message Count 15
Reply Message Bytes 42,528
BMO Space Buffer Size 256
@@ -2313,21 +2313,21 @@ Sort TopN -1
Id DOP Table Name
EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime
1 2 TRAFODION.SCH.TSTAT
- 0 4 100 4 4 0 22,752 12,577
+ 0 4 100 4 4 0 17,013 9,595
--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000031882212373144360231001000000000206U3333300_336_S1 PROGRESS;
-Qid MXID11000031882212373144360231001000000000206U3333300_336_S1
-Compile Start Time 2017/09/26 00:07:04.432712
-Compile End Time 2017/09/26 00:07:04.478608
-Compile Elapsed Time 0:00:00.045896
-Execute Start Time 2017/09/26 00:07:11.341441
-Execute End Time 2017/09/26 00:07:11.375178
-Execute Elapsed Time 0:00:00.033737
+>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_336_S1 PROGRESS;
+Qid MXID11000011701212378219753251307000000000206U3333300_336_S1
+Compile Start Time 2017/11/23 17:56:56.513528
+Compile End Time 2017/11/23 17:56:56.575220
+Compile Elapsed Time 0:00:00.061692
+Execute Start Time 2017/11/23 17:57:00.313805
+Execute End Time 2017/11/23 17:57:00.341117
+Execute Elapsed Time 0:00:00.027312
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2345,7 +2345,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/09/26 00:07:11.366701
+First Row Returned Time 2017/11/23 17:57:00.337861
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2353,44 +2353,44 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
No. of times executed 1
-Min. Execute Time 0.033737 secs
-Max. Execute Time 0.033737 secs
-Avg. Execute Time 0.033737 secs
+Min. Execute Time 0.027312 secs
+Max. Execute Time 0.027312 secs
+Avg. Execute Time 0.027312 secs
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 14,341
+SQL Process Busy Time 15,922
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 200 KB
-SQL Heap Used 78 KB
-SQL Heap WM 10,341 KB
+SQL Heap Allocated 1,032 KB
+SQL Heap Used 913 KB
+SQL Heap WM 11,175 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 39,728
+Request Message Bytes 40,016
Reply Message Count 15
Reply Message Bytes 42,528
Id DOP Table Name
EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime
1 2 TRAFODION.SCH.TSTAT
- 0 4 100 4 4 0 22,752 12,577
+ 0 4 100 4 4 0 17,013 9,595
Id TDBName Mode DOP TopN BMOPhase InterimRowCount CPUTime
BMOHeapUsed BMOHeapAllocated BMOHeapWM EstMemory BMOSpaceBufSz BMOSpaceBufCnt
ScrFileCnt ScrIOSize ScrIORead ScrIOWritten ScrIOTime ScrIOMaxTime
- 6 EX_HASH_GRBY DISK 2 -1 READ_ROWS 0 4,263
- 4 1,024 7,687 0.07 256 0
+ 6 EX_HASH_GRBY DISK 2 -1 READ_ROWS 0 3,392
+ 4 1,024 7,6870.07 256 0
0 -1 0 0 0 0
--- SQL operation complete.
->>get statistics for QID MXID11000031882212373144360231001000000000206U3333300_336_S1 PROGRESS;
-Qid MXID11000031882212373144360231001000000000206U3333300_336_S1
-Compile Start Time 2017/09/26 00:07:04.432712
-Compile End Time 2017/09/26 00:07:04.478608
-Compile Elapsed Time 0:00:00.045896
-Execute Start Time 2017/09/26 00:07:11.341441
-Execute End Time 2017/09/26 00:07:11.375178
-Execute Elapsed Time 0:00:00.033737
+>>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_336_S1 PROGRESS;
+Qid MXID11000011701212378219753251307000000000206U3333300_336_S1
+Compile Start Time 2017/11/23 17:56:56.513528
+Compile End Time 2017/11/23 17:56:56.575220
+Compile Elapsed Time 0:00:00.061692
+Execute Start Time 2017/11/23 17:57:00.313805
+Execute End Time 2017/11/23 17:57:00.341117
+Execute Elapsed Time 0:00:00.027312
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2408,7 +2408,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/09/26 00:07:11.366701
+First Row Returned Time 2017/11/23 17:57:00.337861
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2416,33 +2416,33 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
No. of times executed 1
-Min. Execute Time 0.033737 secs
-Max. Execute Time 0.033737 secs
-Avg. Execute Time 0.033737 secs
+Min. Execute Time 0.027312 secs
+Max. Execute Time 0.027312 secs
+Avg. Execute Time 0.027312 secs
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 14,341
+SQL Process Busy Time 15,922
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 200 KB
-SQL Heap Used 78 KB
-SQL Heap WM 10,341 KB
+SQL Heap Allocated 1,032 KB
+SQL Heap Used 913 KB
+SQL Heap WM 11,175 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 39,728
+Request Message Bytes 40,016
Reply Message Count 15
Reply Message Bytes 42,528
Id DOP Table Name
EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime
1 2 TRAFODION.SCH.TSTAT
- 0 4 100 4 4 0 22,752 12,577
+ 0 4 100 4 4 0 17,013 9,595
Id TDBName Mode DOP TopN BMOPhase InterimRowCount CPUTime
BMOHeapUsed BMOHeapAllocated BMOHeapWM EstMemory BMOSpaceBufSz BMOSpaceBufCnt
ScrFileCnt ScrIOSize ScrIORead ScrIOWritten ScrIOTime ScrIOMaxTime
- 6 EX_HASH_GRBY DISK 2 -1 READ_ROWS 0 4,263
- 4 1,024 7,687 0.07 256 0
+ 6 EX_HASH_GRBY DISK 2 -1 READ_ROWS 0 3,392
+ 4 1,024 7,6870.07 256 0
0 -1 0 0 0 0
--- SQL operation complete.
@@ -2450,14 +2450,14 @@ Reply Message Bytes 42,528
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000031882212373144360231001000000000206U3333300_336_S1 DEFAULT;
-Qid MXID11000031882212373144360231001000000000206U3333300_336_S1
-Compile Start Time 2017/09/26 00:07:04.432712
-Compile End Time 2017/09/26 00:07:04.478608
-Compile Elapsed Time 0:00:00.045896
-Execute Start Time 2017/09/26 00:07:11.341441
-Execute End Time 2017/09/26 00:07:11.375178
-Execute Elapsed Time 0:00:00.033737
+>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_336_S1 DEFAULT;
+Qid MXID11000011701212378219753251307000000000206U3333300_336_S1
+Compile Start Time 2017/11/23 17:56:56.513528
+Compile End Time 2017/11/23 17:56:56.575220
+Compile Elapsed Time 0:00:00.061692
+Execute Start Time 2017/11/23 17:57:00.313805
+Execute End Time 2017/11/23 17:57:00.341117
+Execute Elapsed Time 0:00:00.027312
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2475,7 +2475,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/09/26 00:07:11.366701
+First Row Returned Time 2017/11/23 17:57:00.337861
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2483,34 +2483,34 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
No. of times executed 1
-Min. Execute Time 0.033737 secs
-Max. Execute Time 0.033737 secs
-Avg. Execute Time 0.033737 secs
+Min. Execute Time 0.027312 secs
+Max. Execute Time 0.027312 secs
+Avg. Execute Time 0.027312 secs
Stats Collection Type OPERATOR_STATS
LC RC Id PaId ExId Frag TDBName
<TRUNCATED>