FLUSH QUERY LOGGING Syntax Elements - Teradata Vantage - Analytics Database

• 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.

For more information, see Teradata Vantage™ - SQL Data Definition Language Detailed Topics, B035-1184.