Log database depositories

Using the configuration parameters LogTrezorPath, LogTrezorCompressPath, LogTrezorPeriod and LogTrezorCompressTime it is possible to configure creation of log database depositories.
Log database depositories are supported only on Sybase database platform.

Log database depositories work analogically to archive depository databases. They enable to preserve unlimited time depth of log database data, which can be backed up and used e.g. for the purpose of the system audit (user login and logout records).

Logged data can be (besides the log database) stored also to a log database depository, which is created in a directory specified by a configuration parameter LogTrezorPath with period specified by a configuration parameter LogTrezorPeriod. After the usage period has elapsed, the depository database is disconnected and moved a subdirectory Prev of a directory LogTrezorPath. This detached depository database can be still used for writing delayed data. After the time period defined by a configuration parameter LogTrezorCompressTime has elapsed, the log database depository is put off to a directory specified by a configuration parameter LogTrezorCompressPath.

If a used database engine is Sybase Adaptive Server Anywhere 6, 7 or 9, the put-off depository database is compressed to a *.cdb file (e.g. LogTrezor_2010_02_14_08.cdb).
If a used database engine is Sybase SQL Anywhere 12, which does not support database compression any more, the put-off depository database is kept as *.db and *.log files (e.g. LogTrezor_2010_02_14_08.db and LogTrezor_2010_02_14_08.log).
In both cases the time of disconnection is a part of the database name.

Log database depositories can be activated by setting a non-zero (different than 0H, 0D, 0W resp. 0M) value of a configuration parameter LogTrezorPeriod.

Unlike the process D2000 Archiv the process D2000 Server does not support mounting of log database depositories. Therefore the data in put-off depository databases can be accessed only by external tools, not via log database browsing in D2000 HI.