Hi ,


I have a load script that runs every hour and loads the files every hour into the tables. This script is running perfectly well except that it is failing whenever backup is being taken.It is failing with a deadlock error.Cant we do a backup and load at the same time.Below are the error messages::

SQL0911N The current transaction has been rolled back because of a deadlock
or timeout. Reason code "68". SQLSTATE=40001

SQL0911N The current transaction has been rolled back because of a deadlock
or timeout. Reason code "2". SQLSTATE=40001

You cannot have any one connected if you are doing OFFLINE backup. If you are doing online backup , it is not recommonded to do loads while running the backup

Its an online backup..So do you say that there is no way that online backup and laod can happen at the same time on a DB. I guess there should be some workaround for that..Any help would be appreciated.

Hi,
If online backup occur at a fixed time, then change schedule to skip load during that time.

Regards