Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 24 Feb 2010 @ 20:43:30 GMT


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


Subj:   No SQL captured in DBQL
 
From:   Mark Young

Hi,

I have noticed that on our system there are times where there are entries in the DBQLOGTBL that contain a null for QUERYTEXT. It would seem that anytime there is a syntax error, no SQL is captured, but there appear to be times where both ERRORTEXT and QUERYTEXT are both null and I need to understand why this would be.

It is not due to us not capturing SQL for particular users as there are many SQL statements for the users that are captured. All these anomalies appear to be for mainframe jobs and some appear during backups and also during tpump, so could it be related to these applications?


Cheers,

Mark Young
Teradata DBA



     
  <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: 27 Dec 2016