db2归档日志和活动日志的区别
请问几个问题：1.db2归档日志和活动日志的区别？我的理解是 事物没提交的时候，是在活动日志。事物一旦完成，就变为归档日志了，理解对嘛？
2.在rollforward中指定的目录是什么作用？如果需要恢复到删除点，是把归档日志copy到rollforward指定目录还是活动日志copy到rollforward指定目录？overflow log path如何理解？
3.联机备份include logs包含的是什么日志？活动日志or归档日志？
4.归档日志目录下面C000000 C000001 C0000002 等等在什么作用？为什么不断产生这些新目录？
5.请详细介绍个rollforward在前滚哪个日志目录？
2.在rollforward中指定的目录是什么作用？如果需要恢复到删除点，是把归档日志copy到rollforward指定目录还是活动日志copy到rollforward指定目录？overflow log path如何理解？
3.联机备份include logs包含的是什么日志？活动日志or归档日志？
4.归档日志目录下面C000000 C000001 C0000002 等等在什么作用？为什么不断产生这些新目录？
5.请详细介绍个rollforward在前滚哪个日志目录？
3 同行回答
3.
联机备份include logs包含的是什么日志？活动日志or归档日志？
of course, archive logs
4.
>>归档日志目录下面C000000 C000001 C0000002 等等在什么作用？为什么不断产生这些新目录？
C is short for Chain.
http://www-01.ibm.com/support/docview.wss?uid=swg21405527
5.
>>请详细介绍个rollforward在前滚哪个日志目录？
前面2以讲， db2 will do its best to search multiple locations 收起
联机备份include logs包含的是什么日志？活动日志or归档日志？
of course, archive logs
4.
>>归档日志目录下面C000000 C000001 C0000002 等等在什么作用？为什么不断产生这些新目录？
C is short for Chain.
http://www-01.ibm.com/support/docview.wss?uid=swg21405527
5.
>>请详细介绍个rollforward在前滚哪个日志目录？
前面2以讲， db2 will do its best to search multiple locations 收起
2.
>> 在rollforward中指定的目录是什么作用？
where to store the archive logs
>> 如果需要恢复到删除点，是把归档日志copy到rollforward指定目录还是活动日志copy到rollforward指定目录？
of course, they are archive logs
>> overflow log path如何理解？
Beside the standard locations,
"Path to log files"
MIRRORLOGPATH in the db cfg
OVERFLOWLOGPATH in the db cfg
LOGARCHMETH1 in the db cfg
LOGARCHMETH2 in the db cfg
FAILARCHPATH in the db cfg
you tell db2 engine to check "overflow log path" as well for archive logs during rollforward phase. 收起
>> 在rollforward中指定的目录是什么作用？
where to store the archive logs
>> 如果需要恢复到删除点，是把归档日志copy到rollforward指定目录还是活动日志copy到rollforward指定目录？
of course, they are archive logs
>> overflow log path如何理解？
Beside the standard locations,
"Path to log files"
MIRRORLOGPATH in the db cfg
OVERFLOWLOGPATH in the db cfg
LOGARCHMETH1 in the db cfg
LOGARCHMETH2 in the db cfg
FAILARCHPATH in the db cfg
you tell db2 engine to check "overflow log path" as well for archive logs during rollforward phase. 收起
1.
>> 归档日志和活动日志的区别？
顾名思义：
"archive log" means no long actively being used by db and therefore archived somewhere for future use
"active log" means currently still actively being used by db
>> 我的理解是 事物没提交的时候，是在活动日志。事物一旦完成，就变为归档日志了，理解对嘛？
不对
active log can contain both committed and not yet committed transaction records 收起
>> 归档日志和活动日志的区别？
顾名思义：
"archive log" means no long actively being used by db and therefore archived somewhere for future use
"active log" means currently still actively being used by db
>> 我的理解是 事物没提交的时候，是在活动日志。事物一旦完成，就变为归档日志了，理解对嘛？
不对
active log can contain both committed and not yet committed transaction records 收起