We carry out Hot back-up of our databases i.e. our processes will be running at the back end and database back-up at the same time.
Just i want to know that how this process will be carried out. What kind of lock is applied on DB objects in such back-ups? When I try to insert, delete, update on table whose back-up is going on, my query will be blocked. Can we collect stats on tables whose back-up is going on at the back-end?
And also please let me know where can i get more information of such things for future reference.
what activity is allowed during an Online Backup depends on your release.
An overview is found in Chapter 10: Archiving, Restoring, and Recovering DataT of the "Databasa Administration" and all details are in the "Teradata Archive/Recovery Utility Reference" manual.