Archive Log

DB2 Express-C comes with two logging modes , circular and archive log modes .

DB2Express-C提供两种日志模式，循环和存档日志模式。

Using the automatic option requires you to specify primary archive log path and fail archive log path .

使用自动选项时要求指定主存档日志路径和故障转移存档日志路径。

Archive log files to maintain the current log file at a manageable size .

对日志文件进行归档，将当前日志文件维护到一个可管理的大小。

Before you can put a database in hot backup mode , you need to use the archive log .

在使数据库进入备份模式之前，需要使用归档日志。

Archive log list ( to verify )

验证归档日志清单。

Class provides automated maintenance capabilities to archive log files as needed , on a daily or per-application basis .

类提供自动维护功能，可以根据需要每天或基于每个应用程序对日志文件进行存档。

This parameter applies only to records in the control file that are circularly reusable ( such as archive log records and various backup records ) .

此参数只能应用于控制文件中，可循环重用的部分。

They enforce archive log files to be written to a location that is not the active log path ( by default SQLOGDIR ) .

它们使存档日志文件写到活跃日志路径（默认为SQLOGDIR）之外的位置。

In order to turn to the archive log mode , simply issue the command db2 update db cfg for icmnlsdb using logretain on .

为转换到归档日志模式，只需运行命令db2updatedbcfgforicmnlsdbusinglogretainon即可。

There is a new tool called db2cklog that you can use to check the validity of archive log files before using these files during a roll forward recovery .

有一个名为db2cklog的新工具。

When the userexit configuration parameter is enabled , the user exit is called to archive log files and move them to a location away from the active log path .

当启用了userexit配置参数时，会调用用户出口来归档日志文件，并将它们移到活动日志路径以外的位置。

The drawback though , can be a performance impact if a rollback occurs since the userexit program will need to retrieve the uncommitted log files from the archive log path .

但是其缺点是：如果发生回滚，就可能有性能影响，因为userexit程序将需要从归档日志路径中检索未提交的日志文件。

In this case , the database manager deletes all log files in the logpath directory ( including online archive log files ), allocates new active log files , and reverts to circular logging .

在这种情况下，数据库管理器会删除logpath目录中的所有日志文件（包括联机归档日志文件），分配新的活动日志文件，并且回复到循环日志记录。

If logretain is set to " Recovery " or userexit is set to " Yes "( see below ), the active log files will be retained and become online archive log files for use in roll-forward recovery .

如果logretain设置成“Recovery”或者userexit设置成“Yes”（请参阅下一节），将保留活动日志文件，而且这些文件将变成联机归档日志文件，以便在前滚恢复中使用。

Though there are three options provided , it 's recommended to allow DB2 to automatically archive the log files .

尽管提供了三个选项，但是建议让DB2自动地对日志文件进行存档。

In other words , the server will archive the log files to prevent the file from growing so large that it is unmanageable .

也就是说，服务器将对日志文件进行存档，以防止文件过大而无法管理。

Maybe you just want to keep an archive of the log file that was a success or email a copy of the error log in the event of a problem .

您可能会只想保存成功的日志文件的存档，或在出现问题时将错误日志的副本以电子邮件方式发送出去。

This parameter also indicates that a user exit program should be used to archive and retrieve the log files .

该参数还表示用户出口程序应该用于归档和检索日志文件。