SQL syntax to cancel executing query, phase 2 This check-in causes queries to register with the cancel broker using a nowait Seabed message, and to process the completion of the message by canceling the executing query if the cancel broker so indicates in the message reply. The check-in includes new test cases in the regression test to cancel different types of SELECT queries.
These types of queries do not yet respond to cancel: 1. Queries that are decomposed into child queries, e.g., CREATE INDEX, CREATE TABLE AS, UPDATE STATISTICS, etc; 2. UPDATE and DELETE 3. INSERT queries might work now, but haven't been tested.
Enable RMS monitoring The query execution statistics can now be obtained while the query is running via a) GET STATISTICS FOR QID <qid> b) Using STATISTICS table-valued function c) Using CLI calls – SQL_EXEC_GetStatistics2 and SQL_EXEC_GetStatisticsItems
The statistics can be viewed in accumulated, pertable, progress and operator stats format.
You can also obtain statistics for each fragment instance and process wise statistics for each operator of an active query.
Light-weight SQL Offender (LSO) feature is also enabled. With LSO, you can get 1. Queries offending CPU resource 2. Queries blocked in Trafodion Engine 3. Queries that are not active 4. Queries that haven’t finished but blocked in client 5. Queries offending memory resource
Explain in RMS feature can be enabled by setting the cqd explain_in_rms ‘on’ before compiling a query.
EXPLAIN.. FOR QID <qid> command is now supported. GET PROCESS STATISTICS FOR <pid> is also supported