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/07/18 18:06:55 UTC
[2/4] incubator-trafodion git commit: [TRAFODION-2420] RMS
enhancements
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/419c843a/core/sql/regress/core/EXPECTEDRTS
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/EXPECTEDRTS b/core/sql/regress/core/EXPECTEDRTS
old mode 100755
new mode 100644
index b6273bb..a12f581
--- 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 MXID11000004343212360895605883001000000000206U3333300_279_S1
-Compile Start Time 2017/05/07 05:40:25.200093
-Compile End Time 2017/05/07 05:40:25.230566
-Compile Elapsed Time 0:00:00.030473
+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 -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -87,6 +87,10 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
@@ -94,11 +98,11 @@ Stats Collection Type ACCUMULATED_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_279_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_279_S1
-Compile Start Time 2017/05/07 05:40:25.200093
-Compile End Time 2017/05/07 05:40:25.230566
-Compile Elapsed Time 0:00:00.030473
+>>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 -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -126,14 +130,18 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_279_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_279_S1
-Compile Start Time 2017/05/07 05:40:25.200093
-Compile End Time 2017/05/07 05:40:25.230566
-Compile Elapsed Time 0:00:00.030473
+>>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 -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -161,15 +169,19 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000004343212360895605883001000000000206U3333300_279_S1
-Compile Start Time 2017/05/07 05:40:25.200093
-Compile End Time 2017/05/07 05:40:25.230566
-Compile Elapsed Time 0:00:00.030473
+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 -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -197,14 +209,18 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000004343212360895605883001000000000206U3333300_279_S1
-Compile Start Time 2017/05/07 05:40:25.200093
-Compile End Time 2017/05/07 05:40:25.230566
-Compile Elapsed Time 0:00:00.030473
+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 -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -232,6 +248,10 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
@@ -250,14 +270,14 @@ D
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_279_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_279_S1
-Compile Start Time 2017/05/07 05:40:25.200093
-Compile End Time 2017/05/07 05:40:25.230566
-Compile Elapsed Time 0:00:00.030473
-Execute Start Time 2017/05/07 05:40:29.596727
-Execute End Time 2017/05/07 05:40:34.141843
-Execute Elapsed Time 0:00:04.545116
+>>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
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -275,32 +295,36 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:40:34.139345
+First Row Returned Time 2017/07/17 04:57:26.841272
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
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
Stats Collection Type ACCUMULATED_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 725,870
-SQL Process Busy Time 5,717,075
+SE IO MAX Time 689,510
+SQL Process Busy Time 4,385,817
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 10,472 KB
+SQL Heap Allocated 10,471 KB
SQL Heap Used 80 KB
SQL Heap WM 67 KB
Processes Created 2
-Process Create Time 150,942
+Process Create Time 141,744
Request Message Count 26
-Request Message Bytes 39,808
+Request Message Bytes 39,392
Reply Message Count 15
-Reply Message Bytes 38,840
+Reply Message Bytes 38,792
BMO Space Buffer Size 0
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -313,14 +337,14 @@ Scr. IO Max Time 0
Sort TopN -1
--- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_279_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_279_S1
-Compile Start Time 2017/05/07 05:40:25.200093
-Compile End Time 2017/05/07 05:40:25.230566
-Compile Elapsed Time 0:00:00.030473
-Execute Start Time 2017/05/07 05:40:29.596727
-Execute End Time 2017/05/07 05:40:34.141843
-Execute Elapsed Time 0:00:04.545116
+>>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
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -338,32 +362,36 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:40:34.139345
+First Row Returned Time 2017/07/17 04:57:26.841272
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
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
Stats Collection Type ACCUMULATED_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 725,870
-SQL Process Busy Time 5,717,075
+SE IO MAX Time 689,510
+SQL Process Busy Time 4,385,817
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 10,472 KB
+SQL Heap Allocated 10,471 KB
SQL Heap Used 80 KB
SQL Heap WM 67 KB
Processes Created 2
-Process Create Time 150,942
+Process Create Time 141,744
Request Message Count 26
-Request Message Bytes 39,808
+Request Message Bytes 39,392
Reply Message Count 15
-Reply Message Bytes 38,840
+Reply Message Bytes 38,792
BMO Space Buffer Size 0
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -378,13 +406,13 @@ Sort TopN -1
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000004343212360895605883001000000000206U3333300_279_S1
-Compile Start Time 2017/05/07 05:40:25.200093
-Compile End Time 2017/05/07 05:40:25.230566
-Compile Elapsed Time 0:00:00.030473
-Execute Start Time 2017/05/07 05:40:29.596727
-Execute End Time 2017/05/07 05:40:34.141843
-Execute Elapsed Time 0:00:04.545116
+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
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -402,32 +430,36 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:40:34.139345
+First Row Returned Time 2017/07/17 04:57:26.841272
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
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
Stats Collection Type ACCUMULATED_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 725,870
-SQL Process Busy Time 5,717,075
+SE IO MAX Time 689,510
+SQL Process Busy Time 4,385,817
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 10,472 KB
+SQL Heap Allocated 10,471 KB
SQL Heap Used 80 KB
SQL Heap WM 67 KB
Processes Created 2
-Process Create Time 150,942
+Process Create Time 141,744
Request Message Count 26
-Request Message Bytes 39,808
+Request Message Bytes 39,392
Reply Message Count 15
-Reply Message Bytes 38,840
+Reply Message Bytes 38,792
BMO Space Buffer Size 0
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -441,13 +473,13 @@ Sort TopN -1
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000004343212360895605883001000000000206U3333300_279_S1
-Compile Start Time 2017/05/07 05:40:25.200093
-Compile End Time 2017/05/07 05:40:25.230566
-Compile Elapsed Time 0:00:00.030473
-Execute Start Time 2017/05/07 05:40:29.596727
-Execute End Time 2017/05/07 05:40:34.141843
-Execute Elapsed Time 0:00:04.545116
+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
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -465,32 +497,36 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:40:34.139345
+First Row Returned Time 2017/07/17 04:57:26.841272
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
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
Stats Collection Type ACCUMULATED_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 725,870
-SQL Process Busy Time 5,717,075
+SE IO MAX Time 689,510
+SQL Process Busy Time 4,385,817
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 10,472 KB
+SQL Heap Allocated 10,471 KB
SQL Heap Used 80 KB
SQL Heap WM 67 KB
Processes Created 2
-Process Create Time 150,942
+Process Create Time 141,744
Request Message Count 26
-Request Message Bytes 39,808
+Request Message Bytes 39,392
Reply Message Count 15
-Reply Message Bytes 38,840
+Reply Message Bytes 38,792
BMO Space Buffer Size 0
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -510,25 +546,25 @@ Sort TopN -1
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_279_S1 ;
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_302_S1 ;
-*** ERROR[8923] The given Query Id MXID11000004343212360895605883001000000000206U3333300_279_S1 is not found.
+*** ERROR[8923] The given Query Id MXID11000024709212367027407408000000000000206U3333300_302_S1 is not found.
--- SQL operation failed with errors.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_279_S1 ;
+>>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_302_S1 ;
-*** ERROR[8923] The given Query Id MXID11000004343212360895605883001000000000206U3333300_279_S1 is not found.
+*** ERROR[8923] The given Query Id MXID11000024709212367027407408000000000000206U3333300_302_S1 is not found.
--- SQL operation failed with errors.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_288_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_288_S1
-Compile Start Time 2017/05/07 05:40:41.529514
-Compile End Time 2017/05/07 05:40:41.530838
-Compile Elapsed Time 0:00:00.001324
+>>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
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -556,14 +592,18 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_288_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_288_S1
-Compile Start Time 2017/05/07 05:40:41.529514
-Compile End Time 2017/05/07 05:40:41.530838
-Compile Elapsed Time 0:00:00.001324
+>>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
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -591,15 +631,19 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000004343212360895605883001000000000206U3333300_288_S1
-Compile Start Time 2017/05/07 05:40:41.529514
-Compile End Time 2017/05/07 05:40:41.530838
-Compile Elapsed Time 0:00:00.001324
+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
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -627,14 +671,18 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000004343212360895605883001000000000206U3333300_288_S1
-Compile Start Time 2017/05/07 05:40:41.529514
-Compile End Time 2017/05/07 05:40:41.530838
-Compile Elapsed Time 0:00:00.001324
+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
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -662,6 +710,10 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
@@ -678,10 +730,10 @@ Stats Collection Type ACCUMULATED_STATS
--- SQL command prepared.
>>log;
>>get statistics for qid current ;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
+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 -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -709,6 +761,10 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
@@ -716,11 +772,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_293_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
+>>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 -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -748,14 +804,18 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_293_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
+>>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 -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -783,6 +843,10 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
@@ -790,11 +854,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_293_S1 ACCUMULATED;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
+>>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 -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -822,14 +886,18 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_293_S1 ACCUMULATED;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
+>>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 -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -857,15 +925,19 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
+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 -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -893,14 +965,18 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
+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 -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -928,14 +1004,18 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>display statistics for qid current accumulated ;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
+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 -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -963,14 +1043,18 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>get statistics for qid current accumulated ;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
+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 -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -998,6 +1082,10 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
@@ -1006,24 +1094,24 @@ Stats Collection Type PERTABLE_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 MXID11000004343212360895605883001000000000206U3333300_293_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
-Execute Start Time 2017/05/07 05:40:58.496745
-Execute End Time 2017/05/07 05:40:58.522185
-Execute Elapsed Time 0:00:00.025440
+>>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
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1041,15 +1129,19 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:40:58.520309
+First Row Returned Time 2017/07/17 04:57:49.693689
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
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
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 15,419
+SQL Process Busy Time 5,776
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
@@ -1059,9 +1151,9 @@ SQL Heap WM 10,338 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,968
+Request Message Bytes 39,552
Reply Message Count 15
-Reply Message Bytes 39,264
+Reply Message Bytes 39,208
BMO Space Buffer Size 0
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -1074,19 +1166,19 @@ Scr. IO Max Time 0
Sort TopN -1
Id DOP Table Name
- EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime
+ 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 20,398 10,610
+ 0 4 100 4 4 0 5,738 2,914
--- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_293_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
-Execute Start Time 2017/05/07 05:40:58.496745
-Execute End Time 2017/05/07 05:40:58.522185
-Execute Elapsed Time 0:00:00.025440
+>>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
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1104,15 +1196,19 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:40:58.520309
+First Row Returned Time 2017/07/17 04:57:49.693689
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
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
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 15,419
+SQL Process Busy Time 5,776
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
@@ -1122,9 +1218,9 @@ SQL Heap WM 10,338 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,968
+Request Message Bytes 39,552
Reply Message Count 15
-Reply Message Bytes 39,264
+Reply Message Bytes 39,208
BMO Space Buffer Size 0
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -1137,23 +1233,23 @@ Scr. IO Max Time 0
Sort TopN -1
Id DOP Table Name
- EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime
+ 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 20,398 10,610
+ 0 4 100 4 4 0 5,738 2,914
--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_293_S1 ACCUMULATED;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
-Execute Start Time 2017/05/07 05:40:58.496745
-Execute End Time 2017/05/07 05:40:58.522185
-Execute Elapsed Time 0:00:00.025440
+>>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
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1171,20 +1267,24 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:40:58.520309
+First Row Returned Time 2017/07/17 04:57:49.693689
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
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
Stats Collection Type PERTABLE_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 10,610
-SQL Process Busy Time 15,419
+SE IO MAX Time 2,914
+SQL Process Busy Time 5,776
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
@@ -1194,9 +1294,9 @@ SQL Heap WM 10,338 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,968
+Request Message Bytes 39,552
Reply Message Count 15
-Reply Message Bytes 39,264
+Reply Message Bytes 39,208
BMO Space Buffer Size 0
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -1209,14 +1309,14 @@ Scr. IO Max Time 0
Sort TopN -1
--- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_293_S1 ACCUMULATED;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
-Execute Start Time 2017/05/07 05:40:58.496745
-Execute End Time 2017/05/07 05:40:58.522185
-Execute Elapsed Time 0:00:00.025440
+>>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
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1234,20 +1334,24 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:40:58.520309
+First Row Returned Time 2017/07/17 04:57:49.693689
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
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
Stats Collection Type PERTABLE_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 10,610
-SQL Process Busy Time 15,419
+SE IO MAX Time 2,914
+SQL Process Busy Time 5,776
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
@@ -1257,9 +1361,9 @@ SQL Heap WM 10,338 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,968
+Request Message Bytes 39,552
Reply Message Count 15
-Reply Message Bytes 39,264
+Reply Message Bytes 39,208
BMO Space Buffer Size 0
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -1274,13 +1378,13 @@ Sort TopN -1
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
-Execute Start Time 2017/05/07 05:40:58.496745
-Execute End Time 2017/05/07 05:40:58.522185
-Execute Elapsed Time 0:00:00.025440
+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
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1298,15 +1402,19 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:40:58.520309
+First Row Returned Time 2017/07/17 04:57:49.693689
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
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
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 15,419
+SQL Process Busy Time 5,776
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
@@ -1316,9 +1424,9 @@ SQL Heap WM 10,338 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,968
+Request Message Bytes 39,552
Reply Message Count 15
-Reply Message Bytes 39,264
+Reply Message Bytes 39,208
BMO Space Buffer Size 0
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -1331,19 +1439,19 @@ Scr. IO Max Time 0
Sort TopN -1
Id DOP Table Name
- EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime
+ 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 20,398 10,610
+ 0 4 100 4 4 0 5,738 2,914
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
-Execute Start Time 2017/05/07 05:40:58.496745
-Execute End Time 2017/05/07 05:40:58.522185
-Execute Elapsed Time 0:00:00.025440
+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
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1361,15 +1469,19 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:40:58.520309
+First Row Returned Time 2017/07/17 04:57:49.693689
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
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
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 15,419
+SQL Process Busy Time 5,776
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
@@ -1379,9 +1491,9 @@ SQL Heap WM 10,338 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,968
+Request Message Bytes 39,552
Reply Message Count 15
-Reply Message Bytes 39,264
+Reply Message Bytes 39,208
BMO Space Buffer Size 0
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -1394,19 +1506,19 @@ Scr. IO Max Time 0
Sort TopN -1
Id DOP Table Name
- EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime
+ 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 20,398 10,610
+ 0 4 100 4 4 0 5,738 2,914
--- SQL operation complete.
>>display statistics for qid current accumulated;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
-Execute Start Time 2017/05/07 05:40:58.496745
-Execute End Time 2017/05/07 05:40:58.522185
-Execute Elapsed Time 0:00:00.025440
+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
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1424,20 +1536,24 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:40:58.520309
+First Row Returned Time 2017/07/17 04:57:49.693689
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
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
Stats Collection Type PERTABLE_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 10,610
-SQL Process Busy Time 15,419
+SE IO MAX Time 2,914
+SQL Process Busy Time 5,776
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
@@ -1447,9 +1563,9 @@ SQL Heap WM 10,338 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,968
+Request Message Bytes 39,552
Reply Message Count 15
-Reply Message Bytes 39,264
+Reply Message Bytes 39,208
BMO Space Buffer Size 0
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -1463,13 +1579,13 @@ Sort TopN -1
--- SQL operation complete.
>>get statistics for qid current accumulated;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
-Execute Start Time 2017/05/07 05:40:58.496745
-Execute End Time 2017/05/07 05:40:58.522185
-Execute Elapsed Time 0:00:00.025440
+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
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1487,20 +1603,24 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:40:58.520309
+First Row Returned Time 2017/07/17 04:57:49.693689
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
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
Stats Collection Type PERTABLE_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 10,610
-SQL Process Busy Time 15,419
+SE IO MAX Time 2,914
+SQL Process Busy Time 5,776
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
@@ -1510,9 +1630,9 @@ SQL Heap WM 10,338 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,968
+Request Message Bytes 39,552
Reply Message Count 15
-Reply Message Bytes 39,264
+Reply Message Bytes 39,208
BMO Space Buffer Size 0
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -1527,7 +1647,7 @@ Sort TopN -1
--- SQL operation complete.
>>log;
>>obey PQIDOUT;
->>SET SESSION DEFAULT PARENT_QID 'MXID11000004343212360895605883001000000000206U3333300_293_S1';
+>>SET SESSION DEFAULT PARENT_QID 'MXID11000024709212367027407408000000000000206U3333300_316_S1';
--- SQL operation complete.
>>prepare s1 from select distinct d from tstat ;
@@ -1537,11 +1657,11 @@ Sort TopN -1
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_307_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_307_S1
-Compile Start Time 2017/05/07 05:41:07.096980
-Compile End Time 2017/05/07 05:41:07.097700
-Compile Elapsed Time 0:00:00.000720
+>>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
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1553,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 MXID11000004343212360895605883001000000000206U3333300_293_S1
+Parent Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
Parent Query System SAME
Child Qid NONE
Number of SQL Processes 1
@@ -1569,14 +1689,18 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_307_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_307_S1
-Compile Start Time 2017/05/07 05:41:07.096980
-Compile End Time 2017/05/07 05:41:07.097700
-Compile Elapsed Time 0:00:00.000720
+>>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
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1588,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 MXID11000004343212360895605883001000000000206U3333300_293_S1
+Parent Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
Parent Query System SAME
Child Qid NONE
Number of SQL Processes 1
@@ -1604,6 +1728,10 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
@@ -1618,11 +1746,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_309_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_309_S1
-Compile Start Time 2017/05/07 05:41:17.587174
-Compile End Time 2017/05/07 05:41:17.588229
-Compile Elapsed Time 0:00:00.001055
+>>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
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1650,14 +1778,18 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_309_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_309_S1
-Compile Start Time 2017/05/07 05:41:17.587174
-Compile End Time 2017/05/07 05:41:17.588229
-Compile Elapsed Time 0:00:00.001055
+>>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
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1685,6 +1817,10 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
@@ -1704,11 +1840,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_312_S1
-Compile Start Time 2017/05/07 05:41:21.930615
-Compile End Time 2017/05/07 05:41:21.967829
-Compile Elapsed Time 0:00:00.037214
+>>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 -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1736,14 +1872,18 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type OPERATOR_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_312_S1
-Compile Start Time 2017/05/07 05:41:21.930615
-Compile End Time 2017/05/07 05:41:21.967829
-Compile Elapsed Time 0:00:00.037214
+>>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 -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1771,6 +1911,10 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type OPERATOR_STATS
--- SQL operation complete.
@@ -1790,14 +1934,14 @@ D
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_312_S1
-Compile Start Time 2017/05/07 05:41:21.930615
-Compile End Time 2017/05/07 05:41:21.967829
-Compile Elapsed Time 0:00:00.037214
-Execute Start Time 2017/05/07 05:41:26.529910
-Execute End Time 2017/05/07 05:41:26.567047
-Execute Elapsed Time 0:00:00.037137
+>>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
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1815,38 +1959,42 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:41:26.564755
+First Row Returned Time 2017/07/17 04:58:09.756320
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
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
Stats Collection Type OPERATOR_STATS
LC RC Id PaId ExId Frag TDB Name DOP Dispatches Oper CPU Time Est. Records Used Act. Records Used Details
-10 . 11 . 5 0 EX_ROOT 1 5 10 0 4 24 1975
-9 . 10 11 4 0 EX_SPLIT_TOP 1 5 19 2 4 24
-8 . 9 10 4 0 EX_SEND_TOP 2 10 1,946 2 4 32
-7 . 8 9 4 2 EX_SEND_BOTTOM 2 21 135 2 4 32
-6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 9 2 4 24 5956
-5 . 6 7 3 2 EX_HASH_GRBY 2 6 3,978 1 4 24 0|0|0
-4 . 5 6 2 2 EX_SPLIT_TOP 2 11 22 100 4 24
-3 . 4 5 2 2 EX_SEND_TOP 4 18 1,812 100 4 32
-2 . 3 4 2 3 EX_SEND_BOTTOM 4 42 237 100 4 32
-1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 60 100 4 24 11007
-. . 1 2 1 3 EX_TRAF_KEY_SELECT 2 4 10,710 100 4 24 TRAFODION.SCH.TSTAT|4|176
+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
--- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_312_S1
-Compile Start Time 2017/05/07 05:41:21.930615
-Compile End Time 2017/05/07 05:41:21.967829
-Compile Elapsed Time 0:00:00.037214
-Execute Start Time 2017/05/07 05:41:26.529910
-Execute End Time 2017/05/07 05:41:26.567047
-Execute Elapsed Time 0:00:00.037137
+>>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
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1864,42 +2012,46 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:41:26.564755
+First Row Returned Time 2017/07/17 04:58:09.756320
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
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
Stats Collection Type OPERATOR_STATS
LC RC Id PaId ExId Frag TDB Name DOP Dispatches Oper CPU Time Est. Records Used Act. Records Used Details
-10 . 11 . 5 0 EX_ROOT 1 5 10 0 4 24 1975
-9 . 10 11 4 0 EX_SPLIT_TOP 1 5 19 2 4 24
-8 . 9 10 4 0 EX_SEND_TOP 2 10 1,946 2 4 32
-7 . 8 9 4 2 EX_SEND_BOTTOM 2 21 135 2 4 32
-6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 9 2 4 24 5956
-5 . 6 7 3 2 EX_HASH_GRBY 2 6 3,978 1 4 24 0|0|0
-4 . 5 6 2 2 EX_SPLIT_TOP 2 11 22 100 4 24
-3 . 4 5 2 2 EX_SEND_TOP 4 18 1,812 100 4 32
-2 . 3 4 2 3 EX_SEND_BOTTOM 4 42 237 100 4 32
-1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 60 100 4 24 11007
-. . 1 2 1 3 EX_TRAF_KEY_SELECT 2 4 10,710 100 4 24 TRAFODION.SCH.TSTAT|4|176
+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
--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 ACCUMULATED;
-Qid MXID11000004343212360895605883001000000000206U3333300_312_S1
-Compile Start Time 2017/05/07 05:41:21.930615
-Compile End Time 2017/05/07 05:41:21.967829
-Compile Elapsed Time 0:00:00.037214
-Execute Start Time 2017/05/07 05:41:26.529910
-Execute End Time 2017/05/07 05:41:26.567047
-Execute Elapsed Time 0:00:00.037137
+>>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
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1917,20 +2069,24 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:41:26.564755
+First Row Returned Time 2017/07/17 04:58:09.756320
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
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
Stats Collection Type OPERATOR_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 12,163
-SQL Process Busy Time 18,938
+SE IO MAX Time 5,606
+SQL Process Busy Time 8,241
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
@@ -1940,9 +2096,9 @@ SQL Heap WM 10,341 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 40,128
+Request Message Bytes 39,712
Reply Message Count 15
-Reply Message Bytes 42,696
+Reply Message Bytes 42,528
BMO Space Buffer Size 256
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -1955,14 +2111,14 @@ Scr. IO Max Time 0
Sort TopN -1
--- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 ACCUMULATED;
-Qid MXID11000004343212360895605883001000000000206U3333300_312_S1
-Compile Start Time 2017/05/07 05:41:21.930615
-Compile End Time 2017/05/07 05:41:21.967829
-Compile Elapsed Time 0:00:00.037214
-Execute Start Time 2017/05/07 05:41:26.529910
-Execute End Time 2017/05/07 05:41:26.567047
-Execute Elapsed Time 0:00:00.037137
+>>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
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1980,20 +2136,24 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:41:26.564755
+First Row Returned Time 2017/07/17 04:58:09.756320
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
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
Stats Collection Type OPERATOR_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 12,163
-SQL Process Busy Time 18,938
+SE IO MAX Time 5,606
+SQL Process Busy Time 8,241
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
@@ -2003,9 +2163,9 @@ SQL Heap WM 10,341 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 40,128
+Request Message Bytes 39,712
Reply Message Count 15
-Reply Message Bytes 42,696
+Reply Message Bytes 42,528
BMO Space Buffer Size 256
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -2022,14 +2182,14 @@ Sort TopN -1
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 PERTABLE;
-Qid MXID11000004343212360895605883001000000000206U3333300_312_S1
-Compile Start Time 2017/05/07 05:41:21.930615
-Compile End Time 2017/05/07 05:41:21.967829
-Compile Elapsed Time 0:00:00.037214
-Execute Start Time 2017/05/07 05:41:26.529910
-Execute End Time 2017/05/07 05:41:26.567047
-Execute Elapsed Time 0:00:00.037137
+>>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
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2047,15 +2207,19 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:41:26.564755
+First Row Returned Time 2017/07/17 04:58:09.756320
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
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
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 18,938
+SQL Process Busy Time 8,241
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
@@ -2065,9 +2229,9 @@ SQL Heap WM 10,341 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 40,128
+Request Message Bytes 39,712
Reply Message Count 15
-Reply Message Bytes 42,696
+Reply Message Bytes 42,528
BMO Space Buffer Size 256
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -2080,19 +2244,19 @@ Scr. IO Max Time 0
Sort TopN -1
Id DOP Table Name
- EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime
+ 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,124 12,163
+ 0 4 100 4 4 0 9,682 5,606
--- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 PERTABLE;
-Qid MXID11000004343212360895605883001000000000206U3333300_312_S1
-Compile Start Time 2017/05/07 05:41:21.930615
-Compile End Time 2017/05/07 05:41:21.967829
-Compile Elapsed Time 0:00:00.037214
-Execute Start Time 2017/05/07 05:41:26.529910
-Execute End Time 2017/05/07 05:41:26.567047
-Execute Elapsed Time 0:00:00.037137
+>>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
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2110,15 +2274,19 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:41:26.564755
+First Row Returned Time 2017/07/17 04:58:09.756320
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
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
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 18,938
+SQL Process Busy Time 8,241
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
@@ -2128,9 +2296,9 @@ SQL Heap WM 10,341 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 40,128
+Request Message Bytes 39,712
Reply Message Count 15
-Reply Message Bytes 42,696
+Reply Message Bytes 42,528
BMO Space Buffer Size 256
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -2143,23 +2311,23 @@ Scr. IO Max Time 0
Sort TopN -1
Id DOP Table Name
- EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime
+ 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,124 12,163
+ 0 4 100 4 4 0 9,682 5,606
--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 PROGRESS;
-Qid MXID11000004343212360895605883001000000000206U3333300_312_S1
-Compile Start Time 2017/05/07 05:41:21.930615
-Compile End Time 2017/05/07 05:41:21.967829
-Compile Elapsed Time 0:00:00.037214
-Execute Start Time 2017/05/07 05:41:26.529910
-Execute End Time 2017/05/07 05:41:26.567047
-Execute Elapsed Time 0:00:00.037137
+>>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
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2177,15 +2345,19 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:41:26.564755
+First Row Returned Time 2017/07/17 04:58:09.756320
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
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
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 18,938
+SQL Process Busy Time 8,241
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 200 KB
@@ -2194,31 +2366,31 @@ SQL Heap WM 10,341 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 40,128
+Request Message Bytes 39,712
Reply Message Count 15
-Reply Message Bytes 42,696
+Reply Message Bytes 42,528
Id DOP Table Name
- EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime
+ 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,124 12,163
+ 0 4 100 4 4 0 9,682 5,606
Id TDBName Mode DOP TopN BMOPhase InterimRowCount CPUTime
BMOHeapUsed BMOHeapAllocated BMOHeapWM BMOSpaceBufSz BMOSpaceBufCnt
ScrFileCnt ScrIOSize ScrIORead ScrIOWritten ScrIOTime ScrIOMaxTime
- 6 EX_HASH_GRBY DISK 2 -1 READ_ROWS 0 3,978
+ 6 EX_HASH_GRBY DISK 2 -1 READ_ROWS 0 2,283
4 1,024 7,687 256 0
0 -1 0 0 0 0
--- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 PROGRESS;
-Qid MXID11000004343212360895605883001000000000206U3333300_312_S1
-Comp
<TRUNCATED>