Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 05 Mar 2008 @ 14:50:35 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: DBQL - Query Id in Objects table but not in QueryLog
From:   Woodrow, Steven

You don't have to restart the system to force DBQL to flush.

If you turn DBQL off and back on for a user, that will force DBQL to flush.

What we typically do is have DBQL turned on for SYSTEMFE. Then, we just shut it off and back on to flush if we don't want to wait.

Note: Prior to V2R6, DBQL would only write out after the cache filled up or when an End Logging statement was executed. With V2R6, there is a DBSControl Parameter that allows you to specify how often DBQL should be written out. I believe the default is 10 minutes.

Steve Woodrow
Teradata PS Americas
Performance & Workload Management COE

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020