problem with load command while online backups running

anjan.k · Post by **anjan.k** » Sat Oct 13, 2007 3:58 pm

Hi All,

While the online backups are running the load command is not working,

but the job has to perform daily...when ever weekend online backups are running...this load command will not be working .....the job is running long time and finally it is abending...

How could we fix this problem as the job should run daily or even week end also...

the command which i am giving is

db2 "load from /dev/null of del replace into TEDCSTG.CR_LDGR_ACCT_PTR_W nonrecoverable without prompting"

please give me your valuable suggestions....

thanks in Advance

ray.wurlod · Post by **ray.wurlod** » Sat Oct 13, 2007 5:36 pm

Welcome aboard.

Check with your DBA how much of the database is quiesced or locked when backups are running.

I think you will have your explanation.

anjan.k · Post by **anjan.k** » Sat Oct 13, 2007 7:20 pm

thanks ray ,

giving such good suggestion...

How I should proceed further after getting information from DBA to fix this problem?

thanks in Advance..

ray.wurlod · Post by **ray.wurlod** » Sun Oct 14, 2007 8:31 am

You ask the DataBase Administrator. Some kind of inducement is often good, too.