You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by su...@apache.org on 2017/02/16 16:22:51 UTC
[1/4] incubator-trafodion git commit: [TRAFODION-2854] Improve SET
STATISTICS command to display the information in new format
Repository: incubator-trafodion
Updated Branches:
refs/heads/master 60fcb5457 -> da2bd7b0f
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6973d3a1/core/sql/regress/core/TESTRTS
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/TESTRTS b/core/sql/regress/core/TESTRTS
index 9a97213..e206bef 100755
--- a/core/sql/regress/core/TESTRTS
+++ b/core/sql/regress/core/TESTRTS
@@ -174,6 +174,17 @@ set session default statistics_view_type 'progress' ;
get statistics for qid current ;
set session default statistics_view_type 'pertable' ;
+-- TEST for set session settings
+set statistics pertable ;
+execute s1 ;
+set statistics progress ;
+execute s1 ;
+set statistics default ;
+execute s1 ;
+set statistics all ;
+execute s1 ;
+set statistics off ;
+
-- TEST for RMS Stats
get statistics for RMS 0 ;
-- get statistics for RMS all is not tested because it can filtering issues
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6973d3a1/core/sql/sqlci/SqlciStats.cpp
----------------------------------------------------------------------
diff --git a/core/sql/sqlci/SqlciStats.cpp b/core/sql/sqlci/SqlciStats.cpp
index a01ab40..ea15aee 100644
--- a/core/sql/sqlci/SqlciStats.cpp
+++ b/core/sql/sqlci/SqlciStats.cpp
@@ -118,26 +118,48 @@ short SqlciStats::displayStats(SqlciEnv * sqlci_env)
// do not display, if stats display is set to off.
if (statsDisplay_ == FALSE)
return 0;
-
Lng32 newStrLen =
- strlen("GET STATISTICS , options ") +
+ strlen("GET STATISTICS ") +
(statsOptions_ ? strlen(statsOptions_) : 0) +
- 10;
+ 50;
char * newStr = new char[newStrLen+1];
+ NABoolean displayAll = FALSE;
strcpy(newStr, "GET STATISTICS ");
if (statsOptions_)
- {
- strcat(newStr, ", options '");
- strcat(newStr, statsOptions_);
- strcat(newStr, "'");
- }
+ {
+ if (strcmp(statsOptions_, "PERTABLE") == 0)
+ strcat(newStr, "FOR QID CURRENT PERTABLE ");
+ else if (strcmp(statsOptions_, "PROGRESS") == 0)
+ strcat(newStr, "FOR QID CURRENT PROGRESS ");
+ else if (strcmp(statsOptions_, "DEFAULT") == 0)
+ strcat(newStr, "FOR QID CURRENT DEFAULT ");
+ else if (strcmp(statsOptions_, "ALL") == 0)
+ displayAll = TRUE;
+ else if (statsOptions_)
+ {
+ strcat(newStr, ", options '");
+ strcat(newStr, statsOptions_);
+ strcat(newStr, "'");
+ }
+ }
strcat(newStr, ";");
-
NABoolean savedShowshape = sqlci_env->showShape();
sqlci_env->showShape() = FALSE;
statsDisplay_ = FALSE;
- DML dml(newStr, DML_DESCRIBE_TYPE, "__MXCI_GET_STATS__");
- retcode = dml.process(sqlci_env);
+ if (displayAll)
+ {
+ strcpy(newStr, "GET STATISTICS FOR QID CURRENT PROGRESS ;");
+ DML dml(newStr, DML_DESCRIBE_TYPE, "__MXCI_GET_STATS__");
+ retcode = dml.process(sqlci_env);
+ strcpy(newStr, "GET STATISTICS FOR QID CURRENT DEFAULT ;");
+ DML dml1(newStr, DML_DESCRIBE_TYPE, "__MXCI_GET_STATS__");
+ retcode = dml1.process(sqlci_env);
+ }
+ else
+ {
+ DML dml(newStr, DML_DESCRIBE_TYPE, "__MXCI_GET_STATS__");
+ retcode = dml.process(sqlci_env);
+ }
delete [] newStr;
sqlci_env->showShape() = savedShowshape;
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6973d3a1/core/sql/sqlci/sqlci_yacc.y
----------------------------------------------------------------------
diff --git a/core/sql/sqlci/sqlci_yacc.y b/core/sql/sqlci/sqlci_yacc.y
index 6ff169c..03e6094 100644
--- a/core/sql/sqlci/sqlci_yacc.y
+++ b/core/sql/sqlci/sqlci_yacc.y
@@ -1130,32 +1130,57 @@ sqlci_cmd : MODE REPORT
$$ = new Shape(FALSE, identifier_name_internal, $7);
}
- | SETtoken STATISTICS ON COMMA GETtoken STATISTICS
+ | SETtoken STATISTICS OFF
{
- // display stats in new format
- $$ = new Statistics(NULL, 0, Statistics::SET_ON, NULL);
+ $$ = new Statistics(0,0,Statistics::SET_OFF, NULL);
}
- | SETtoken STATISTICS ON COMMA GETtoken STATISTICS COMMA OPTIONStoken QUOTED_STRING
+ | SETtoken STATISTICS ON
{
- // display stats in new format based on options in
- // quoted_string
+ // display statistics in old format
$$ = new Statistics(NULL, 0, Statistics::SET_ON,
- $9);
+ (char *)"of");
+ }
+
+ | SETtoken STATISTICS PERTABLEtoken
+ {
+ $$ = new Statistics(NULL, 0, Statistics::SET_ON,
+ (char *)"PERTABLE");
}
- | SETtoken STATISTICS ON
+ | SETtoken STATISTICS PROGRESStoken
{
- // display statistics in old format
$$ = new Statistics(NULL, 0, Statistics::SET_ON,
- (char *)"of");
+ (char *)"PROGRESS");
}
- | SETtoken STATISTICS OFF
+ | SETtoken STATISTICS DEFAULTtoken
{
- $$ = new Statistics(0,0,Statistics::SET_OFF, NULL);
+ $$ = new Statistics(NULL, 0, Statistics::SET_ON,
+ (char *)"DEFAULT");
+ }
+
+ | SETtoken STATISTICS ALLtoken
+ {
+ $$ = new Statistics(NULL, 0, Statistics::SET_ON,
+ (char *)"ALL");
+ }
+
+
+ | SETtoken STATISTICS ON COMMA GETtoken STATISTICS
+ {
+ // display stats in new format
+ $$ = new Statistics(NULL, 0, Statistics::SET_ON, NULL);
}
+ | SETtoken STATISTICS ON COMMA GETtoken STATISTICS COMMA OPTIONStoken QUOTED_STRING
+ {
+ // display stats in new format based on options in
+ // quoted_string
+ $$ = new Statistics(NULL, 0, Statistics::SET_ON,
+ $9);
+ }
+
| SETtoken LISTCOUNT NUMBER
{
#pragma nowarn(1506) // warning elimination
[2/4] incubator-trafodion git commit: [TRAFODION-2854] Improve SET
STATISTICS command to display the information in new format
Posted by su...@apache.org.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6973d3a1/core/sql/regress/core/EXPECTEDRTS
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/EXPECTEDRTS b/core/sql/regress/core/EXPECTEDRTS
index aa54988..c75fae3 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 MXID11000008082212350752509978000000000000206U3333300_303_S1
-Compile Start Time 2017/01/09 20:08:43.285350
-Compile End Time 2017/01/09 20:08:43.355507
-Compile Elapsed Time 0:00:00.070157
+Qid MXID11000027092212353966950645999000000000206U3333300_303_S1
+Compile Start Time 2017/02/16 01:02:45.193696
+Compile End Time 2017/02/16 01:02:45.225119
+Compile Elapsed Time 0:00:00.031423
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -74,7 +74,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -94,11 +94,11 @@ Stats Collection Type ACCUMULATED_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000008082212350752509978000000000000206U3333300_303_S1 ;
-Qid MXID11000008082212350752509978000000000000206U3333300_303_S1
-Compile Start Time 2017/01/09 20:08:43.285350
-Compile End Time 2017/01/09 20:08:43.355507
-Compile Elapsed Time 0:00:00.070157
+>>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_303_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_303_S1
+Compile Start Time 2017/02/16 01:02:45.193696
+Compile End Time 2017/02/16 01:02:45.225119
+Compile Elapsed Time 0:00:00.031423
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -113,7 +113,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -129,11 +129,11 @@ Last Suspend Time -1
Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_303_S1 ;
-Qid MXID11000008082212350752509978000000000000206U3333300_303_S1
-Compile Start Time 2017/01/09 20:08:43.285350
-Compile End Time 2017/01/09 20:08:43.355507
-Compile Elapsed Time 0:00:00.070157
+>>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_303_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_303_S1
+Compile Start Time 2017/02/16 01:02:45.193696
+Compile End Time 2017/02/16 01:02:45.225119
+Compile Elapsed Time 0:00:00.031423
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -148,7 +148,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -166,10 +166,10 @@ Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000008082212350752509978000000000000206U3333300_303_S1
-Compile Start Time 2017/01/09 20:08:43.285350
-Compile End Time 2017/01/09 20:08:43.355507
-Compile Elapsed Time 0:00:00.070157
+Qid MXID11000027092212353966950645999000000000206U3333300_303_S1
+Compile Start Time 2017/02/16 01:02:45.193696
+Compile End Time 2017/02/16 01:02:45.225119
+Compile Elapsed Time 0:00:00.031423
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -184,7 +184,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -201,10 +201,10 @@ Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000008082212350752509978000000000000206U3333300_303_S1
-Compile Start Time 2017/01/09 20:08:43.285350
-Compile End Time 2017/01/09 20:08:43.355507
-Compile Elapsed Time 0:00:00.070157
+Qid MXID11000027092212353966950645999000000000206U3333300_303_S1
+Compile Start Time 2017/02/16 01:02:45.193696
+Compile End Time 2017/02/16 01:02:45.225119
+Compile Elapsed Time 0:00:00.031423
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -219,7 +219,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -240,24 +240,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 MXID11000008082212350752509978000000000000206U3333300_303_S1 ;
-Qid MXID11000008082212350752509978000000000000206U3333300_303_S1
-Compile Start Time 2017/01/09 20:08:43.285350
-Compile End Time 2017/01/09 20:08:43.355507
-Compile Elapsed Time 0:00:00.070157
-Execute Start Time 2017/01/09 20:09:49.582511
-Execute End Time 2017/01/09 20:09:52.475038
-Execute Elapsed Time 0:00:02.892527
+>>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_303_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_303_S1
+Compile Start Time 2017/02/16 01:02:45.193696
+Compile End Time 2017/02/16 01:02:45.225119
+Compile Elapsed Time 0:00:00.031423
+Execute Start Time 2017/02/16 01:02:48.212804
+Execute End Time 2017/02/16 01:02:51.350916
+Execute Elapsed Time 0:00:03.138112
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -269,13 +269,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 2
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:09:52.472998
+First Row Returned Time 2017/02/16 01:02:51.349044
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -287,19 +287,19 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 521,867
-SQL Process Busy Time 4,010,959
+SE IO MAX Time 708,700
+SQL Process Busy Time 4,139,515
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 17 KB
+SQL Heap Used 16 KB
Processes Created 2
-Process Create Time 187,585
+Process Create Time 120,844
Request Message Count 26
-Request Message Bytes 39,664
-Reply Message Count 15
-Reply Message Bytes 38,696
+Request Message Bytes 39,392
+Reply Message Count 14
+Reply Message Bytes 32,184
Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -309,14 +309,14 @@ Scr. Read Count 0
Scr. Write Count 0
--- SQL operation complete.
->>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_303_S1 ;
-Qid MXID11000008082212350752509978000000000000206U3333300_303_S1
-Compile Start Time 2017/01/09 20:08:43.285350
-Compile End Time 2017/01/09 20:08:43.355507
-Compile Elapsed Time 0:00:00.070157
-Execute Start Time 2017/01/09 20:09:49.582511
-Execute End Time 2017/01/09 20:09:52.475038
-Execute Elapsed Time 0:00:02.892527
+>>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_303_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_303_S1
+Compile Start Time 2017/02/16 01:02:45.193696
+Compile End Time 2017/02/16 01:02:45.225119
+Compile Elapsed Time 0:00:00.031423
+Execute Start Time 2017/02/16 01:02:48.212804
+Execute End Time 2017/02/16 01:02:51.350916
+Execute Elapsed Time 0:00:03.138112
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -328,13 +328,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 2
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:09:52.472998
+First Row Returned Time 2017/02/16 01:02:51.349044
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -346,19 +346,19 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 521,867
-SQL Process Busy Time 4,010,959
+SE IO MAX Time 708,700
+SQL Process Busy Time 4,139,515
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 17 KB
+SQL Heap Used 16 KB
Processes Created 2
-Process Create Time 187,585
+Process Create Time 120,844
Request Message Count 26
-Request Message Bytes 39,664
-Reply Message Count 15
-Reply Message Bytes 38,696
+Request Message Bytes 39,392
+Reply Message Count 14
+Reply Message Bytes 32,184
Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -370,13 +370,13 @@ Scr. Write Count 0
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000008082212350752509978000000000000206U3333300_303_S1
-Compile Start Time 2017/01/09 20:08:43.285350
-Compile End Time 2017/01/09 20:08:43.355507
-Compile Elapsed Time 0:00:00.070157
-Execute Start Time 2017/01/09 20:09:49.582511
-Execute End Time 2017/01/09 20:09:52.475038
-Execute Elapsed Time 0:00:02.892527
+Qid MXID11000027092212353966950645999000000000206U3333300_303_S1
+Compile Start Time 2017/02/16 01:02:45.193696
+Compile End Time 2017/02/16 01:02:45.225119
+Compile Elapsed Time 0:00:00.031423
+Execute Start Time 2017/02/16 01:02:48.212804
+Execute End Time 2017/02/16 01:02:51.350916
+Execute Elapsed Time 0:00:03.138112
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -388,13 +388,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 1
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:09:52.472998
+First Row Returned Time 2017/02/16 01:02:51.349044
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -406,19 +406,19 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 521,867
-SQL Process Busy Time 4,010,959
+SE IO MAX Time 708,700
+SQL Process Busy Time 4,139,515
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 17 KB
+SQL Heap Used 16 KB
Processes Created 2
-Process Create Time 187,585
+Process Create Time 120,844
Request Message Count 26
-Request Message Bytes 39,664
-Reply Message Count 15
-Reply Message Bytes 38,696
+Request Message Bytes 39,392
+Reply Message Count 14
+Reply Message Bytes 32,184
Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -429,13 +429,13 @@ Scr. Write Count 0
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000008082212350752509978000000000000206U3333300_303_S1
-Compile Start Time 2017/01/09 20:08:43.285350
-Compile End Time 2017/01/09 20:08:43.355507
-Compile Elapsed Time 0:00:00.070157
-Execute Start Time 2017/01/09 20:09:49.582511
-Execute End Time 2017/01/09 20:09:52.475038
-Execute Elapsed Time 0:00:02.892527
+Qid MXID11000027092212353966950645999000000000206U3333300_303_S1
+Compile Start Time 2017/02/16 01:02:45.193696
+Compile End Time 2017/02/16 01:02:45.225119
+Compile Elapsed Time 0:00:00.031423
+Execute Start Time 2017/02/16 01:02:48.212804
+Execute End Time 2017/02/16 01:02:51.350916
+Execute Elapsed Time 0:00:03.138112
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -447,13 +447,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 1
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:09:52.472998
+First Row Returned Time 2017/02/16 01:02:51.349044
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -465,19 +465,19 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 521,867
-SQL Process Busy Time 4,010,959
+SE IO MAX Time 708,700
+SQL Process Busy Time 4,139,515
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 17 KB
+SQL Heap Used 16 KB
Processes Created 2
-Process Create Time 187,585
+Process Create Time 120,844
Request Message Count 26
-Request Message Bytes 39,664
-Reply Message Count 15
-Reply Message Bytes 38,696
+Request Message Bytes 39,392
+Reply Message Count 14
+Reply Message Bytes 32,184
Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -494,25 +494,25 @@ Scr. Write Count 0
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000008082212350752509978000000000000206U3333300_303_S1 ;
+>>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_303_S1 ;
-*** ERROR[8923] The given Query Id MXID11000008082212350752509978000000000000206U3333300_303_S1 is not found.
+*** ERROR[8923] The given Query Id MXID11000027092212353966950645999000000000206U3333300_303_S1 is not found.
--- SQL operation failed with errors.
->>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_303_S1 ;
+>>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_303_S1 ;
-*** ERROR[8923] The given Query Id MXID11000008082212350752509978000000000000206U3333300_303_S1 is not found.
+*** ERROR[8923] The given Query Id MXID11000027092212353966950645999000000000206U3333300_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 MXID11000008082212350752509978000000000000206U3333300_312_S1 ;
-Qid MXID11000008082212350752509978000000000000206U3333300_312_S1
-Compile Start Time 2017/01/09 20:09:55.468228
-Compile End Time 2017/01/09 20:09:55.470745
-Compile Elapsed Time 0:00:00.002517
+>>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_312_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_312_S1
+Compile Start Time 2017/02/16 01:02:54.344766
+Compile End Time 2017/02/16 01:02:54.345294
+Compile Elapsed Time 0:00:00.000528
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -527,7 +527,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -543,11 +543,11 @@ Last Suspend Time -1
Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_312_S1 ;
-Qid MXID11000008082212350752509978000000000000206U3333300_312_S1
-Compile Start Time 2017/01/09 20:09:55.468228
-Compile End Time 2017/01/09 20:09:55.470745
-Compile Elapsed Time 0:00:00.002517
+>>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_312_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_312_S1
+Compile Start Time 2017/02/16 01:02:54.344766
+Compile End Time 2017/02/16 01:02:54.345294
+Compile Elapsed Time 0:00:00.000528
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -562,7 +562,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -580,10 +580,10 @@ Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000008082212350752509978000000000000206U3333300_312_S1
-Compile Start Time 2017/01/09 20:09:55.468228
-Compile End Time 2017/01/09 20:09:55.470745
-Compile Elapsed Time 0:00:00.002517
+Qid MXID11000027092212353966950645999000000000206U3333300_312_S1
+Compile Start Time 2017/02/16 01:02:54.344766
+Compile End Time 2017/02/16 01:02:54.345294
+Compile Elapsed Time 0:00:00.000528
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -598,7 +598,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -615,10 +615,10 @@ Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000008082212350752509978000000000000206U3333300_312_S1
-Compile Start Time 2017/01/09 20:09:55.468228
-Compile End Time 2017/01/09 20:09:55.470745
-Compile Elapsed Time 0:00:00.002517
+Qid MXID11000027092212353966950645999000000000206U3333300_312_S1
+Compile Start Time 2017/02/16 01:02:54.344766
+Compile End Time 2017/02/16 01:02:54.345294
+Compile Elapsed Time 0:00:00.000528
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -633,7 +633,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -662,10 +662,10 @@ Stats Collection Type ACCUMULATED_STATS
--- SQL command prepared.
>>log;
>>get statistics for qid current ;
-Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
-Compile Start Time 2017/01/09 20:10:01.640865
-Compile End Time 2017/01/09 20:10:01.709896
-Compile Elapsed Time 0:00:00.069031
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -680,7 +680,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -700,11 +700,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000008082212350752509978000000000000206U3333300_317_S1 ;
-Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
-Compile Start Time 2017/01/09 20:10:01.640865
-Compile End Time 2017/01/09 20:10:01.709896
-Compile Elapsed Time 0:00:00.069031
+>>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_317_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -719,7 +719,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -735,11 +735,11 @@ Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_317_S1 ;
-Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
-Compile Start Time 2017/01/09 20:10:01.640865
-Compile End Time 2017/01/09 20:10:01.709896
-Compile Elapsed Time 0:00:00.069031
+>>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_317_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -754,7 +754,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -774,11 +774,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000008082212350752509978000000000000206U3333300_317_S1 ACCUMULATED;
-Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
-Compile Start Time 2017/01/09 20:10:01.640865
-Compile End Time 2017/01/09 20:10:01.709896
-Compile Elapsed Time 0:00:00.069031
+>>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_317_S1 ACCUMULATED;
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -793,7 +793,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -809,11 +809,11 @@ Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_317_S1 ACCUMULATED;
-Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
-Compile Start Time 2017/01/09 20:10:01.640865
-Compile End Time 2017/01/09 20:10:01.709896
-Compile Elapsed Time 0:00:00.069031
+>>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_317_S1 ACCUMULATED;
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -828,7 +828,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -846,10 +846,10 @@ Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
-Compile Start Time 2017/01/09 20:10:01.640865
-Compile End Time 2017/01/09 20:10:01.709896
-Compile Elapsed Time 0:00:00.069031
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -864,7 +864,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -881,10 +881,10 @@ Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
-Compile Start Time 2017/01/09 20:10:01.640865
-Compile End Time 2017/01/09 20:10:01.709896
-Compile Elapsed Time 0:00:00.069031
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -899,7 +899,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -916,10 +916,10 @@ Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>display statistics for qid current accumulated ;
-Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
-Compile Start Time 2017/01/09 20:10:01.640865
-Compile End Time 2017/01/09 20:10:01.709896
-Compile Elapsed Time 0:00:00.069031
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -934,7 +934,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -951,10 +951,10 @@ Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>get statistics for qid current accumulated ;
-Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
-Compile Start Time 2017/01/09 20:10:01.640865
-Compile End Time 2017/01/09 20:10:01.709896
-Compile Elapsed Time 0:00:00.069031
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -969,7 +969,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -1000,14 +1000,14 @@ D
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000008082212350752509978000000000000206U3333300_317_S1 ;
-Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
-Compile Start Time 2017/01/09 20:10:01.640865
-Compile End Time 2017/01/09 20:10:01.709896
-Compile Elapsed Time 0:00:00.069031
-Execute Start Time 2017/01/09 20:10:07.923088
-Execute End Time 2017/01/09 20:10:07.942935
-Execute Elapsed Time 0:00:00.019847
+>>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_317_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
+Execute Start Time 2017/02/16 01:03:06.512541
+Execute End Time 2017/02/16 01:03:06.522982
+Execute Elapsed Time 0:00:00.010441
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1019,13 +1019,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 2
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:10:07.940066
+First Row Returned Time 2017/02/16 01:03:06.521253
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1033,18 +1033,18 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 9,754
+SQL Process Busy Time 6,176
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 15 KB
+SQL Heap Used 14 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,824
-Reply Message Count 15
-Reply Message Bytes 39,080
+Request Message Bytes 39,552
+Reply Message Count 14
+Reply Message Bytes 32,568
Scr. Overflow Mode UNKNOWN
Scr File Count 0
Scr. Buffer Blk Size 0
@@ -1059,17 +1059,17 @@ Table Name
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 9,099 4,678
+ 4 4 4 0 4,755 2,404
--- SQL operation complete.
->>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_317_S1 ;
-Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
-Compile Start Time 2017/01/09 20:10:01.640865
-Compile End Time 2017/01/09 20:10:01.709896
-Compile Elapsed Time 0:00:00.069031
-Execute Start Time 2017/01/09 20:10:07.923088
-Execute End Time 2017/01/09 20:10:07.942935
-Execute Elapsed Time 0:00:00.019847
+>>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_317_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
+Execute Start Time 2017/02/16 01:03:06.512541
+Execute End Time 2017/02/16 01:03:06.522982
+Execute Elapsed Time 0:00:00.010441
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1081,13 +1081,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 2
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:10:07.940066
+First Row Returned Time 2017/02/16 01:03:06.521253
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1095,18 +1095,18 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 9,754
+SQL Process Busy Time 6,176
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 15 KB
+SQL Heap Used 14 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,824
-Reply Message Count 15
-Reply Message Bytes 39,080
+Request Message Bytes 39,552
+Reply Message Count 14
+Reply Message Bytes 32,568
Scr. Overflow Mode UNKNOWN
Scr File Count 0
Scr. Buffer Blk Size 0
@@ -1121,21 +1121,21 @@ Table Name
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 9,099 4,678
+ 4 4 4 0 4,755 2,404
--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000008082212350752509978000000000000206U3333300_317_S1 ACCUMULATED;
-Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
-Compile Start Time 2017/01/09 20:10:01.640865
-Compile End Time 2017/01/09 20:10:01.709896
-Compile Elapsed Time 0:00:00.069031
-Execute Start Time 2017/01/09 20:10:07.923088
-Execute End Time 2017/01/09 20:10:07.942935
-Execute Elapsed Time 0:00:00.019847
+>>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_317_S1 ACCUMULATED;
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
+Execute Start Time 2017/02/16 01:03:06.512541
+Execute End Time 2017/02/16 01:03:06.522982
+Execute Elapsed Time 0:00:00.010441
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1147,13 +1147,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 2
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:10:07.940066
+First Row Returned Time 2017/02/16 01:03:06.521253
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1165,19 +1165,19 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 4,678
-SQL Process Busy Time 9,754
+SE IO MAX Time 2,404
+SQL Process Busy Time 6,176
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 15 KB
+SQL Heap Used 14 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,824
-Reply Message Count 15
-Reply Message Bytes 39,080
+Request Message Bytes 39,552
+Reply Message Count 14
+Reply Message Bytes 32,568
Scr. Overflow Mode UNKNOWN
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -1187,14 +1187,14 @@ Scr. Read Count 0
Scr. Write Count 0
--- SQL operation complete.
->>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_317_S1 ACCUMULATED;
-Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
-Compile Start Time 2017/01/09 20:10:01.640865
-Compile End Time 2017/01/09 20:10:01.709896
-Compile Elapsed Time 0:00:00.069031
-Execute Start Time 2017/01/09 20:10:07.923088
-Execute End Time 2017/01/09 20:10:07.942935
-Execute Elapsed Time 0:00:00.019847
+>>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_317_S1 ACCUMULATED;
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
+Execute Start Time 2017/02/16 01:03:06.512541
+Execute End Time 2017/02/16 01:03:06.522982
+Execute Elapsed Time 0:00:00.010441
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1206,13 +1206,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 2
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:10:07.940066
+First Row Returned Time 2017/02/16 01:03:06.521253
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1224,19 +1224,19 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 4,678
-SQL Process Busy Time 9,754
+SE IO MAX Time 2,404
+SQL Process Busy Time 6,176
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 15 KB
+SQL Heap Used 14 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,824
-Reply Message Count 15
-Reply Message Bytes 39,080
+Request Message Bytes 39,552
+Reply Message Count 14
+Reply Message Bytes 32,568
Scr. Overflow Mode UNKNOWN
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -1248,13 +1248,13 @@ Scr. Write Count 0
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
-Compile Start Time 2017/01/09 20:10:01.640865
-Compile End Time 2017/01/09 20:10:01.709896
-Compile Elapsed Time 0:00:00.069031
-Execute Start Time 2017/01/09 20:10:07.923088
-Execute End Time 2017/01/09 20:10:07.942935
-Execute Elapsed Time 0:00:00.019847
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
+Execute Start Time 2017/02/16 01:03:06.512541
+Execute End Time 2017/02/16 01:03:06.522982
+Execute Elapsed Time 0:00:00.010441
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1266,13 +1266,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 1
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:10:07.940066
+First Row Returned Time 2017/02/16 01:03:06.521253
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1280,18 +1280,18 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 9,754
+SQL Process Busy Time 6,176
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 15 KB
+SQL Heap Used 14 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,824
-Reply Message Count 15
-Reply Message Bytes 39,080
+Request Message Bytes 39,552
+Reply Message Count 14
+Reply Message Bytes 32,568
Scr. Overflow Mode UNKNOWN
Scr File Count 0
Scr. Buffer Blk Size 0
@@ -1306,17 +1306,17 @@ Table Name
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 9,099 4,678
+ 4 4 4 0 4,755 2,404
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
-Compile Start Time 2017/01/09 20:10:01.640865
-Compile End Time 2017/01/09 20:10:01.709896
-Compile Elapsed Time 0:00:00.069031
-Execute Start Time 2017/01/09 20:10:07.923088
-Execute End Time 2017/01/09 20:10:07.942935
-Execute Elapsed Time 0:00:00.019847
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
+Execute Start Time 2017/02/16 01:03:06.512541
+Execute End Time 2017/02/16 01:03:06.522982
+Execute Elapsed Time 0:00:00.010441
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1328,13 +1328,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 1
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:10:07.940066
+First Row Returned Time 2017/02/16 01:03:06.521253
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1342,18 +1342,18 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 9,754
+SQL Process Busy Time 6,176
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 15 KB
+SQL Heap Used 14 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,824
-Reply Message Count 15
-Reply Message Bytes 39,080
+Request Message Bytes 39,552
+Reply Message Count 14
+Reply Message Bytes 32,568
Scr. Overflow Mode UNKNOWN
Scr File Count 0
Scr. Buffer Blk Size 0
@@ -1368,17 +1368,17 @@ Table Name
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 9,099 4,678
+ 4 4 4 0 4,755 2,404
--- SQL operation complete.
>>display statistics for qid current accumulated;
-Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
-Compile Start Time 2017/01/09 20:10:01.640865
-Compile End Time 2017/01/09 20:10:01.709896
-Compile Elapsed Time 0:00:00.069031
-Execute Start Time 2017/01/09 20:10:07.923088
-Execute End Time 2017/01/09 20:10:07.942935
-Execute Elapsed Time 0:00:00.019847
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
+Execute Start Time 2017/02/16 01:03:06.512541
+Execute End Time 2017/02/16 01:03:06.522982
+Execute Elapsed Time 0:00:00.010441
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1390,13 +1390,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 1
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:10:07.940066
+First Row Returned Time 2017/02/16 01:03:06.521253
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1408,19 +1408,19 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 4,678
-SQL Process Busy Time 9,754
+SE IO MAX Time 2,404
+SQL Process Busy Time 6,176
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 15 KB
+SQL Heap Used 14 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,824
-Reply Message Count 15
-Reply Message Bytes 39,080
+Request Message Bytes 39,552
+Reply Message Count 14
+Reply Message Bytes 32,568
Scr. Overflow Mode UNKNOWN
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -1431,13 +1431,13 @@ Scr. Write Count 0
--- SQL operation complete.
>>get statistics for qid current accumulated;
-Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
-Compile Start Time 2017/01/09 20:10:01.640865
-Compile End Time 2017/01/09 20:10:01.709896
-Compile Elapsed Time 0:00:00.069031
-Execute Start Time 2017/01/09 20:10:07.923088
-Execute End Time 2017/01/09 20:10:07.942935
-Execute Elapsed Time 0:00:00.019847
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
+Execute Start Time 2017/02/16 01:03:06.512541
+Execute End Time 2017/02/16 01:03:06.522982
+Execute Elapsed Time 0:00:00.010441
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1449,13 +1449,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 1
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:10:07.940066
+First Row Returned Time 2017/02/16 01:03:06.521253
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1467,19 +1467,19 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 4,678
-SQL Process Busy Time 9,754
+SE IO MAX Time 2,404
+SQL Process Busy Time 6,176
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 15 KB
+SQL Heap Used 14 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,824
-Reply Message Count 15
-Reply Message Bytes 39,080
+Request Message Bytes 39,552
+Reply Message Count 14
+Reply Message Bytes 32,568
Scr. Overflow Mode UNKNOWN
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -1491,7 +1491,7 @@ Scr. Write Count 0
--- SQL operation complete.
>>log;
>>obey PQIDOUT;
->>SET SESSION DEFAULT PARENT_QID 'MXID11000008082212350752509978000000000000206U3333300_317_S1';
+>>SET SESSION DEFAULT PARENT_QID 'MXID11000027092212353966950645999000000000206U3333300_317_S1';
--- SQL operation complete.
>>prepare s1 from select distinct d from tstat ;
@@ -1501,11 +1501,11 @@ Scr. Write Count 0
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000008082212350752509978000000000000206U3333300_331_S1 ;
-Qid MXID11000008082212350752509978000000000000206U3333300_331_S1
-Compile Start Time 2017/01/09 20:10:14.157278
-Compile End Time 2017/01/09 20:10:14.159949
-Compile Elapsed Time 0:00:00.002671
+>>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_331_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_331_S1
+Compile Start Time 2017/02/16 01:03:16.005126
+Compile End Time 2017/02/16 01:03:16.005736
+Compile Elapsed Time 0:00:00.000610
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1517,10 +1517,10 @@ Query Type SQL_SELECT_NON_UNIQUE
Sub Query Type SQL_STMT_NA
Estimated Accessed Rows 0
Estimated Used Rows 0
-Parent Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
+Parent Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
Parent Query System SAME
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -1536,11 +1536,11 @@ Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_331_S1 ;
-Qid MXID11000008082212350752509978000000000000206U3333300_331_S1
-Compile Start Time 2017/01/09 20:10:14.157278
-Compile End Time 2017/01/09 20:10:14.159949
-Compile Elapsed Time 0:00:00.002671
+>>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_331_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_331_S1
+Compile Start Time 2017/02/16 01:03:16.005126
+Compile End Time 2017/02/16 01:03:16.005736
+Compile Elapsed Time 0:00:00.000610
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1552,10 +1552,10 @@ Query Type SQL_SELECT_NON_UNIQUE
Sub Query Type SQL_STMT_NA
Estimated Accessed Rows 0
Estimated Used Rows 0
-Parent Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
+Parent Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
Parent Query System SAME
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -1582,11 +1582,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000008082212350752509978000000000000206U3333300_333_S1 ;
-Qid MXID11000008082212350752509978000000000000206U3333300_333_S1
-Compile Start Time 2017/01/09 20:10:20.557111
-Compile End Time 2017/01/09 20:10:20.558991
-Compile Elapsed Time 0:00:00.001880
+>>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_333_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_333_S1
+Compile Start Time 2017/02/16 01:03:19.022446
+Compile End Time 2017/02/16 01:03:19.022986
+Compile Elapsed Time 0:00:00.000540
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1601,7 +1601,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -1617,11 +1617,11 @@ Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_333_S1 ;
-Qid MXID11000008082212350752509978000000000000206U3333300_333_S1
-Compile Start Time 2017/01/09 20:10:20.557111
-Compile End Time 2017/01/09 20:10:20.558991
-Compile Elapsed Time 0:00:00.001880
+>>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_333_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_333_S1
+Compile Start Time 2017/02/16 01:03:19.022446
+Compile End Time 2017/02/16 01:03:19.022986
+Compile Elapsed Time 0:00:00.000540
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1636,7 +1636,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -1668,11 +1668,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000008082212350752509978000000000000206U3333300_336_S1 ;
-Qid MXID11000008082212350752509978000000000000206U3333300_336_S1
-Compile Start Time 2017/01/09 20:10:26.602817
-Compile End Time 2017/01/09 20:10:26.667823
-Compile Elapsed Time 0:00:00.065006
+>>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
+Compile Start Time 2017/02/16 01:03:25.061984
+Compile End Time 2017/02/16 01:03:25.102150
+Compile Elapsed Time 0:00:00.040166
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1687,7 +1687,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -1703,11 +1703,11 @@ Last Suspend Time -1
Stats Collection Type OPERATOR_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_336_S1 ;
-Qid MXID11000008082212350752509978000000000000206U3333300_336_S1
-Compile Start Time 2017/01/09 20:10:26.602817
-Compile End Time 2017/01/09 20:10:26.667823
-Compile Elapsed Time 0:00:00.065006
+>>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
+Compile Start Time 2017/02/16 01:03:25.061984
+Compile End Time 2017/02/16 01:03:25.102150
+Compile Elapsed Time 0:00:00.040166
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1722,7 +1722,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -1754,14 +1754,14 @@ D
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000008082212350752509978000000000000206U3333300_336_S1 ;
-Qid MXID11000008082212350752509978000000000000206U3333300_336_S1
-Compile Start Time 2017/01/09 20:10:26.602817
-Compile End Time 2017/01/09 20:10:26.667823
-Compile Elapsed Time 0:00:00.065006
-Execute Start Time 2017/01/09 20:10:32.694186
-Execute End Time 2017/01/09 20:10:32.714103
-Execute Elapsed Time 0:00:00.019917
+>>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
+Compile Start Time 2017/02/16 01:03:25.061984
+Compile End Time 2017/02/16 01:03:25.102150
+Compile Elapsed Time 0:00:00.040166
+Execute Start Time 2017/02/16 01:03:28.196863
+Execute End Time 2017/02/16 01:03:28.208332
+Execute Elapsed Time 0:00:00.011469
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1773,13 +1773,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 2
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:10:32.710668
+First Row Returned Time 2017/02/16 01:03:28.206366
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1790,27 +1790,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 18 0 4 1941
-9 . 10 11 4 0 EX_SPLIT_TOP 1 5 32 2 4
-8 . 9 10 4 0 EX_SEND_TOP 2 10 1,891 2 4
-7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 282 2 4
-6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 83 2 4 5468
-5 . 6 7 3 2 EX_HASH_GRBY 2 6 3,491 1 4 0|0|0
-4 . 5 6 2 2 EX_SPLIT_TOP 2 9 71 100 4
-3 . 4 5 2 2 EX_SEND_TOP 4 18 1,541 100 4
-2 . 3 4 2 3 EX_SEND_BOTTOM 4 24 388 100 4
-1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 50 100 4 3814
-. . 1 2 1 3 EX_TRAF_KEY_SELECT 6 12 10,128 100 4 TRAFODION.SCH.TSTAT|4|176
-
---- SQL operation complete.
->>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_336_S1 ;
-Qid MXID11000008082212350752509978000000000000206U3333300_336_S1
-Compile Start Time 2017/01/09 20:10:26.602817
-Compile End Time 2017/01/09 20:10:26.667823
-Compile Elapsed Time 0:00:00.065006
-Execute Start Time 2017/01/09 20:10:32.694186
-Execute End Time 2017/01/09 20:10:32.714103
-Execute Elapsed Time 0:00:00.019917
+10 . 11 . 5 0 EX_ROOT 1 5 17 0 4 1049
+9 . 10 11 4 0 EX_SPLIT_TOP 1 5 7 2 4
+8 . 9 10 4 0 EX_SEND_TOP 2 10 1,025 2 4
+7 . 8 9 4 2 EX_SEND_BOTTOM 2 21 77 2 4
+6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 7 2 4 3223
+5 . 6 7 3 2 EX_HASH_GRBY 2 6 2,559 1 4 0|0|0
+4 . 5 6 2 2 EX_SPLIT_TOP 2 11 8 100 4
+3 . 4 5 2 2 EX_SEND_TOP 4 18 572 100 4
+2 . 3 4 2 3 EX_SEND_BOTTOM 4 35 136 100 4
+1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 11 100 4 1377
+. . 1 2 1 3 EX_TRAF_KEY_SELECT 6 12 3,690 100 4 TRAFODION.SCH.TSTAT|4|176
+
+--- SQL operation complete.
+>>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
+Compile Start Time 2017/02/16 01:03:25.061984
+Compile End Time 2017/02/16 01:03:25.102150
+Compile Elapsed Time 0:00:00.040166
+Execute Start Time 2017/02/16 01:03:28.196863
+Execute End Time 2017/02/16 01:03:28.208332
+Execute Elapsed Time 0:00:00.011469
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1822,13 +1822,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 2
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:10:32.710668
+First Row Returned Time 2017/02/16 01:03:28.206366
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1839,31 +1839,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 18 0 4 1941
-9 . 10 11 4 0 EX_SPLIT_TOP 1 5 32 2 4
-8 . 9 10 4 0 EX_SEND_TOP 2 10 1,891 2 4
-7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 282 2 4
-6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 83 2 4 5468
-5 . 6 7 3 2 EX_HASH_GRBY 2 6 3,491 1 4 0|0|0
-4 . 5 6 2 2 EX_SPLIT_TOP 2 9 71 100 4
-3 . 4 5 2 2 EX_SEND_TOP 4 18 1,541 100 4
-2 . 3 4 2 3 EX_SEND_BOTTOM 4 24 388 100 4
-1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 50 100 4 3814
-. . 1 2 1 3 EX_TRAF_KEY_SELECT 6 12 10,128 100 4 TRAFODION.SCH.TSTAT|4|176
+10 . 11 . 5 0 EX_ROOT 1 5 17 0 4 1049
+9 . 10 11 4 0 EX_SPLIT_TOP 1 5 7 2 4
+8 . 9 10 4 0 EX_SEND_TOP 2 10 1,025 2 4
+7 . 8 9 4 2 EX_SEND_BOTTOM 2 21 77 2 4
+6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 7 2 4 3223
+5 . 6 7 3 2 EX_HASH_GRBY 2 6 2,559 1 4 0|0|0
+4 . 5 6 2 2 EX_SPLIT_TOP 2 11 8 100 4
+3 . 4 5 2 2 EX_SEND_TOP 4 18 572 100 4
+2 . 3 4 2 3 EX_SEND_BOTTOM 4 35 136 100 4
+1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 11 100 4 1377
+. . 1 2 1 3 EX_TRAF_KEY_SELECT 6 12 3,690 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 MXID11000008082212350752509978000000000000206U3333300_336_S1 ACCUMULATED;
-Qid MXID11000008082212350752509978000000000000206U3333300_336_S1
-Compile Start Time 2017/01/09 20:10:26.602817
-Compile End Time 2017/01/09 20:10:26.667823
-Compile Elapsed Time 0:00:00.065006
-Execute Start Time 2017/01/09 20:10:32.694186
-Execute End Time 2017/01/09 20:10:32.714103
-Execute Elapsed Time 0:00:00.019917
+>>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 ACCUMULATED;
+Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
+Compile Start Time 2017/02/16 01:03:25.061984
+Compile End Time 2017/02/16 01:03:25.102150
+Compile Elapsed Time 0:00:00.040166
+Execute Start Time 2017/02/16 01:03:28.196863
+Execute End Time 2017/02/16 01:03:28.208332
+Execute Elapsed Time 0:00:00.011469
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1875,13 +1875,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 2
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:10:32.710668
+First Row Returned Time 2017/02/16 01:03:28.206366
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1893,19 +1893,19 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 4,705
-SQL Process Busy Time 11,223
+SE IO MAX Time 2,387
+SQL Process Busy Time 5,649
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 15 KB
+SQL Heap Used 14 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 39,984
+Request Message Bytes 39,712
Reply Message Count 15
-Reply Message Bytes 42,240
+Reply Message Bytes 42,256
Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -1915,14 +1915,14 @@ Scr. Read Count 0
Scr. Write Count 0
--- SQL operation complete.
->>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_336_S1 ACCUMULATED;
-Qid MXID11000008082212350752509978000000000000206U3333300_336_S1
-Compile Start Time 2017/01/09 20:10:26.602817
-Compile End Time 2017/01/09 20:10:26.667823
-Compile Elapsed Time 0:00:00.065006
-Execute Start Time 2017/01/09 20:10:32.694186
-Execute End Time 2017/01/09 20:10:32.714103
-Execute Elapsed Time 0:00:00.019917
+>>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 ACCUMULATED;
+Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
+Compile Start Time 2017/02/16 01:03:25.061984
+Compile End Time 2017/02/16 01:03:25.102150
+Compile Elapsed Time 0:00:00.040166
+Execute Start Time 2017/02/16 01:03:28.196863
+Execute End Time 2017/02/16 01:03:28.208332
+Execute Elapsed Time 0:00:00.011469
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1934,13 +1934,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 2
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:10:32.710668
+First Row Returned Time 2017/02/16 01:03:28.206366
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1952,19 +1952,19 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 4,705
-SQL Process Busy Time 11,223
+SE IO MAX Time 2,387
+SQL Process Busy Time 5,649
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 15 KB
+SQL Heap Used 14 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 39,984
+Request Message Bytes 39,712
Reply Message Count 15
-Reply Message Bytes 42,240
+Reply Message Bytes 42,256
Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -1978,14 +1978,14 @@ Scr. Write Count 0
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000008082212350752509978000000000000206U3333300_336_S1 PERTABLE;
-Qid MXID11000008082212350752509978000000000000206U3333300_336_S1
-Compile Start Time 2017/01/09 20:10:26.602817
-Compile End Time 2017/01/09 20:10:26.667823
-Compile Elapsed Time 0:00:00.065006
-Execute Start Time 2017/01/09 20:10:32.694186
-Execute End Time 2017/01/09 20:10:32.714103
-Execute Elapsed Time 0:00:00.019917
+>>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 PERTABLE;
+Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
+Compile Start Time 2017/02/16 01:03:25.061984
+Compile End Time 2017/02/16 01:03:25.102150
+Compile Elapsed Time 0:00:00.040166
+Execute Start Time 2017/02/16 01:03:28.196863
+Execute End Time 2017/02/16 01:03:28.208332
+Execute Elapsed Time 0:00:00.011469
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1997,13 +1997,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 2
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:10:32.710668
+First Row Returned Time 2017/02/16 01:03:28.206366
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2011,18 +2011,18 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 11,223
+SQL Process Busy Time 5,649
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 15 KB
+SQL Heap Used 14 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 39,984
+Request Message Bytes 39,712
Reply Message Count 15
-Reply Message Bytes 42,240
+Reply Message Bytes 42,256
Scr. Overflow Mode DISK
Scr File Count 0
Scr. Buffer Blk Size 0
@@ -2037,17 +2037,17 @@ Table Name
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 8,692 4,705
+ 4 4 4 0 4,503 2,387
--- SQL operation complete.
->>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_336_S1 PERTABLE;
-Qid MXID11000008082212350752509978000000000000206U3333300_336_S1
-Compile Start Time 2017/01/09 20:10:26.602817
-Compile End Time 2017/01/09 20:10:26.667823
-Compile Elapsed Time 0:00:00.065006
-Execute Start Time 2017/01/09 20:10:32.694186
-Execute End Time 2017/01/09 20:10:32.714103
-Execute Elapsed Time 0:00:00.019917
+>>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 PERTABLE;
+Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
+Compile Start Time 2017/02/16 01:03:25.061984
+Compile End Time 2017/02/16 01:03:25.102150
+Compile Elapsed Time 0:00:00.040166
+Execute Start Time 2017/02/16 01:03:28.196863
+Execute End Time 2017/02/16 01:03:28.208332
+Execute Elapsed Time 0:00:00.011469
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2059,13 +2059,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 2
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:10:32.710668
+First Row Returned Time 2017/02/16 01:03:28.206366
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2073,18 +2073,18 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 11,223
+SQL Process Busy Time 5,649
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 15 KB
+SQL Heap Used 14 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 39,984
+Request Message Bytes 39,712
Reply Message Count 15
-Reply Message Bytes 42,240
+Reply Message Bytes 42,256
Scr. Overflow Mode DISK
Scr File Count 0
Scr. Buffer Blk Size 0
@@ -2099,21 +2099,21 @@ Table Name
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 8,692 4,705
+ 4 4 4 0 4,503 2,387
--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000008082212350752509978000000000000206U3333300_336_S1 PROGRESS;
-Qid MXID11000008082212350752509978000000000000206U3333300_336_S1
-Compile Start Time 2017/01/09 20:10:26.602817
-Compile End Time 2017/01/09 20:10:26.667823
-Compile Elapsed Time 0:00:00.065006
-Execute Start Time 2017/01/09 20:10:32.694186
-Execute End Time 2017/01/09 20:10:32.714103
-Execute Elapsed Time 0:00:00.019917
+>>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 PROGRESS;
+Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
+Compile Start Time 2017/02/16 01:03:25.061984
+Compile End Time 2017/02/16 01:03:25.102150
+Compile Elapsed Time 0:00:00.040166
+Execute Start Time 2017/02/16 01:03:28.196863
+Execute End Time 2017/02/16 01:03:28.208332
+Execute Elapsed Time 0:00:00.011469
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2125,13 +2125,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 2
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:10:32.710668
+First Row Returned Time 2017/02/16 01:03:28.206366
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2139,41 +2139,41 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 11,223
+SQL Process Busy Time 5,649
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 15 KB
+SQL Heap Used 14 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 39,984
+Request Message Bytes 39,712
Reply Message Count 15
-Reply Message Bytes 42,240
+Reply Message Bytes 42,256
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
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 8,692 4,705
+ 4 4 4 0 4,503 2,387
Id TDB Name Mode TopN CPU Time File Count
BMO Heap Used BMO Heap Total BMO Heap WM BMO Space BufSz BMO Space BufCnt
ScrBlk Size ScrBlk Read ScrBlk Written ScrIO Read ScrIO Written
- 6 EX_HASH_GRBY DISK -1 3,491 0
+ 6 EX_HASH_GRBY DISK -1 2,559 0
4 1,024 7,687 256 0
-1 0 0 0 0
--- SQL operation complete.
->>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_336_S1 PROGRESS;
-Qid MXID11000008082212350752509978000000000000206U3333300_336_S1
-Compile Start Time 2017/01/09 20:10:26.602817
-Compile End Time 2017/01/09 20:10:26.667823
-Compile Elapsed Time 0:00:00.065006
-Execute Start Time 2017/01/09 20:10:32.694186
-Execute End Time 2017/01/09 20:10:32.714103
-Execute Elapsed Time 0:00:00.019917
+>>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 PROGRESS;
+Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
+Compile Start Time 2017/02/16 01:03:25.061984
+Compile End Time 2017/02/16 01:03:25.102150
+Compile Elapsed Time 0:00:00.040166
+Execute Start Time 2017/02/16 01:03:28.196863
+Execute End Time 2017/02/16 01:03:28.208332
+Execute Elapsed Time 0:00:00.011469
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2185,13 +2185,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 2
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09
<TRUNCATED>
[4/4] incubator-trafodion git commit: Merge [TRAFODION-2854] PR-961
Improve SET STATISTICS command
Posted by su...@apache.org.
Merge [TRAFODION-2854] PR-961 Improve SET STATISTICS command
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/da2bd7b0
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/da2bd7b0
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/da2bd7b0
Branch: refs/heads/master
Commit: da2bd7b0fd28ecb2c6fdb7b4c66ed701941b66f6
Parents: 60fcb54 6973d3a
Author: Suresh Subbiah <su...@apache.org>
Authored: Thu Feb 16 16:21:56 2017 +0000
Committer: Suresh Subbiah <su...@apache.org>
Committed: Thu Feb 16 16:21:56 2017 +0000
----------------------------------------------------------------------
.../java/org/trafodion/ci/DatabaseQuery.java | 23 +-
.../java/org/trafodion/ci/InterfaceQuery.java | 14 +-
.../src/main/java/org/trafodion/ci/Session.java | 11 +
core/sql/regress/core/EXPECTEDRTS | 1828 +++++++++++-------
core/sql/regress/core/TESTRTS | 11 +
core/sql/sqlci/SqlciStats.cpp | 44 +-
core/sql/sqlci/sqlci_yacc.y | 49 +-
7 files changed, 1196 insertions(+), 784 deletions(-)
----------------------------------------------------------------------
[3/4] incubator-trafodion git commit: [TRAFODION-2854] Improve SET
STATISTICS command to display the information in new format
Posted by su...@apache.org.
[TRAFODION-2854] Improve SET STATISTICS command to display the information in new format
Currently SET STATISTICS ON | OFF alone is supported. It is improved to take some more options
SET STATISTICS PERTABLE ;
SET STATISTICS PROGRESS ;
SET STATISTICS DEFAULT ;
This will display pertable, progress, operator level statistics for the these options respectively.
SET STATISTICS ALL will display both progress and operator level statistics.
These commands are valid both in sqlci and trafci.
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/6973d3a1
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/6973d3a1
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/6973d3a1
Branch: refs/heads/master
Commit: 6973d3a120aaa02a45157622517ed94559cb5899
Parents: f6f4402
Author: selvaganesang <se...@esgyn.com>
Authored: Thu Feb 16 01:48:11 2017 +0000
Committer: selvaganesang <se...@esgyn.com>
Committed: Thu Feb 16 01:48:11 2017 +0000
----------------------------------------------------------------------
.../java/org/trafodion/ci/DatabaseQuery.java | 23 +-
.../java/org/trafodion/ci/InterfaceQuery.java | 14 +-
.../src/main/java/org/trafodion/ci/Session.java | 11 +
core/sql/regress/core/EXPECTEDRTS | 1828 +++++++++++-------
core/sql/regress/core/TESTRTS | 11 +
core/sql/sqlci/SqlciStats.cpp | 44 +-
core/sql/sqlci/sqlci_yacc.y | 49 +-
7 files changed, 1196 insertions(+), 784 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6973d3a1/core/conn/trafci/src/main/java/org/trafodion/ci/DatabaseQuery.java
----------------------------------------------------------------------
diff --git a/core/conn/trafci/src/main/java/org/trafodion/ci/DatabaseQuery.java b/core/conn/trafci/src/main/java/org/trafodion/ci/DatabaseQuery.java
index 8b8b2ac..ec57060 100644
--- a/core/conn/trafci/src/main/java/org/trafodion/ci/DatabaseQuery.java
+++ b/core/conn/trafci/src/main/java/org/trafodion/ci/DatabaseQuery.java
@@ -306,17 +306,32 @@ public class DatabaseQuery extends QueryWrapper
//Overwrite the queryStr with the 'GET STATISTICS'
//command. dbExec executes the command stored in
//queryStr.
- queryStr = getStatsCmd;
+ String qryRowCnt = qryObj.getRowCount();
+ if (sessObj.getSessionStatsType().equals("ALL"))
+ {
+ queryStr = "GET STATISTICS FOR QID CURRENT PROGRESS";
+ qryObj.resetQueryText(queryStr);
+ parser.setRemainderStr(queryStr);
+ qryObj.setRowCount(null);
+ execGet(false);
+ }
+ if (sessObj.getSessionStatsType().equals("PERTABLE"))
+ queryStr = "GET STATISTICS FOR QID CURRENT PERTABLE";
+ else if (sessObj.getSessionStatsType().equals("PROGRESS"))
+ queryStr = "GET STATISTICS FOR QID CURRENT PROGRESS";
+ else if (sessObj.getSessionStatsType().equals("DEFAULT"))
+ queryStr = "GET STATISTICS FOR QID CURRENT DEFAULT";
+ else if (sessObj.getSessionStatsType().equals("ALL"))
+ queryStr = "GET STATISTICS FOR QID CURRENT DEFAULT";
+ else
+ queryStr = getStatsCmd;
qryObj.resetQueryText(queryStr);
parser.setRemainderStr(queryStr);
- String qryRowCnt = qryObj.getRowCount();
qryObj.setRowCount(null);
execGet(false);
//Reset the record count to row count of the
//original query
qryObj.setRowCount(qryRowCnt);
-
-
}
}
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6973d3a1/core/conn/trafci/src/main/java/org/trafodion/ci/InterfaceQuery.java
----------------------------------------------------------------------
diff --git a/core/conn/trafci/src/main/java/org/trafodion/ci/InterfaceQuery.java b/core/conn/trafci/src/main/java/org/trafodion/ci/InterfaceQuery.java
index 5bd73cb..026486f 100644
--- a/core/conn/trafci/src/main/java/org/trafodion/ci/InterfaceQuery.java
+++ b/core/conn/trafci/src/main/java/org/trafodion/ci/InterfaceQuery.java
@@ -1977,7 +1977,9 @@ public class InterfaceQuery extends QueryWrapper implements SessionDefaults {
break;
}
setValue = setValue.toUpperCase();
- if ((!setValue.equals("ON") && !setValue.equals("OFF"))) {
+ if (!setValue.equals("ON") && !setValue.equals("OFF")
+ && !setValue.equals("PERTABLE") && !setValue.equals("PROGRESS") && !setValue.equals("DEFAULT")
+ && !setValue.equals("ALL")) {
writeSyntaxError(this.queryStr,
setValue + parser.getRemainderStr());
break;
@@ -1986,13 +1988,13 @@ public class InterfaceQuery extends QueryWrapper implements SessionDefaults {
writeSyntaxError(this.queryStr, parser.getRemainderStr());
break;
}
- if (setValue.equals("ON")) {
- sessObj.setSessionStatsEnabled(true);
- } else {
+ if (setValue.equals("OFF")) {
sessObj.setSessionStatsEnabled(false);
+ } else {
+ sessObj.setSessionStatsEnabled(true);
}
- envMap.put("STATISTICS", sessObj.isSessionStatsEnabled() ? "ON"
- : "OFF");
+ sessObj.setSessionStatsType(setValue);
+ envMap.put("STATISTICS", setValue);
break;
case SET_MARKUP:
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6973d3a1/core/conn/trafci/src/main/java/org/trafodion/ci/Session.java
----------------------------------------------------------------------
diff --git a/core/conn/trafci/src/main/java/org/trafodion/ci/Session.java b/core/conn/trafci/src/main/java/org/trafodion/ci/Session.java
index e6c9e30..62d26f5 100644
--- a/core/conn/trafci/src/main/java/org/trafodion/ci/Session.java
+++ b/core/conn/trafci/src/main/java/org/trafodion/ci/Session.java
@@ -111,6 +111,7 @@ public class Session extends RepObjInterface
String varSessionSQLPrompt=SessionDefaults.DEFAULT_SQL_PROMPT;
boolean ampmFmt = false;
boolean sessionStats = false;
+ String sessionStatsType;
LFProperties lfProps = null;
Process procObj=null;
private HTMLObject htmlObj=null;
@@ -1262,6 +1263,16 @@ static {
return lfProps;
}
+ public String getSessionStatsType()
+ {
+ return sessionStatsType;
+ }
+
+ public void setSessionStatsType(String sessionStatsType)
+ {
+ this.sessionStatsType = sessionStatsType;
+ }
+
public void setLFProps(LFProperties lfProps)
{
this.lfProps = lfProps;