>>
>>create table tstat (a char(5) not null ,
+>                     b smallint not null ,
+>                     c char(4),
+>                     d integer,
+>                     primary key (a,b) )
+>                     salt using 2 partitions ;

--- SQL operation complete.
>>insert into tstat values ('AAAA ',11,'AAAA',11);

--- 1 row(s) inserted.
>>insert into tstat values ('BBBB ',12,'BBBB',12);

--- 1 row(s) inserted.
>>insert into tstat values ('MMMM ',21,'MMMM',21);

--- 1 row(s) inserted.
>>insert into tstat values ('XXXXX',22,'XXXX', 22);

--- 1 row(s) inserted.
>>
>>control query default attempt_esp_parallelism 'on' ;

--- SQL operation complete.
>>control query default parallel_num_esps '2' ;

--- SQL operation complete.
>>control query default detailed_statistics 'ACCUMULATED' ;

--- SQL operation complete.
>>set session default statistics_view_type 'default' ;

--- SQL operation complete.
>>control query shape esp_exchange(hash_groupby(esp_exchange(scan)));

--- SQL operation complete.
>>
>>-- ACCUMULATED Stats Test
>>-- Also tests to mimic ODBC by calling explain options 'f'
>>-- and ensure qid current returns the qid user prepared statement
>>prepare s1 from select distinct d from tstat ;

--- SQL command prepared.
>>explain options 'f' s1 ;

LC   RC   OP   OPERATOR              OPT       DESCRIPTION           CARD
---- ---- ---- --------------------  --------  --------------------  ---------

4    .    5    root                                                  2.00E+000
3    .    4    esp_exchange                    1:2(hash2)            2.00E+000
2    .    3    hash_groupby                                          2.00E+000
1    .    2    esp_exchange                    2(hash2):2(hash2)     1.00E+002
.    .    1    trafodion_scan                  TSTAT                 1.00E+002

--- SQL operation complete.
>>log LOGRTS;
>>get statistics for qid current ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_303_S1
Compile Start Time       2017/11/23 17:56:10.510027
Compile End Time         2017/11/23 17:56:10.581329
Compile Elapsed Time                 0:00:00.071302
Execute Start Time       -1
Execute End Time         -1
Execute Elapsed Time                 0:00:00.000000
State                    CLOSE
Rows Affected            -1
SQL Error Code           0
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select distinct d from tstat ;
SQL Source Length        30
Rows Returned            0
First Row Returned Time  -1
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    0
Min. Execute Time        0.000000 secs
Max. Execute Time        0.000000 secs
Avg. Execute Time        0.000000 secs
Stats Collection Type    ACCUMULATED_STATS

--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;

--- SQL operation complete.
>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_303_S1 ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_303_S1
Compile Start Time       2017/11/23 17:56:10.510027
Compile End Time         2017/11/23 17:56:10.581329
Compile Elapsed Time                 0:00:00.071302
Execute Start Time       -1
Execute End Time         -1
Execute Elapsed Time                 0:00:00.000000
State                    CLOSE
Rows Affected            -1
SQL Error Code           0
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select distinct d from tstat ;
SQL Source Length        30
Rows Returned            0
First Row Returned Time  -1
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    0
Min. Execute Time        0.000000 secs
Max. Execute Time        0.000000 secs
Avg. Execute Time        0.000000 secs
Stats Collection Type    ACCUMULATED_STATS

--- SQL operation complete.
>>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_303_S1 ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_303_S1
Compile Start Time       2017/11/23 17:56:10.510027
Compile End Time         2017/11/23 17:56:10.581329
Compile Elapsed Time                 0:00:00.071302
Execute Start Time       -1
Execute End Time         -1
Execute Elapsed Time                 0:00:00.000000
State                    CLOSE
Rows Affected            -1
SQL Error Code           0
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select distinct d from tstat ;
SQL Source Length        30
Rows Returned            0
First Row Returned Time  -1
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    0
Min. Execute Time        0.000000 secs
Max. Execute Time        0.000000 secs
Avg. Execute Time        0.000000 secs
Stats Collection Type    ACCUMULATED_STATS

--- SQL operation complete.
>>log;
>>display statistics for qid current;
Qid                      MXID11000011701212378219753251307000000000206U3333300_303_S1
Compile Start Time       2017/11/23 17:56:10.510027
Compile End Time         2017/11/23 17:56:10.581329
Compile Elapsed Time                 0:00:00.071302
Execute Start Time       -1
Execute End Time         -1
Execute Elapsed Time                 0:00:00.000000
State                    CLOSE
Rows Affected            -1
SQL Error Code           0
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select distinct d from tstat ;
SQL Source Length        30
Rows Returned            0
First Row Returned Time  -1
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    0
Min. Execute Time        0.000000 secs
Max. Execute Time        0.000000 secs
Avg. Execute Time        0.000000 secs
Stats Collection Type    ACCUMULATED_STATS

--- SQL operation complete.
>>get statistics for qid current ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_303_S1
Compile Start Time       2017/11/23 17:56:10.510027
Compile End Time         2017/11/23 17:56:10.581329
Compile Elapsed Time                 0:00:00.071302
Execute Start Time       -1
Execute End Time         -1
Execute Elapsed Time                 0:00:00.000000
State                    CLOSE
Rows Affected            -1
SQL Error Code           0
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select distinct d from tstat ;
SQL Source Length        30
Rows Returned            0
First Row Returned Time  -1
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    0
Min. Execute Time        0.000000 secs
Max. Execute Time        0.000000 secs
Avg. Execute Time        0.000000 secs
Stats Collection Type    ACCUMULATED_STATS

--- SQL operation complete.
>>execute s1;

D          
-----------

         12
         11
         21
         22

--- 4 row(s) selected.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;

--- SQL operation complete.
>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_303_S1 ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_303_S1
Compile Start Time       2017/11/23 17:56:10.510027
Compile End Time         2017/11/23 17:56:10.581329
Compile Elapsed Time                 0:00:00.071302
Execute Start Time       2017/11/23 17:56:18.062665
Execute End Time         2017/11/23 17:56:21.535598
Execute Elapsed Time                 0:00:03.472933
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:56:21.533164
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        3.472933 secs
Max. Execute Time        3.472933 secs
Avg. Execute Time        3.472933 secs
Stats Collection Type    ACCUMULATED_STATS
Accessed Rows            4
Used Rows                4
SE IOs                   4
SE IO Bytes              176
SE IO MAX Time           699,617
SQL Process Busy Time    4,836,770
UDR Process Busy Time    0
SQL Space Allocated      896 KB
SQL Space Used           766 KB
SQL Heap Allocated       12,138 KB
SQL Heap Used            917 KB
SQL Heap WM              68 KB
Processes Created        2
Process Create Time      203,095
Request Message Count    26
Request Message Bytes    39,696
Reply Message Count      15
Reply Message Bytes      38,792
BMO Space Buffer Size    0
BMO Space Buffer Count   0
BMO Interim Row Count    0
Scr. Overflow Mode       DISK
Scr. File Count          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 MXID11000011701212378219753251307000000000206U3333300_303_S1 ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_303_S1
Compile Start Time       2017/11/23 17:56:10.510027
Compile End Time         2017/11/23 17:56:10.581329
Compile Elapsed Time                 0:00:00.071302
Execute Start Time       2017/11/23 17:56:18.062665
Execute End Time         2017/11/23 17:56:21.535598
Execute Elapsed Time                 0:00:03.472933
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:56:21.533164
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        3.472933 secs
Max. Execute Time        3.472933 secs
Avg. Execute Time        3.472933 secs
Stats Collection Type    ACCUMULATED_STATS
Accessed Rows            4
Used Rows                4
SE IOs                   4
SE IO Bytes              176
SE IO MAX Time           699,617
SQL Process Busy Time    4,836,770
UDR Process Busy Time    0
SQL Space Allocated      896 KB
SQL Space Used           766 KB
SQL Heap Allocated       12,138 KB
SQL Heap Used            917 KB
SQL Heap WM              68 KB
Processes Created        2
Process Create Time      203,095
Request Message Count    26
Request Message Bytes    39,696
Reply Message Count      15
Reply Message Bytes      38,792
BMO Space Buffer Size    0
BMO Space Buffer Count   0
BMO Interim Row Count    0
Scr. Overflow Mode       DISK
Scr. File Count          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                      MXID11000011701212378219753251307000000000206U3333300_303_S1
Compile Start Time       2017/11/23 17:56:10.510027
Compile End Time         2017/11/23 17:56:10.581329
Compile Elapsed Time                 0:00:00.071302
Execute Start Time       2017/11/23 17:56:18.062665
Execute End Time         2017/11/23 17:56:21.535598
Execute Elapsed Time                 0:00:03.472933
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:56:21.533164
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        3.472933 secs
Max. Execute Time        3.472933 secs
Avg. Execute Time        3.472933 secs
Stats Collection Type    ACCUMULATED_STATS
Accessed Rows            4
Used Rows                4
SE IOs                   4
SE IO Bytes              176
SE IO MAX Time           699,617
SQL Process Busy Time    4,836,770
UDR Process Busy Time    0
SQL Space Allocated      896 KB
SQL Space Used           766 KB
SQL Heap Allocated       12,138 KB
SQL Heap Used            917 KB
SQL Heap WM              68 KB
Processes Created        2
Process Create Time      203,095
Request Message Count    26
Request Message Bytes    39,696
Reply Message Count      15
Reply Message Bytes      38,792
BMO Space Buffer Size    0
BMO Space Buffer Count   0
BMO Interim Row Count    0
Scr. Overflow Mode       DISK
Scr. File Count          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                      MXID11000011701212378219753251307000000000206U3333300_303_S1
Compile Start Time       2017/11/23 17:56:10.510027
Compile End Time         2017/11/23 17:56:10.581329
Compile Elapsed Time                 0:00:00.071302
Execute Start Time       2017/11/23 17:56:18.062665
Execute End Time         2017/11/23 17:56:21.535598
Execute Elapsed Time                 0:00:03.472933
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:56:21.533164
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        3.472933 secs
Max. Execute Time        3.472933 secs
Avg. Execute Time        3.472933 secs
Stats Collection Type    ACCUMULATED_STATS
Accessed Rows            4
Used Rows                4
SE IOs                   4
SE IO Bytes              176
SE IO MAX Time           699,617
SQL Process Busy Time    4,836,770
UDR Process Busy Time    0
SQL Space Allocated      896 KB
SQL Space Used           766 KB
SQL Heap Allocated       12,138 KB
SQL Heap Used            917 KB
SQL Heap WM              68 KB
Processes Created        2
Process Create Time      203,095
Request Message Count    26
Request Message Bytes    39,696
Reply Message Count      15
Reply Message Bytes      38,792
BMO Space Buffer Size    0
BMO Space Buffer Count   0
BMO Interim Row Count    0
Scr. Overflow Mode       DISK
Scr. File Count          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 ;

--- SQL command prepared.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;

--- SQL operation complete.
>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_303_S1 ;

*** ERROR[8923] The given Query Id MXID11000011701212378219753251307000000000206U3333300_303_S1 is not found.

--- SQL operation failed with errors.
>>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_303_S1 ;

*** ERROR[8923] The given Query Id MXID11000011701212378219753251307000000000206U3333300_303_S1 is not found.

--- SQL operation failed with errors.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;

--- SQL operation complete.
>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_312_S1 ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_312_S1
Compile Start Time       2017/11/23 17:56:25.831881
Compile End Time         2017/11/23 17:56:25.834511
Compile Elapsed Time                 0:00:00.002630
Execute Start Time       -1
Execute End Time         -1
Execute Elapsed Time                 0:00:00.000000
State                    CLOSE
Rows Affected            -1
SQL Error Code           0
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select distinct d from tstat ;
SQL Source Length        30
Rows Returned            0
First Row Returned Time  -1
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    0
Min. Execute Time        0.000000 secs
Max. Execute Time        0.000000 secs
Avg. Execute Time        0.000000 secs
Stats Collection Type    ACCUMULATED_STATS

--- SQL operation complete.
>>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_312_S1 ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_312_S1
Compile Start Time       2017/11/23 17:56:25.831881
Compile End Time         2017/11/23 17:56:25.834511
Compile Elapsed Time                 0:00:00.002630
Execute Start Time       -1
Execute End Time         -1
Execute Elapsed Time                 0:00:00.000000
State                    CLOSE
Rows Affected            -1
SQL Error Code           0
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select distinct d from tstat ;
SQL Source Length        30
Rows Returned            0
First Row Returned Time  -1
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    0
Min. Execute Time        0.000000 secs
Max. Execute Time        0.000000 secs
Avg. Execute Time        0.000000 secs
Stats Collection Type    ACCUMULATED_STATS

--- SQL operation complete.
>>log;
>>display statistics for qid current;
Qid                      MXID11000011701212378219753251307000000000206U3333300_312_S1
Compile Start Time       2017/11/23 17:56:25.831881
Compile End Time         2017/11/23 17:56:25.834511
Compile Elapsed Time                 0:00:00.002630
Execute Start Time       -1
Execute End Time         -1
Execute Elapsed Time                 0:00:00.000000
State                    CLOSE
Rows Affected            -1
SQL Error Code           0
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select distinct d from tstat ;
SQL Source Length        30
Rows Returned            0
First Row Returned Time  -1
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    0
Min. Execute Time        0.000000 secs
Max. Execute Time        0.000000 secs
Avg. Execute Time        0.000000 secs
Stats Collection Type    ACCUMULATED_STATS

--- SQL operation complete.
>>get statistics for qid current ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_312_S1
Compile Start Time       2017/11/23 17:56:25.831881
Compile End Time         2017/11/23 17:56:25.834511
Compile Elapsed Time                 0:00:00.002630
Execute Start Time       -1
Execute End Time         -1
Execute Elapsed Time                 0:00:00.000000
State                    CLOSE
Rows Affected            -1
SQL Error Code           0
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select distinct d from tstat ;
SQL Source Length        30
Rows Returned            0
First Row Returned Time  -1
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    0
Min. Execute Time        0.000000 secs
Max. Execute Time        0.000000 secs
Avg. Execute Time        0.000000 secs
Stats Collection Type    ACCUMULATED_STATS

--- SQL operation complete.
>>
>>-- PERTABLE stats
>>control query default detailed_statistics 'pertable' ;

--- SQL operation complete.
>>set session default statistics_view_type 'default' ;

--- SQL operation complete.
>>prepare s1 from select distinct d from tstat ;

--- SQL command prepared.
>>log;
>>get statistics for qid current ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_317_S1
Compile Start Time       2017/11/23 17:56:33.591183
Compile End Time         2017/11/23 17:56:33.657895
Compile Elapsed Time                 0:00:00.066712
Execute Start Time       -1
Execute End Time         -1
Execute Elapsed Time                 0:00:00.000000
State                    CLOSE
Rows Affected            -1
SQL Error Code           0
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select distinct d from tstat ;
SQL Source Length        30
Rows Returned            0
First Row Returned Time  -1
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    0
Min. Execute Time        0.000000 secs
Max. Execute Time        0.000000 secs
Avg. Execute Time        0.000000 secs
Stats Collection Type    PERTABLE_STATS

--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;

--- SQL operation complete.
>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_317_S1 ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_317_S1
Compile Start Time       2017/11/23 17:56:33.591183
Compile End Time         2017/11/23 17:56:33.657895
Compile Elapsed Time                 0:00:00.066712
Execute Start Time       -1
Execute End Time         -1
Execute Elapsed Time                 0:00:00.000000
State                    CLOSE
Rows Affected            -1
SQL Error Code           0
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select distinct d from tstat ;
SQL Source Length        30
Rows Returned            0
First Row Returned Time  -1
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    0
Min. Execute Time        0.000000 secs
Max. Execute Time        0.000000 secs
Avg. Execute Time        0.000000 secs
Stats Collection Type    PERTABLE_STATS

--- SQL operation complete.
>>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_317_S1 ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_317_S1
Compile Start Time       2017/11/23 17:56:33.591183
Compile End Time         2017/11/23 17:56:33.657895
Compile Elapsed Time                 0:00:00.066712
Execute Start Time       -1
Execute End Time         -1
Execute Elapsed Time                 0:00:00.000000
State                    CLOSE
Rows Affected            -1
SQL Error Code           0
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select distinct d from tstat ;
SQL Source Length        30
Rows Returned            0
First Row Returned Time  -1
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    0
Min. Execute Time        0.000000 secs
Max. Execute Time        0.000000 secs
Avg. Execute Time        0.000000 secs
Stats Collection Type    PERTABLE_STATS

--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;

--- SQL operation complete.
>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_317_S1 ACCUMULATED;
Qid                      MXID11000011701212378219753251307000000000206U3333300_317_S1
Compile Start Time       2017/11/23 17:56:33.591183
Compile End Time         2017/11/23 17:56:33.657895
Compile Elapsed Time                 0:00:00.066712
Execute Start Time       -1
Execute End Time         -1
Execute Elapsed Time                 0:00:00.000000
State                    CLOSE
Rows Affected            -1
SQL Error Code           0
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select distinct d from tstat ;
SQL Source Length        30
Rows Returned            0
First Row Returned Time  -1
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    0
Min. Execute Time        0.000000 secs
Max. Execute Time        0.000000 secs
Avg. Execute Time        0.000000 secs
Stats Collection Type    PERTABLE_STATS

--- SQL operation complete.
>>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_317_S1 ACCUMULATED;
Qid                      MXID11000011701212378219753251307000000000206U3333300_317_S1
Compile Start Time       2017/11/23 17:56:33.591183
Compile End Time         2017/11/23 17:56:33.657895
Compile Elapsed Time                 0:00:00.066712
Execute Start Time       -1
Execute End Time         -1
Execute Elapsed Time                 0:00:00.000000
State                    CLOSE
Rows Affected            -1
SQL Error Code           0
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select distinct d from tstat ;
SQL Source Length        30
Rows Returned            0
First Row Returned Time  -1
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    0
Min. Execute Time        0.000000 secs
Max. Execute Time        0.000000 secs
Avg. Execute Time        0.000000 secs
Stats Collection Type    PERTABLE_STATS

--- SQL operation complete.
>>log;
>>display statistics for qid current;
Qid                      MXID11000011701212378219753251307000000000206U3333300_317_S1
Compile Start Time       2017/11/23 17:56:33.591183
Compile End Time         2017/11/23 17:56:33.657895
Compile Elapsed Time                 0:00:00.066712
Execute Start Time       -1
Execute End Time         -1
Execute Elapsed Time                 0:00:00.000000
State                    CLOSE
Rows Affected            -1
SQL Error Code           0
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select distinct d from tstat ;
SQL Source Length        30
Rows Returned            0
First Row Returned Time  -1
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    0
Min. Execute Time        0.000000 secs
Max. Execute Time        0.000000 secs
Avg. Execute Time        0.000000 secs
Stats Collection Type    PERTABLE_STATS

--- SQL operation complete.
>>get statistics for qid current ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_317_S1
Compile Start Time       2017/11/23 17:56:33.591183
Compile End Time         2017/11/23 17:56:33.657895
Compile Elapsed Time                 0:00:00.066712
Execute Start Time       -1
Execute End Time         -1
Execute Elapsed Time                 0:00:00.000000
State                    CLOSE
Rows Affected            -1
SQL Error Code           0
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select distinct d from tstat ;
SQL Source Length        30
Rows Returned            0
First Row Returned Time  -1
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    0
Min. Execute Time        0.000000 secs
Max. Execute Time        0.000000 secs
Avg. Execute Time        0.000000 secs
Stats Collection Type    PERTABLE_STATS

--- SQL operation complete.
>>display statistics for qid current accumulated ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_317_S1
Compile Start Time       2017/11/23 17:56:33.591183
Compile End Time         2017/11/23 17:56:33.657895
Compile Elapsed Time                 0:00:00.066712
Execute Start Time       -1
Execute End Time         -1
Execute Elapsed Time                 0:00:00.000000
State                    CLOSE
Rows Affected            -1
SQL Error Code           0
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select distinct d from tstat ;
SQL Source Length        30
Rows Returned            0
First Row Returned Time  -1
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    0
Min. Execute Time        0.000000 secs
Max. Execute Time        0.000000 secs
Avg. Execute Time        0.000000 secs
Stats Collection Type    PERTABLE_STATS

--- SQL operation complete.
>>get statistics for qid current accumulated ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_317_S1
Compile Start Time       2017/11/23 17:56:33.591183
Compile End Time         2017/11/23 17:56:33.657895
Compile Elapsed Time                 0:00:00.066712
Execute Start Time       -1
Execute End Time         -1
Execute Elapsed Time                 0:00:00.000000
State                    CLOSE
Rows Affected            -1
SQL Error Code           0
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select distinct d from tstat ;
SQL Source Length        30
Rows Returned            0
First Row Returned Time  -1
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    0
Min. Execute Time        0.000000 secs
Max. Execute Time        0.000000 secs
Avg. Execute Time        0.000000 secs
Stats Collection Type    PERTABLE_STATS

--- SQL operation complete.
>>execute s1;

D          
-----------

         12
         11
         21
         22

--- 4 row(s) selected.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;

--- SQL operation complete.
>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_317_S1 ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_317_S1
Compile Start Time       2017/11/23 17:56:33.591183
Compile End Time         2017/11/23 17:56:33.657895
Compile Elapsed Time                 0:00:00.066712
Execute Start Time       2017/11/23 17:56:41.333784
Execute End Time         2017/11/23 17:56:41.377591
Execute Elapsed Time                 0:00:00.043807
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:56:41.375158
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.043807 secs
Max. Execute Time        0.043807 secs
Avg. Execute Time        0.043807 secs
Stats Collection Type    PERTABLE_STATS
SQL Process Busy Time    23,792
UDR Process Busy Time    0
SQL Space Allocated      896 KB
SQL Space Used           766 KB
SQL Heap Allocated       1,032 KB
SQL Heap Used            913 KB
SQL Heap WM              11,171 KB
Processes Created        0
Process Create Time      0
Request Message Count    27
Request Message Bytes    39,856
Reply Message Count      15
Reply Message Bytes      39,208
BMO Space Buffer Size    0
BMO Space Buffer Count   0
BMO Interim Row Count    0
Scr. Overflow Mode       UNKNOWN
Scr. File Count          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
  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs        SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
    1         2 TRAFODION.SCH.TSTAT
              0                   4            100                   4                   4                   0              13,543               7,340

--- SQL operation complete.
>>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_317_S1 ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_317_S1
Compile Start Time       2017/11/23 17:56:33.591183
Compile End Time         2017/11/23 17:56:33.657895
Compile Elapsed Time                 0:00:00.066712
Execute Start Time       2017/11/23 17:56:41.333784
Execute End Time         2017/11/23 17:56:41.377591
Execute Elapsed Time                 0:00:00.043807
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:56:41.375158
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.043807 secs
Max. Execute Time        0.043807 secs
Avg. Execute Time        0.043807 secs
Stats Collection Type    PERTABLE_STATS
SQL Process Busy Time    23,792
UDR Process Busy Time    0
SQL Space Allocated      896 KB
SQL Space Used           766 KB
SQL Heap Allocated       1,032 KB
SQL Heap Used            913 KB
SQL Heap WM              11,171 KB
Processes Created        0
Process Create Time      0
Request Message Count    27
Request Message Bytes    39,856
Reply Message Count      15
Reply Message Bytes      39,208
BMO Space Buffer Size    0
BMO Space Buffer Count   0
BMO Interim Row Count    0
Scr. Overflow Mode       UNKNOWN
Scr. File Count          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
  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs        SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
    1         2 TRAFODION.SCH.TSTAT
              0                   4            100                   4                   4                   0              13,543               7,340

--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;

--- SQL operation complete.
>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_317_S1 ACCUMULATED;
Qid                      MXID11000011701212378219753251307000000000206U3333300_317_S1
Compile Start Time       2017/11/23 17:56:33.591183
Compile End Time         2017/11/23 17:56:33.657895
Compile Elapsed Time                 0:00:00.066712
Execute Start Time       2017/11/23 17:56:41.333784
Execute End Time         2017/11/23 17:56:41.377591
Execute Elapsed Time                 0:00:00.043807
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:56:41.375158
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.043807 secs
Max. Execute Time        0.043807 secs
Avg. Execute Time        0.043807 secs
Stats Collection Type    PERTABLE_STATS
Accessed Rows            4
Used Rows                4
SE IOs                   4
SE IO Bytes              176
SE IO MAX Time           7,340
SQL Process Busy Time    23,792
UDR Process Busy Time    0
SQL Space Allocated      896 KB
SQL Space Used           766 KB
SQL Heap Allocated       1,032 KB
SQL Heap Used            913 KB
SQL Heap WM              11,171 KB
Processes Created        0
Process Create Time      0
Request Message Count    27
Request Message Bytes    39,856
Reply Message Count      15
Reply Message Bytes      39,208
BMO Space Buffer Size    0
BMO Space Buffer Count   0
BMO Interim Row Count    0
Scr. Overflow Mode       UNKNOWN
Scr. File Count          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 MXID11000011701212378219753251307000000000206U3333300_317_S1 ACCUMULATED;
Qid                      MXID11000011701212378219753251307000000000206U3333300_317_S1
Compile Start Time       2017/11/23 17:56:33.591183
Compile End Time         2017/11/23 17:56:33.657895
Compile Elapsed Time                 0:00:00.066712
Execute Start Time       2017/11/23 17:56:41.333784
Execute End Time         2017/11/23 17:56:41.377591
Execute Elapsed Time                 0:00:00.043807
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:56:41.375158
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.043807 secs
Max. Execute Time        0.043807 secs
Avg. Execute Time        0.043807 secs
Stats Collection Type    PERTABLE_STATS
Accessed Rows            4
Used Rows                4
SE IOs                   4
SE IO Bytes              176
SE IO MAX Time           7,340
SQL Process Busy Time    23,792
UDR Process Busy Time    0
SQL Space Allocated      896 KB
SQL Space Used           766 KB
SQL Heap Allocated       1,032 KB
SQL Heap Used            913 KB
SQL Heap WM              11,171 KB
Processes Created        0
Process Create Time      0
Request Message Count    27
Request Message Bytes    39,856
Reply Message Count      15
Reply Message Bytes      39,208
BMO Space Buffer Size    0
BMO Space Buffer Count   0
BMO Interim Row Count    0
Scr. Overflow Mode       UNKNOWN
Scr. File Count          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                      MXID11000011701212378219753251307000000000206U3333300_317_S1
Compile Start Time       2017/11/23 17:56:33.591183
Compile End Time         2017/11/23 17:56:33.657895
Compile Elapsed Time                 0:00:00.066712
Execute Start Time       2017/11/23 17:56:41.333784
Execute End Time         2017/11/23 17:56:41.377591
Execute Elapsed Time                 0:00:00.043807
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:56:41.375158
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.043807 secs
Max. Execute Time        0.043807 secs
Avg. Execute Time        0.043807 secs
Stats Collection Type    PERTABLE_STATS
SQL Process Busy Time    23,792
UDR Process Busy Time    0
SQL Space Allocated      896 KB
SQL Space Used           766 KB
SQL Heap Allocated       1,032 KB
SQL Heap Used            913 KB
SQL Heap WM              11,171 KB
Processes Created        0
Process Create Time      0
Request Message Count    27
Request Message Bytes    39,856
Reply Message Count      15
Reply Message Bytes      39,208
BMO Space Buffer Size    0
BMO Space Buffer Count   0
BMO Interim Row Count    0
Scr. Overflow Mode       UNKNOWN
Scr. File Count          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
  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs        SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
    1         2 TRAFODION.SCH.TSTAT
              0                   4            100                   4                   4                   0              13,543               7,340

--- SQL operation complete.
>>get statistics for qid current ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_317_S1
Compile Start Time       2017/11/23 17:56:33.591183
Compile End Time         2017/11/23 17:56:33.657895
Compile Elapsed Time                 0:00:00.066712
Execute Start Time       2017/11/23 17:56:41.333784
Execute End Time         2017/11/23 17:56:41.377591
Execute Elapsed Time                 0:00:00.043807
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:56:41.375158
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.043807 secs
Max. Execute Time        0.043807 secs
Avg. Execute Time        0.043807 secs
Stats Collection Type    PERTABLE_STATS
SQL Process Busy Time    23,792
UDR Process Busy Time    0
SQL Space Allocated      896 KB
SQL Space Used           766 KB
SQL Heap Allocated       1,032 KB
SQL Heap Used            913 KB
SQL Heap WM              11,171 KB
Processes Created        0
Process Create Time      0
Request Message Count    27
Request Message Bytes    39,856
Reply Message Count      15
Reply Message Bytes      39,208
BMO Space Buffer Size    0
BMO Space Buffer Count   0
BMO Interim Row Count    0
Scr. Overflow Mode       UNKNOWN
Scr. File Count          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
  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs        SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
    1         2 TRAFODION.SCH.TSTAT
              0                   4            100                   4                   4                   0              13,543               7,340

--- SQL operation complete.
>>display statistics for qid current accumulated;
Qid                      MXID11000011701212378219753251307000000000206U3333300_317_S1
Compile Start Time       2017/11/23 17:56:33.591183
Compile End Time         2017/11/23 17:56:33.657895
Compile Elapsed Time                 0:00:00.066712
Execute Start Time       2017/11/23 17:56:41.333784
Execute End Time         2017/11/23 17:56:41.377591
Execute Elapsed Time                 0:00:00.043807
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:56:41.375158
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.043807 secs
Max. Execute Time        0.043807 secs
Avg. Execute Time        0.043807 secs
Stats Collection Type    PERTABLE_STATS
Accessed Rows            4
Used Rows                4
SE IOs                   4
SE IO Bytes              176
SE IO MAX Time           7,340
SQL Process Busy Time    23,792
UDR Process Busy Time    0
SQL Space Allocated      896 KB
SQL Space Used           766 KB
SQL Heap Allocated       1,032 KB
SQL Heap Used            913 KB
SQL Heap WM              11,171 KB
Processes Created        0
Process Create Time      0
Request Message Count    27
Request Message Bytes    39,856
Reply Message Count      15
Reply Message Bytes      39,208
BMO Space Buffer Size    0
BMO Space Buffer Count   0
BMO Interim Row Count    0
Scr. Overflow Mode       UNKNOWN
Scr. File Count          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                      MXID11000011701212378219753251307000000000206U3333300_317_S1
Compile Start Time       2017/11/23 17:56:33.591183
Compile End Time         2017/11/23 17:56:33.657895
Compile Elapsed Time                 0:00:00.066712
Execute Start Time       2017/11/23 17:56:41.333784
Execute End Time         2017/11/23 17:56:41.377591
Execute Elapsed Time                 0:00:00.043807
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:56:41.375158
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.043807 secs
Max. Execute Time        0.043807 secs
Avg. Execute Time        0.043807 secs
Stats Collection Type    PERTABLE_STATS
Accessed Rows            4
Used Rows                4
SE IOs                   4
SE IO Bytes              176
SE IO MAX Time           7,340
SQL Process Busy Time    23,792
UDR Process Busy Time    0
SQL Space Allocated      896 KB
SQL Space Used           766 KB
SQL Heap Allocated       1,032 KB
SQL Heap Used            913 KB
SQL Heap WM              11,171 KB
Processes Created        0
Process Create Time      0
Request Message Count    27
Request Message Bytes    39,856
Reply Message Count      15
Reply Message Bytes      39,208
BMO Space Buffer Size    0
BMO Space Buffer Count   0
BMO Interim Row Count    0
Scr. Overflow Mode       UNKNOWN
Scr. File Count          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 'MXID11000011701212378219753251307000000000206U3333300_317_S1';

--- SQL operation complete.
>>prepare s1 from select distinct d from tstat ;

--- SQL command prepared.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;

--- SQL operation complete.
>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_331_S1 ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_331_S1
Compile Start Time       2017/11/23 17:56:49.393860
Compile End Time         2017/11/23 17:56:49.395625
Compile Elapsed Time                 0:00:00.001765
Execute Start Time       -1
Execute End Time         -1
Execute Elapsed Time                 0:00:00.000000
State                    CLOSE
Rows Affected            -1
SQL Error Code           0
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               MXID11000011701212378219753251307000000000206U3333300_317_S1
Parent Query System      SAME
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select distinct d from tstat ;
SQL Source Length        30
Rows Returned            0
First Row Returned Time  -1
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    0
Min. Execute Time        0.000000 secs
Max. Execute Time        0.000000 secs
Avg. Execute Time        0.000000 secs
Stats Collection Type    PERTABLE_STATS

--- SQL operation complete.
>>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_331_S1 ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_331_S1
Compile Start Time       2017/11/23 17:56:49.393860
Compile End Time         2017/11/23 17:56:49.395625
Compile Elapsed Time                 0:00:00.001765
Execute Start Time       -1
Execute End Time         -1
Execute Elapsed Time                 0:00:00.000000
State                    CLOSE
Rows Affected            -1
SQL Error Code           0
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               MXID11000011701212378219753251307000000000206U3333300_317_S1
Parent Query System      SAME
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select distinct d from tstat ;
SQL Source Length        30
Rows Returned            0
First Row Returned Time  -1
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    0
Min. Execute Time        0.000000 secs
Max. Execute Time        0.000000 secs
Avg. Execute Time        0.000000 secs
Stats Collection Type    PERTABLE_STATS

--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT PARENT_QID 'NONE' ;

--- SQL operation complete.
>>prepare s1 from select distinct d from tstat ;

--- SQL command prepared.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;

--- SQL operation complete.
>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_333_S1 ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_333_S1
Compile Start Time       2017/11/23 17:56:53.100908
Compile End Time         2017/11/23 17:56:53.102456
Compile Elapsed Time                 0:00:00.001548
Execute Start Time       -1
Execute End Time         -1
Execute Elapsed Time                 0:00:00.000000
State                    CLOSE
Rows Affected            -1
SQL Error Code           0
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select distinct d from tstat ;
SQL Source Length        30
Rows Returned            0
First Row Returned Time  -1
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    0
Min. Execute Time        0.000000 secs
Max. Execute Time        0.000000 secs
Avg. Execute Time        0.000000 secs
Stats Collection Type    PERTABLE_STATS

--- SQL operation complete.
>>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_333_S1 ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_333_S1
Compile Start Time       2017/11/23 17:56:53.100908
Compile End Time         2017/11/23 17:56:53.102456
Compile Elapsed Time                 0:00:00.001548
Execute Start Time       -1
Execute End Time         -1
Execute Elapsed Time                 0:00:00.000000
State                    CLOSE
Rows Affected            -1
SQL Error Code           0
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select distinct d from tstat ;
SQL Source Length        30
Rows Returned            0
First Row Returned Time  -1
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    0
Min. Execute Time        0.000000 secs
Max. Execute Time        0.000000 secs
Avg. Execute Time        0.000000 secs
Stats Collection Type    PERTABLE_STATS

--- SQL operation complete.
>>log;
>>
>>-- TEST for OPERATOR stats
>>control query default detailed_statistics 'system' ;

--- SQL operation complete.
>>set session default statistics_view_type 'default' ;

--- SQL operation complete.
>>prepare s1 from select distinct d from tstat ;

--- SQL command prepared.
>>log ;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;

--- SQL operation complete.
>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_336_S1 ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_336_S1
Compile Start Time       2017/11/23 17:56:56.513528
Compile End Time         2017/11/23 17:56:56.575220
Compile Elapsed Time                 0:00:00.061692
Execute Start Time       -1
Execute End Time         -1
Execute Elapsed Time                 0:00:00.000000
State                    CLOSE
Rows Affected            -1
SQL Error Code           0
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select distinct d from tstat ;
SQL Source Length        30
Rows Returned            0
First Row Returned Time  -1
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    0
Min. Execute Time        0.000000 secs
Max. Execute Time        0.000000 secs
Avg. Execute Time        0.000000 secs
Stats Collection Type    OPERATOR_STATS

--- SQL operation complete.
>>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_336_S1 ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_336_S1
Compile Start Time       2017/11/23 17:56:56.513528
Compile End Time         2017/11/23 17:56:56.575220
Compile Elapsed Time                 0:00:00.061692
Execute Start Time       -1
Execute End Time         -1
Execute Elapsed Time                 0:00:00.000000
State                    CLOSE
Rows Affected            -1
SQL Error Code           0
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select distinct d from tstat ;
SQL Source Length        30
Rows Returned            0
First Row Returned Time  -1
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    0
Min. Execute Time        0.000000 secs
Max. Execute Time        0.000000 secs
Avg. Execute Time        0.000000 secs
Stats Collection Type    OPERATOR_STATS

--- SQL operation complete.
>>log;
>>execute s1 ;

D          
-----------

         12
         11
         21
         22

--- 4 row(s) selected.
>>log ;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;

--- SQL operation complete.
>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_336_S1 ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_336_S1
Compile Start Time       2017/11/23 17:56:56.513528
Compile End Time         2017/11/23 17:56:56.575220
Compile Elapsed Time                 0:00:00.061692
Execute Start Time       2017/11/23 17:57:00.313805
Execute End Time         2017/11/23 17:57:00.341117
Execute Elapsed Time                 0:00:00.027312
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:57:00.337861
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.027312 secs
Max. Execute Time        0.027312 secs
Avg. Execute Time        0.027312 secs
Stats Collection Type    OPERATOR_STATS

   LC   RC   Id PaId ExId Frag TDBName                    DOP   Dispatches        OperCPUTime        EstRowsUsed        ActRowsUsed Details

   10    .   11    .    5    0 EX_ROOT                      1            5                 16                  0                  4 1683
    9    .   10   11    4    0 EX_SPLIT_TOP                 1            5                 46                  2                  4
    8    .    9   10    4    0 EX_SEND_TOP                  2           10              1,621                  2                  4
    7    .    8    9    4    2 EX_SEND_BOTTOM               2           17                240                  2                  4
    6    .    7    8    4    2 EX_SPLIT_BOTTOM              2            7                 52                  2                  4 5674
    5    .    6    7    3    2 EX_HASH_GRBY                 2            6              3,392                  1                  4 0|0|0
    4    .    5    6    2    2 EX_SPLIT_TOP                 2            9                 52                100                  4
    3    .    4    5    2    2 EX_SEND_TOP                  4           18              1,938                100                  4
    2    .    3    4    2    3 EX_SEND_BOTTOM               4           26                395                100                  4
    1    .    2    3    2    3 EX_SPLIT_BOTTOM              2            8                 80                100                  4 8565
    .    .    1    2    1    3 EX_TRAF_KEY_SELECT           2            4              8,090                100                  4 TRAFODION.SCH.TSTAT|4|176

--- SQL operation complete.
>>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_336_S1 ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_336_S1
Compile Start Time       2017/11/23 17:56:56.513528
Compile End Time         2017/11/23 17:56:56.575220
Compile Elapsed Time                 0:00:00.061692
Execute Start Time       2017/11/23 17:57:00.313805
Execute End Time         2017/11/23 17:57:00.341117
Execute Elapsed Time                 0:00:00.027312
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:57:00.337861
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.027312 secs
Max. Execute Time        0.027312 secs
Avg. Execute Time        0.027312 secs
Stats Collection Type    OPERATOR_STATS

   LC   RC   Id PaId ExId Frag TDBName                    DOP   Dispatches        OperCPUTime        EstRowsUsed        ActRowsUsed Details

   10    .   11    .    5    0 EX_ROOT                      1            5                 16                  0                  4 1683
    9    .   10   11    4    0 EX_SPLIT_TOP                 1            5                 46                  2                  4
    8    .    9   10    4    0 EX_SEND_TOP                  2           10              1,621                  2                  4
    7    .    8    9    4    2 EX_SEND_BOTTOM               2           17                240                  2                  4
    6    .    7    8    4    2 EX_SPLIT_BOTTOM              2            7                 52                  2                  4 5674
    5    .    6    7    3    2 EX_HASH_GRBY                 2            6              3,392                  1                  4 0|0|0
    4    .    5    6    2    2 EX_SPLIT_TOP                 2            9                 52                100                  4
    3    .    4    5    2    2 EX_SEND_TOP                  4           18              1,938                100                  4
    2    .    3    4    2    3 EX_SEND_BOTTOM               4           26                395                100                  4
    1    .    2    3    2    3 EX_SPLIT_BOTTOM              2            8                 80                100                  4 8565
    .    .    1    2    1    3 EX_TRAF_KEY_SELECT           2            4              8,090                100                  4 TRAFODION.SCH.TSTAT|4|176

--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;

--- SQL operation complete.
>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_336_S1 ACCUMULATED;
Qid                      MXID11000011701212378219753251307000000000206U3333300_336_S1
Compile Start Time       2017/11/23 17:56:56.513528
Compile End Time         2017/11/23 17:56:56.575220
Compile Elapsed Time                 0:00:00.061692
Execute Start Time       2017/11/23 17:57:00.313805
Execute End Time         2017/11/23 17:57:00.341117
Execute Elapsed Time                 0:00:00.027312
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:57:00.337861
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.027312 secs
Max. Execute Time        0.027312 secs
Avg. Execute Time        0.027312 secs
Stats Collection Type    OPERATOR_STATS
Accessed Rows            4
Used Rows                4
SE IOs                   4
SE IO Bytes              176
SE IO MAX Time           9,595
SQL Process Busy Time    15,922
UDR Process Busy Time    0
SQL Space Allocated      896 KB
SQL Space Used           766 KB
SQL Heap Allocated       1,032 KB
SQL Heap Used            913 KB
SQL Heap WM              11,175 KB
Processes Created        0
Process Create Time      0
Request Message Count    28
Request Message Bytes    40,016
Reply Message Count      15
Reply Message Bytes      42,528
BMO Space Buffer Size    256
BMO Space Buffer Count   0
BMO Interim Row Count    0
Scr. Overflow Mode       DISK
Scr. File Count          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 MXID11000011701212378219753251307000000000206U3333300_336_S1 ACCUMULATED;
Qid                      MXID11000011701212378219753251307000000000206U3333300_336_S1
Compile Start Time       2017/11/23 17:56:56.513528
Compile End Time         2017/11/23 17:56:56.575220
Compile Elapsed Time                 0:00:00.061692
Execute Start Time       2017/11/23 17:57:00.313805
Execute End Time         2017/11/23 17:57:00.341117
Execute Elapsed Time                 0:00:00.027312
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:57:00.337861
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.027312 secs
Max. Execute Time        0.027312 secs
Avg. Execute Time        0.027312 secs
Stats Collection Type    OPERATOR_STATS
Accessed Rows            4
Used Rows                4
SE IOs                   4
SE IO Bytes              176
SE IO MAX Time           9,595
SQL Process Busy Time    15,922
UDR Process Busy Time    0
SQL Space Allocated      896 KB
SQL Space Used           766 KB
SQL Heap Allocated       1,032 KB
SQL Heap Used            913 KB
SQL Heap WM              11,175 KB
Processes Created        0
Process Create Time      0
Request Message Count    28
Request Message Bytes    40,016
Reply Message Count      15
Reply Message Bytes      42,528
BMO Space Buffer Size    256
BMO Space Buffer Count   0
BMO Interim Row Count    0
Scr. Overflow Mode       DISK
Scr. File Count          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 MXID11000011701212378219753251307000000000206U3333300_336_S1 PERTABLE;
Qid                      MXID11000011701212378219753251307000000000206U3333300_336_S1
Compile Start Time       2017/11/23 17:56:56.513528
Compile End Time         2017/11/23 17:56:56.575220
Compile Elapsed Time                 0:00:00.061692
Execute Start Time       2017/11/23 17:57:00.313805
Execute End Time         2017/11/23 17:57:00.341117
Execute Elapsed Time                 0:00:00.027312
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:57:00.337861
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.027312 secs
Max. Execute Time        0.027312 secs
Avg. Execute Time        0.027312 secs
Stats Collection Type    OPERATOR_STATS
SQL Process Busy Time    15,922
UDR Process Busy Time    0
SQL Space Allocated      896 KB
SQL Space Used           766 KB
SQL Heap Allocated       1,032 KB
SQL Heap Used            913 KB
SQL Heap WM              11,175 KB
Processes Created        0
Process Create Time      0
Request Message Count    28
Request Message Bytes    40,016
Reply Message Count      15
Reply Message Bytes      42,528
BMO Space Buffer Size    256
BMO Space Buffer Count   0
BMO Interim Row Count    0
Scr. Overflow Mode       DISK
Scr. File Count          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
  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs        SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
    1         2 TRAFODION.SCH.TSTAT
              0                   4            100                   4                   4                   0              17,013               9,595

--- SQL operation complete.
>>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_336_S1 PERTABLE;
Qid                      MXID11000011701212378219753251307000000000206U3333300_336_S1
Compile Start Time       2017/11/23 17:56:56.513528
Compile End Time         2017/11/23 17:56:56.575220
Compile Elapsed Time                 0:00:00.061692
Execute Start Time       2017/11/23 17:57:00.313805
Execute End Time         2017/11/23 17:57:00.341117
Execute Elapsed Time                 0:00:00.027312
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:57:00.337861
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.027312 secs
Max. Execute Time        0.027312 secs
Avg. Execute Time        0.027312 secs
Stats Collection Type    OPERATOR_STATS
SQL Process Busy Time    15,922
UDR Process Busy Time    0
SQL Space Allocated      896 KB
SQL Space Used           766 KB
SQL Heap Allocated       1,032 KB
SQL Heap Used            913 KB
SQL Heap WM              11,175 KB
Processes Created        0
Process Create Time      0
Request Message Count    28
Request Message Bytes    40,016
Reply Message Count      15
Reply Message Bytes      42,528
BMO Space Buffer Size    256
BMO Space Buffer Count   0
BMO Interim Row Count    0
Scr. Overflow Mode       DISK
Scr. File Count          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
  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs        SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
    1         2 TRAFODION.SCH.TSTAT
              0                   4            100                   4                   4                   0              17,013               9,595

--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;

--- SQL operation complete.
>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_336_S1 PROGRESS;
Qid                      MXID11000011701212378219753251307000000000206U3333300_336_S1
Compile Start Time       2017/11/23 17:56:56.513528
Compile End Time         2017/11/23 17:56:56.575220
Compile Elapsed Time                 0:00:00.061692
Execute Start Time       2017/11/23 17:57:00.313805
Execute End Time         2017/11/23 17:57:00.341117
Execute Elapsed Time                 0:00:00.027312
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:57:00.337861
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.027312 secs
Max. Execute Time        0.027312 secs
Avg. Execute Time        0.027312 secs
Stats Collection Type    OPERATOR_STATS
SQL Process Busy Time    15,922
SQL Space Allocated      896 KB
SQL Space Used           766 KB
SQL Heap Allocated       1,032 KB
SQL Heap Used            913 KB
SQL Heap WM              11,175 KB
Processes Created        0
Process Create Time      0
Request Message Count    28
Request Message Bytes    40,016
Reply Message Count      15
Reply Message Bytes      42,528

   Id       DOP Table Name
  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs        SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
    1         2 TRAFODION.SCH.TSTAT
              0                   4            100                   4                   4                   0              17,013               9,595

   Id             TDBName                Mode       DOP      TopN            BMOPhase     InterimRowCount             CPUTime
              BMOHeapUsed    BMOHeapAllocated           BMOHeapWM           EstMemory       BMOSpaceBufSz      BMOSpaceBufCnt
               ScrFileCnt           ScrIOSize           ScrIORead        ScrIOWritten           ScrIOTime        ScrIOMaxTime
    6        EX_HASH_GRBY                DISK         2        -1           READ_ROWS                   0               3,392
                        4               1,024               7,6870.07                                 256                   0
                        0                  -1                   0                   0                   0                   0

--- SQL operation complete.
>>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_336_S1 PROGRESS;
Qid                      MXID11000011701212378219753251307000000000206U3333300_336_S1
Compile Start Time       2017/11/23 17:56:56.513528
Compile End Time         2017/11/23 17:56:56.575220
Compile Elapsed Time                 0:00:00.061692
Execute Start Time       2017/11/23 17:57:00.313805
Execute End Time         2017/11/23 17:57:00.341117
Execute Elapsed Time                 0:00:00.027312
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:57:00.337861
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.027312 secs
Max. Execute Time        0.027312 secs
Avg. Execute Time        0.027312 secs
Stats Collection Type    OPERATOR_STATS
SQL Process Busy Time    15,922
SQL Space Allocated      896 KB
SQL Space Used           766 KB
SQL Heap Allocated       1,032 KB
SQL Heap Used            913 KB
SQL Heap WM              11,175 KB
Processes Created        0
Process Create Time      0
Request Message Count    28
Request Message Bytes    40,016
Reply Message Count      15
Reply Message Bytes      42,528

   Id       DOP Table Name
  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs        SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
    1         2 TRAFODION.SCH.TSTAT
              0                   4            100                   4                   4                   0              17,013               9,595

   Id             TDBName                Mode       DOP      TopN            BMOPhase     InterimRowCount             CPUTime
              BMOHeapUsed    BMOHeapAllocated           BMOHeapWM           EstMemory       BMOSpaceBufSz      BMOSpaceBufCnt
               ScrFileCnt           ScrIOSize           ScrIORead        ScrIOWritten           ScrIOTime        ScrIOMaxTime
    6        EX_HASH_GRBY                DISK         2        -1           READ_ROWS                   0               3,392
                        4               1,024               7,6870.07                                 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 MXID11000011701212378219753251307000000000206U3333300_336_S1 DEFAULT;
Qid                      MXID11000011701212378219753251307000000000206U3333300_336_S1
Compile Start Time       2017/11/23 17:56:56.513528
Compile End Time         2017/11/23 17:56:56.575220
Compile Elapsed Time                 0:00:00.061692
Execute Start Time       2017/11/23 17:57:00.313805
Execute End Time         2017/11/23 17:57:00.341117
Execute Elapsed Time                 0:00:00.027312
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:57:00.337861
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.027312 secs
Max. Execute Time        0.027312 secs
Avg. Execute Time        0.027312 secs
Stats Collection Type    OPERATOR_STATS

   LC   RC   Id PaId ExId Frag TDBName                    DOP   Dispatches        OperCPUTime        EstRowsUsed        ActRowsUsed Details

   10    .   11    .    5    0 EX_ROOT                      1            5                 16                  0                  4 1683
    9    .   10   11    4    0 EX_SPLIT_TOP                 1            5                 46                  2                  4
    8    .    9   10    4    0 EX_SEND_TOP                  2           10              1,621                  2                  4
    7    .    8    9    4    2 EX_SEND_BOTTOM               2           17                240                  2                  4
    6    .    7    8    4    2 EX_SPLIT_BOTTOM              2            7                 52                  2                  4 5674
    5    .    6    7    3    2 EX_HASH_GRBY                 2            6              3,392                  1                  4 0|0|0
    4    .    5    6    2    2 EX_SPLIT_TOP                 2            9                 52                100                  4
    3    .    4    5    2    2 EX_SEND_TOP                  4           18              1,938                100                  4
    2    .    3    4    2    3 EX_SEND_BOTTOM               4           26                395                100                  4
    1    .    2    3    2    3 EX_SPLIT_BOTTOM              2            8                 80                100                  4 8565
    .    .    1    2    1    3 EX_TRAF_KEY_SELECT           2            4              8,090                100                  4 TRAFODION.SCH.TSTAT|4|176

--- SQL operation complete.
>>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_336_S1 DEFAULT;
Qid                      MXID11000011701212378219753251307000000000206U3333300_336_S1
Compile Start Time       2017/11/23 17:56:56.513528
Compile End Time         2017/11/23 17:56:56.575220
Compile Elapsed Time                 0:00:00.061692
Execute Start Time       2017/11/23 17:57:00.313805
Execute End Time         2017/11/23 17:57:00.341117
Execute Elapsed Time                 0:00:00.027312
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:57:00.337861
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.027312 secs
Max. Execute Time        0.027312 secs
Avg. Execute Time        0.027312 secs
Stats Collection Type    OPERATOR_STATS

   LC   RC   Id PaId ExId Frag TDBName                    DOP   Dispatches        OperCPUTime        EstRowsUsed        ActRowsUsed Details

   10    .   11    .    5    0 EX_ROOT                      1            5                 16                  0                  4 1683
    9    .   10   11    4    0 EX_SPLIT_TOP                 1            5                 46                  2                  4
    8    .    9   10    4    0 EX_SEND_TOP                  2           10              1,621                  2                  4
    7    .    8    9    4    2 EX_SEND_BOTTOM               2           17                240                  2                  4
    6    .    7    8    4    2 EX_SPLIT_BOTTOM              2            7                 52                  2                  4 5674
    5    .    6    7    3    2 EX_HASH_GRBY                 2            6              3,392                  1                  4 0|0|0
    4    .    5    6    2    2 EX_SPLIT_TOP                 2            9                 52                100                  4
    3    .    4    5    2    2 EX_SEND_TOP                  4           18              1,938                100                  4
    2    .    3    4    2    3 EX_SEND_BOTTOM               4           26                395                100                  4
    1    .    2    3    2    3 EX_SPLIT_BOTTOM              2            8                 80                100                  4 8565
    .    .    1    2    1    3 EX_TRAF_KEY_SELECT           2            4              8,090                100                  4 TRAFODION.SCH.TSTAT|4|176

--- SQL operation complete.
>>log;
>>get statistics for qid current ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_336_S1
Compile Start Time       2017/11/23 17:56:56.513528
Compile End Time         2017/11/23 17:56:56.575220
Compile Elapsed Time                 0:00:00.061692
Execute Start Time       2017/11/23 17:57:00.313805
Execute End Time         2017/11/23 17:57:00.341117
Execute Elapsed Time                 0:00:00.027312
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:57:00.337861
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.027312 secs
Max. Execute Time        0.027312 secs
Avg. Execute Time        0.027312 secs
Stats Collection Type    OPERATOR_STATS

   LC   RC   Id PaId ExId Frag TDBName                    DOP   Dispatches        OperCPUTime        EstRowsUsed        ActRowsUsed Details

   10    .   11    .    5    0 EX_ROOT                      1            5                 16                  0                  4 1683
    9    .   10   11    4    0 EX_SPLIT_TOP                 1            5                 46                  2                  4
    8    .    9   10    4    0 EX_SEND_TOP                  2           10              1,621                  2                  4
    7    .    8    9    4    2 EX_SEND_BOTTOM               2            7                240                  2                  4
    6    .    7    8    4    2 EX_SPLIT_BOTTOM              2            5                 52                  2                  4 5674
    5    .    6    7    3    2 EX_HASH_GRBY                 2            6              3,392                  1                  4 0|0|0
    4    .    5    6    2    2 EX_SPLIT_TOP                 2            9                 52                100                  4
    3    .    4    5    2    2 EX_SEND_TOP                  4           18              1,938                100                  4
    2    .    3    4    2    3 EX_SEND_BOTTOM               4           10                395                100                  4
    1    .    2    3    2    3 EX_SPLIT_BOTTOM              2            6                 80                100                  4 8565
    .    .    1    2    1    3 EX_TRAF_KEY_SELECT           2            4              8,090                100                  4 TRAFODION.SCH.TSTAT|4|176

--- SQL operation complete.
>>get statistics for qid current accumulated ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_336_S1
Compile Start Time       2017/11/23 17:56:56.513528
Compile End Time         2017/11/23 17:56:56.575220
Compile Elapsed Time                 0:00:00.061692
Execute Start Time       2017/11/23 17:57:00.313805
Execute End Time         2017/11/23 17:57:00.341117
Execute Elapsed Time                 0:00:00.027312
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:57:00.337861
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.027312 secs
Max. Execute Time        0.027312 secs
Avg. Execute Time        0.027312 secs
Stats Collection Type    OPERATOR_STATS
Accessed Rows            4
Used Rows                4
SE IOs                   4
SE IO Bytes              176
SE IO MAX Time           9,595
SQL Process Busy Time    15,922
UDR Process Busy Time    0
SQL Space Allocated      896 KB
SQL Space Used           766 KB
SQL Heap Allocated       1,032 KB
SQL Heap Used            913 KB
SQL Heap WM              11,175 KB
Processes Created        0
Process Create Time      0
Request Message Count    28
Request Message Bytes    40,016
Reply Message Count      15
Reply Message Bytes      42,528
BMO Space Buffer Size    256
BMO Space Buffer Count   0
BMO Interim Row Count    0
Scr. Overflow Mode       DISK
Scr. File Count          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 pertable ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_336_S1
Compile Start Time       2017/11/23 17:56:56.513528
Compile End Time         2017/11/23 17:56:56.575220
Compile Elapsed Time                 0:00:00.061692
Execute Start Time       2017/11/23 17:57:00.313805
Execute End Time         2017/11/23 17:57:00.341117
Execute Elapsed Time                 0:00:00.027312
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:57:00.337861
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.027312 secs
Max. Execute Time        0.027312 secs
Avg. Execute Time        0.027312 secs
Stats Collection Type    OPERATOR_STATS
SQL Process Busy Time    15,922
UDR Process Busy Time    0
SQL Space Allocated      896 KB
SQL Space Used           766 KB
SQL Heap Allocated       1,032 KB
SQL Heap Used            913 KB
SQL Heap WM              11,175 KB
Processes Created        0
Process Create Time      0
Request Message Count    28
Request Message Bytes    40,016
Reply Message Count      15
Reply Message Bytes      42,528
BMO Space Buffer Size    256
BMO Space Buffer Count   0
BMO Interim Row Count    0
Scr. Overflow Mode       DISK
Scr. File Count          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
  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs        SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
    1         2 TRAFODION.SCH.TSTAT
              0                   4            100                   4                   4                   0              17,013               9,595

--- SQL operation complete.
>>get statistics for qid current progress ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_336_S1
Compile Start Time       2017/11/23 17:56:56.513528
Compile End Time         2017/11/23 17:56:56.575220
Compile Elapsed Time                 0:00:00.061692
Execute Start Time       2017/11/23 17:57:00.313805
Execute End Time         2017/11/23 17:57:00.341117
Execute Elapsed Time                 0:00:00.027312
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:57:00.337861
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.027312 secs
Max. Execute Time        0.027312 secs
Avg. Execute Time        0.027312 secs
Stats Collection Type    OPERATOR_STATS
SQL Process Busy Time    15,922
SQL Space Allocated      896 KB
SQL Space Used           766 KB
SQL Heap Allocated       1,032 KB
SQL Heap Used            913 KB
SQL Heap WM              11,175 KB
Processes Created        0
Process Create Time      0
Request Message Count    28
Request Message Bytes    40,016
Reply Message Count      15
Reply Message Bytes      42,528

   Id       DOP Table Name
  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs        SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
    1         2 TRAFODION.SCH.TSTAT
              0                   4            100                   4                   4                   0              17,013               9,595

   Id             TDBName                Mode       DOP      TopN            BMOPhase     InterimRowCount             CPUTime
              BMOHeapUsed    BMOHeapAllocated           BMOHeapWM           EstMemory       BMOSpaceBufSz      BMOSpaceBufCnt
               ScrFileCnt           ScrIOSize           ScrIORead        ScrIOWritten           ScrIOTime        ScrIOMaxTime
    6        EX_HASH_GRBY                DISK         2        -1           READ_ROWS                   0               3,392
                        4               1,024               7,6870.07                                 256                   0
                        0                  -1                   0                   0                   0                   0

--- SQL operation complete.
>>get statistics for qid current progress, options 'sl' ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_336_S1
Compile Start Time       2017/11/23 17:56:56.513528
Compile End Time         2017/11/23 17:56:56.575220
Compile Elapsed Time                 0:00:00.061692
Execute Start Time       2017/11/23 17:57:00.313805
Execute End Time         2017/11/23 17:57:00.341117
Execute Elapsed Time                 0:00:00.027312
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:57:00.337861
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.027312 secs
Max. Execute Time        0.027312 secs
Avg. Execute Time        0.027312 secs
Stats Collection Type    OPERATOR_STATS
SQL Process Busy Time    15,922
SQL Space Allocated      896 KB
SQL Space Used           766 KB
SQL Heap Allocated       1,032 KB
SQL Heap Used            913 KB
SQL Heap WM              11,175 KB
Processes Created        0
Process Create Time      0
Request Message Count    28
Request Message Bytes    40,016
Reply Message Count      15
Reply Message Bytes      42,528

   Id       DOP  EstRowsAccess       ActRowsAccess     EstRowUsed         ActRowsUsed              SE_IOs        SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime TableName
    1         2              0                   4            100                   4                   4                   0              17,013               9,595 TRAFODION.SCH.TSTAT

   Id             TDBName Mode       DOP      TopN    BMOPhase     InterimRowCount             CPUTime         BMOHeapUsed    BMOHeapAllocated           BMOHeapWM           EstMemory       BMOSpaceBufSz      BMOSpaceBufCnt   FileCnt ScrIOSize           ScrIORead        ScrIOWritten           ScrIOTime        ScrIOMaxTime
    6        EX_HASH_GRBY DISK         2        -1   READ_ROWS                   0               3,392                   4               1,024               7,6870.07                                 256                   0         0        -1                   0                   0                   0                   0

--- SQL operation complete.
>>get statistics for qid current default ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_336_S1
Compile Start Time       2017/11/23 17:56:56.513528
Compile End Time         2017/11/23 17:56:56.575220
Compile Elapsed Time                 0:00:00.061692
Execute Start Time       2017/11/23 17:57:00.313805
Execute End Time         2017/11/23 17:57:00.341117
Execute Elapsed Time                 0:00:00.027312
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:57:00.337861
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.027312 secs
Max. Execute Time        0.027312 secs
Avg. Execute Time        0.027312 secs
Stats Collection Type    OPERATOR_STATS

   LC   RC   Id PaId ExId Frag TDBName                    DOP   Dispatches        OperCPUTime        EstRowsUsed        ActRowsUsed Details

   10    .   11    .    5    0 EX_ROOT                      1            5                 16                  0                  4 1683
    9    .   10   11    4    0 EX_SPLIT_TOP                 1            5                 46                  2                  4
    8    .    9   10    4    0 EX_SEND_TOP                  2           10              1,621                  2                  4
    7    .    8    9    4    2 EX_SEND_BOTTOM               2            7                240                  2                  4
    6    .    7    8    4    2 EX_SPLIT_BOTTOM              2            5                 52                  2                  4 5674
    5    .    6    7    3    2 EX_HASH_GRBY                 2            6              3,392                  1                  4 0|0|0
    4    .    5    6    2    2 EX_SPLIT_TOP                 2            9                 52                100                  4
    3    .    4    5    2    2 EX_SEND_TOP                  4           18              1,938                100                  4
    2    .    3    4    2    3 EX_SEND_BOTTOM               4           10                395                100                  4
    1    .    2    3    2    3 EX_SPLIT_BOTTOM              2            6                 80                100                  4 8565
    .    .    1    2    1    3 EX_TRAF_KEY_SELECT           2            4              8,090                100                  4 TRAFODION.SCH.TSTAT|4|176

--- SQL operation complete.
>>set session default statistics_view_type 'default' ;

--- SQL operation complete.
>>get statistics for qid current ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_336_S1
Compile Start Time       2017/11/23 17:56:56.513528
Compile End Time         2017/11/23 17:56:56.575220
Compile Elapsed Time                 0:00:00.061692
Execute Start Time       2017/11/23 17:57:00.313805
Execute End Time         2017/11/23 17:57:00.341117
Execute Elapsed Time                 0:00:00.027312
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:57:00.337861
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.027312 secs
Max. Execute Time        0.027312 secs
Avg. Execute Time        0.027312 secs
Stats Collection Type    OPERATOR_STATS

   LC   RC   Id PaId ExId Frag TDBName                    DOP   Dispatches        OperCPUTime        EstRowsUsed        ActRowsUsed Details

   10    .   11    .    5    0 EX_ROOT                      1            5                 16                  0                  4 1683
    9    .   10   11    4    0 EX_SPLIT_TOP                 1            5                 46                  2                  4
    8    .    9   10    4    0 EX_SEND_TOP                  2           10              1,621                  2                  4
    7    .    8    9    4    2 EX_SEND_BOTTOM               2            7                240                  2                  4
    6    .    7    8    4    2 EX_SPLIT_BOTTOM              2            5                 52                  2                  4 5674
    5    .    6    7    3    2 EX_HASH_GRBY                 2            6              3,392                  1                  4 0|0|0
    4    .    5    6    2    2 EX_SPLIT_TOP                 2            9                 52                100                  4
    3    .    4    5    2    2 EX_SEND_TOP                  4           18              1,938                100                  4
    2    .    3    4    2    3 EX_SEND_BOTTOM               4           10                395                100                  4
    1    .    2    3    2    3 EX_SPLIT_BOTTOM              2            6                 80                100                  4 8565
    .    .    1    2    1    3 EX_TRAF_KEY_SELECT           2            4              8,090                100                  4 TRAFODION.SCH.TSTAT|4|176

--- SQL operation complete.
>>set session default statistics_view_type 'accumulated' ;

--- SQL operation complete.
>>get statistics for qid current ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_336_S1
Compile Start Time       2017/11/23 17:56:56.513528
Compile End Time         2017/11/23 17:56:56.575220
Compile Elapsed Time                 0:00:00.061692
Execute Start Time       2017/11/23 17:57:00.313805
Execute End Time         2017/11/23 17:57:00.341117
Execute Elapsed Time                 0:00:00.027312
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:57:00.337861
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.027312 secs
Max. Execute Time        0.027312 secs
Avg. Execute Time        0.027312 secs
Stats Collection Type    OPERATOR_STATS
Accessed Rows            4
Used Rows                4
SE IOs                   4
SE IO Bytes              176
SE IO MAX Time           9,595
SQL Process Busy Time    15,922
UDR Process Busy Time    0
SQL Space Allocated      896 KB
SQL Space Used           766 KB
SQL Heap Allocated       1,032 KB
SQL Heap Used            913 KB
SQL Heap WM              11,175 KB
Processes Created        0
Process Create Time      0
Request Message Count    28
Request Message Bytes    40,016
Reply Message Count      15
Reply Message Bytes      42,528
BMO Space Buffer Size    256
BMO Space Buffer Count   0
BMO Interim Row Count    0
Scr. Overflow Mode       DISK
Scr. File Count          0
Scr. IO Size             0
Scr. Read Count          0
Scr. Write Count         0
Scr. IO Max Time         0
Sort TopN                -1

--- SQL operation complete.
>>set session default statistics_view_type 'pertable' ;

--- SQL operation complete.
>>get statistics for qid current ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_336_S1
Compile Start Time       2017/11/23 17:56:56.513528
Compile End Time         2017/11/23 17:56:56.575220
Compile Elapsed Time                 0:00:00.061692
Execute Start Time       2017/11/23 17:57:00.313805
Execute End Time         2017/11/23 17:57:00.341117
Execute Elapsed Time                 0:00:00.027312
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:57:00.337861
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.027312 secs
Max. Execute Time        0.027312 secs
Avg. Execute Time        0.027312 secs
Stats Collection Type    OPERATOR_STATS
SQL Process Busy Time    15,922
UDR Process Busy Time    0
SQL Space Allocated      896 KB
SQL Space Used           766 KB
SQL Heap Allocated       1,032 KB
SQL Heap Used            913 KB
SQL Heap WM              11,175 KB
Processes Created        0
Process Create Time      0
Request Message Count    28
Request Message Bytes    40,016
Reply Message Count      15
Reply Message Bytes      42,528
BMO Space Buffer Size    256
BMO Space Buffer Count   0
BMO Interim Row Count    0
Scr. Overflow Mode       DISK
Scr. File Count          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
  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs        SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
    1         2 TRAFODION.SCH.TSTAT
              0                   4            100                   4                   4                   0              17,013               9,595

--- SQL operation complete.
>>set session default statistics_view_type 'progress' ;

--- SQL operation complete.
>>get statistics for qid current ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_336_S1
Compile Start Time       2017/11/23 17:56:56.513528
Compile End Time         2017/11/23 17:56:56.575220
Compile Elapsed Time                 0:00:00.061692
Execute Start Time       2017/11/23 17:57:00.313805
Execute End Time         2017/11/23 17:57:00.341117
Execute Elapsed Time                 0:00:00.027312
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
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/11/23 17:57:00.337861
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.027312 secs
Max. Execute Time        0.027312 secs
Avg. Execute Time        0.027312 secs
Stats Collection Type    OPERATOR_STATS
SQL Process Busy Time    15,922
SQL Space Allocated      896 KB
SQL Space Used           766 KB
SQL Heap Allocated       1,032 KB
SQL Heap Used            913 KB
SQL Heap WM              11,175 KB
Processes Created        0
Process Create Time      0
Request Message Count    28
Request Message Bytes    40,016
Reply Message Count      15
Reply Message Bytes      42,528

   Id       DOP Table Name
  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs        SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
    1         2 TRAFODION.SCH.TSTAT
              0                   4            100                   4                   4                   0              17,013               9,595

   Id             TDBName                Mode       DOP      TopN            BMOPhase     InterimRowCount             CPUTime
              BMOHeapUsed    BMOHeapAllocated           BMOHeapWM           EstMemory       BMOSpaceBufSz      BMOSpaceBufCnt
               ScrFileCnt           ScrIOSize           ScrIORead        ScrIOWritten           ScrIOTime        ScrIOMaxTime
    6        EX_HASH_GRBY                DISK         2        -1           READ_ROWS                   0               3,392
                        4               1,024               7,6870.07                                 256                   0
                        0                  -1                   0                   0                   0                   0

--- SQL operation complete.
>>set session default statistics_view_type 'pertable' ;

--- SQL operation complete.
>>
>>-- TEST for set session settings
>>set statistics pertable ;
>>execute s1 ;

D          
-----------

         12
         11
         21
         22

--- 4 row(s) selected.
Qid                      MXID11000011701212378219753251307000000000206U3333300_336_S1
Compile Start Time       2017/11/23 17:56:56.513528
Compile End Time         2017/11/23 17:56:56.575220
Compile Elapsed Time                 0:00:00.061692
Execute Start Time       2017/11/23 17:57:19.265825
Execute End Time         2017/11/23 17:57:19.285723
Execute Elapsed Time                 0:00:00.019898
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select distinct d from tstat ;
SQL Source Length        30
Rows Returned            4
First Row Returned Time  2017/11/23 17:57:19.281560
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    2
Min. Execute Time        0.019898 secs
Max. Execute Time        0.027312 secs
Avg. Execute Time        0.023605 secs
Stats Collection Type    OPERATOR_STATS
SQL Process Busy Time    11,337
UDR Process Busy Time    0
SQL Space Allocated      896 KB
SQL Space Used           773 KB
SQL Heap Allocated       1,032 KB
SQL Heap Used            913 KB
SQL Heap WM              11,175 KB
Processes Created        0
Process Create Time      0
Request Message Count    18
Request Message Bytes    5,856
Reply Message Count      6
Reply Message Bytes      45,520
BMO Space Buffer Size    256
BMO Space Buffer Count   2
BMO Interim Row Count    0
Scr. Overflow Mode       DISK
Scr. File Count          0
Scr. IO Size             0
Scr. Read Count          0
Scr. Write Count         0
Scr. IO Max Time         0
Sort TopN                -1

   Id       DOP  EstRowsAccess       ActRowsAccess     EstRowUsed         ActRowsUsed              SE_IOs        SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime TableName
    1         2              0                   4            100                   4                   4                   0              11,553               5,830 TRAFODION.SCH.TSTAT

--- SQL operation complete.
>>set statistics progress ;
>>execute s1 ;

D          
-----------

         12
         11
         21
         22

--- 4 row(s) selected.
Qid                      MXID11000011701212378219753251307000000000206U3333300_336_S1
Compile Start Time       2017/11/23 17:56:56.513528
Compile End Time         2017/11/23 17:56:56.575220
Compile Elapsed Time                 0:00:00.061692
Execute Start Time       2017/11/23 17:57:19.294814
Execute End Time         2017/11/23 17:57:19.304072
Execute Elapsed Time                 0:00:00.009258
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select distinct d from tstat ;
SQL Source Length        30
Rows Returned            4
First Row Returned Time  2017/11/23 17:57:19.302006
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    3
Min. Execute Time        0.009258 secs
Max. Execute Time        0.027312 secs
Avg. Execute Time        0.018822 secs
Stats Collection Type    OPERATOR_STATS
SQL Process Busy Time    5,357
SQL Space Allocated      896 KB
SQL Space Used           774 KB
SQL Heap Allocated       1,032 KB
SQL Heap Used            913 KB
SQL Heap WM              11,175 KB
Processes Created        0
Process Create Time      0
Request Message Count    18
Request Message Bytes    5,856
Reply Message Count      6
Reply Message Bytes      45,520

   Id       DOP  EstRowsAccess       ActRowsAccess     EstRowUsed         ActRowsUsed              SE_IOs        SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime TableName
    1         2              0                   4            100                   4                   4                   0               3,947               2,047 TRAFODION.SCH.TSTAT

   Id             TDBName Mode       DOP      TopN    BMOPhase     InterimRowCount             CPUTime         BMOHeapUsed    BMOHeapAllocated           BMOHeapWM           EstMemory       BMOSpaceBufSz      BMOSpaceBufCnt   FileCnt ScrIOSize           ScrIORead        ScrIOWritten           ScrIOTime        ScrIOMaxTime
    6        EX_HASH_GRBY DISK         2        -1   READ_ROWS                   0               2,280                   4               1,024               7,6870.07                                 256                   2         0        -1                   0                   0                   0                   0

--- SQL operation complete.
>>set statistics default ;
>>execute s1 ;

D          
-----------

         12
         11
         21
         22

--- 4 row(s) selected.
Qid                      MXID11000011701212378219753251307000000000206U3333300_336_S1
Compile Start Time       2017/11/23 17:56:56.513528
Compile End Time         2017/11/23 17:56:56.575220
Compile Elapsed Time                 0:00:00.061692
Execute Start Time       2017/11/23 17:57:19.313762
Execute End Time         2017/11/23 17:57:19.324361
Execute Elapsed Time                 0:00:00.010599
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select distinct d from tstat ;
SQL Source Length        30
Rows Returned            4
First Row Returned Time  2017/11/23 17:57:19.321364
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    4
Min. Execute Time        0.009258 secs
Max. Execute Time        0.027312 secs
Avg. Execute Time        0.016766 secs
Stats Collection Type    OPERATOR_STATS

   LC   RC   Id PaId ExId Frag TDBName                    DOP   Dispatches        OperCPUTime        EstRowsUsed        ActRowsUsed Details

   10    .   11    .    5    0 EX_ROOT                      1            5                 19                  0                  4 507
    9    .   10   11    4    0 EX_SPLIT_TOP                 1            5                 24                  2                  4
    8    .    9   10    4    0 EX_SEND_TOP                  2            6                464                  2                  4
    7    .    8    9    4    2 EX_SEND_BOTTOM               2           19                 13                  2                  4
    6    .    7    8    4    2 EX_SPLIT_BOTTOM              2            7                 25                  2                  4 2821
    5    .    6    7    3    2 EX_HASH_GRBY                 2            5              2,357                  1                  4 0|0|0
    4    .    5    6    2    2 EX_SPLIT_TOP                 2            8                 35                100                  4
    3    .    4    5    2    2 EX_SEND_TOP                  4           18                391                100                  4
    2    .    3    4    2    3 EX_SEND_BOTTOM               4           20                148                100                  4
    1    .    2    3    2    3 EX_SPLIT_BOTTOM              2            6                 34                100                  4 2055
    .    .    1    2    1    3 EX_TRAF_KEY_SELECT           2            2              1,873                100                  4 TRAFODION.SCH.TSTAT|4|176

--- SQL operation complete.
>>set statistics all ;
>>execute s1 ;

D          
-----------

         12
         11
         21
         22

--- 4 row(s) selected.
Qid                      MXID11000011701212378219753251307000000000206U3333300_336_S1
Compile Start Time       2017/11/23 17:56:56.513528
Compile End Time         2017/11/23 17:56:56.575220
Compile Elapsed Time                 0:00:00.061692
Execute Start Time       2017/11/23 17:57:19.334122
Execute End Time         2017/11/23 17:57:19.343143
Execute Elapsed Time                 0:00:00.009021
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select distinct d from tstat ;
SQL Source Length        30
Rows Returned            4
First Row Returned Time  2017/11/23 17:57:19.340938
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    5
Min. Execute Time        0.009021 secs
Max. Execute Time        0.027312 secs
Avg. Execute Time        0.015217 secs
Stats Collection Type    OPERATOR_STATS
SQL Process Busy Time    5,199
SQL Space Allocated      896 KB
SQL Space Used           774 KB
SQL Heap Allocated       1,032 KB
SQL Heap Used            913 KB
SQL Heap WM              11,175 KB
Processes Created        0
Process Create Time      0
Request Message Count    18
Request Message Bytes    5,856
Reply Message Count      6
Reply Message Bytes      45,520

   Id       DOP  EstRowsAccess       ActRowsAccess     EstRowUsed         ActRowsUsed              SE_IOs        SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime TableName
    1         2              0                   4            100                   4                   4                   0               5,946               2,997 TRAFODION.SCH.TSTAT

   Id             TDBName Mode       DOP      TopN    BMOPhase     InterimRowCount             CPUTime         BMOHeapUsed    BMOHeapAllocated           BMOHeapWM           EstMemory       BMOSpaceBufSz      BMOSpaceBufCnt   FileCnt ScrIOSize           ScrIORead        ScrIOWritten           ScrIOTime        ScrIOMaxTime
    6        EX_HASH_GRBY DISK         2        -1   READ_ROWS                   0               2,327                   4               1,024               7,6870.07                                 256                   2         0        -1                   0                   0                   0                   0

--- SQL operation complete.
Qid                      MXID11000011701212378219753251307000000000206U3333300_336_S1
Compile Start Time       2017/11/23 17:56:56.513528
Compile End Time         2017/11/23 17:56:56.575220
Compile Elapsed Time                 0:00:00.061692
Execute Start Time       2017/11/23 17:57:19.334122
Execute End Time         2017/11/23 17:57:19.343143
Execute Elapsed Time                 0:00:00.009021
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select distinct d from tstat ;
SQL Source Length        30
Rows Returned            4
First Row Returned Time  2017/11/23 17:57:19.340938
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    5
Min. Execute Time        0.009021 secs
Max. Execute Time        0.027312 secs
Avg. Execute Time        0.015217 secs
Stats Collection Type    OPERATOR_STATS

   LC   RC   Id PaId ExId Frag TDBName                    DOP   Dispatches        OperCPUTime        EstRowsUsed        ActRowsUsed Details

   10    .   11    .    5    0 EX_ROOT                      1            5                 10                  0                  4 486
    9    .   10   11    4    0 EX_SPLIT_TOP                 1            5                 34                  2                  4
    8    .    9   10    4    0 EX_SEND_TOP                  2            6                442                  2                  4
    7    .    8    9    4    2 EX_SEND_BOTTOM               2           15                 12                  2                  4
    6    .    7    8    4    2 EX_SPLIT_BOTTOM              2            7                 29                  2                  4 2796
    5    .    6    7    3    2 EX_HASH_GRBY                 2            5              2,327                  1                  4 0|0|0
    4    .    5    6    2    2 EX_SPLIT_TOP                 2            8                 31                100                  4
    3    .    4    5    2    2 EX_SEND_TOP                  4           18                397                100                  4
    2    .    3    4    2    3 EX_SEND_BOTTOM               4           15                137                100                  4
    1    .    2    3    2    3 EX_SPLIT_BOTTOM              2            7                 27                100                  4 1917
    .    .    1    2    1    3 EX_TRAF_KEY_SELECT           2            2              1,753                100                  4 TRAFODION.SCH.TSTAT|4|176

--- SQL operation complete.
>>set statistics off ;
>>
>>-- TEST for RMS Stats
>>get statistics for RMS 0 ;
Node name                     edev06.esgyn.local:0
Node Id                       0
RMS Version                   2511
SSCP PID                      29181
SSCP Creation Timestamp       2017/11/23 16:54:13.933909
SSMP PID                      29245
SSMP Creation Timestamp       2017/11/23 16:54:16.774836
Source String Store Len       254
Stats Heap Allocated          67,106,592
Stats Heap Used               1,794,672
Stats Heap High WM            1,971,088
No.of Process Stats Heaps     9
No.of Process Regd.           4
No.of Query Fragments Regd.   9
RMS Semaphore Owner           -1
No.of SSCPs Opened            2
No.of SSCPs Open Deleted      0
Last GC Time                  2017/11/23 17:54:23.352792
Queries GCed in Last Run      3
Total Queries GCed            82
SSMP Request Message Count    24,226
SSMP Request Message Bytes    13,781,592
SSMP Reply Message Count      24,225
SSMP Reply Message Bytes      3,418,240
SSCP Request Message Count    353
SSCP Request Message Bytes    80,176
SSCP Reply Message Count      353
SSCP Reply Message Bytes      139,848
RMS Stats Reset Timestamp     2017/11/23 16:54:16.511971
No. Query Invalidation Keys   121
Configured Pid Max            32768


--- SQL operation complete.
>>-- get statistics for RMS all is not tested because it can filtering issues
>>
>>-- Misc tests to increase code coverage
>>control query shape cut;

--- SQL operation complete.
>>select 'FUNKY_OPT_UNIQUE', count(*) from table(statistics(NULL,'CPU=0'));

(EXPR)            (EXPR)              
----------------  --------------------

FUNKY_OPT_UNIQUE                     0

--- 1 row(s) selected.
>>select 'FUNKY_OPT_UNIQUE', count(*) from table(statistics(NULL,'CPU_OFFENDER=-1'));

(EXPR)            (EXPR)              
----------------  --------------------

FUNKY_OPT_UNIQUE                     0

--- 1 row(s) selected.
>>-- Coverage for SscpNewIncomingConnectionStream::processCpuStatsReq
>>select 'FUNKY_OPT_UNIQUE', count(*) from table(statistics(NULL,'CPU_OFFENDER=-1'));

(EXPR)            (EXPR)              
----------------  --------------------

FUNKY_OPT_UNIQUE                     0

--- 1 row(s) selected.
>>select 'FUNKY_OPT_UNIQUE', count(*) from table(statistics(NULL,'DISK_OFFENDER=-1'));

(EXPR)            (EXPR)              
----------------  --------------------

FUNKY_OPT_UNIQUE                     0

--- 1 row(s) selected.
>>log;
Stats Heap Allocated          67,106,592
>>
>>-- TEST for EXPLAIN_IN_RMS 
>>control query default explain_in_rms 'on' ;

--- SQL operation complete.
>>control query shape cut;

--- SQL operation complete.
>>prepare s1 from select d from tstat ;

--- SQL command prepared.
>>log;
>>explain options 'f' for qid MXID11000011701212378219753251307000000000206U3333300_366_S1 ;

LC   RC   OP   OPERATOR              OPT       DESCRIPTION           CARD
---- ---- ---- --------------------  --------  --------------------  ---------

1    .    2    root                                                  1.00E+002
.    .    1    trafodion_scan                  TSTAT                 1.00E+002

--- SQL operation complete.
>>log;
>>control query default explain_in_rms reset;

--- SQL operation complete.
>>
>>-- TEST for index name - Soln 10-090330-0390 
>>create index tstati on tstat(d);

--- SQL operation complete.
>>prepare s1 from select d from tstat ;

--- SQL command prepared.
>>explain options 'f' s1 ;

LC   RC   OP   OPERATOR              OPT       DESCRIPTION           CARD
---- ---- ---- --------------------  --------  --------------------  ---------

1    .    2    root                                                  1.00E+002
.    .    1    trafodion_index_scan            TSTATI                1.00E+002

--- SQL operation complete.
>>log ;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;

--- SQL operation complete.
>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_491_S1 ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_491_S1
Compile Start Time       2017/11/23 17:57:44.184561
Compile End Time         2017/11/23 17:57:44.630325
Compile Elapsed Time                 0:00:00.445764
Execute Start Time       -1
Execute End Time         -1
Execute Elapsed Time                 0:00:00.000000
State                    CLOSE
Rows Affected            -1
SQL Error Code           0
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select d from tstat ;
SQL Source Length        21
Rows Returned            0
First Row Returned Time  -1
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    0
Min. Execute Time        0.000000 secs
Max. Execute Time        0.000000 secs
Avg. Execute Time        0.000000 secs
Stats Collection Type    OPERATOR_STATS

--- SQL operation complete.
>>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_491_S1 ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_491_S1
Compile Start Time       2017/11/23 17:57:44.184561
Compile End Time         2017/11/23 17:57:44.630325
Compile Elapsed Time                 0:00:00.445764
Execute Start Time       -1
Execute End Time         -1
Execute Elapsed Time                 0:00:00.000000
State                    CLOSE
Rows Affected            -1
SQL Error Code           0
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           0
Transaction Id           -1
Source String            select d from tstat ;
SQL Source Length        21
Rows Returned            0
First Row Returned Time  -1
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    0
Min. Execute Time        0.000000 secs
Max. Execute Time        0.000000 secs
Avg. Execute Time        0.000000 secs
Stats Collection Type    OPERATOR_STATS

--- SQL operation complete.
>>log;
>>execute s1 ;

D          
-----------

         11
         12
         21
         22

--- 4 row(s) selected.
>>log ;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;

--- SQL operation complete.
>>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_491_S1 PERTABLE;
Qid                      MXID11000011701212378219753251307000000000206U3333300_491_S1
Compile Start Time       2017/11/23 17:57:44.184561
Compile End Time         2017/11/23 17:57:44.630325
Compile Elapsed Time                 0:00:00.445764
Execute Start Time       2017/11/23 17:57:51.904186
Execute End Time         2017/11/23 17:57:51.929161
Execute Elapsed Time                 0:00:00.024975
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           1
Transaction Id           -1
Source String            select d from tstat ;
SQL Source Length        21
Rows Returned            4
First Row Returned Time  2017/11/23 17:57:51.927636
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.024975 secs
Max. Execute Time        0.024975 secs
Avg. Execute Time        0.024975 secs
Stats Collection Type    OPERATOR_STATS
SQL Process Busy Time    2,653
UDR Process Busy Time    0
SQL Space Allocated      32 KB
SQL Space Used           5 KB
SQL Heap Allocated       40 KB
SQL Heap Used            36 KB
SQL Heap WM              43 KB
Processes Created        0
Process Create Time      0
Request Message Count    0
Request Message Bytes    0
Reply Message Count      0
Reply Message Bytes      0
BMO Space Buffer Size    0
BMO Space Buffer Count   0
BMO Interim Row Count    0
Scr. Overflow Mode       UNKNOWN
Scr. File Count          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
  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs        SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
    1         1 TRAFODION.SCH.TSTATI
              0                   4            100                   4                   2                   0              20,698              20,698

--- SQL operation complete.
>>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_491_S1 PERTABLE;
Qid                      MXID11000011701212378219753251307000000000206U3333300_491_S1
Compile Start Time       2017/11/23 17:57:44.184561
Compile End Time         2017/11/23 17:57:44.630325
Compile Elapsed Time                 0:00:00.445764
Execute Start Time       2017/11/23 17:57:51.904186
Execute End Time         2017/11/23 17:57:51.929161
Execute Elapsed Time                 0:00:00.024975
State                    CLOSE
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           1
Transaction Id           -1
Source String            select d from tstat ;
SQL Source Length        21
Rows Returned            4
First Row Returned Time  2017/11/23 17:57:51.927636
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.024975 secs
Max. Execute Time        0.024975 secs
Avg. Execute Time        0.024975 secs
Stats Collection Type    OPERATOR_STATS
SQL Process Busy Time    2,653
UDR Process Busy Time    0
SQL Space Allocated      32 KB
SQL Space Used           5 KB
SQL Heap Allocated       40 KB
SQL Heap Used            36 KB
SQL Heap WM              43 KB
Processes Created        0
Process Create Time      0
Request Message Count    0
Request Message Bytes    0
Reply Message Count      0
Reply Message Bytes      0
BMO Space Buffer Size    0
BMO Space Buffer Count   0
BMO Interim Row Count    0
Scr. Overflow Mode       UNKNOWN
Scr. File Count          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
  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs        SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
    1         1 TRAFODION.SCH.TSTATI
              0                   4            100                   4                   2                   0              20,698              20,698

--- SQL operation complete.
>>log;
>>
>>-- EXECDirect test to check if QID current is proper
>>select * from tstat ;

A      B       C     D          
-----  ------  ----  -----------

MMMM       21  MMMM           21
XXXXX      22  XXXX           22
AAAA       11  AAAA           11
BBBB       12  BBBB           12

--- 4 row(s) selected.
>>get statistics for qid current ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_515___SQLCI_DML_LAST__
Compile Start Time       2017/11/23 17:57:55.581199
Compile End Time         2017/11/23 17:57:55.609168
Compile Elapsed Time                 0:00:00.027969
Execute Start Time       2017/11/23 17:57:55.609379
Execute End Time         2017/11/23 17:57:55.619162
Execute Elapsed Time                 0:00:00.009783
State                    DEALLOCATED
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           1
Transaction Id           -1
Source String            select * from tstat ;
SQL Source Length        21
Rows Returned            4
First Row Returned Time  2017/11/23 17:57:55.617820
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.009783 secs
Max. Execute Time        0.009783 secs
Avg. Execute Time        0.009783 secs
Stats Collection Type    OPERATOR_STATS
SQL Process Busy Time    2,139
UDR Process Busy Time    0
SQL Space Allocated      32 KB
SQL Space Used           5 KB
SQL Heap Allocated       40 KB
SQL Heap Used            36 KB
SQL Heap WM              43 KB
Processes Created        0
Process Create Time      0
Request Message Count    0
Request Message Bytes    0
Reply Message Count      0
Reply Message Bytes      0
BMO Space Buffer Size    0
BMO Space Buffer Count   0
BMO Interim Row Count    0
Scr. Overflow Mode       UNKNOWN
Scr. File Count          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
  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs        SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
    1         1 TRAFODION.SCH.TSTAT
              0                   4            100                   4                   2                   0               6,627               6,627

--- SQL operation complete.
>>
>>-- Compare QID CURRENT to QID <qid>
>>control query default detailed_statistics 'ACCUMULATED' ;

--- SQL operation complete.
>>obey TESTRTS(compare_current_qid);
>>prepare s1 from select count(*) from
+>tstat A, tstat B, tstat C, tstat D;

--- SQL command prepared.
>>
>>execute s1;

(EXPR)              
--------------------

                 256

--- 1 row(s) selected.
>>
>>log;
>>sh grep "^QID is " QID_TEMP | cut -c 8- | sed "s/^/get statistics for qid /g" | sed "s/$/;/g"  > STATS_CMD_QID;
>>log;
1c1,2
< >>get statistics for qid current;
---
> >>obey STATS_CMD_QID;
> >>get statistics for qid MXID11000011701212378219753251307000000000206U3333300_518_S1;
21c22
< Number of Cpus           1
---
> Number of Cpus           2
38a40,50
>    Id       DOP Table Name
>   EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs        SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
>     1         0 TRAFODION.SCH.TSTATI
>               0                   0            100                   0                   0                   0                   0                   0
>     6         0 TRAFODION.SCH.TSTATI
>               0                   0            100                   0                   0                   0                   0                   0
>    11         0 TRAFODION.SCH.TSTATI
>               0                   0            100                   0                   0                   0                   0                   0
>    16         0 TRAFODION.SCH.TSTATI
>               0                   0            100                   0                   0                   0                   0                   0
> 
>>
>>
>>control query default detailed_statistics 'PERTABLE' ;

--- SQL operation complete.
>>obey TESTRTS(compare_current_qid);
>>prepare s1 from select count(*) from
+>tstat A, tstat B, tstat C, tstat D;

--- SQL command prepared.
>>
>>execute s1;

(EXPR)              
--------------------

                 256

--- 1 row(s) selected.
>>
>>log;
>>sh grep "^QID is " QID_TEMP | cut -c 8- | sed "s/^/get statistics for qid /g" | sed "s/$/;/g"  > STATS_CMD_QID;
>>log;
1c1,2
< >>get statistics for qid current;
---
> >>obey STATS_CMD_QID;
> >>get statistics for qid MXID11000011701212378219753251307000000000206U3333300_522_S1;
21c22
< Number of Cpus           1
---
> Number of Cpus           2
>>
>>
>>control query default detailed_statistics 'system' ;

--- SQL operation complete.
>>obey TESTRTS(compare_current_qid);
>>prepare s1 from select count(*) from
+>tstat A, tstat B, tstat C, tstat D;

--- SQL command prepared.
>>
>>execute s1;

(EXPR)              
--------------------

                 256

--- 1 row(s) selected.
>>
>>log;
>>sh grep "^QID is " QID_TEMP | cut -c 8- | sed "s/^/get statistics for qid /g" | sed "s/$/;/g"  > STATS_CMD_QID;
>>log;
1c1,2
< >>get statistics for qid current;
---
> >>obey STATS_CMD_QID;
> >>get statistics for qid MXID11000011701212378219753251307000000000206U3333300_526_S1;
21c22
< Number of Cpus           1
---
> Number of Cpus           2
>>
>>
>>obey TESTRTS(exeindp2_stats);

*** ERROR[15014] Section exeindp2_stats was not found in file TESTRTS.

>>--Negative tests using STATISTICS stored procedure
>>select * from table (statistics(null, 'QID='));

--- 0 row(s) selected.
>>select * from table (statistics(null, 'QID=mxid'));

*** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query Id mxid.

--- 0 row(s) selected.
>>select * from table (statistics(null, 'QID=MXID01001'));

*** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query Id MXID01001.

--- 0 row(s) selected.
>>select * from table (statistics(null, 'CPU='));

--- 0 row(s) selected.
>>select * from table (statistics(null, 'PID='));

*** ERROR[8920] Invalid CPU or PID passed in. Unable to retrieve Runtime Statistics.

--- 0 row(s) selected.
>>select * from table (statistics(null, 'SYSTEM='));

--- 0 row(s) selected.
>>select * from table (statistics(null, 'MERGE=2'));

--- 0 row(s) selected.
>>
>>--Negative tests using GET STATISTICS command
>>get statistics for qid ;

*** ERROR[15001] A syntax error occurred at or before: 
get statistics for qid ;
                       ^ (24 characters from start of SQL statement)

*** ERROR[8822] The statement was not prepared.

>>get statistics for qid mxid ;

*** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query Id MXID.

--- SQL operation failed with errors.
>>get statistics for qid "mxid" ;

*** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query Id mxid.

--- SQL operation failed with errors.
>>get statistics for qid mxid01001 ;

*** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query Id MXID01001.

--- SQL operation failed with errors.
>>get statistics for qid mxid0100202 ;

*** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query Id MXID0100202.

--- SQL operation failed with errors.
>>get statistics for qid mxid010010A0788 ;

*** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query Id MXID010010A0788.

--- SQL operation failed with errors.
>>get statistics for qid mxid01002020880 ;

*** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query Id MXID01002020880.

--- SQL operation failed with errors.
>>get statistics for cpu ;

*** ERROR[15001] A syntax error occurred at or before: 
get statistics for cpu ;
                       ^ (24 characters from start of SQL statement)

*** ERROR[8822] The statement was not prepared.

>>get statistics for cpu a;

*** ERROR[15001] A syntax error occurred at or before: 
get statistics for cpu a;
                       ^ (24 characters from start of SQL statement)

*** ERROR[8822] The statement was not prepared.

>>get statistics for cpu "A";

*** ERROR[15001] A syntax error occurred at or before: 
get statistics for cpu "A";
                         ^ (26 characters from start of SQL statement)

*** ERROR[8822] The statement was not prepared.

>>get statistics for pid ;

*** ERROR[15001] A syntax error occurred at or before: 
get statistics for pid ;
                       ^ (24 characters from start of SQL statement)

*** ERROR[8822] The statement was not prepared.

>>get statistics for pid a,a ;

*** ERROR[15001] A syntax error occurred at or before: 
get statistics for pid a,a ;
                       ^ (24 characters from start of SQL statement)

*** ERROR[8822] The statement was not prepared.

>>get statistics for pid a;

*** ERROR[15001] A syntax error occurred at or before: 
get statistics for pid a;
                       ^ (24 characters from start of SQL statement)

*** ERROR[8822] The statement was not prepared.

>>
>>-- Test to determine if invalid token is taken as stmt name
>>select * from table (statistics(null, 'AAA='));

--- 0 row(s) selected.
>>
>>obey TESTRTS(esp_idle_timeout);
>>get process statistics for current ;

Node Id:                      0
PID                           11701
Start Time                    2017/11/23 17:55:53.251307
EXE Memory Allocated          20 MB
EXE Memory Used High WM       98 MB
EXE Memory Used               20 MB
IPC Memory Allocated          1 MB
IPC Memory Used High WM       1 MB
IPC Memory Used               1 MB
Static Stmt Count             0
Dynamic Stmt Count            3
Open Stmt Count               0
Reclaimable Stmt Count        0
Reclaimed Stmt Count          0
Total ESPs Started            2
Total ESPs Startup Completed  2
Total ESPs Error in Startup   0
Total ESPs Deleted            0
Num ESPs In Use               2
Num ESPs Free                 0
Recent Qid                    MXID11000011701212378219753251307000000000206U3333300_526_S1

--- SQL operation complete.
>>set session default esp_idle_timeout '60' ;

--- SQL operation complete.
>>cqd esp_idle_timeout '60' ;

--- SQL operation complete.
>>control query shape esp_exchange(hash_groupby(esp_exchange(scan)));

--- SQL operation complete.
>>select distinct d from tstat ;

D          
-----------

         11
         21
         22
         12

--- 4 row(s) selected.
>>get process statistics for current ;

Node Id:                      0
PID                           11701
Start Time                    2017/11/23 17:55:53.251307
EXE Memory Allocated          20 MB
EXE Memory Used High WM       98 MB
EXE Memory Used               20 MB
IPC Memory Allocated          1 MB
IPC Memory Used High WM       1 MB
IPC Memory Used               1 MB
Static Stmt Count             0
Dynamic Stmt Count            3
Open Stmt Count               0
Reclaimable Stmt Count        0
Reclaimed Stmt Count          0
Total ESPs Started            4
Total ESPs Startup Completed  4
Total ESPs Error in Startup   0
Total ESPs Deleted            0
Num ESPs In Use               2
Num ESPs Free                 2
Recent Qid                    MXID11000011701212378219753251307000000000206U3333300_554___SQLCI_DML_LAST__

--- SQL operation complete.
>>sh sleep 70;
>>select distinct d from tstat ;

D          
-----------

         12
         11
         21
         22

--- 4 row(s) selected.
>>get process statistics for current ;

Node Id:                      0
PID                           11701
Start Time                    2017/11/23 17:55:53.251307
EXE Memory Allocated          20 MB
EXE Memory Used High WM       98 MB
EXE Memory Used               20 MB
IPC Memory Allocated          1 MB
IPC Memory Used High WM       1 MB
IPC Memory Used               1 MB
Static Stmt Count             0
Dynamic Stmt Count            3
Open Stmt Count               0
Reclaimable Stmt Count        0
Reclaimed Stmt Count          0
Total ESPs Started            6
Total ESPs Startup Completed  6
Total ESPs Error in Startup   0
Total ESPs Deleted            2
Num ESPs In Use               2
Num ESPs Free                 2
Recent Qid                    MXID11000011701212378219753251307000000000206U3333300_556___SQLCI_DML_LAST__

--- SQL operation complete.
>>control query shape cut;

--- SQL operation complete.
>>
>>obey TESTRTS(hive_tests);
>>select [last 0] * from hive.hive.store;

--- 0 row(s) selected.
>>get statistics for qid current ;
Qid                      MXID11000011701212378219753251307000000000206U3333300_559___SQLCI_DML_LAST__
Compile Start Time       2017/11/23 17:59:15.477494
Compile End Time         2017/11/23 17:59:22.839987
Compile Elapsed Time                 0:00:07.362493
Execute Start Time       2017/11/23 17:59:22.841372
Execute End Time         2017/11/23 17:59:22.904988
Execute Elapsed Time                 0:00:00.063616
State                    DEALLOCATED
Rows Affected            0
SQL Error Code           100
Stats Error Code         0
Query Type               SQL_SELECT_NON_UNIQUE
Sub Query Type           SQL_STMT_NA
Estimated Accessed Rows  0
Estimated Used Rows      0
Parent Qid               NONE
Parent Query System      NONE
Child Qid                NONE
Number of SQL Processes  1
Number of Cpus           1
Transaction Id           -1
Source String            select [last 0] * from hive.hive.store;
SQL Source Length        39
Rows Returned            0
First Row Returned Time  -1
Last Error before AQR    0
Number of AQR retries    0
Delay before AQR         0
No. of times reclaimed   0
Cancel Time              -1
Last Suspend Time        -1
No. of times executed    1
Min. Execute Time        0.063616 secs
Max. Execute Time        0.063616 secs
Avg. Execute Time        0.063616 secs
Stats Collection Type    OPERATOR_STATS
SQL Process Busy Time    6,473
UDR Process Busy Time    0
SQL Space Allocated      72,584 KB
SQL Space Used           72,577 KB
SQL Heap Allocated       139,169 KB
SQL Heap Used            139,152 KB
SQL Heap WM              139,152 KB
Processes Created        0
Process Create Time      0
Request Message Count    0
Request Message Bytes    0
Reply Message Count      0
Reply Message Bytes      0
BMO Space Buffer Size    0
BMO Space Buffer Count   0
BMO Interim Row Count    0
Scr. Overflow Mode       UNKNOWN
Scr. File Count          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
  EstRowsAccess       ActRowsAccess    EstRowsUsed         ActRowsUsed              SE_IOs        SE_IO_KBytes       SE_IO_SumTime       SE_IO_MaxTime
    1         1 HIVE.HIVE.STORE
              0                  12              0                  12                   1                   3               2,000               2,000

--- SQL operation complete.
>>
>>obey TESTRTS(clean_up);
>>drop table tstat;

--- SQL operation complete.
>>
>>log ;
