1 修改成归档模式 [db2inst1@db210 arc]$ db2 update db cfg for test using LOGARCHMETH1 "DISK:/test/arch" DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully. SQL1363W Database must be deactivated and reactivated before the changes to one or more of the configuration parameters will be effective. 2 关闭数据库 [db2inst1@db210 arc]$ db2 force application all DB20000I The FORCE APPLICATION command completed successfully. DB21024I This command is asynchronous and may not be effective immediately. 3 连接数据库 [db2inst1@db210 arc]$ db2 connect to test Database Connection Information Database server = DB2/LINUXX8664 10.1.0 SQL authorization ID = DB2INST1 Local database alias = TEST 4 参数已经生效 db2 get db cfg for test | grep -i loga First log archive method (LOGARCHMETH1) = DISK:/test/arch/ Archive compression for logarchmeth1 (LOGARCHCOMPR1) = OFF Options for logarchmeth1 (LOGARCHOPT1) = Second log archive method (LOGARCHMETH2) = OFF Archive compression for logarchmeth2 (LOGARCHCOMPR2) = OFF Options for logarchmeth2 (LOGARCHOPT2) =