- flush_option
- Specifies which database query logging or Teradata workload management cache to flush:
- ALL
Perform option ALLDBQL,ALLTDWM and USECOUNT.
ALL is mutually exclusive to all other options.
- ALLDBQL
This is equivalent to DEFAULT,SQL,STEPINFO,OBJECTS, EXPLAIN,XMLPLAN,SUMMARY,LOCK,PARAMINFO,AMPDATA.
ALLDBQL is mutually exclusive to all other DBQL options.
- ALLTDWM
This is equivalent to DEFAULT,SQL,TDWMHISTORY, TDWMEXCEPTION,TDWMEVENT.
ALLTDWM is mutually exclusive to all other TDWM options.
- AMPDATA
The AMPDATA option will help with manually flushing Detailed diagnostics and extended DBQL data including the PE side extended data. To avoid orphaned rows in DBC.DBQLAmpDataTbl and associated views, DBC.DBQLogTbl cache will also get flushed.
Flushes DBC.dbqlampdatatbl (granular, extended AMP, and PE data) and DBC.dbqlogtbl table caches.
Due to the nature of the Extended DBQL cache flushing, there is a small window where some Extended PE data may not be flushed to DBC.DBQLAmpDataTbl upon the first execution of FLUSH QUERY LOGGING WITH AMPDATA. Issue an a second FLUSH QUERY LOGGING WITH AMPDATA statement to guarantee Extended PE data gets flushed to DBC.DBQLAmpDataTbl.
- DEFAULT
Flushes DBC.dbqlogtbl table cache.
- EXPLAIN
Flushes DBC.dbqlexplaintbl table cache.
- LOCK
Flushes DBC.dbqlxmllocktbl table cache.
- OBJECTS
Flushes DBC.dbqlobjtbl table cache.
- PARAMINFO
Flushes DBC.dbqlParamtbl table cache.
- SQL
Flushes DBC.dbqlsqltbl table cache.
- STATUSAGE
Flushes DBC.dbqlxmltbl table cache.
- STEPINFO
Flushes DBC.dbqlsteptbl table cache.
- SUMMARY
Flushes DBC.dbqlsummarytbl table cache.
- TDWMEVENT
Flushes DBC.tdwmeventlog table cache.
- TDWMEXCEPTION
Flushes DBC.tdwmexceptionlog table cache.
- TDWMHISTORY
Flushes DBC.tdwmeventhistory table cache.
- USECOUNT
Flushes DBC.objectusage table cache.
- XMLPLAN
Flushes DBC.dbqlxmltbl table cache.
- ALL