DB2 9.5 on Windows. I periodically restore our Production Datamart Database to a Development area and now I would like ot do this on a scheduled (once a week basis) and automate it. My problem is trying to firgure out how to do the restore when the backup filename changes everytime??? I was planning on using the task center and scheduling a one-off backup that I would use for my restore.. BUt I'm not sure how to write the restore command since the backup filename changes everytime/??? anyone have any ideas??

You do not need to know the backup file name - only the time of the backup. This can be obtained from the output of list history command or the db_history administrative view.

If you have only one backup on a specific date, db2 will be able to find the backup for you even if you specify only the date in the TAKEN AT part of the command.

Not sure about your requirements, but you may be able to use RECOVER database command.

HTH

Sathyaram

so if I only need to know the backup time.. how would I code that in the recover or backup command..

db2 restore db sample from D:\DB2Backups taken at 20010320122644 would be my command.. but the 'taken at 2001.....' would change every week...

need to scheduled it so that it runs in the wee hours of the morning once a week?

If you create a separate directory which only contains one backup file for a particular database, you can omit the "taken at" clause. I have done this by using a script that always moves the existing backup to an archive backup directory right before taking the latest backup, so that my directory only contains one backup per database, and then I can automate the restore.

I didn't try that!!! I'll give it a try! Thanks so much

You can obtain the backup timestamp using db_history admin view ... of course, it needs OS Scripting. Marcus suggestion will make it straight forward.