Archives of the TeradataForum
Message Posted: Wed, 05 Mar 2008 @ 14:50:35 GMT
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
|