Hi,

If I give the db2 restore command, then I get the following message...

SQL2539W Warning! Restoring to an existing database that is the same as the backup image database. The database files will be deleted.
Do you want to continue ? (y/n)

We are trying to put this command as a part of an automatic script that runs early morning. Can you think of anyway we can avoid any manual intervention to press 'y' to continue with the restore? thanks!

Are you using the "WITHOUT PROMPTING" clause?

Andy

Thanks for the reply.. I also found the REPLACE EXISTING option...that should also work.