You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by se...@apache.org on 2017/09/29 23:56:25 UTC
[02/13] incubator-trafodion git commit: [TRAFODION-2754] Get
statistics cores sqlci or mxosrvr at str_sprintf()
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/43c312df/core/sql/regress/core/EXPECTEDRTS
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/EXPECTEDRTS b/core/sql/regress/core/EXPECTEDRTS
index a12f581..a975e8b 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 MXID11000024709212367027407408000000000000206U3333300_302_S1
-Compile Start Time 2017/07/17 04:57:16.975498
-Compile End Time 2017/07/17 04:57:17.007581
-Compile Elapsed Time 0:00:00.032083
+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 -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 MXID11000024709212367027407408000000000000206U3333300_302_S1 ;
-Qid MXID11000024709212367027407408000000000000206U3333300_302_S1
-Compile Start Time 2017/07/17 04:57:16.975498
-Compile End Time 2017/07/17 04:57:17.007581
-Compile Elapsed Time 0:00:00.032083
+>>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 -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 MXID11000024709212367027407408000000000000206U3333300_302_S1 ;
-Qid MXID11000024709212367027407408000000000000206U3333300_302_S1
-Compile Start Time 2017/07/17 04:57:16.975498
-Compile End Time 2017/07/17 04:57:17.007581
-Compile Elapsed Time 0:00:00.032083
+>>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 -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 MXID11000024709212367027407408000000000000206U3333300_302_S1
-Compile Start Time 2017/07/17 04:57:16.975498
-Compile End Time 2017/07/17 04:57:17.007581
-Compile Elapsed Time 0:00:00.032083
+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 -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 MXID11000024709212367027407408000000000000206U3333300_302_S1
-Compile Start Time 2017/07/17 04:57:16.975498
-Compile End Time 2017/07/17 04:57:17.007581
-Compile Elapsed Time 0:00:00.032083
+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 -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 MXID11000024709212367027407408000000000000206U3333300_302_S1 ;
-Qid MXID11000024709212367027407408000000000000206U3333300_302_S1
-Compile Start Time 2017/07/17 04:57:16.975498
-Compile End Time 2017/07/17 04:57:17.007581
-Compile Elapsed Time 0:00:00.032083
-Execute Start Time 2017/07/17 04:57:23.613254
-Execute End Time 2017/07/17 04:57:26.843039
-Execute Elapsed Time 0:00:03.229785
+>>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
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/07/17 04:57:26.841272
+First Row Returned Time 2017/09/26 00:06:27.511111
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.229785 secs
-Max. Execute Time 3.229785 secs
-Avg. Execute Time 3.229785 secs
+Min. Execute Time 3.829638 secs
+Max. Execute Time 3.829638 secs
+Avg. Execute Time 3.829638 secs
Stats Collection Type ACCUMULATED_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 689,510
-SQL Process Busy Time 4,385,817
+SE IO MAX Time 789,718
+SQL Process Busy Time 5,000,157
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 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
Processes Created 2
-Process Create Time 141,744
+Process Create Time 161,427
Request Message Count 26
-Request Message Bytes 39,392
-Reply Message Count 15
-Reply Message Bytes 38,792
+Request Message Bytes 39,408
+Reply Message Count 14
+Reply Message Bytes 32,280
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 MXID11000024709212367027407408000000000000206U3333300_302_S1 ;
-Qid MXID11000024709212367027407408000000000000206U3333300_302_S1
-Compile Start Time 2017/07/17 04:57:16.975498
-Compile End Time 2017/07/17 04:57:17.007581
-Compile Elapsed Time 0:00:00.032083
-Execute Start Time 2017/07/17 04:57:23.613254
-Execute End Time 2017/07/17 04:57:26.843039
-Execute Elapsed Time 0:00:03.229785
+>>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
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/07/17 04:57:26.841272
+First Row Returned Time 2017/09/26 00:06:27.511111
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.229785 secs
-Max. Execute Time 3.229785 secs
-Avg. Execute Time 3.229785 secs
+Min. Execute Time 3.829638 secs
+Max. Execute Time 3.829638 secs
+Avg. Execute Time 3.829638 secs
Stats Collection Type ACCUMULATED_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 689,510
-SQL Process Busy Time 4,385,817
+SE IO MAX Time 789,718
+SQL Process Busy Time 5,000,157
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 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
Processes Created 2
-Process Create Time 141,744
+Process Create Time 161,427
Request Message Count 26
-Request Message Bytes 39,392
-Reply Message Count 15
-Reply Message Bytes 38,792
+Request Message Bytes 39,408
+Reply Message Count 14
+Reply Message Bytes 32,280
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 MXID11000024709212367027407408000000000000206U3333300_302_S1
-Compile Start Time 2017/07/17 04:57:16.975498
-Compile End Time 2017/07/17 04:57:17.007581
-Compile Elapsed Time 0:00:00.032083
-Execute Start Time 2017/07/17 04:57:23.613254
-Execute End Time 2017/07/17 04:57:26.843039
-Execute Elapsed Time 0:00:03.229785
+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
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/07/17 04:57:26.841272
+First Row Returned Time 2017/09/26 00:06:27.511111
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.229785 secs
-Max. Execute Time 3.229785 secs
-Avg. Execute Time 3.229785 secs
+Min. Execute Time 3.829638 secs
+Max. Execute Time 3.829638 secs
+Avg. Execute Time 3.829638 secs
Stats Collection Type ACCUMULATED_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 689,510
-SQL Process Busy Time 4,385,817
+SE IO MAX Time 789,718
+SQL Process Busy Time 5,000,157
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 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
Processes Created 2
-Process Create Time 141,744
+Process Create Time 161,427
Request Message Count 26
-Request Message Bytes 39,392
-Reply Message Count 15
-Reply Message Bytes 38,792
+Request Message Bytes 39,408
+Reply Message Count 14
+Reply Message Bytes 32,280
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 MXID11000024709212367027407408000000000000206U3333300_302_S1
-Compile Start Time 2017/07/17 04:57:16.975498
-Compile End Time 2017/07/17 04:57:17.007581
-Compile Elapsed Time 0:00:00.032083
-Execute Start Time 2017/07/17 04:57:23.613254
-Execute End Time 2017/07/17 04:57:26.843039
-Execute Elapsed Time 0:00:03.229785
+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
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/07/17 04:57:26.841272
+First Row Returned Time 2017/09/26 00:06:27.511111
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.229785 secs
-Max. Execute Time 3.229785 secs
-Avg. Execute Time 3.229785 secs
+Min. Execute Time 3.829638 secs
+Max. Execute Time 3.829638 secs
+Avg. Execute Time 3.829638 secs
Stats Collection Type ACCUMULATED_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 689,510
-SQL Process Busy Time 4,385,817
+SE IO MAX Time 789,718
+SQL Process Busy Time 5,000,157
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 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
Processes Created 2
-Process Create Time 141,744
+Process Create Time 161,427
Request Message Count 26
-Request Message Bytes 39,392
-Reply Message Count 15
-Reply Message Bytes 38,792
+Request Message Bytes 39,408
+Reply Message Count 14
+Reply Message Bytes 32,280
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 MXID11000024709212367027407408000000000000206U3333300_302_S1 ;
+>>display statistics for QID MXID11000031882212373144360231001000000000206U3333300_303_S1 ;
-*** ERROR[8923] The given Query Id MXID11000024709212367027407408000000000000206U3333300_302_S1 is not found.
+*** ERROR[8923] The given Query Id MXID11000031882212373144360231001000000000206U3333300_303_S1 is not found.
--- SQL operation failed with errors.
->>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_302_S1 ;
+>>get statistics for QID MXID11000031882212373144360231001000000000206U3333300_303_S1 ;
-*** ERROR[8923] The given Query Id MXID11000024709212367027407408000000000000206U3333300_302_S1 is not found.
+*** ERROR[8923] The given Query Id MXID11000031882212373144360231001000000000206U3333300_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 MXID11000024709212367027407408000000000000206U3333300_311_S1 ;
-Qid MXID11000024709212367027407408000000000000206U3333300_311_S1
-Compile Start Time 2017/07/17 04:57:33.096199
-Compile End Time 2017/07/17 04:57:33.096764
-Compile Elapsed Time 0:00:00.000565
+>>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
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 MXID11000024709212367027407408000000000000206U3333300_311_S1 ;
-Qid MXID11000024709212367027407408000000000000206U3333300_311_S1
-Compile Start Time 2017/07/17 04:57:33.096199
-Compile End Time 2017/07/17 04:57:33.096764
-Compile Elapsed Time 0:00:00.000565
+>>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
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 MXID11000024709212367027407408000000000000206U3333300_311_S1
-Compile Start Time 2017/07/17 04:57:33.096199
-Compile End Time 2017/07/17 04:57:33.096764
-Compile Elapsed Time 0:00:00.000565
+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
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 MXID11000024709212367027407408000000000000206U3333300_311_S1
-Compile Start Time 2017/07/17 04:57:33.096199
-Compile End Time 2017/07/17 04:57:33.096764
-Compile Elapsed Time 0:00:00.000565
+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
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 MXID11000024709212367027407408000000000000206U3333300_316_S1
-Compile Start Time 2017/07/17 04:57:39.632898
-Compile End Time 2017/07/17 04:57:39.665467
-Compile Elapsed Time 0:00:00.032569
+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 -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 MXID11000024709212367027407408000000000000206U3333300_316_S1 ;
-Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
-Compile Start Time 2017/07/17 04:57:39.632898
-Compile End Time 2017/07/17 04:57:39.665467
-Compile Elapsed Time 0:00:00.032569
+>>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 -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 MXID11000024709212367027407408000000000000206U3333300_316_S1 ;
-Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
-Compile Start Time 2017/07/17 04:57:39.632898
-Compile End Time 2017/07/17 04:57:39.665467
-Compile Elapsed Time 0:00:00.032569
+>>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 -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 MXID11000024709212367027407408000000000000206U3333300_316_S1 ACCUMULATED;
-Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
-Compile Start Time 2017/07/17 04:57:39.632898
-Compile End Time 2017/07/17 04:57:39.665467
-Compile Elapsed Time 0:00:00.032569
+>>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 -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 MXID11000024709212367027407408000000000000206U3333300_316_S1 ACCUMULATED;
-Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
-Compile Start Time 2017/07/17 04:57:39.632898
-Compile End Time 2017/07/17 04:57:39.665467
-Compile Elapsed Time 0:00:00.032569
+>>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 -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 MXID11000024709212367027407408000000000000206U3333300_316_S1
-Compile Start Time 2017/07/17 04:57:39.632898
-Compile End Time 2017/07/17 04:57:39.665467
-Compile Elapsed Time 0:00:00.032569
+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 -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 MXID11000024709212367027407408000000000000206U3333300_316_S1
-Compile Start Time 2017/07/17 04:57:39.632898
-Compile End Time 2017/07/17 04:57:39.665467
-Compile Elapsed Time 0:00:00.032569
+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 -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 MXID11000024709212367027407408000000000000206U3333300_316_S1
-Compile Start Time 2017/07/17 04:57:39.632898
-Compile End Time 2017/07/17 04:57:39.665467
-Compile Elapsed Time 0:00:00.032569
+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 -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 MXID11000024709212367027407408000000000000206U3333300_316_S1
-Compile Start Time 2017/07/17 04:57:39.632898
-Compile End Time 2017/07/17 04:57:39.665467
-Compile Elapsed Time 0:00:00.032569
+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 -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 MXID11000024709212367027407408000000000000206U3333300_316_S1 ;
-Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
-Compile Start Time 2017/07/17 04:57:39.632898
-Compile End Time 2017/07/17 04:57:39.665467
-Compile Elapsed Time 0:00:00.032569
-Execute Start Time 2017/07/17 04:57:49.683630
-Execute End Time 2017/07/17 04:57:49.695340
-Execute Elapsed Time 0:00:00.011710
+>>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
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/07/17 04:57:49.693689
+First Row Returned Time 2017/09/26 00:06:46.636794
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.011710 secs
-Max. Execute Time 0.011710 secs
-Avg. Execute Time 0.011710 secs
+Min. Execute Time 0.063858 secs
+Max. Execute Time 0.063858 secs
+Avg. Execute Time 0.063858 secs
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 5,776
+SQL Process Busy Time 16,866
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 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
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,552
+Request Message Bytes 39,568
Reply Message Count 15
Reply Message Bytes 39,208
BMO Space Buffer Size 0
@@ -1165,20 +1165,20 @@ Scr. Write Count 0
Scr. IO Max Time 0
Sort TopN -1
- Id DOP Table Name
+ 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 5,738 2,914
+ 1 2 TRAFODION.SCH.TSTAT
+ 0 4 100 4 4 0 53,929 46,340
--- SQL operation complete.
->>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_316_S1 ;
-Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
-Compile Start Time 2017/07/17 04:57:39.632898
-Compile End Time 2017/07/17 04:57:39.665467
-Compile Elapsed Time 0:00:00.032569
-Execute Start Time 2017/07/17 04:57:49.683630
-Execute End Time 2017/07/17 04:57:49.695340
-Execute Elapsed Time 0:00:00.011710
+>>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
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/07/17 04:57:49.693689
+First Row Returned Time 2017/09/26 00:06:46.636794
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.011710 secs
-Max. Execute Time 0.011710 secs
-Avg. Execute Time 0.011710 secs
+Min. Execute Time 0.063858 secs
+Max. Execute Time 0.063858 secs
+Avg. Execute Time 0.063858 secs
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 5,776
+SQL Process Busy Time 16,866
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 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
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,552
+Request Message Bytes 39,568
Reply Message Count 15
Reply Message Bytes 39,208
BMO Space Buffer Size 0
@@ -1232,24 +1232,24 @@ Scr. Write Count 0
Scr. IO Max Time 0
Sort TopN -1
- Id DOP Table Name
+ 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 5,738 2,914
+ 1 2 TRAFODION.SCH.TSTAT
+ 0 4 100 4 4 0 53,929 46,340
--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_316_S1 ACCUMULATED;
-Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
-Compile Start Time 2017/07/17 04:57:39.632898
-Compile End Time 2017/07/17 04:57:39.665467
-Compile Elapsed Time 0:00:00.032569
-Execute Start Time 2017/07/17 04:57:49.683630
-Execute End Time 2017/07/17 04:57:49.695340
-Execute Elapsed Time 0:00:00.011710
+>>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
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/07/17 04:57:49.693689
+First Row Returned Time 2017/09/26 00:06:46.636794
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.011710 secs
-Max. Execute Time 0.011710 secs
-Avg. Execute Time 0.011710 secs
+Min. Execute Time 0.063858 secs
+Max. Execute Time 0.063858 secs
+Avg. Execute Time 0.063858 secs
Stats Collection Type PERTABLE_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 2,914
-SQL Process Busy Time 5,776
+SE IO MAX Time 46,340
+SQL Process Busy Time 16,866
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 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
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,552
+Request Message Bytes 39,568
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 MXID11000024709212367027407408000000000000206U3333300_316_S1 ACCUMULATED;
-Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
-Compile Start Time 2017/07/17 04:57:39.632898
-Compile End Time 2017/07/17 04:57:39.665467
-Compile Elapsed Time 0:00:00.032569
-Execute Start Time 2017/07/17 04:57:49.683630
-Execute End Time 2017/07/17 04:57:49.695340
-Execute Elapsed Time 0:00:00.011710
+>>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
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/07/17 04:57:49.693689
+First Row Returned Time 2017/09/26 00:06:46.636794
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.011710 secs
-Max. Execute Time 0.011710 secs
-Avg. Execute Time 0.011710 secs
+Min. Execute Time 0.063858 secs
+Max. Execute Time 0.063858 secs
+Avg. Execute Time 0.063858 secs
Stats Collection Type PERTABLE_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 2,914
-SQL Process Busy Time 5,776
+SE IO MAX Time 46,340
+SQL Process Busy Time 16,866
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 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
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,552
+Request Message Bytes 39,568
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 MXID11000024709212367027407408000000000000206U3333300_316_S1
-Compile Start Time 2017/07/17 04:57:39.632898
-Compile End Time 2017/07/17 04:57:39.665467
-Compile Elapsed Time 0:00:00.032569
-Execute Start Time 2017/07/17 04:57:49.683630
-Execute End Time 2017/07/17 04:57:49.695340
-Execute Elapsed Time 0:00:00.011710
+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
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/07/17 04:57:49.693689
+First Row Returned Time 2017/09/26 00:06:46.636794
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.011710 secs
-Max. Execute Time 0.011710 secs
-Avg. Execute Time 0.011710 secs
+Min. Execute Time 0.063858 secs
+Max. Execute Time 0.063858 secs
+Avg. Execute Time 0.063858 secs
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 5,776
+SQL Process Busy Time 16,866
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 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
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,552
+Request Message Bytes 39,568
Reply Message Count 15
Reply Message Bytes 39,208
BMO Space Buffer Size 0
@@ -1438,20 +1438,20 @@ Scr. Write Count 0
Scr. IO Max Time 0
Sort TopN -1
- Id DOP Table Name
+ 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 5,738 2,914
+ 1 2 TRAFODION.SCH.TSTAT
+ 0 4 100 4 4 0 53,929 46,340
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
-Compile Start Time 2017/07/17 04:57:39.632898
-Compile End Time 2017/07/17 04:57:39.665467
-Compile Elapsed Time 0:00:00.032569
-Execute Start Time 2017/07/17 04:57:49.683630
-Execute End Time 2017/07/17 04:57:49.695340
-Execute Elapsed Time 0:00:00.011710
+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
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/07/17 04:57:49.693689
+First Row Returned Time 2017/09/26 00:06:46.636794
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.011710 secs
-Max. Execute Time 0.011710 secs
-Avg. Execute Time 0.011710 secs
+Min. Execute Time 0.063858 secs
+Max. Execute Time 0.063858 secs
+Avg. Execute Time 0.063858 secs
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 5,776
+SQL Process Busy Time 16,866
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 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
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,552
+Request Message Bytes 39,568
Reply Message Count 15
Reply Message Bytes 39,208
BMO Space Buffer Size 0
@@ -1505,20 +1505,20 @@ Scr. Write Count 0
Scr. IO Max Time 0
Sort TopN -1
- Id DOP Table Name
+ 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 5,738 2,914
+ 1 2 TRAFODION.SCH.TSTAT
+ 0 4 100 4 4 0 53,929 46,340
--- SQL operation complete.
>>display statistics for qid current accumulated;
-Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
-Compile Start Time 2017/07/17 04:57:39.632898
-Compile End Time 2017/07/17 04:57:39.665467
-Compile Elapsed Time 0:00:00.032569
-Execute Start Time 2017/07/17 04:57:49.683630
-Execute End Time 2017/07/17 04:57:49.695340
-Execute Elapsed Time 0:00:00.011710
+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
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/07/17 04:57:49.693689
+First Row Returned Time 2017/09/26 00:06:46.636794
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.011710 secs
-Max. Execute Time 0.011710 secs
-Avg. Execute Time 0.011710 secs
+Min. Execute Time 0.063858 secs
+Max. Execute Time 0.063858 secs
+Avg. Execute Time 0.063858 secs
Stats Collection Type PERTABLE_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 2,914
-SQL Process Busy Time 5,776
+SE IO MAX Time 46,340
+SQL Process Busy Time 16,866
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 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
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,552
+Request Message Bytes 39,568
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 MXID11000024709212367027407408000000000000206U3333300_316_S1
-Compile Start Time 2017/07/17 04:57:39.632898
-Compile End Time 2017/07/17 04:57:39.665467
-Compile Elapsed Time 0:00:00.032569
-Execute Start Time 2017/07/17 04:57:49.683630
-Execute End Time 2017/07/17 04:57:49.695340
-Execute Elapsed Time 0:00:00.011710
+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
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/07/17 04:57:49.693689
+First Row Returned Time 2017/09/26 00:06:46.636794
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.011710 secs
-Max. Execute Time 0.011710 secs
-Avg. Execute Time 0.011710 secs
+Min. Execute Time 0.063858 secs
+Max. Execute Time 0.063858 secs
+Avg. Execute Time 0.063858 secs
Stats Collection Type PERTABLE_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 2,914
-SQL Process Busy Time 5,776
+SE IO MAX Time 46,340
+SQL Process Busy Time 16,866
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 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
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,552
+Request Message Bytes 39,568
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 'MXID11000024709212367027407408000000000000206U3333300_316_S1';
+>>SET SESSION DEFAULT PARENT_QID 'MXID11000031882212373144360231001000000000206U3333300_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 MXID11000024709212367027407408000000000000206U3333300_330_S1 ;
-Qid MXID11000024709212367027407408000000000000206U3333300_330_S1
-Compile Start Time 2017/07/17 04:57:56.670883
-Compile End Time 2017/07/17 04:57:56.671315
-Compile Elapsed Time 0:00:00.000432
+>>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
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 MXID11000024709212367027407408000000000000206U3333300_316_S1
+Parent Qid MXID11000031882212373144360231001000000000206U3333300_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 MXID11000024709212367027407408000000000000206U3333300_330_S1 ;
-Qid MXID11000024709212367027407408000000000000206U3333300_330_S1
-Compile Start Time 2017/07/17 04:57:56.670883
-Compile End Time 2017/07/17 04:57:56.671315
-Compile Elapsed Time 0:00:00.000432
+>>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
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 MXID11000024709212367027407408000000000000206U3333300_316_S1
+Parent Qid MXID11000031882212373144360231001000000000206U3333300_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 MXID11000024709212367027407408000000000000206U3333300_332_S1 ;
-Qid MXID11000024709212367027407408000000000000206U3333300_332_S1
-Compile Start Time 2017/07/17 04:57:59.906249
-Compile End Time 2017/07/17 04:57:59.906902
-Compile Elapsed Time 0:00:00.000653
+>>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
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 MXID11000024709212367027407408000000000000206U3333300_332_S1 ;
-Qid MXID11000024709212367027407408000000000000206U3333300_332_S1
-Compile Start Time 2017/07/17 04:57:59.906249
-Compile End Time 2017/07/17 04:57:59.906902
-Compile Elapsed Time 0:00:00.000653
+>>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
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 MXID11000024709212367027407408000000000000206U3333300_335_S1 ;
-Qid MXID11000024709212367027407408000000000000206U3333300_335_S1
-Compile Start Time 2017/07/17 04:58:06.342753
-Compile End Time 2017/07/17 04:58:06.391558
-Compile Elapsed Time 0:00:00.048805
+>>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 -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 MXID11000024709212367027407408000000000000206U3333300_335_S1 ;
-Qid MXID11000024709212367027407408000000000000206U3333300_335_S1
-Compile Start Time 2017/07/17 04:58:06.342753
-Compile End Time 2017/07/17 04:58:06.391558
-Compile Elapsed Time 0:00:00.048805
+>>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 -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 MXID11000024709212367027407408000000000000206U3333300_335_S1 ;
-Qid MXID11000024709212367027407408000000000000206U3333300_335_S1
-Compile Start Time 2017/07/17 04:58:06.342753
-Compile End Time 2017/07/17 04:58:06.391558
-Compile Elapsed Time 0:00:00.048805
-Execute Start Time 2017/07/17 04:58:09.741408
-Execute End Time 2017/07/17 04:58:09.757985
-Execute Elapsed Time 0:00:00.016577
+>>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
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/07/17 04:58:09.756320
+First Row Returned Time 2017/09/26 00:07:11.366701
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.016577 secs
-Max. Execute Time 0.016577 secs
-Avg. Execute Time 0.016577 secs
+Min. Execute Time 0.033737 secs
+Max. Execute Time 0.033737 secs
+Avg. Execute Time 0.033737 secs
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
+ LC RC Id PaId ExId Frag TDB Name DOP Dispatches Oper CPU Time Est. Records Used Act. Records Used Details
-10 . 11 . 5 0 EX_ROOT 1 5 10 0 4 1694
-9 . 10 11 4 0 EX_SPLIT_TOP 1 5 10 2 4
-8 . 9 10 4 0 EX_SEND_TOP 2 10 1,674 2 4
-7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 119 2 4
-6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 7 2 4 3201
-5 . 6 7 3 2 EX_HASH_GRBY 2 6 2,283 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 781 100 4
-2 . 3 4 2 3 EX_SEND_BOTTOM 4 31 154 100 4
-1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 13 100 4 3346
-. . 1 2 1 3 EX_TRAF_KEY_SELECT 2 4 3,179 100 4 TRAFODION.SCH.TSTAT|4|176
+ 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
--- SQL operation complete.
->>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_335_S1 ;
-Qid MXID11000024709212367027407408000000000000206U3333300_335_S1
-Compile Start Time 2017/07/17 04:58:06.342753
-Compile End Time 2017/07/17 04:58:06.391558
-Compile Elapsed Time 0:00:00.048805
-Execute Start Time 2017/07/17 04:58:09.741408
-Execute End Time 2017/07/17 04:58:09.757985
-Execute Elapsed Time 0:00:00.016577
+>>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
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/07/17 04:58:09.756320
+First Row Returned Time 2017/09/26 00:07:11.366701
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.016577 secs
-Max. Execute Time 0.016577 secs
-Avg. Execute Time 0.016577 secs
+Min. Execute Time 0.033737 secs
+Max. Execute Time 0.033737 secs
+Avg. Execute Time 0.033737 secs
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
+ LC RC Id PaId ExId Frag TDB Name DOP Dispatches Oper CPU Time Est. Records Used Act. Records Used Details
-10 . 11 . 5 0 EX_ROOT 1 5 10 0 4 1694
-9 . 10 11 4 0 EX_SPLIT_TOP 1 5 10 2 4
-8 . 9 10 4 0 EX_SEND_TOP 2 10 1,674 2 4
-7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 119 2 4
-6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 7 2 4 3201
-5 . 6 7 3 2 EX_HASH_GRBY 2 6 2,283 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 781 100 4
-2 . 3 4 2 3 EX_SEND_BOTTOM 4 31 154 100 4
-1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 13 100 4 3346
-. . 1 2 1 3 EX_TRAF_KEY_SELECT 2 4 3,179 100 4 TRAFODION.SCH.TSTAT|4|176
+ 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
--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_335_S1 ACCUMULATED;
-Qid MXID11000024709212367027407408000000000000206U3333300_335_S1
-Compile Start Time 2017/07/17 04:58:06.342753
-Compile End Time 2017/07/17 04:58:06.391558
-Compile Elapsed Time 0:00:00.048805
-Execute Start Time 2017/07/17 04:58:09.741408
-Execute End Time 2017/07/17 04:58:09.757985
-Execute Elapsed Time 0:00:00.016577
+>>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
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/07/17 04:58:09.756320
+First Row Returned Time 2017/09/26 00:07:11.366701
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.016577 secs
-Max. Execute Time 0.016577 secs
-Avg. Execute Time 0.016577 secs
+Min. Execute Time 0.033737 secs
+Max. Execute Time 0.033737 secs
+Avg. Execute Time 0.033737 secs
Stats Collection Type OPERATOR_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 5,606
-SQL Process Busy Time 8,241
+SE IO MAX Time 12,577
+SQL Process Busy Time 14,341
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 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
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 39,712
+Request Message Bytes 39,728
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 MXID11000024709212367027407408000000000000206U3333300_335_S1 ACCUMULATED;
-Qid MXID11000024709212367027407408000000000000206U3333300_335_S1
-Compile Start Time 2017/07/17 04:58:06.342753
-Compile End Time 2017/07/17 04:58:06.391558
-Compile Elapsed Time 0:00:00.048805
-Execute Start Time 2017/07/17 04:58:09.741408
-Execute End Time 2017/07/17 04:58:09.757985
-Execute Elapsed Time 0:00:00.016577
+>>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
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/07/17 04:58:09.756320
+First Row Returned Time 2017/09/26 00:07:11.366701
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.016577 secs
-Max. Execute Time 0.016577 secs
-Avg. Execute Time 0.016577 secs
+Min. Execute Time 0.033737 secs
+Max. Execute Time 0.033737 secs
+Avg. Execute Time 0.033737 secs
Stats Collection Type OPERATOR_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 5,606
-SQL Process Busy Time 8,241
+SE IO MAX Time 12,577
+SQL Process Busy Time 14,341
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 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
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 39,712
+Request Message Bytes 39,728
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 MXID11000024709212367027407408000000000000206U3333300_335_S1 PERTABLE;
-Qid MXID11000024709212367027407408000000000000206U3333300_335_S1
-Compile Start Time 2017/07/17 04:58:06.342753
-Compile End Time 2017/07/17 04:58:06.391558
-Compile Elapsed Time 0:00:00.048805
-Execute Start Time 2017/07/17 04:58:09.741408
-Execute End Time 2017/07/17 04:58:09.757985
-Execute Elapsed Time 0:00:00.016577
+>>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
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/07/17 04:58:09.756320
+First Row Returned Time 2017/09/26 00:07:11.366701
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.016577 secs
-Max. Execute Time 0.016577 secs
-Avg. Execute Time 0.016577 secs
+Min. Execute Time 0.033737 secs
+Max. Execute Time 0.033737 secs
+Avg. Execute Time 0.033737 secs
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 8,241
+SQL Process Busy Time 14,341
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 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
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 39,712
+Request Message Bytes 39,728
Reply Message Count 15
Reply Message Bytes 42,528
BMO Space Buffer Size 256
@@ -2243,20 +2243,20 @@ Scr. Write Count 0
Scr. IO Max Time 0
Sort TopN -1
- Id DOP Table Name
+ 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 9,682 5,606
+ 1 2 TRAFODION.SCH.TSTAT
+ 0 4 100 4 4 0 22,752 12,577
--- SQL operation complete.
->>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_335_S1 PERTABLE;
-Qid MXID11000024709212367027407408000000000000206U3333300_335_S1
-Compile Start Time 2017/07/17 04:58:06.342753
-Compile End Time 2017/07/17 04:58:06.391558
-Compile Elapsed Time 0:00:00.048805
-Execute Start Time 2017/07/17 04:58:09.741408
-Execute End Time 2017/07/17 04:58:09.757985
-Execute Elapsed Time 0:00:00.016577
+>>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
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/07/17 04:58:09.756320
+First Row Returned Time 2017/09/26 00:07:11.366701
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.016577 secs
-Max. Execute Time 0.016577 secs
-Avg. Execute Time 0.016577 secs
+Min. Execute Time 0.033737 secs
+Max. Execute Time 0.033737 secs
+Avg. Execute Time 0.033737 secs
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 8,241
+SQL Process Busy Time 14,341
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 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
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 39,712
+Request Message Bytes 39,728
Reply Message Count 15
Reply Message Bytes 42,528
BMO Space Buffer Size 256
@@ -2310,24 +2310,24 @@ Scr. Write Count 0
Scr. IO Max Time 0
Sort TopN -1
- Id DOP Table Name
+ 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 9,682 5,606
+ 1 2 TRAFODION.SCH.TSTAT
+ 0 4 100 4 4 0 22,752 12,577
--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_335_S1 PROGRESS;
-Qid MXID11000024709212367027407408000000000000206U3333300_335_S1
-Compile Start Time 2017/07/17 04:58:06.342753
-Compile End Time 2017/07/17 04:58:06.391558
-Compile Elapsed Time 0:00:00.048805
-Execute Start Time 2017/07/17 04:58:09.741408
-Execute End Time 2017/07/17 04:58:09.757985
-Execute Elapsed Time 0:00:00.016577
+>>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
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/07/17 04:58:09.756320
+First Row Returned Time 2017/09/26 00:07:11.366701
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.016577 secs
-Max. Execute Time 0.016577 secs
-Avg. Execute Time 0.016577 secs
+Min. Execute Time 0.033737 secs
+Max. Execute Time 0.033737 secs
+Avg. Execute Time 0.033737 secs
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 8,241
-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 Process Busy Time 14,341
+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
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 39,712
+Request Message Bytes 39,728
Reply Message Count 15
Reply Message Bytes 42,528
- Id DOP Table Name
+ 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 9,682 5,606
+ 1 2 TRAFODION.SCH.TSTAT
+ 0 4 100 4 4 0 22,752 12,577
Id TDBName Mode DOP TopN BMOPhase InterimRowCount CPUTime
- BMOHeapUsed BMOHeapAllocated BMOHeapWM BMOSpaceBufSz BMOSpaceBufCnt
+ BMOHeapUsed BMOHeapAllocated BMOHeapWM EstMemory BMOSpaceBufSz BMOSpaceBufCnt
ScrFileCnt ScrIOSize ScrIORead ScrIOWritten ScrIOTime ScrIOMaxTime
- 6 EX_HASH_GRBY DISK 2 -1 READ_ROWS 0 2,283
- 4 1,024 7,687 256 0
+ 6 EX_HASH_GRBY DISK 2 -1 READ_ROWS 0 4,263
+ 4 1,024 7,687 0.07 256 0
0 -1 0 0 0 0
--- SQL operation complete.
->>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_335_S1 PROGRESS;
-Qid MXID11000024709212367027407408000000000000206U3333300_335_S1
-Compile Start Time 2017/07/17 04:58:06.342753
-Compile End Time 2017/07/17 04:58:06.391558
-Compile Elapsed Time 0:00:00.048805
-Execute Start Time 2017/07/17 04:58:09.741408
-Execute End Time 2017/07/17 04:58:09.757985
-Execute Elapsed Time 0:00:00.016577
+>>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
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/07/17 04:58:09.756320
+First Row Returned Time 2017/09/26 00:07:11.366701
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.016577 secs
-Max. Execute Time 0.016577 secs
-Avg. Execute Time 0.016577 secs
+Min. Execute Time 0.033737 secs
+Max. Execute Time 0.033737 secs
+Avg. Execute Time 0.033737 secs
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 8,241
-SQL
<TRUNCATED>