When system write encounters backup read lock

Database
N/A

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
N/A

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 ...

N/A

Re: When system write encounters backup read lock

Hi dnoeth,

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

Bo