Need a standard approach for deleting DBQLSQLTBL records...

Database
l_k
Enthusiast

Need a standard approach for deleting DBQLSQLTBL records...

Hi,

I want to cleanup 3 months of data from DBQLSQLTBL in DBC database.If i do the deletion
using sql assistant,it is taking time and blocking the DBC and other scheduled jobs getting failed due to DBC got blocked.

Can anyone please tell me the good approach / standard option to delete records from DBQLSQLTBL without blocking / deadlocking the DBC?

Thanks

Lavakumar
2 REPLIES
Enthusiast

Re: Need a standard approach for deleting DBQLSQLTBL records...

You can have a look under the topic 'DBQL Setup and Maintenance' in Chapter 4 of 'Performance Management' (1097)
Enthusiast

Re: Need a standard approach for deleting DBQLSQLTBL records...

This should help for Teradata V2R6 and 12 respectively:
http://downloads.teradata.com/download/database/dbql-setup-and-maintenance-scripts-for-teradata-database-v2r6-x
http://downloads.teradata.com/download/database/dbql-setup-and-maintenance-scripts-for-teradata-database-12-0