Unsolved
This post is more than 5 years old
18 Posts
0
1118
May 25th, 2011 09:00
Failed to rollforward DB2 database after restore
Brother,
1. Networker Server 7.6 (Windows) is connected to HP StorageWorks MSL4048 through FC.
2. A cluster of two DB2 nodes (DB2 Windows 8.1.13) are installed with Networker client 7.6 and NMDB2 2.1.
The problem is that it failed to rollforward DB2 database after db2 database restore. I think that the main reason is transaction logs are not backed up before. How to verify and troubleshoot transaction log backup?
The nmdb2 configuration file is as follows:
DB2_NODE_NAME=DB2
DB2_USR=db2admin
NSR_DB2_BACKUP_INFO=yes
DB2PATH=D:\IBM\SQLLIB
DB2_VENDOR_LIB_PATH=c:\program files\Legato\nsr\bin\libnsrdb2.dll
DB2_OPTIONS=DB2BACKUP_ONLINE,DB2BACKUP_INCLUDE_LOGS
NSR_SERVER=nwbackup
NSR_CLIENT=wiepd03cls.dp.epd.local
NSR_DEBUG_LEVEL=9
NSR_DEBUG_FILE=c:\program files\Legato\nsr\applogs\db2.log
NSR_LIBNSRDB2_DEBUG_LEVEL=9
NSR_LIBNSRDB2_DEBUG_FILE=c:\program files\Legato\nsr\applogs\db2sql.log
NSR_DB2SV_DEBUG_LEVEL=9
NSR_DB2SV_DEBUG_FILE=c:\program files\Legato\nsr\applogs\db2sv.log
DB2_PSWD=????????
Have Brothers any idea?
Thanks,
Mike Tang
No Events found!
ASL-Mike
18 Posts
0
May 25th, 2011 09:00
Update info as below:
Run db2 online backup with logs.
And then restore to the same database instance in different machine.