Log file for rollforward

r_thirumalai · #1 (**permalink**) 02-24-08, 23:24

Hi,

I am working on DB2 Version 8.1 Fixpack 15. My O/S is Solaris.

Consider I have taken a full online backup of Database which is having 4 tablespaces on Sunday. One of the table space got crashed on Tuesday? How could you check which log file we need to rollfforward the Tablespace which got crashed?

Nambi

guyprzytula · #2 (**permalink**) 02-25-08, 05:34

list history will show the first log needed after the restore of this online backup

anu_chiluka · #3 (**permalink**) 02-26-08, 12:58

ROLLFORWARD database with QUERY STATUS option will also give you the next log file that is expected for recovery.

db2rocks · #4 (**permalink**) 02-26-08, 13:10

Use the include logs option when you backup..That would ease your restore process..That way you need not get the logfiles separate

n_i · #5 (**permalink**) 02-26-08, 15:43

Quote:

Originally Posted by guyprzytula

list history will show the first log needed after the restore of this online backup

and from there you will need all log files until the moment of failure (or until the rollforward point, if it is earlier than that).

Internet Services

Web Development

Digital Marketing

Consumer Tech