Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 71A40200C80 for ; Thu, 11 May 2017 00:49:57 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 700A3160BC6; Wed, 10 May 2017 22:49:57 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 6A736160B9C for ; Thu, 11 May 2017 00:49:55 +0200 (CEST) Received: (qmail 46140 invoked by uid 500); 10 May 2017 22:49:54 -0000 Mailing-List: contact commits-help@trafodion.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: commits@trafodion.apache.org Delivered-To: mailing list commits@trafodion.apache.org Received: (qmail 46127 invoked by uid 99); 10 May 2017 22:49:54 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 10 May 2017 22:49:54 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id C184AC0EA2 for ; Wed, 10 May 2017 22:49:53 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -4.772 X-Spam-Level: X-Spam-Status: No, score=-4.772 tagged_above=-999 required=6.31 tests=[KAM_LOTSOFHASH=0.25, RCVD_IN_DNSWL_HI=-5, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RP_MATCHES_RCVD=-0.001, SPF_PASS=-0.001] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id 7Q_KttqUTXaG for ; Wed, 10 May 2017 22:49:43 +0000 (UTC) Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with SMTP id B57235F36C for ; Wed, 10 May 2017 22:49:40 +0000 (UTC) Received: (qmail 45716 invoked by uid 99); 10 May 2017 22:49:39 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 10 May 2017 22:49:39 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id AA90CE00A3; Wed, 10 May 2017 22:49:39 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: selva@apache.org To: commits@trafodion.incubator.apache.org Date: Wed, 10 May 2017 22:49:40 -0000 Message-Id: <20551f1ddcc348cfaf6f3034b825afb9@git.apache.org> In-Reply-To: References: X-Mailer: ASF-Git Admin Mailer Subject: [2/7] incubator-trafodion git commit: [TRAFODION-2420] RMS enhancements archived-at: Wed, 10 May 2017 22:49:57 -0000 http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/e7719015/core/sql/regress/core/EXPECTEDRTS ---------------------------------------------------------------------- diff --git a/core/sql/regress/core/EXPECTEDRTS b/core/sql/regress/core/EXPECTEDRTS index bff1d37..1ea5583 100755 --- 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 MXID11000009156212358279905535000000000000206U3333300_272_S1 -Compile Start Time 2017/04/06 23:05:20.156375 -Compile End Time 2017/04/06 23:05:20.204717 -Compile Elapsed Time 0:00:00.048342 +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 -1 Execute End Time -1 Execute Elapsed Time 0:00:00.000000 @@ -94,11 +94,11 @@ Stats Collection Type ACCUMULATED_STATS >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; --- SQL operation complete. ->>display statistics for QID MXID11000009156212358279905535000000000000206U3333300_272_S1 ; -Qid MXID11000009156212358279905535000000000000206U3333300_272_S1 -Compile Start Time 2017/04/06 23:05:20.156375 -Compile End Time 2017/04/06 23:05:20.204717 -Compile Elapsed Time 0:00:00.048342 +>>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 -1 Execute End Time -1 Execute Elapsed Time 0:00:00.000000 @@ -129,11 +129,11 @@ Last Suspend Time -1 Stats Collection Type ACCUMULATED_STATS --- SQL operation complete. ->>get statistics for QID MXID11000009156212358279905535000000000000206U3333300_272_S1 ; -Qid MXID11000009156212358279905535000000000000206U3333300_272_S1 -Compile Start Time 2017/04/06 23:05:20.156375 -Compile End Time 2017/04/06 23:05:20.204717 -Compile Elapsed Time 0:00:00.048342 +>>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 -1 Execute End Time -1 Execute Elapsed Time 0:00:00.000000 @@ -166,10 +166,10 @@ Stats Collection Type ACCUMULATED_STATS --- SQL operation complete. >>log; >>display statistics for qid current; -Qid MXID11000009156212358279905535000000000000206U3333300_272_S1 -Compile Start Time 2017/04/06 23:05:20.156375 -Compile End Time 2017/04/06 23:05:20.204717 -Compile Elapsed Time 0:00:00.048342 +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 -1 Execute End Time -1 Execute Elapsed Time 0:00:00.000000 @@ -201,10 +201,10 @@ Stats Collection Type ACCUMULATED_STATS --- SQL operation complete. >>get statistics for qid current ; -Qid MXID11000009156212358279905535000000000000206U3333300_272_S1 -Compile Start Time 2017/04/06 23:05:20.156375 -Compile End Time 2017/04/06 23:05:20.204717 -Compile Elapsed Time 0:00:00.048342 +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 -1 Execute End Time -1 Execute Elapsed Time 0:00:00.000000 @@ -240,24 +240,24 @@ Stats Collection Type ACCUMULATED_STATS D ----------- + 12 + 11 21 22 - 11 - 12 --- 4 row(s) selected. >>log; >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; --- SQL operation complete. ->>display statistics for QID MXID11000009156212358279905535000000000000206U3333300_272_S1 ; -Qid MXID11000009156212358279905535000000000000206U3333300_272_S1 -Compile Start Time 2017/04/06 23:05:20.156375 -Compile End Time 2017/04/06 23:05:20.204717 -Compile Elapsed Time 0:00:00.048342 -Execute Start Time 2017/04/06 23:05:26.507000 -Execute End Time 2017/04/06 23:05:30.219438 -Execute Elapsed Time 0:00:03.712438 +>>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 State CLOSE Rows Affected 0 SQL Error Code 100 @@ -275,7 +275,7 @@ Transaction Id -1 Source String select distinct d from tstat ; SQL Source Length 30 Rows Returned 4 -First Row Returned Time 2017/04/06 23:05:30.217591 +First Row Returned Time 2017/05/07 05:40:34.139345 Last Error before AQR 0 Number of AQR retries 0 Delay before AQR 0 @@ -287,37 +287,40 @@ Accessed Rows 4 Used Rows 4 SE IOs 4 SE IO Bytes 176 -SE IO MAX Time 765,673 -SQL Process Busy Time 3,750,747 +SE IO MAX Time 725,870 +SQL Process Busy Time 5,717,075 UDR Process Busy Time 0 SQL Space Allocated 896 KB SQL Space Used 766 KB -SQL Heap Allocated 10,471 KB +SQL Heap Allocated 10,472 KB SQL Heap Used 80 KB SQL Heap WM 67 KB Processes Created 2 -Process Create Time 142,012 +Process Create Time 150,942 Request Message Count 26 -Request Message Bytes 39,392 +Request Message Bytes 39,808 Reply Message Count 15 -Reply Message Bytes 38,760 +Reply Message Bytes 38,840 +BMO Space Buffer Size 0 +BMO Space Buffer Count 0 +BMO Interim Row Count 0 Scr. Overflow Mode DISK Scr. File Count 0 -Scr. Buffer Blk Size 0 -Scr. Buffer Blks Read 0 -Scr. Buffer Blks Written 0 +Scr. IO Size 0 Scr. Read Count 0 Scr. Write Count 0 +Scr. IO Max Time 0 +Sort TopN -1 --- SQL operation complete. ->>get statistics for QID MXID11000009156212358279905535000000000000206U3333300_272_S1 ; -Qid MXID11000009156212358279905535000000000000206U3333300_272_S1 -Compile Start Time 2017/04/06 23:05:20.156375 -Compile End Time 2017/04/06 23:05:20.204717 -Compile Elapsed Time 0:00:00.048342 -Execute Start Time 2017/04/06 23:05:26.507000 -Execute End Time 2017/04/06 23:05:30.219438 -Execute Elapsed Time 0:00:03.712438 +>>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 State CLOSE Rows Affected 0 SQL Error Code 100 @@ -335,7 +338,7 @@ Transaction Id -1 Source String select distinct d from tstat ; SQL Source Length 30 Rows Returned 4 -First Row Returned Time 2017/04/06 23:05:30.217591 +First Row Returned Time 2017/05/07 05:40:34.139345 Last Error before AQR 0 Number of AQR retries 0 Delay before AQR 0 @@ -347,38 +350,41 @@ Accessed Rows 4 Used Rows 4 SE IOs 4 SE IO Bytes 176 -SE IO MAX Time 765,673 -SQL Process Busy Time 3,750,747 +SE IO MAX Time 725,870 +SQL Process Busy Time 5,717,075 UDR Process Busy Time 0 SQL Space Allocated 896 KB SQL Space Used 766 KB -SQL Heap Allocated 10,471 KB +SQL Heap Allocated 10,472 KB SQL Heap Used 80 KB SQL Heap WM 67 KB Processes Created 2 -Process Create Time 142,012 +Process Create Time 150,942 Request Message Count 26 -Request Message Bytes 39,392 +Request Message Bytes 39,808 Reply Message Count 15 -Reply Message Bytes 38,760 +Reply Message Bytes 38,840 +BMO Space Buffer Size 0 +BMO Space Buffer Count 0 +BMO Interim Row Count 0 Scr. Overflow Mode DISK Scr. File Count 0 -Scr. Buffer Blk Size 0 -Scr. Buffer Blks Read 0 -Scr. Buffer Blks Written 0 +Scr. IO Size 0 Scr. Read Count 0 Scr. Write Count 0 +Scr. IO Max Time 0 +Sort TopN -1 --- SQL operation complete. >>log; >>display statistics for qid current; -Qid MXID11000009156212358279905535000000000000206U3333300_272_S1 -Compile Start Time 2017/04/06 23:05:20.156375 -Compile End Time 2017/04/06 23:05:20.204717 -Compile Elapsed Time 0:00:00.048342 -Execute Start Time 2017/04/06 23:05:26.507000 -Execute End Time 2017/04/06 23:05:30.219438 -Execute Elapsed Time 0:00:03.712438 +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 State CLOSE Rows Affected 0 SQL Error Code 100 @@ -396,7 +402,7 @@ Transaction Id -1 Source String select distinct d from tstat ; SQL Source Length 30 Rows Returned 4 -First Row Returned Time 2017/04/06 23:05:30.217591 +First Row Returned Time 2017/05/07 05:40:34.139345 Last Error before AQR 0 Number of AQR retries 0 Delay before AQR 0 @@ -408,37 +414,40 @@ Accessed Rows 4 Used Rows 4 SE IOs 4 SE IO Bytes 176 -SE IO MAX Time 765,673 -SQL Process Busy Time 3,750,747 +SE IO MAX Time 725,870 +SQL Process Busy Time 5,717,075 UDR Process Busy Time 0 SQL Space Allocated 896 KB SQL Space Used 766 KB -SQL Heap Allocated 10,471 KB +SQL Heap Allocated 10,472 KB SQL Heap Used 80 KB SQL Heap WM 67 KB Processes Created 2 -Process Create Time 142,012 +Process Create Time 150,942 Request Message Count 26 -Request Message Bytes 39,392 +Request Message Bytes 39,808 Reply Message Count 15 -Reply Message Bytes 38,760 +Reply Message Bytes 38,840 +BMO Space Buffer Size 0 +BMO Space Buffer Count 0 +BMO Interim Row Count 0 Scr. Overflow Mode DISK Scr. File Count 0 -Scr. Buffer Blk Size 0 -Scr. Buffer Blks Read 0 -Scr. Buffer Blks Written 0 +Scr. IO Size 0 Scr. Read Count 0 Scr. Write Count 0 +Scr. IO Max Time 0 +Sort TopN -1 --- SQL operation complete. >>get statistics for qid current ; -Qid MXID11000009156212358279905535000000000000206U3333300_272_S1 -Compile Start Time 2017/04/06 23:05:20.156375 -Compile End Time 2017/04/06 23:05:20.204717 -Compile Elapsed Time 0:00:00.048342 -Execute Start Time 2017/04/06 23:05:26.507000 -Execute End Time 2017/04/06 23:05:30.219438 -Execute Elapsed Time 0:00:03.712438 +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 State CLOSE Rows Affected 0 SQL Error Code 100 @@ -456,7 +465,7 @@ Transaction Id -1 Source String select distinct d from tstat ; SQL Source Length 30 Rows Returned 4 -First Row Returned Time 2017/04/06 23:05:30.217591 +First Row Returned Time 2017/05/07 05:40:34.139345 Last Error before AQR 0 Number of AQR retries 0 Delay before AQR 0 @@ -468,27 +477,30 @@ Accessed Rows 4 Used Rows 4 SE IOs 4 SE IO Bytes 176 -SE IO MAX Time 765,673 -SQL Process Busy Time 3,750,747 +SE IO MAX Time 725,870 +SQL Process Busy Time 5,717,075 UDR Process Busy Time 0 SQL Space Allocated 896 KB SQL Space Used 766 KB -SQL Heap Allocated 10,471 KB +SQL Heap Allocated 10,472 KB SQL Heap Used 80 KB SQL Heap WM 67 KB Processes Created 2 -Process Create Time 142,012 +Process Create Time 150,942 Request Message Count 26 -Request Message Bytes 39,392 +Request Message Bytes 39,808 Reply Message Count 15 -Reply Message Bytes 38,760 +Reply Message Bytes 38,840 +BMO Space Buffer Size 0 +BMO Space Buffer Count 0 +BMO Interim Row Count 0 Scr. Overflow Mode DISK Scr. File Count 0 -Scr. Buffer Blk Size 0 -Scr. Buffer Blks Read 0 -Scr. Buffer Blks Written 0 +Scr. IO Size 0 Scr. Read Count 0 Scr. Write Count 0 +Scr. IO Max Time 0 +Sort TopN -1 --- SQL operation complete. >>prepare s1 from select distinct d from tstat ; @@ -498,25 +510,25 @@ Scr. Write Count 0 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; --- SQL operation complete. ->>display statistics for QID MXID11000009156212358279905535000000000000206U3333300_272_S1 ; +>>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_279_S1 ; -*** ERROR[8923] The given Query Id MXID11000009156212358279905535000000000000206U3333300_272_S1 is not found. +*** ERROR[8923] The given Query Id MXID11000004343212360895605883001000000000206U3333300_279_S1 is not found. --- SQL operation failed with errors. ->>get statistics for QID MXID11000009156212358279905535000000000000206U3333300_272_S1 ; +>>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_279_S1 ; -*** ERROR[8923] The given Query Id MXID11000009156212358279905535000000000000206U3333300_272_S1 is not found. +*** ERROR[8923] The given Query Id MXID11000004343212360895605883001000000000206U3333300_279_S1 is not found. --- SQL operation failed with errors. >>log; >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; --- SQL operation complete. ->>display statistics for QID MXID11000009156212358279905535000000000000206U3333300_281_S1 ; -Qid MXID11000009156212358279905535000000000000206U3333300_281_S1 -Compile Start Time 2017/04/06 23:05:33.259103 -Compile End Time 2017/04/06 23:05:33.259721 -Compile Elapsed Time 0:00:00.000618 +>>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 Execute Start Time -1 Execute End Time -1 Execute Elapsed Time 0:00:00.000000 @@ -547,11 +559,11 @@ Last Suspend Time -1 Stats Collection Type ACCUMULATED_STATS --- SQL operation complete. ->>get statistics for QID MXID11000009156212358279905535000000000000206U3333300_281_S1 ; -Qid MXID11000009156212358279905535000000000000206U3333300_281_S1 -Compile Start Time 2017/04/06 23:05:33.259103 -Compile End Time 2017/04/06 23:05:33.259721 -Compile Elapsed Time 0:00:00.000618 +>>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 Execute Start Time -1 Execute End Time -1 Execute Elapsed Time 0:00:00.000000 @@ -584,10 +596,10 @@ Stats Collection Type ACCUMULATED_STATS --- SQL operation complete. >>log; >>display statistics for qid current; -Qid MXID11000009156212358279905535000000000000206U3333300_281_S1 -Compile Start Time 2017/04/06 23:05:33.259103 -Compile End Time 2017/04/06 23:05:33.259721 -Compile Elapsed Time 0:00:00.000618 +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 Execute Start Time -1 Execute End Time -1 Execute Elapsed Time 0:00:00.000000 @@ -619,10 +631,10 @@ Stats Collection Type ACCUMULATED_STATS --- SQL operation complete. >>get statistics for qid current ; -Qid MXID11000009156212358279905535000000000000206U3333300_281_S1 -Compile Start Time 2017/04/06 23:05:33.259103 -Compile End Time 2017/04/06 23:05:33.259721 -Compile Elapsed Time 0:00:00.000618 +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 Execute Start Time -1 Execute End Time -1 Execute Elapsed Time 0:00:00.000000 @@ -666,10 +678,10 @@ Stats Collection Type ACCUMULATED_STATS --- SQL command prepared. >>log; >>get statistics for qid current ; -Qid MXID11000009156212358279905535000000000000206U3333300_286_S1 -Compile Start Time 2017/04/06 23:05:39.345617 -Compile End Time 2017/04/06 23:05:39.388433 -Compile Elapsed Time 0:00:00.042816 +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 -1 Execute End Time -1 Execute Elapsed Time 0:00:00.000000 @@ -704,11 +716,11 @@ Stats Collection Type PERTABLE_STATS >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; --- SQL operation complete. ->>display statistics for QID MXID11000009156212358279905535000000000000206U3333300_286_S1 ; -Qid MXID11000009156212358279905535000000000000206U3333300_286_S1 -Compile Start Time 2017/04/06 23:05:39.345617 -Compile End Time 2017/04/06 23:05:39.388433 -Compile Elapsed Time 0:00:00.042816 +>>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 -1 Execute End Time -1 Execute Elapsed Time 0:00:00.000000 @@ -739,11 +751,11 @@ Last Suspend Time -1 Stats Collection Type PERTABLE_STATS --- SQL operation complete. ->>get statistics for QID MXID11000009156212358279905535000000000000206U3333300_286_S1 ; -Qid MXID11000009156212358279905535000000000000206U3333300_286_S1 -Compile Start Time 2017/04/06 23:05:39.345617 -Compile End Time 2017/04/06 23:05:39.388433 -Compile Elapsed Time 0:00:00.042816 +>>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 -1 Execute End Time -1 Execute Elapsed Time 0:00:00.000000 @@ -778,11 +790,11 @@ Stats Collection Type PERTABLE_STATS >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; --- SQL operation complete. ->>display statistics for QID MXID11000009156212358279905535000000000000206U3333300_286_S1 ACCUMULATED; -Qid MXID11000009156212358279905535000000000000206U3333300_286_S1 -Compile Start Time 2017/04/06 23:05:39.345617 -Compile End Time 2017/04/06 23:05:39.388433 -Compile Elapsed Time 0:00:00.042816 +>>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 -1 Execute End Time -1 Execute Elapsed Time 0:00:00.000000 @@ -813,11 +825,11 @@ Last Suspend Time -1 Stats Collection Type PERTABLE_STATS --- SQL operation complete. ->>get statistics for QID MXID11000009156212358279905535000000000000206U3333300_286_S1 ACCUMULATED; -Qid MXID11000009156212358279905535000000000000206U3333300_286_S1 -Compile Start Time 2017/04/06 23:05:39.345617 -Compile End Time 2017/04/06 23:05:39.388433 -Compile Elapsed Time 0:00:00.042816 +>>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 -1 Execute End Time -1 Execute Elapsed Time 0:00:00.000000 @@ -850,10 +862,10 @@ Stats Collection Type PERTABLE_STATS --- SQL operation complete. >>log; >>display statistics for qid current; -Qid MXID11000009156212358279905535000000000000206U3333300_286_S1 -Compile Start Time 2017/04/06 23:05:39.345617 -Compile End Time 2017/04/06 23:05:39.388433 -Compile Elapsed Time 0:00:00.042816 +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 -1 Execute End Time -1 Execute Elapsed Time 0:00:00.000000 @@ -885,10 +897,10 @@ Stats Collection Type PERTABLE_STATS --- SQL operation complete. >>get statistics for qid current ; -Qid MXID11000009156212358279905535000000000000206U3333300_286_S1 -Compile Start Time 2017/04/06 23:05:39.345617 -Compile End Time 2017/04/06 23:05:39.388433 -Compile Elapsed Time 0:00:00.042816 +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 -1 Execute End Time -1 Execute Elapsed Time 0:00:00.000000 @@ -920,10 +932,10 @@ Stats Collection Type PERTABLE_STATS --- SQL operation complete. >>display statistics for qid current accumulated ; -Qid MXID11000009156212358279905535000000000000206U3333300_286_S1 -Compile Start Time 2017/04/06 23:05:39.345617 -Compile End Time 2017/04/06 23:05:39.388433 -Compile Elapsed Time 0:00:00.042816 +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 -1 Execute End Time -1 Execute Elapsed Time 0:00:00.000000 @@ -955,10 +967,10 @@ Stats Collection Type PERTABLE_STATS --- SQL operation complete. >>get statistics for qid current accumulated ; -Qid MXID11000009156212358279905535000000000000206U3333300_286_S1 -Compile Start Time 2017/04/06 23:05:39.345617 -Compile End Time 2017/04/06 23:05:39.388433 -Compile Elapsed Time 0:00:00.042816 +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 -1 Execute End Time -1 Execute Elapsed Time 0:00:00.000000 @@ -994,24 +1006,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 MXID11000009156212358279905535000000000000206U3333300_286_S1 ; -Qid MXID11000009156212358279905535000000000000206U3333300_286_S1 -Compile Start Time 2017/04/06 23:05:39.345617 -Compile End Time 2017/04/06 23:05:39.388433 -Compile Elapsed Time 0:00:00.042816 -Execute Start Time 2017/04/06 23:05:45.596219 -Execute End Time 2017/04/06 23:05:45.609391 -Execute Elapsed Time 0:00:00.013172 +>>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 State CLOSE Rows Affected 0 SQL Error Code 100 @@ -1029,7 +1041,7 @@ Transaction Id -1 Source String select distinct d from tstat ; SQL Source Length 30 Rows Returned 4 -First Row Returned Time 2017/04/06 23:05:45.606884 +First Row Returned Time 2017/05/07 05:40:58.520309 Last Error before AQR 0 Number of AQR retries 0 Delay before AQR 0 @@ -1037,7 +1049,7 @@ No. of times reclaimed 0 Cancel Time -1 Last Suspend Time -1 Stats Collection Type PERTABLE_STATS -SQL Process Busy Time 5,884 +SQL Process Busy Time 15,419 UDR Process Busy Time 0 SQL Space Allocated 896 KB SQL Space Used 766 KB @@ -1047,34 +1059,34 @@ SQL Heap WM 10,338 KB Processes Created 0 Process Create Time 0 Request Message Count 27 -Request Message Bytes 39,552 +Request Message Bytes 39,968 Reply Message Count 15 -Reply Message Bytes 39,144 +Reply Message Bytes 39,264 +BMO Space Buffer Size 0 +BMO Space Buffer Count 0 +BMO Interim Row Count 0 Scr. Overflow Mode UNKNOWN Scr. File Count 0 -Scr. Buffer Blk Size 0 -Scr. Buffer Blks Read 0 -Scr. Buffer Blks Written 0 +Scr. IO Size 0 Scr. Read Count 0 Scr. Write Count 0 +Scr. IO Max Time 0 Sort TopN -1 - ID DOP Table Name - Records Accessed Records Used HBase/Hive HBase/Hive HBase/Hive IO HBase/Hive IO - Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time - 1 2 TRAFODION.SCH.TSTAT - 0 100 - 4 4 4 0 7,088 4,227 + Id DOP Table Name + EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_Bytes SE_IO_SumTime SE_IO_MaxTime + 1 2 TRAFODION.SCH.TSTAT + 0 4 100 4 4 0 20,398 10,610 --- SQL operation complete. ->>get statistics for QID MXID11000009156212358279905535000000000000206U3333300_286_S1 ; -Qid MXID11000009156212358279905535000000000000206U3333300_286_S1 -Compile Start Time 2017/04/06 23:05:39.345617 -Compile End Time 2017/04/06 23:05:39.388433 -Compile Elapsed Time 0:00:00.042816 -Execute Start Time 2017/04/06 23:05:45.596219 -Execute End Time 2017/04/06 23:05:45.609391 -Execute Elapsed Time 0:00:00.013172 +>>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 State CLOSE Rows Affected 0 SQL Error Code 100 @@ -1092,7 +1104,7 @@ Transaction Id -1 Source String select distinct d from tstat ; SQL Source Length 30 Rows Returned 4 -First Row Returned Time 2017/04/06 23:05:45.606884 +First Row Returned Time 2017/05/07 05:40:58.520309 Last Error before AQR 0 Number of AQR retries 0 Delay before AQR 0 @@ -1100,7 +1112,7 @@ No. of times reclaimed 0 Cancel Time -1 Last Suspend Time -1 Stats Collection Type PERTABLE_STATS -SQL Process Busy Time 5,884 +SQL Process Busy Time 15,419 UDR Process Busy Time 0 SQL Space Allocated 896 KB SQL Space Used 766 KB @@ -1110,38 +1122,38 @@ SQL Heap WM 10,338 KB Processes Created 0 Process Create Time 0 Request Message Count 27 -Request Message Bytes 39,552 +Request Message Bytes 39,968 Reply Message Count 15 -Reply Message Bytes 39,144 +Reply Message Bytes 39,264 +BMO Space Buffer Size 0 +BMO Space Buffer Count 0 +BMO Interim Row Count 0 Scr. Overflow Mode UNKNOWN Scr. File Count 0 -Scr. Buffer Blk Size 0 -Scr. Buffer Blks Read 0 -Scr. Buffer Blks Written 0 +Scr. IO Size 0 Scr. Read Count 0 Scr. Write Count 0 +Scr. IO Max Time 0 Sort TopN -1 - ID DOP Table Name - Records Accessed Records Used HBase/Hive HBase/Hive HBase/Hive IO HBase/Hive IO - Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time - 1 2 TRAFODION.SCH.TSTAT - 0 100 - 4 4 4 0 7,088 4,227 + Id DOP Table Name + EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_Bytes SE_IO_SumTime SE_IO_MaxTime + 1 2 TRAFODION.SCH.TSTAT + 0 4 100 4 4 0 20,398 10,610 --- SQL operation complete. >>log; >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; --- SQL operation complete. ->>display statistics for QID MXID11000009156212358279905535000000000000206U3333300_286_S1 ACCUMULATED; -Qid MXID11000009156212358279905535000000000000206U3333300_286_S1 -Compile Start Time 2017/04/06 23:05:39.345617 -Compile End Time 2017/04/06 23:05:39.388433 -Compile Elapsed Time 0:00:00.042816 -Execute Start Time 2017/04/06 23:05:45.596219 -Execute End Time 2017/04/06 23:05:45.609391 -Execute Elapsed Time 0:00:00.013172 +>>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 State CLOSE Rows Affected 0 SQL Error Code 100 @@ -1159,7 +1171,7 @@ Transaction Id -1 Source String select distinct d from tstat ; SQL Source Length 30 Rows Returned 4 -First Row Returned Time 2017/04/06 23:05:45.606884 +First Row Returned Time 2017/05/07 05:40:58.520309 Last Error before AQR 0 Number of AQR retries 0 Delay before AQR 0 @@ -1171,8 +1183,8 @@ Accessed Rows 4 Used Rows 4 SE IOs 4 SE IO Bytes 176 -SE IO MAX Time 4,227 -SQL Process Busy Time 5,884 +SE IO MAX Time 10,610 +SQL Process Busy Time 15,419 UDR Process Busy Time 0 SQL Space Allocated 896 KB SQL Space Used 766 KB @@ -1182,26 +1194,29 @@ SQL Heap WM 10,338 KB Processes Created 0 Process Create Time 0 Request Message Count 27 -Request Message Bytes 39,552 +Request Message Bytes 39,968 Reply Message Count 15 -Reply Message Bytes 39,144 +Reply Message Bytes 39,264 +BMO Space Buffer Size 0 +BMO Space Buffer Count 0 +BMO Interim Row Count 0 Scr. Overflow Mode UNKNOWN Scr. File Count 0 -Scr. Buffer Blk Size 0 -Scr. Buffer Blks Read 0 -Scr. Buffer Blks Written 0 +Scr. IO Size 0 Scr. Read Count 0 Scr. Write Count 0 +Scr. IO Max Time 0 +Sort TopN -1 --- SQL operation complete. ->>get statistics for QID MXID11000009156212358279905535000000000000206U3333300_286_S1 ACCUMULATED; -Qid MXID11000009156212358279905535000000000000206U3333300_286_S1 -Compile Start Time 2017/04/06 23:05:39.345617 -Compile End Time 2017/04/06 23:05:39.388433 -Compile Elapsed Time 0:00:00.042816 -Execute Start Time 2017/04/06 23:05:45.596219 -Execute End Time 2017/04/06 23:05:45.609391 -Execute Elapsed Time 0:00:00.013172 +>>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 State CLOSE Rows Affected 0 SQL Error Code 100 @@ -1219,7 +1234,7 @@ Transaction Id -1 Source String select distinct d from tstat ; SQL Source Length 30 Rows Returned 4 -First Row Returned Time 2017/04/06 23:05:45.606884 +First Row Returned Time 2017/05/07 05:40:58.520309 Last Error before AQR 0 Number of AQR retries 0 Delay before AQR 0 @@ -1231,8 +1246,8 @@ Accessed Rows 4 Used Rows 4 SE IOs 4 SE IO Bytes 176 -SE IO MAX Time 4,227 -SQL Process Busy Time 5,884 +SE IO MAX Time 10,610 +SQL Process Busy Time 15,419 UDR Process Busy Time 0 SQL Space Allocated 896 KB SQL Space Used 766 KB @@ -1242,27 +1257,30 @@ SQL Heap WM 10,338 KB Processes Created 0 Process Create Time 0 Request Message Count 27 -Request Message Bytes 39,552 +Request Message Bytes 39,968 Reply Message Count 15 -Reply Message Bytes 39,144 +Reply Message Bytes 39,264 +BMO Space Buffer Size 0 +BMO Space Buffer Count 0 +BMO Interim Row Count 0 Scr. Overflow Mode UNKNOWN Scr. File Count 0 -Scr. Buffer Blk Size 0 -Scr. Buffer Blks Read 0 -Scr. Buffer Blks Written 0 +Scr. IO Size 0 Scr. Read Count 0 Scr. Write Count 0 +Scr. IO Max Time 0 +Sort TopN -1 --- SQL operation complete. >>log; >>display statistics for qid current; -Qid MXID11000009156212358279905535000000000000206U3333300_286_S1 -Compile Start Time 2017/04/06 23:05:39.345617 -Compile End Time 2017/04/06 23:05:39.388433 -Compile Elapsed Time 0:00:00.042816 -Execute Start Time 2017/04/06 23:05:45.596219 -Execute End Time 2017/04/06 23:05:45.609391 -Execute Elapsed Time 0:00:00.013172 +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 State CLOSE Rows Affected 0 SQL Error Code 100 @@ -1280,7 +1298,7 @@ Transaction Id -1 Source String select distinct d from tstat ; SQL Source Length 30 Rows Returned 4 -First Row Returned Time 2017/04/06 23:05:45.606884 +First Row Returned Time 2017/05/07 05:40:58.520309 Last Error before AQR 0 Number of AQR retries 0 Delay before AQR 0 @@ -1288,7 +1306,7 @@ No. of times reclaimed 0 Cancel Time -1 Last Suspend Time -1 Stats Collection Type PERTABLE_STATS -SQL Process Busy Time 5,884 +SQL Process Busy Time 15,419 UDR Process Busy Time 0 SQL Space Allocated 896 KB SQL Space Used 766 KB @@ -1298,34 +1316,34 @@ SQL Heap WM 10,338 KB Processes Created 0 Process Create Time 0 Request Message Count 27 -Request Message Bytes 39,552 +Request Message Bytes 39,968 Reply Message Count 15 -Reply Message Bytes 39,144 +Reply Message Bytes 39,264 +BMO Space Buffer Size 0 +BMO Space Buffer Count 0 +BMO Interim Row Count 0 Scr. Overflow Mode UNKNOWN Scr. File Count 0 -Scr. Buffer Blk Size 0 -Scr. Buffer Blks Read 0 -Scr. Buffer Blks Written 0 +Scr. IO Size 0 Scr. Read Count 0 Scr. Write Count 0 +Scr. IO Max Time 0 Sort TopN -1 - ID DOP Table Name - Records Accessed Records Used HBase/Hive HBase/Hive HBase/Hive IO HBase/Hive IO - Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time - 1 2 TRAFODION.SCH.TSTAT - 0 100 - 4 4 4 0 7,088 4,227 + Id DOP Table Name + EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_Bytes SE_IO_SumTime SE_IO_MaxTime + 1 2 TRAFODION.SCH.TSTAT + 0 4 100 4 4 0 20,398 10,610 --- SQL operation complete. >>get statistics for qid current ; -Qid MXID11000009156212358279905535000000000000206U3333300_286_S1 -Compile Start Time 2017/04/06 23:05:39.345617 -Compile End Time 2017/04/06 23:05:39.388433 -Compile Elapsed Time 0:00:00.042816 -Execute Start Time 2017/04/06 23:05:45.596219 -Execute End Time 2017/04/06 23:05:45.609391 -Execute Elapsed Time 0:00:00.013172 +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 State CLOSE Rows Affected 0 SQL Error Code 100 @@ -1343,7 +1361,7 @@ Transaction Id -1 Source String select distinct d from tstat ; SQL Source Length 30 Rows Returned 4 -First Row Returned Time 2017/04/06 23:05:45.606884 +First Row Returned Time 2017/05/07 05:40:58.520309 Last Error before AQR 0 Number of AQR retries 0 Delay before AQR 0 @@ -1351,7 +1369,7 @@ No. of times reclaimed 0 Cancel Time -1 Last Suspend Time -1 Stats Collection Type PERTABLE_STATS -SQL Process Busy Time 5,884 +SQL Process Busy Time 15,419 UDR Process Busy Time 0 SQL Space Allocated 896 KB SQL Space Used 766 KB @@ -1361,34 +1379,34 @@ SQL Heap WM 10,338 KB Processes Created 0 Process Create Time 0 Request Message Count 27 -Request Message Bytes 39,552 +Request Message Bytes 39,968 Reply Message Count 15 -Reply Message Bytes 39,144 +Reply Message Bytes 39,264 +BMO Space Buffer Size 0 +BMO Space Buffer Count 0 +BMO Interim Row Count 0 Scr. Overflow Mode UNKNOWN Scr. File Count 0 -Scr. Buffer Blk Size 0 -Scr. Buffer Blks Read 0 -Scr. Buffer Blks Written 0 +Scr. IO Size 0 Scr. Read Count 0 Scr. Write Count 0 +Scr. IO Max Time 0 Sort TopN -1 - ID DOP Table Name - Records Accessed Records Used HBase/Hive HBase/Hive HBase/Hive IO HBase/Hive IO - Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time - 1 2 TRAFODION.SCH.TSTAT - 0 100 - 4 4 4 0 7,088 4,227 + Id DOP Table Name + EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_Bytes SE_IO_SumTime SE_IO_MaxTime + 1 2 TRAFODION.SCH.TSTAT + 0 4 100 4 4 0 20,398 10,610 --- SQL operation complete. >>display statistics for qid current accumulated; -Qid MXID11000009156212358279905535000000000000206U3333300_286_S1 -Compile Start Time 2017/04/06 23:05:39.345617 -Compile End Time 2017/04/06 23:05:39.388433 -Compile Elapsed Time 0:00:00.042816 -Execute Start Time 2017/04/06 23:05:45.596219 -Execute End Time 2017/04/06 23:05:45.609391 -Execute Elapsed Time 0:00:00.013172 +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 State CLOSE Rows Affected 0 SQL Error Code 100 @@ -1406,7 +1424,7 @@ Transaction Id -1 Source String select distinct d from tstat ; SQL Source Length 30 Rows Returned 4 -First Row Returned Time 2017/04/06 23:05:45.606884 +First Row Returned Time 2017/05/07 05:40:58.520309 Last Error before AQR 0 Number of AQR retries 0 Delay before AQR 0 @@ -1418,8 +1436,8 @@ Accessed Rows 4 Used Rows 4 SE IOs 4 SE IO Bytes 176 -SE IO MAX Time 4,227 -SQL Process Busy Time 5,884 +SE IO MAX Time 10,610 +SQL Process Busy Time 15,419 UDR Process Busy Time 0 SQL Space Allocated 896 KB SQL Space Used 766 KB @@ -1429,26 +1447,29 @@ SQL Heap WM 10,338 KB Processes Created 0 Process Create Time 0 Request Message Count 27 -Request Message Bytes 39,552 +Request Message Bytes 39,968 Reply Message Count 15 -Reply Message Bytes 39,144 +Reply Message Bytes 39,264 +BMO Space Buffer Size 0 +BMO Space Buffer Count 0 +BMO Interim Row Count 0 Scr. Overflow Mode UNKNOWN Scr. File Count 0 -Scr. Buffer Blk Size 0 -Scr. Buffer Blks Read 0 -Scr. Buffer Blks Written 0 +Scr. IO Size 0 Scr. Read Count 0 Scr. Write Count 0 +Scr. IO Max Time 0 +Sort TopN -1 --- SQL operation complete. >>get statistics for qid current accumulated; -Qid MXID11000009156212358279905535000000000000206U3333300_286_S1 -Compile Start Time 2017/04/06 23:05:39.345617 -Compile End Time 2017/04/06 23:05:39.388433 -Compile Elapsed Time 0:00:00.042816 -Execute Start Time 2017/04/06 23:05:45.596219 -Execute End Time 2017/04/06 23:05:45.609391 -Execute Elapsed Time 0:00:00.013172 +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 State CLOSE Rows Affected 0 SQL Error Code 100 @@ -1466,7 +1487,7 @@ Transaction Id -1 Source String select distinct d from tstat ; SQL Source Length 30 Rows Returned 4 -First Row Returned Time 2017/04/06 23:05:45.606884 +First Row Returned Time 2017/05/07 05:40:58.520309 Last Error before AQR 0 Number of AQR retries 0 Delay before AQR 0 @@ -1478,8 +1499,8 @@ Accessed Rows 4 Used Rows 4 SE IOs 4 SE IO Bytes 176 -SE IO MAX Time 4,227 -SQL Process Busy Time 5,884 +SE IO MAX Time 10,610 +SQL Process Busy Time 15,419 UDR Process Busy Time 0 SQL Space Allocated 896 KB SQL Space Used 766 KB @@ -1489,21 +1510,24 @@ SQL Heap WM 10,338 KB Processes Created 0 Process Create Time 0 Request Message Count 27 -Request Message Bytes 39,552 +Request Message Bytes 39,968 Reply Message Count 15 -Reply Message Bytes 39,144 +Reply Message Bytes 39,264 +BMO Space Buffer Size 0 +BMO Space Buffer Count 0 +BMO Interim Row Count 0 Scr. Overflow Mode UNKNOWN Scr. File Count 0 -Scr. Buffer Blk Size 0 -Scr. Buffer Blks Read 0 -Scr. Buffer Blks Written 0 +Scr. IO Size 0 Scr. Read Count 0 Scr. Write Count 0 +Scr. IO Max Time 0 +Sort TopN -1 --- SQL operation complete. >>log; >>obey PQIDOUT; ->>SET SESSION DEFAULT PARENT_QID 'MXID11000009156212358279905535000000000000206U3333300_286_S1'; +>>SET SESSION DEFAULT PARENT_QID 'MXID11000004343212360895605883001000000000206U3333300_293_S1'; --- SQL operation complete. >>prepare s1 from select distinct d from tstat ; @@ -1513,11 +1537,11 @@ Scr. Write Count 0 >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; --- SQL operation complete. ->>display statistics for QID MXID11000009156212358279905535000000000000206U3333300_300_S1 ; -Qid MXID11000009156212358279905535000000000000206U3333300_300_S1 -Compile Start Time 2017/04/06 23:05:54.780156 -Compile End Time 2017/04/06 23:05:54.780786 -Compile Elapsed Time 0:00:00.000630 +>>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 Execute Start Time -1 Execute End Time -1 Execute Elapsed Time 0:00:00.000000 @@ -1529,7 +1553,7 @@ Query Type SQL_SELECT_NON_UNIQUE Sub Query Type SQL_STMT_NA Estimated Accessed Rows 0 Estimated Used Rows 0 -Parent Qid MXID11000009156212358279905535000000000000206U3333300_286_S1 +Parent Qid MXID11000004343212360895605883001000000000206U3333300_293_S1 Parent Query System SAME Child Qid NONE Number of SQL Processes 1 @@ -1548,11 +1572,11 @@ Last Suspend Time -1 Stats Collection Type PERTABLE_STATS --- SQL operation complete. ->>get statistics for QID MXID11000009156212358279905535000000000000206U3333300_300_S1 ; -Qid MXID11000009156212358279905535000000000000206U3333300_300_S1 -Compile Start Time 2017/04/06 23:05:54.780156 -Compile End Time 2017/04/06 23:05:54.780786 -Compile Elapsed Time 0:00:00.000630 +>>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 Execute Start Time -1 Execute End Time -1 Execute Elapsed Time 0:00:00.000000 @@ -1564,7 +1588,7 @@ Query Type SQL_SELECT_NON_UNIQUE Sub Query Type SQL_STMT_NA Estimated Accessed Rows 0 Estimated Used Rows 0 -Parent Qid MXID11000009156212358279905535000000000000206U3333300_286_S1 +Parent Qid MXID11000004343212360895605883001000000000206U3333300_293_S1 Parent Query System SAME Child Qid NONE Number of SQL Processes 1 @@ -1594,11 +1618,11 @@ Stats Collection Type PERTABLE_STATS >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; --- SQL operation complete. ->>display statistics for QID MXID11000009156212358279905535000000000000206U3333300_302_S1 ; -Qid MXID11000009156212358279905535000000000000206U3333300_302_S1 -Compile Start Time 2017/04/06 23:05:57.786576 -Compile End Time 2017/04/06 23:05:57.787052 -Compile Elapsed Time 0:00:00.000476 +>>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 Execute Start Time -1 Execute End Time -1 Execute Elapsed Time 0:00:00.000000 @@ -1629,11 +1653,11 @@ Last Suspend Time -1 Stats Collection Type PERTABLE_STATS --- SQL operation complete. ->>get statistics for QID MXID11000009156212358279905535000000000000206U3333300_302_S1 ; -Qid MXID11000009156212358279905535000000000000206U3333300_302_S1 -Compile Start Time 2017/04/06 23:05:57.786576 -Compile End Time 2017/04/06 23:05:57.787052 -Compile Elapsed Time 0:00:00.000476 +>>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 Execute Start Time -1 Execute End Time -1 Execute Elapsed Time 0:00:00.000000 @@ -1680,11 +1704,11 @@ Stats Collection Type PERTABLE_STATS >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; --- SQL operation complete. ->>display statistics for QID MXID11000009156212358279905535000000000000206U3333300_305_S1 ; -Qid MXID11000009156212358279905535000000000000206U3333300_305_S1 -Compile Start Time 2017/04/06 23:06:00.886062 -Compile End Time 2017/04/06 23:06:00.933429 -Compile Elapsed Time 0:00:00.047367 +>>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 -1 Execute End Time -1 Execute Elapsed Time 0:00:00.000000 @@ -1715,11 +1739,11 @@ Last Suspend Time -1 Stats Collection Type OPERATOR_STATS --- SQL operation complete. ->>get statistics for QID MXID11000009156212358279905535000000000000206U3333300_305_S1 ; -Qid MXID11000009156212358279905535000000000000206U3333300_305_S1 -Compile Start Time 2017/04/06 23:06:00.886062 -Compile End Time 2017/04/06 23:06:00.933429 -Compile Elapsed Time 0:00:00.047367 +>>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 -1 Execute End Time -1 Execute Elapsed Time 0:00:00.000000 @@ -1766,14 +1790,14 @@ D >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; --- SQL operation complete. ->>display statistics for QID MXID11000009156212358279905535000000000000206U3333300_305_S1 ; -Qid MXID11000009156212358279905535000000000000206U3333300_305_S1 -Compile Start Time 2017/04/06 23:06:00.886062 -Compile End Time 2017/04/06 23:06:00.933429 -Compile Elapsed Time 0:00:00.047367 -Execute Start Time 2017/04/06 23:06:06.989107 -Execute End Time 2017/04/06 23:06:07.002116 -Execute Elapsed Time 0:00:00.013009 +>>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 State CLOSE Rows Affected 0 SQL Error Code 100 @@ -1791,7 +1815,7 @@ Transaction Id -1 Source String select distinct d from tstat ; SQL Source Length 30 Rows Returned 4 -First Row Returned Time 2017/04/06 23:06:07.000444 +First Row Returned Time 2017/05/07 05:41:26.564755 Last Error before AQR 0 Number of AQR retries 0 Delay before AQR 0 @@ -1802,27 +1826,27 @@ 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 8 0 4 24 815 -9 . 10 11 4 0 EX_SPLIT_TOP 1 5 7 2 4 24 -8 . 9 10 4 0 EX_SEND_TOP 2 10 800 2 4 32 -7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 144 2 4 32 -6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 14 2 4 24 3583 -5 . 6 7 3 2 EX_HASH_GRBY 2 6 2,638 1 4 24 0|0|0 -4 . 5 6 2 2 EX_SPLIT_TOP 2 11 13 100 4 24 -3 . 4 5 2 2 EX_SEND_TOP 4 18 774 100 4 32 -2 . 3 4 2 3 EX_SEND_BOTTOM 4 35 176 100 4 32 -1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 22 100 4 24 1983 -. . 1 2 1 3 EX_TRAF_KEY_SELECT 2 12 5,355 100 4 24 TRAFODION.SCH.TSTAT|4|176 - ---- SQL operation complete. ->>get statistics for QID MXID11000009156212358279905535000000000000206U3333300_305_S1 ; -Qid MXID11000009156212358279905535000000000000206U3333300_305_S1 -Compile Start Time 2017/04/06 23:06:00.886062 -Compile End Time 2017/04/06 23:06:00.933429 -Compile Elapsed Time 0:00:00.047367 -Execute Start Time 2017/04/06 23:06:06.989107 -Execute End Time 2017/04/06 23:06:07.002116 -Execute Elapsed Time 0:00:00.013009 +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 + +--- 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 State CLOSE Rows Affected 0 SQL Error Code 100 @@ -1840,7 +1864,7 @@ Transaction Id -1 Source String select distinct d from tstat ; SQL Source Length 30 Rows Returned 4 -First Row Returned Time 2017/04/06 23:06:07.000444 +First Row Returned Time 2017/05/07 05:41:26.564755 Last Error before AQR 0 Number of AQR retries 0 Delay before AQR 0 @@ -1851,31 +1875,31 @@ 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 8 0 4 24 815 -9 . 10 11 4 0 EX_SPLIT_TOP 1 5 7 2 4 24 -8 . 9 10 4 0 EX_SEND_TOP 2 10 800 2 4 32 -7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 144 2 4 32 -6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 14 2 4 24 3583 -5 . 6 7 3 2 EX_HASH_GRBY 2 6 2,638 1 4 24 0|0|0 -4 . 5 6 2 2 EX_SPLIT_TOP 2 11 13 100 4 24 -3 . 4 5 2 2 EX_SEND_TOP 4 18 774 100 4 32 -2 . 3 4 2 3 EX_SEND_BOTTOM 4 35 176 100 4 32 -1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 22 100 4 24 1983 -. . 1 2 1 3 EX_TRAF_KEY_SELECT 2 12 5,355 100 4 24 TRAFODION.SCH.TSTAT|4|176 +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 --- SQL operation complete. >>log; >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; --- SQL operation complete. ->>display statistics for QID MXID11000009156212358279905535000000000000206U3333300_305_S1 ACCUMULATED; -Qid MXID11000009156212358279905535000000000000206U3333300_305_S1 -Compile Start Time 2017/04/06 23:06:00.886062 -Compile End Time 2017/04/06 23:06:00.933429 -Compile Elapsed Time 0:00:00.047367 -Execute Start Time 2017/04/06 23:06:06.989107 -Execute End Time 2017/04/06 23:06:07.002116 -Execute Elapsed Time 0:00:00.013009 +>>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 State CLOSE Rows Affected 0 SQL Error Code 100 @@ -1893,7 +1917,7 @@ Transaction Id -1 Source String select distinct d from tstat ; SQL Source Length 30 Rows Returned 4 -First Row Returned Time 2017/04/06 23:06:07.000444 +First Row Returned Time 2017/05/07 05:41:26.564755 Last Error before AQR 0 Number of AQR retries 0 Delay before AQR 0 @@ -1905,8 +1929,8 @@ Accessed Rows 4 Used Rows 4 SE IOs 4 SE IO Bytes 176 -SE IO MAX Time 3,572 -SQL Process Busy Time 6,381 +SE IO MAX Time 12,163 +SQL Process Busy Time 18,938 UDR Process Busy Time 0 SQL Space Allocated 896 KB SQL Space Used 766 KB @@ -1916,26 +1940,29 @@ SQL Heap WM 10,341 KB Processes Created 0 Process Create Time 0 Request Message Count 28 -Request Message Bytes 39,712 +Request Message Bytes 40,128 Reply Message Count 15 -Reply Message Bytes 42,416 +Reply Message Bytes 42,696 +BMO Space Buffer Size 256 +BMO Space Buffer Count 0 +BMO Interim Row Count 0 Scr. Overflow Mode DISK Scr. File Count 0 -Scr. Buffer Blk Size 0 -Scr. Buffer Blks Read 0 -Scr. Buffer Blks Written 0 +Scr. IO Size 0 Scr. Read Count 0 Scr. Write Count 0 +Scr. IO Max Time 0 +Sort TopN -1 --- SQL operation complete. ->>get statistics for QID MXID11000009156212358279905535000000000000206U3333300_305_S1 ACCUMULATED; -Qid MXID11000009156212358279905535000000000000206U3333300_305_S1 -Compile Start Time 2017/04/06 23:06:00.886062 -Compile End Time 2017/04/06 23:06:00.933429 -Compile Elapsed Time 0:00:00.047367 -Execute Start Time 2017/04/06 23:06:06.989107 -Execute End Time 2017/04/06 23:06:07.002116 -Execute Elapsed Time 0:00:00.013009 +>>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 State CLOSE Rows Affected 0 SQL Error Code 100 @@ -1953,7 +1980,7 @@ Transaction Id -1 Source String select distinct d from tstat ; SQL Source Length 30 Rows Returned 4 -First Row Returned Time 2017/04/06 23:06:07.000444 +First Row Returned Time 2017/05/07 05:41:26.564755 Last Error before AQR 0 Number of AQR retries 0 Delay before AQR 0 @@ -1965,8 +1992,8 @@ Accessed Rows 4 Used Rows 4 SE IOs 4 SE IO Bytes 176 -SE IO MAX Time 3,572 -SQL Process Busy Time 6,381 +SE IO MAX Time 12,163 +SQL Process Busy Time 18,938 UDR Process Busy Time 0 SQL Space Allocated 896 KB SQL Space Used 766 KB @@ -1976,30 +2003,33 @@ SQL Heap WM 10,341 KB Processes Created 0 Process Create Time 0 Request Message Count 28 -Request Message Bytes 39,712 +Request Message Bytes 40,128 Reply Message Count 15 -Reply Message Bytes 42,416 +Reply Message Bytes 42,696 +BMO Space Buffer Size 256 +BMO Space Buffer Count 0 +BMO Interim Row Count 0 Scr. Overflow Mode DISK Scr. File Count 0 -Scr. Buffer Blk Size 0 -Scr. Buffer Blks Read 0 -Scr. Buffer Blks Written 0 +Scr. IO Size 0 Scr. Read Count 0 Scr. Write Count 0 +Scr. IO Max Time 0 +Sort TopN -1 --- SQL operation complete. >>log; >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; --- SQL operation complete. ->>display statistics for QID MXID11000009156212358279905535000000000000206U3333300_305_S1 PERTABLE; -Qid MXID11000009156212358279905535000000000000206U3333300_305_S1 -Compile Start Time 2017/04/06 23:06:00.886062 -Compile End Time 2017/04/06 23:06:00.933429 -Compile Elapsed Time 0:00:00.047367 -Execute Start Time 2017/04/06 23:06:06.989107 -Execute End Time 2017/04/06 23:06:07.002116 -Execute Elapsed Time 0:00:00.013009 +>>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 State CLOSE Rows Affected 0 SQL Error Code 100 @@ -2017,7 +2047,7 @@ Transaction Id -1 Source String select distinct d from tstat ; SQL Source Length 30 Rows Returned 4 -First Row Returned Time 2017/04/06 23:06:07.000444 +First Row Returned Time 2017/05/07 05:41:26.564755 Last Error before AQR 0 Number of AQR retries 0 Delay before AQR 0 @@ -2025,7 +2055,7 @@ No. of times reclaimed 0 Cancel Time -1 Last Suspend Time -1 Stats Collection Type OPERATOR_STATS -SQL Process Busy Time 6,381 +SQL Process Busy Time 18,938 UDR Process Busy Time 0 SQL Space Allocated 896 KB SQL Space Used 766 KB @@ -2035,34 +2065,34 @@ SQL Heap WM 10,341 KB Processes Created 0 Process Create Time 0 Request Message Count 28 -Request Message Bytes 39,712 +Request Message Bytes 40,128 Reply Message Count 15 -Reply Message Bytes 42,416 +Reply Message Bytes 42,696 +BMO Space Buffer Size 256 +BMO Space Buffer Count 0 +BMO Interim Row Count 0 Scr. Overflow Mode DISK Scr. File Count 0 -Scr. Buffer Blk Size 0 -Scr. Buffer Blks Read 0 -Scr. Buffer Blks Written 0 +Scr. IO Size 0 Scr. Read Count 0 Scr. Write Count 0 +Scr. IO Max Time 0 Sort TopN -1 - ID DOP Table Name - Records Accessed Records Used HBase/Hive HBase/Hive HBase/Hive IO HBase/Hive IO - Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time - 1 2 TRAFODION.SCH.TSTAT - 0 100 - 4 4 4 0 6,690 3,572 + Id DOP Table Name + EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_Bytes SE_IO_SumTime SE_IO_MaxTime + 1 2 TRAFODION.SCH.TSTAT + 0 4 100 4 4 0 22,124 12,163 --- SQL operation complete. ->>get statistics for QID MXID11000009156212358279905535000000000000206U3333300_305_S1 PERTABLE; -Qid MXID11000009156212358279905535000000000000206U3333300_305_S1 -Compile Start Time 2017/04/06 23:06:00.886062 -Compile End Time 2017/04/06 23:06:00.933429 -Compile Elapsed Time 0:00:00.047367 -Execute Start Time 2017/04/06 23:06:06.989107 -Execute End Time 2017/04/06 23:06:07.002116 -Execute Elapsed Time 0:00:00.013009 +>>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 State CLOSE Rows Affected 0 SQL Error Code 100 @@ -2080,7 +2110,7 @@ Transaction Id -1 Source String select distinct d from tstat ; SQL Source Length 30 Rows Returned 4 -First Row Returned Time 2017/04/06 23:06:07.000444 +First Row Returned Time 2017/05/07 05:41:26.564755 Last Error before AQR 0 Number of AQR retries 0 Delay before AQR 0 @@ -2088,7 +2118,7 @@ No. of times reclaimed 0 Cancel Time -1 Last Suspend Time -1 Stats Collection Type OPERATOR_STATS -SQL Process Busy Time 6,381 +SQL Process Busy Time 18,938 UDR Process Busy Time 0 SQL Space Allocated 896 KB SQL Space Used 766 KB @@ -2098,38 +2128,38 @@ SQL Heap WM 10,341 KB Processes Created 0 Process Create Time 0 Request Message Count 28 -Request Message Bytes 39,712 +Request Message Bytes 40,128 Reply Message Count 15 -Reply Message Bytes 42,416 +Reply Message Bytes 42,696 +BMO Space Buffer Size 256 +BMO Space Buffer Count 0 +BMO Interim Row Count 0 Scr. Overflow Mode DISK Scr. File Count 0 -Scr. Buffer Blk Size 0 -Scr. Buffer Blks Read 0 -Scr. Buffer Blks Written 0 +Scr. IO Size 0 Scr. Read Count 0 Scr. Write Count 0 +Scr. IO Max Time 0 Sort TopN -1 - ID DOP Table Name - Records Accessed Records Used HBase/Hive HBase/Hive HBase/Hive IO HBase/Hive IO - Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time - 1 2 TRAFODION.SCH.TSTAT - 0 100 - 4 4 4 0 6,690 3,572 + Id DOP Table Name + EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_Bytes SE_IO_SumTime SE_IO_MaxTime + 1 2 TRAFODION.SCH.TSTAT + 0 4 100 4 4 0 22,124 12,163 --- SQL operation complete. >>log; >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; --- SQL operation complete. ->>display statistics for QID MXID11000009156212358279905535000000000000206U3333300_305_S1 PROGRESS; -Qid MXID11000009156212358279905535000000000000206U3333300_305_S1 -Compile Start Time 2017/04/06 23:06:00.886062 -Compile End Time 2017/04/06 23:06:00.933429 -Compile Elapsed Time 0:00:00.047367 -Execute Start Time 2017/04/06 23:06:06.989107 -Execute End Time 2017/04/06 23:06:07.002116 -Execute Elapsed Time 0:00:00.013009 +>>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 State CLOSE Rows Affected 0 SQL Error Code 100 @@ -2147,7 +2177,7 @@ Transaction Id -1 Source String select distinct d from tstat ; SQL Source Length 30 Rows Returned 4 -First Row Returned Time 2017/04/06 23:06:07.000444 +First Row Returned Time 2017/05/07 05:41:26.564755 Last Error before AQR 0 Number of AQR retries 0 Delay before AQR 0 @@ -2155,7 +2185,7 @@ No. of times reclaimed 0 Cancel Time -1 Last Suspend Time -1 Stats Collection Type OPERATOR_STATS -SQL Process Busy Time 6,381 +SQL Process Busy Time 18,938 SQL Space Allocated 896 KB SQL Space Used 766 KB SQL Heap Allocated 200 KB @@ -2164,33 +2194,31 @@ SQL Heap WM 10,341 KB Processes Created 0 Process Create Time 0 Request Message Count 28 -Request Message Bytes 39,712 +Request Message Bytes 40,128 Reply Message Count 15 -Reply Message Bytes 42,416 - - ID DOP Table Name - Records Accessed Records Used HBase/Hive HBase/Hive HBase/Hive IO HBase/Hive IO - Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time - 1 2 TRAFODION.SCH.TSTAT - 0 100 - 4 4 4 0 6,690 3,572 - - Id TDBName Mode DOP TopN CPUTime - BMOHeapUsed BMOHeapAllocated BMOHeapWM BMOSpaceBufSz BMOSpaceBufCnt - ScrFileCnt ScrIOSize ScrIORead ScrIOWritten ScrIOTime ScrIOMaxTime - 6 EX_HASH_GRBY DISK 2 -1 2,638 - 0 0 0 256 0 - 0 -1 0 0 0 0 - ---- SQL operation complete. ->>get statistics for QID MXID11000009156212358279905535000000000000206U3333300_305_S1 PROGRESS; -Qid MXID11000009156212358279905535000000000000206U3333300_305_S1 -Compile Start Time 2017/04/06 23:06:00.886062 -Compile End Time 2017/04/06 23:06:00.933429 -Compile Elapsed Time 0:00:00.047367 -Execute Start Time 2017/04/06 23:06:06.989107 -Execute End Time 2017/04/06 23:06:07.002116 -Execute Elapsed Time 0:00:00.013009 +Reply Message Bytes 42,696 + + Id DOP Table Name + EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_Bytes SE_IO_SumTime SE_IO_MaxTime + 1 2 TRAFODION.SCH.TSTAT + 0 4 100 4 4 0 22,124 12,163 + + 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 + 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 +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 State CLOSE Rows Affected 0 SQL Error Code 100 @@ -2208,7 +2236,7 @@ Transaction Id -1 Source String select distinct d from tstat ; SQL Source Length 30 Rows Returned 4 -First Row Returned Time 2017/04/06 23:06:07.000444 +First Row Returned Time 2017/05/07 05:41:26.564755 Last Error before AQR 0 Number of AQR retries 0 Delay before AQR 0 @@ -2216,7 +2244,7 @@ No. of times reclaimed 0 Cancel Time -1 Last Suspend Time -1 Stats Collection Type OPERATOR_STATS -SQL Process Busy Time 6,381 +SQL Process Busy Time 18,938 SQL Space Allocated 896 KB SQL Space Used 766 KB SQL Heap Allocated 200 KB @@ -2225,37 +2253,35 @@ SQL Heap WM 10,341 KB Processes Created 0 Process Create Time 0 Request Message Count 28 -Request Message Bytes 39,712 +Request Message Bytes 40,128 Reply Message Count 15 -Reply Message Bytes 42,416 +Reply Message Bytes 42,696 - ID DOP Table Name - Records Accessed Records Used HBase/Hive HBase/Hive HBase/Hive IO HBase/Hive IO - Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time - 1 2 TRAFODION.SCH.TSTAT - 0 100 - 4 4 4 0 6,690 3,572 + Id DOP Table Name + EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_Bytes SE_IO_SumTime SE_IO_MaxTime + 1 2 TRAFODION.SCH.TSTAT + 0 4 100 4 4 0 22,124 12,163 - Id TDBName Mode DOP TopN CPUTime - BMOHeapUsed BMOHeapAllocated BMOHeapWM BMOSpaceBufSz BMOSpaceBufCnt - ScrFileCnt ScrIOSize ScrIORead ScrIOWritten ScrIOTime ScrIOMaxTime - 6 EX_HASH_GRBY DISK 2 -1 2,638 - 0 0 0 256 0 - 0 -1 0 0 0 0 + 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 + 4 1,024 7,687 256 0 + 0 -1 0 0 0 0 --- SQL operation complete. >>log; >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; --- SQL operation complete. ->>display statistics for QID MXID11000009156212358279905535000000000000206U3333300_305_S1 DEFAULT; -Qid MXID11000009156212358279905535000000000000206U3333300_305_S1 -Compile Start Time 2017/04/06 23:06:00.886062 -Compile End Time 2017/04/06 23:06:00.933429 -Compile Elapsed Time 0:00:00.047367 -Execute Start Time 2017/04/06 23:06:06.989107 -Execute End Time 2017/04/06 23:06:07.002116 -Execute Elapsed Time 0:00:00.013009 +>>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 DEFAULT; +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