We are using the DSA for taking our backups. We have a backup that has some components at DB level and some components are table level. I wanted to know about the locks taken by DSA during backup.
I tried to look into the dsa user manual, but coudnt get the answer. IS tehre a better place to get such documentation?
DSA places a HUT READ Lock during backups.
When backup is at DB level,all the objects in that database will be locked for the entire duration of backup.
When backup is at table level then DSA will place HUT locks on all the tables listed in job definition in the dictionary phase itself.
For table level it locks all objects at the start and releases lock as soon as a table is done.