Archives of the TeradataForum

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

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

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>>