Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Accesslog type queries from dbql
 
From:   McBride, Michael

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023