Hi all,

I have one online full backup(20150705) with logs created on Sunday and 2 incremental backups on Monday and Tuesday (db2 10 , linux)
Now I want to restore Tuesday backup to db_report on report_srv as read_only:

I think I should run five commands as bellow:

[db2inst1@report_srv ~]> db2 restore database db_report from /db2data/BACKUPS taken at 20150705011504 without prompting
[db2inst1@report_srv ~]> db2 rollforward db db_report to end of backup and complete
[db2inst1@report_srv ~]> db2 restore DB db_report INCREMENTAL AUTOMATIC TAKEN AT 20150506011505
[db2inst1@report_srv ~]> db2 restore DB db_report INCREMENTAL AUTOMATIC TAKEN AT 20150507011505
[db2inst1@report_srv ~]> db2 set write suspend for db_report

Please correct me if I my commands is wrong?

Can I run this commends from shell script or cron job to automate this process for next weeks?
I want to keep db_report update by last backup of prod from previous day.

Thanks,
Saber