You can, however, specify the value to be -1, which allows infinite active log space.
但是,可以指定- 1,这允许无限的活跃日志空间。
Active logs: a log is considered active if either of the following two conditions are satisfied.
活动日志:只要满足下列两个条件中的任意一个,则可认为日志是活动的。
With the current DB2 Express-C version, the upper limit for total active log space size is 256gb.
在当前的DB 2Express - c版本中,整个活跃日志空间大小的上限是256gb。
When using circular logging log file extents are reused once they no longer contain active log data.
使用循环日志记录时,当日志文件扩展不再包括活动数据日志时,会将其进行重新使用。
Replace the source database (excluding the active log directory) with the mirror copy of the database.
用数据库的镜像拷贝替换源数据库(除了活动日志目录之外)。
It is therefore imperative to use the database configuration parameter MIRRORLOGPATH to mirror the active log.
因此强制使用数据库配置参数MIRRORLOGPATH来镜像活动日志。
They enforce archive log files to be written to a location that is not the active log path (by default SQLOGDIR).
它们使存档日志文件写到活跃日志路径(默认为SQLOGDIR)之外的位置。
When the logretain configuration parameter is set to "RECOVERY", the log files will remain in the active log path.
当logretain配置参数设置成“RECOVERY”时,日志文件将保留在活动日志路径中。
This not only delayed the availability of data that was rolled-in, it also consumed large amount of active log space.
这不仅延误了对滚入数据的使用,还会消耗大量活动日志空间。
The active log directory of the split mirror database must not contain any log file that is not a part of the split mirror.
分割镜像数据库的活动日志目录不能包含任何不属于分割镜像的日志文件。
To figure out which log is active and which are archived, use the DB2 command GET DB CFG to view the 'First active log file'.
要确定哪个日志是活动的,哪些日志是归档的,请使用DB2命令GETDBCFG来查看“第一个活动日志文件”。
When this option is enabled, applications running when a disk full condition occurs on the active log path will not be disconnected.
当启用该选项时,在活动日志路径上发生磁写盘满情况时正在运行的应用程序将不会断开连接。
Offline archive logs - archive logs that are being moved from active log directory to either another directory in another media or tape.
脱机归档日志——如果将联机归档日志从活动日志所在目录移动到其他目录或磁带中,就成为了脱机归档日志。
The number of log files allocated is based on the logprimary parameter value and the total number of log files in the active log directory.
所分配的日志文件数量基于logprimary参数值和活动日志目录中日志文件的总数。
By leveraging local indexes, roll-in not only makes the newly attached data visible more quickly, but consumes virtually no active log space.
借助本地索引功能,滚入操作使得新附加的数据更快可见,并且不会耗费活动日志空间。
When the database is initialized, the system allocates a certain number of primary log files of a specified size in the active log directory.
当初始化数据库时,系统会在活动日志目录中分配一定数量、指定大小的主日志文件。
DB2 Express supports infinite active log for a single transaction, so a long transaction will never fail (provided physical disk space is sufficient).
DB 2Express支持单个事务的无限多个活动日志,所以长期事务永远不会失败(只要物理磁盘空间足够)。
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配置参数时,会调用用户出口来归档日志文件,并将它们移到活动日志路径以外的位置。
The active log path is determined either by the path to log Files (logpath) or Changed path to log Files (newlogpath) value in the database configuration file.
活动日志路径由数据库配置文件中的“日志文件路径(pathtolog Files) (logpath)”或“更改的日志文件路径(Changedpath tologFiles) (newlogpath)”值确定。
The active log path is important when using either the userexit configuration parameter or the logretain configuration parameter to allow roll-forward recovery.
当使用userexit配置参数或logretain配置参数以允许前滚恢复时,活动日志路径非常重要。
This means that upon first connection to the database, the total number of primary logs is equal to the total number of log files residing in the active log directory.
这表示在第一次连接到数据库时,主日志的总数等于驻留在活动日志目录中的日志文件的总数。
Logging scalability - for those who have a penchant for extremely long transactions, DB2 has increased the maximum active log space from 32 GB (version 7.2) to 256 GB.
日志记录可伸缩性—对于那些喜欢使用非常长的事务的人,DB 2已经将最大活动日志空间从32GB (V7.2)增加到256 GB。
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目录中的所有日志文件(包括联机归档日志文件),分配新的活动日志文件,并且回复到循环日志记录。
The idea is that since log files will be constantly archived by the userexit program during a long transaction, there will always be new room for additional log files in the active log directory.
其想法是由于在长事务期间,日志文件将经常由userexit程序归档,在活动日志目录中始终要有新的空间来存放额外的日志文件。
It provides the log file that is currently active, and therefore archived logs will be those logs earlier than this current one.
该命令提供了目前活动的日志文件,因此被归档的日志将是那些比当前日志更早的日志。
You can, therefore, use the audit log to query information about active processes and to track historical data about processes that ran in the past.
因此,您可以使用该审核日志来查询有关活动流程的信息,并且可以跟踪查询过去已运行的流程的历史数据。
However, during a long running transaction, a log full situation may occur, where all the primary logs are active.
但在长期运行的事务期间,可能发生日志已满的情形,在这种情形中,主要日志是活动的。
应用推荐