Archives of the TeradataForum

Message Posted: Wed, 01 Dec 2004 @ 19:00:01 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Sorry to piggyback on someone else's question, but I am having trouble with establishing DBQL to track all queries, maybe someone can help me?

I have both Access Logging and Query Logging active for the same set of users...Access logging is for each 'select' statement.

ALL my users are created with the same account string = $M&D&I

These are my begin logging statements...

     BEGIN LOGGING on each SELECT by "x";

     BEGIN QUERY LOGGING WITH ALL LIMIT SQLTEXT=0 ON  "x" ACCOUNT = ('$M&D&I');

     BEGIN LOGGING on each SELECT by "y";

     BEGIN QUERY LOGGING WITH ALL LIMIT SQLTEXT=0 ON  "y" ACCOUNT = ('$M&D&I');

I query the access log table (DBC.AccessLog) for any non 'DBC' (dictionary) select query and find two access entries for both user x and user y.

The DBQLogTBL(DBC.QRYLog) has entries for both queries from x but not for y?

Why does x's queries show up and not y's???

mem

	<Prev	Next>		<<First	<Prev	Next>	Last>>