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>