Various changes, details listed below. -- fixed error msg 1429 text -- added code to set objectUID & owner for metadata, histogram and sequence tables during creation of metadata structs for these objects. -- removed previously added code in binder that computed objectUID for sequence. -- Updated method lookupObjectUid to call an existing method to get objectuid. -- removed obsolete code for reorg, replicate and load
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