Archives of the TeradataForum

Message Posted: Tue, 26 Jan 2016 @ 13:59:27 GMT

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

I simply apply it on all databases that contain actual tables

     LOCKING ROW FOR ACCESS
     SELECT 'BEGIN QUERY LOGGING WITH USECOUNT ON ' || TRIM(d.databasename) || ';'
     BEGIN_LOGGING
       FROM DBC.tables d
     WHERE d.DatabaseName LIKE 'EFBI_PROD%'

     GROUP BY 1
     ORDER BY 1
     ;

____________________

David Roth
Senior Consultant
Teradata Certified Master
Certified Scrum Master

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