When system write encounters backup read lock

Database
Fan

When system write encounters backup read lock

We are trying to understand system behaviours for the following scenario.

When an all AMP backup is running for database AAA, a Mload Delete with ET table on database BBB starts.

All AMP backup put a read lock on the dictionary table dbc.errortbls.  When Mload creates ET table, system will  insert a record in dbc.errortbls and should encounter the read lock from backup user.

We are just wondering what is the system's behaviours now? Any help would be much appreciated! 

Tags (1)
2 REPLIES
Junior Contributor

Re: When system write encounters backup read lock

Your scenario is wrong :)

dbc.errortbls is not used by Mload, it records Error Tables for MERGE, i.e. CREATE ERROR TABLE ...

Fan

Re: When system write encounters backup read lock

Hi dnoeth,

Thank you for finding out the wrong senario. Mload doesn't fit here. 

Bo