5、检查db2diag.log,查看是否有日志归档,你会看到类似下面的内容:
|
2004-10-26-19.42.13.373000+480 I14935459H319 LEVEL: Warning PID : 1872 TID : 1884 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 FUNCTION: DB2 UDB, data protection, sqlpghck, probe:1390 MESSAGE : ExtNum 1, state 401, baselsn 0000000000FA0000 nextlsn 0000000000FA21E 2004-10-26-19.42.13.403000+480 I14935780H418 LEVEL: Warning PID : 1872 TID : 1516 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 FUNCTION: DB2 UDB, data protection, sqlpgArchiveLogFile, probe:3180 MESSAGE : Successfully archived log file S0000001.LOG to D:\TEMP\logarc1\DB2\SAMPLE\NODE0000\C0000002\ from C:\DB2\NODE0000\SQL00001\SQLOGDIR\. 2004-10-26-19.42.13.573000+480 I14936200H316 LEVEL: Warning PID : 1872 TID : 196 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 FUNCTION: DB2 UDB, data protection, sqlpgLoggrInitDelOldLog, probe:1440 MESSAGE : Cleaning up logs from RenameArchNum 1 to delLimit 2 |
6、检查一下我们的归档日志,就会看到已经归档的文件:
|
D:\Temp\logarc1\DB2\SAMPLE\NODE0000\C0000002 的目录 2004-10-26 07:43 下午 2004-10-26 07:43 下午 2004-10-26 07:42 下午 20,480 S0000001.LOG 2004-10-26 07:43 下午 4,104,192 S0000002.LOG 2004-10-26 07:43 下午 4,104,192 S0000003.LOG 2004-10-26 07:43 下午 4,104,192 S0000004.LOG |
关于使用TSM服务器和第三方厂商备份软件配置归档日志的方法,请参见DB2 UDB V8.2 信息中心:
http://publib.boulder.ibm.com/infocenter/db2help/index.jsp
