The parm you want is RECOVER LOGONLY - This is discussed in DB2 administration guide and the utilities manual. The short answer is both DF/DSS, FDR and all the products that do volume backups can easily do volume restores or dataset restores with the one exception of multi-volume datasets - then you need to get the manual out - it is recoverable just not as easy.
Next step is DB2 RECOVER tablespace LOGONLY - DB2 keeps track of starting and ending rba's or LRSN's for updates so it will only read the archive logs required. for the recovery. If the archive logs are in HSM or something, it will recall them and apply the log records. If you have a big DB2 subsystem, this can take a long time to read archive logs. Once this completes, you can REBUILD the indexes and use the table. You should take an image copy at this point since you no longer have a normal recovery point. Mike ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
