SQL> alter system archive log stop;
把自动方式改为手动方式。
DB2 UDB will maintain the archive log files, so enter 1 when prompted.
DB 2UDB将包含该存档日志文件，在提示的时候输入1。
DB2 Express-C comes with two logging modes, circular and archive log modes.
DB 2 Express- C提供两种日志模式，循环和存档日志模式。
Before you can put a database in hot backup mode, you need to use the archive log.
在使数据库进入备份模式之前，需要使用归档日志。
For online backup (using archive logging), the threshold of the log space used is triggered.
对于在线备份(使用存档日志)，达到使用的日志空间的阈值。
You must ensure that there is sufficient disk space at all times for archive log destinations.
要确保指定的归档路径有足够的空间来存放归档日志。
Using the automatic option requires you to specify primary archive log path and fail archive log path.
使用自动选项时要求指定主存档日志路径和故障转移存档日志路径。
To prevent a single point of failure for offline archive logs such as media failure, log mirroring shouldl be used.
要防止脱机归档日志的单点故障，比如媒介失败，则应该使用日志镜像。
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.
为转换到归档日志模式，只需运行命令db2updatedbcfgfor icmnlsdb using logretain on即可。
Offline archive logs - archive logs that are being moved from active log directory to either another directory in another media or tape.
脱机归档日志——如果将联机归档日志从活动日志所在目录移动到其他目录或磁带中，就成为了脱机归档日志。
With archive logging, if you don't move old log files from the active log directory, they will accumulate and share the directory with the active log files.
使用归档日志记录时，如果您没有把旧的日志文件从活动日志目录中移走，它们将累积起来，并与活动日志文件共享该目录。
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配置参数时，会调用用户出口来归档日志文件，并将它们移到活动日志路径以外的位置。
Archive logs that are currently stored in the database log path directory are not moved to the new location if the database is configured for roll-forward recovery.
如果将数据库配置成进行前滚恢复，那么就不会将当前存储在数据库日志路径目录中的归档日志移到新的位置。
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程序将需要从归档日志路径中检索未提交的日志文件。
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”(请参阅下一节)，将保留活动日志文件，而且这些文件将变成联机归档日志文件，以便在前滚恢复中使用。
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目录中的所有日志文件(包括联机归档日志文件)，分配新的活动日志文件，并且回复到循环日志记录。
In this situation, 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 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.
在上述情况下，如果性能很重要的话，最好是在执行上述操作时禁用事务日志归档模式。
This parameter also indicates that a user exit program should be used to archive and retrieve the log files.
该参数还表示用户出口程序应该用于归档和检索日志文件。
Online backups with transaction log archive mode enabled at regular intervals and the transaction logs are stored on a fault-tolerant disk.
定期启用事务日志归档模式进行的在线备份，事务日志存储在一个容错磁盘上。
Listing 10: Checking for the transaction log archive mode status?
清单10：查看事务日志归档模式状态。
In other words, the server will archive the log files to prevent the file from growing so large that it is unmanageable.
也就是说，服务器将对日志文件进行存档，以防止文件过大而无法管理。
Though there are three options provided, it's recommended to allow DB2 to automatically archive the log files.
尽管提供了三个选项，但是建议让DB 2自动地对日志文件进行存档。
Checking if the transaction log archive mode is on.
检查事务日志归档模式是否启用。
Listing 7: Perform a backup, enable the transaction log archive mode, and delete archived transaction logs before this backup.
清单7：执行备份，启用事务日志归档模式，并删除这次备份之前归档的事务日志。
Listing 6: Perform a backup, enable the transaction log archive mode, and preserve archived transaction logs before this backup.
清单6：执行备份，启用事务日志归档模式，并保存这次备份之前归档的事务日志。
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.
启用事务日志归档模式的一个副作用是：在下面两种情况下，所有数据更改(insert)都会被记录到日志中，而默认情况下它们不会被记录。
Disabling the transaction log archive mode.
禁用事务日志归档模式。
Listing 9: Disable the transaction log archive mode, and delete all the archived transaction log files.
清单9：禁用事务日志归档模式，并删除所有归档的事务日志文件。
应用推荐