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