DB2日志的管理

DB重要的日志概念 $ db2 get db cfg for sample Log file size (4KB) (LOGFILSIZ) = 1000 Number of primary log files (LOGPR

关于归档日志模式设置

如果 "USEREXIT" 没有启用,可将 logarchmeth1 或 logarchmeth2 设置为 OFF 以外的值,使用数据库可以进行前滚恢复。

如果更新 userexit或 logretain 配置参数，，将自动更新 logarchmeth1，

反之亦然。然而，如果您正在使用 userexit 或 logretain, 必须将 logarchmeth2 设置为 OFF。

另外,db2 8.2里面还提供了FAILARCHPATH(故障转移日志归档路径)

[db2inst1@O11g64 bin]$ db2level

DB21085I Instance "db2inst1" uses "64" bits and DB2 code release "SQL09013"

with level identifier "01040107".

Informational tokens are "DB2 v9.1.0.3", "s070719", "MI00203", and Fix Pack

"3".

Product is installed at "/u01/db2v9".

[db2inst1@O11g64 bin]$ mkdir -p /home/db2inst1/db2inst1/mylog

[db2inst1@O11g64 bin]$ db2 "update db cfg for xcldb using logfilsiz 8 LOGARCHMETH1 disk:/home/db2inst1/db2inst1/mylog/"

[db2inst1@O11g64 bin]$ mkdir -p /home/db2inst1/db2inst1/cold

-- db2 rollforward db xcldb query status -- not pending

[db2inst1@O11g64 bin]$ db2 backup db xcldb to /home/db2inst1/db2inst1/cold

Backup successful. The timestamp for this backup image is : 20131213225508

First log archive method (LOGARCHMETH1) = DISK:/home/db2inst1/db2inst1/mylog/

[db2inst1@O11g64 bin]$ db2 get db cfg for xcldb|grep "LOGARCHMETH1"

First log archive method (LOGARCHMETH1) = DISK:/home/db2inst1/db2inst1/mylog/

[db2inst1@O11g64 bin]$ db2 get db cfg for xcldb|grep "LOGFILSIZ"

Log file size (4KB) (LOGFILSIZ) = 8

[db2inst1@O11g64 bin]$

[db2inst1@O11g64 bin]$ db2 archive log for db xcldb

DB20000I The ARCHIVE LOG command completed successfully.

[db2inst1@O11g64 bin]$ ls -lrt /home/db2inst1/db2inst1/mylog/db2inst1/XCLDB/NODE0000/C0000000

total 24

去日租网站系统

去日租程序是一款具有强大的功能的基于.NET+SQL2000+AJAX构架的房屋出租管理系统。 日租网站管理系统,采用ASP.NET2.0语言开发，它集成租房模块、文章模块、订单模块、邮箱短信模块、用户模板、SEO优化模块、房间模块、支付模块等多项强大功能。系统有多年经验的高级工程师采用三层架构开发，页面代码全部采用DIV+CSS，完全符合SEO标准，有利于搜索引擎关键排名优化。日租网站

下载

-rw-r-----. 1 db2inst1 db2iadm1 12288 Dec 13 22:53 S0000000.LOG

-rw-r-----. 1 db2inst1 db2iadm1 12288 Dec 13 23:07 S0000001.LOG

[db2inst1@O11g64 bin]$ db2level

DB21085I Instance "db2inst1" uses "64" bits and DB2 code release "SQL09013"

with level identifier "01040107".

Informational tokens are "DB2 v9.1.0.3", "s070719", "MI00203", and Fix Pack

"3".

Product is installed at "/u01/db2v9".

[db2inst1@O11g64 bin]$ mkdir -p /home/db2inst1/db2inst1/mylog

[db2inst1@O11g64 bin]$ db2 "update db cfg for xcldb using logfilsiz 8 LOGARCHMETH1 disk:/home/db2inst1/db2inst1/mylog/"

[db2inst1@O11g64 bin]$ mkdir -p /home/db2inst1/db2inst1/cold

-- db2 rollforward db xcldb query status -- not pending

[db2inst1@O11g64 bin]$ db2 backup db xcldb to /home/db2inst1/db2inst1/cold

Backup successful. The timestamp for this backup image is : 20131213225508

First log archive method (LOGARCHMETH1) = DISK:/home/db2inst1/db2inst1/mylog/

[db2inst1@O11g64 bin]$ db2 get db cfg for xcldb|grep "LOGARCHMETH1"

First log archive method (LOGARCHMETH1) = DISK:/home/db2inst1/db2inst1/mylog/

[db2inst1@O11g64 bin]$ db2 get db cfg for xcldb|grep "LOGFILSIZ"

Log file size (4KB) (LOGFILSIZ) = 8

[db2inst1@O11g64 bin]$

[db2inst1@O11g64 bin]$ db2 archive log for db xcldb

DB20000I The ARCHIVE LOG command completed successfully.

[db2inst1@O11g64 bin]$ ls -lrt /home/db2inst1/db2inst1/mylog/db2inst1/XCLDB/NODE0000/C0000000

total 24

-rw-r-----. 1 db2inst1 db2iadm1 12288 Dec 13 22:53 S0000000.LOG

-rw-r-----. 1 db2inst1 db2iadm1 12288 Dec 13 23:07 S0000001.LOG