存档日志模式支持在线备份和恢复。
OFF——默认设置，表示使用循环日志模式。
OFF - The default setting to indicate circular logging to be used.
循环日志：循环日志是DB2的默认日志模式。
Circular logging: Circular logging is the default logging mode for DB2.
如果要进行在线备份，那么需要将日志模式改为存档日志。
Should you desire to do an online backup (which you will explore later), log mode needs to be modified to archived logging.
这些参数的默认值是OFF，这表示使用循环日志模式。
The default values for these parameters are OFF, which indicates circular logging mode to be used. There are five values you can set for these two parameters
采用这种方法时，使用循环日志模式，可以以循环方式重写日志。
With this method, circular logging is used and logs can be overwritten in a round robin manner.
可用性——在使用循环日志模式时，只能进行离线全备份。
Availability - With circular logging mode, only offline full backup is possible.
对于DB 2LUW，您可以备份的内容取决于数据库的日志模式。
For DB2 LUW, what you can backup depends on the logging mode of the database.
DB 2 Express- C提供两种日志模式，循环和存档日志模式。
DB2 Express-C comes with two logging modes, circular and archive log modes.
例如，日志缓冲区将每个事务写到日志，可以使用不同的日志模式来实现不同的备份和恢复模式。
For example, the log buffer writes each transaction to logs and how different log mode can be used to accomplished different modes of backup and recovery.
DCS配置文件为更改dcs配置提供了支持，例如设置日志模式、转换超时、日志文件位置和远程dcs地址。
The DCS configuration file provides support for changing the DCS configuration such as setting the log modes, conversion timeout, log file location and Remote DCS address.
我们在日志模式下运行PerformanceMonitor，每隔15 分钟收集一次数据。
We ran the Performance Monitor in logging mode and collected data at 15-minute intervals.
LOGRETAIN——设置logretain值会自动地将参数LOGRETAIN的值改为RECOVERY，这表示使用存档日志模式。
LOGRETAIN - Setting the value LOGRETAIN will automatically change the value for the parameter, LOGRETAIN to RECOVERY, which indicates archive logging mode will be used.
为转换到归档日志模式，只需运行命令db2updatedbcfgfor icmnlsdb usinglogretain on即可。
In order to turn to the archive log mode, simply issue the command db2 update db CFG for icmnlsdb using logretain on.
Logging列显示在创建数据库时设置的日志模式（buffered、unbuffered、ANSI compliant和notlogged）。
The Logging column mentions the logging mode that has been set while creating the database (buffered, unbuffered, ANSI compliant, and not logged).
在物理恢复完成之后，数据库实例处于快速恢复模式，等待恢复逻辑日志。
After the physical restore completes, the database instance waits in fast recovery mode to restore logical logs.
在上述情况下，如果性能很重要的话，最好是在执行上述操作时禁用事务日志归档模式。
If performance is important in the above cases, it would be a good idea to disable transaction log archive mode for the duration of their execution.
关于日志，您要做的一个最重要的选择可能是确定一种模式，将每个日志消息分配给一个特定的类别。
Perhaps the most important choice you have to make about logging is to decide on a scheme that assigns each log message to a particular category.
清单10：查看事务日志归档模式状态。
Listing 10: Checking for the transaction log archive mode status?
定期启用事务日志归档模式进行的在线备份，事务日志存储在一个容错磁盘上。
Online backups with transaction log archive mode enabled at regular intervals and the transaction logs are stored on a fault-tolerant disk.
如果服务器处于排出模式下时遇到另一条日志检查点记录，那么它会回到缓冲模式。
If another log checkpoint record is encountered while it is in drain mode, it goes back to buffering mode.
当系统中不再存在属于旧模式的日志记录时，影子复制将被自动删除，系统中就只有新的主复制。
After the log records pertaining to older schema no longer exist in the system, the shadow replicate is automatically deleted and system only has new master replicates.
日志记录模式提供服务调用可跟踪性。
The logging pattern provides service invocation traceability.
我个人喜欢选用流模式，因为它以文本模式写审计日志文件，允许实时地查看审计事件。
The stream mode is my personal choice, because it offers real-time viewing of audit events due to the audit log file being written to in text mode.
检查事务日志归档模式是否启用。
清单7：执行备份，启用事务日志归档模式，并删除这次备份之前归档的事务日志。
Listing 7: Perform a backup, enable the transaction log archive mode, and delete archived transaction logs before this backup.
清单6：执行备份，启用事务日志归档模式，并保存这次备份之前归档的事务日志。
Listing 6: Perform a backup, enable the transaction log archive mode, and preserve archived transaction logs before this backup.
禁用事务日志归档模式。
启用事务日志归档模式的一个副作用是：在下面两种情况下，所有数据更改(insert)都会被记录到日志中，而默认情况下它们不会被记录。
One side effect of enabling the transaction log archive mode is all the data changes (inserts) get logged, whereas by default they are not logged in the following two cases.
通过检查数据库属性 derby.storage.logArchiveMode ，可以发现事务日志归档模式是否被启用。
You can find out if the transaction log archive mode is enabled for a database by checking the database property derby.storage.logArchiveMode .
应用推荐