DB2修改活动日志参数的疑惑
DB2数据库活动日志参数修改，比如修改了LOGFILSIZ或者LOGPRIMARY，重新激活数据库，有时需要等待日志文件重新初始化完毕才能完成激活，有时候就直接激活了，日志文件会在后台慢慢初始化，这个有什么规律吗？
1同行回答
搜了下资料，不同版本日志初始化的时机不一样
10.1/9.7 When allocated
1、The database is created
2、A log is moved to a different location (which occurs when the newlogpath parameter is updated)
3、When the database is next started following an increase in the value of this parameter (logprimary), provided that the database is not started as an HADR standby database
4、A log file becomes inactive and a new log file is required to keep at least logprimary logs in the primary log path (the logarchmeth1 or logarchmeth2 parameter must not be set to a value other than OFF).
5、If the logfilsiz parameter has been changed, the log files are re-sized during the next database startup, provided that it is not started as an HADR standby database
10.5 When allocated
1、The database is created
2、A log is moved to a different location (which occurs when the newlogpath parameter is updated)
3、When the first log record is written after the database is next started following an increase in the value of this parameter (logprimary), provided that the database is not started as an HADR standby database
4、A log file becomes inactive and a new log file is required to keep at least logprimary logs in the primary log path (the logarchmeth1 or logarchmeth2 parameter must not be set to a value other than OFF).
5、If the logfilsiz parameter has been changed, the log files are re-sized during the next database startup, provided that it is not started as an HADR standby database
收起