 |
 |
Archives of the TeradataForum
Message Posted: Thu, 02 Oct 2003 @ 18:04:33 GMT
| Subj: | | Re: Database Query Log (DBQL) |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Thursday, October 02, 2003 09:58 -->
Thanks everyone for your insights on DBQL thus far.
Our site has V2R5.0.1 in development, and I have done some experimenting with query logging. My question is, can we control when the
DBQL buffers are written to the tables? If so, how? And if not, can someone address how frequently the tables are written to?
So far, when starting and stopping query logging thru Teradata Administrator, I haven't yet had any problems seeing rows written to the
DBQL tables for queries I have submitted, providing that I turn off logging before attempting to look at the logs (the development system is
currently not being used very much, so I don't know how frequently the system would flush the buffers by itself). However, an NCR person
told me that there have been issues of not being able to see rows in the table - I don't know if he meant that they don't get written at
all, or just not within an expected period of time.
I did open an incident earlier regarding query submission/response timestamps in one of the DBQL tables - I was seeing that the hour of
day written to the tables was incorrect for the start time, first and last step times, and last response time. A person from GSC responded
that this bug is corrected in V2R5.0.2 as a part of DR 82429.
| |
