请问修改DB2 9.7的归档日志设置后是否即时生效

请问修改DB2 9.7的归档日志设置后是否即时生效？或是需要重启数据库？

本地环境 AIX 6.1+DB2 9.7

修改DB2为归档方式：

KPRE01:db2pre 4> db2 update db cfg for PRE using LOGRETAIN on

DB20000I  The UPDATE DATABASE CONFIGURATION command completed successfully.

KPRE01:db2pre 6> db2 update db cfg for PRE using logarchmeth1 VENDOR:/usr/lib/libnsrdb2.o logarchopt1 @/nsr/apps/config/nmda_db2_tlogs.cfg

DB20000I  The UPDATE DATABASE CONFIGURATION command completed successfully.

修改完成后查看配置：

KPRE01:db2pre 1> db2 get db cfg for PRE|grep -i log

Log retain for recovery status                          = NO

User exit for logging status                            = NO

Catalog cache size (4KB)              (CATALOGCACHE_SZ) = 2560

Log buffer size (4KB)                        (LOGBUFSZ) = 1024

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

Number of primary log files                (LOGPRIMARY) = 20

Number of secondary log files               (LOGSECOND) = 40

Changed path to log files                  (NEWLOGPATH) =

Path to log files                                       = /db2/PRE/log_dir/NODE0000/

Overflow log path                     (OVERFLOWLOGPATH) =

Mirror log path                         (MIRRORLOGPATH) =

First active log file                                   =

Block log on disk full                (BLK_LOG_DSK_FUL) = YES

Block non logged operations            (BLOCKNONLOGGED) = NO

Percent max primary log space by transaction  (MAX_LOG) = 0

Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0

Percent log file reclaimed before soft chckpt (SOFTMAX) = 300

Log retain for recovery enabled             (LOGRETAIN) = RECOVERY

User exit for logging enabled                (USEREXIT) = OFF

HADR log write synchronization mode     (HADR_SYNCMODE) = NEARSYNC

First log archive method                 (LOGARCHMETH1) = VENDOR:/usr/lib/libnsrdb2.o

Options for logarchmeth1                  (LOGARCHOPT1) = @/nsr/apps/config/nmda_db2_tlogs.cfg

Second log archive method                (LOGARCHMETH2) = OFF

Options for logarchmeth2                  (LOGARCHOPT2) =

Failover log archive path                (FAILARCHPATH) =

Number of log archive retries on error   (NUMARCHRETRY) = 5

Log archive retry Delay (secs)         (ARCHRETRYDELAY) = 20

Log pages during index build            (LOGINDEXBUILD) = OFF

KPRE01:db2pre 2>