Linux RHEL 5.5 - DB2 V8.2 FP14

I am trying to automate a process that needs to restore the production database from the latest backup that is in a directory with previous backups. There is more that 1 backup file in the directory for the same database but I want to restore the latest.

Is there a DB2 command to do this ?

Thanks

There is no such command, but you can find the latest backup timestamp by selecting from the table function ADMIN_LIST_HIST(), then use the timestamp to invoke RESTORE with the TAKEN AT clause.

Thanks for the suggestion. I got the taken at value but having problems placing in the restore command.................

Got it...................

db2 -x "select 'db2 restore db TESTDB from /home/db2server01/backup/ taken at', (SELECT START_TIME FROM TABLE(SYSPROC.ADMIN_LIST_HIST()) AS backup_time where OPERATION='B' Order by START_TIME desc fetch first 1 rows only), 'replace existing;' FROM SYSIBM.SYSDUMMY1"