Forgot your password?
Document Actions
How to find out which log files are required for a table space rollforward operation
use the db2logsForRfwd command to find out which log files are required for a table space rollforward operation
Command syntax
>>db2logsForRfwd---path--+-------+-----------------------------><
'- -all-'
Command parameters
path
Full path and name of the DB2TSCHG.HIS file.
-all
Displays more detailed information.
Example:
db2logsForRfwd /home/db2inst1/db2inst1/NODE0000/SQL00004/DB2TSCHG.HIS
Output:
----------------------------------------------------------
Log file number :S0000000.LOG
First New Record LSN : 000003A9800C
Log Extent Tail LSN : 000003E80000
Backup End Time Stamp : 496ddd79
Flags : 107
pID : 1230953696 2009-01-03-03.34.56.000000 GMT
cID : 1231936768 2009-01-14-12.39.28.000000 GMT
Tablespace ID : 2
----------------------------------------------------------
Log file number : S0000001.LOG
First New Record LSN : 000003E8000C
Log Extent Tail LSN : 000004268000
Backup End Time Stamp : 0
Flags : 107
pID : 1231936768 2009-01-14-12.39.28.000000 GMT
cID : 1231936769 2009-01-14-12.39.29.000000 GMT
Tablespace ID : 0 4 -al
Hacker Rangers - Gamification for CyberSecurity