| Kotva | ||||
|---|---|---|---|---|
|
...
Depositories on the Sybase platform
...
Configuration The configuration of the the D2000 Archiv process contains a configured time period, TrezorPeriod, during which the process writes data to one depository database. When this period elapses, the database is released, and the system starts storing data in a new database. The released database is available for storing delayed data for a defined time (configuration parameter TrezorCompressTime). After this time, the database is compressed by Sybase tools and moved to a directory specified by the configuration parameter TrezorCompressPath. The name of the compressed database contains the end time of the repository database (e.g., Trezor_2008_03_20_16.cdb).
Note: Compression of Sybase databases is implemented by supported versions of Sybase Adaptive Server Anywhere 6 to 9. Starting with the version Sybase SQL Anywhere 12, the utility for database compression does not exist anymoreno longer exists, and compressed databases are considered to be obsolete. Therefore, if you use Sybase SQL Anywhere 12, the depository databases are not being compressed, but they remain in the directory specified by configuration parameter parameter TrezorCompressPath, as files .db and .log (e.g., Trezor_2010_02_04_07.db and Trezor_2010_02_04_07.log).
Premature releasing of the depository database can be performed using the RELEASE_TREZOR TELL command.
Off-line Offline analysis of the data from the depository database is possible without performing any decompression. The support for the the data import from the depository database into MS-EXCEL was created for the analysis. As the Sybase Adaptive Server Anywhere is a standard SQL server, any tool suitable for working with SQL databases can be used for the analysis.
Configuration The configuration of the parameters defining the method of depository database creation is implemented in the D2000 Application Manager process. They may be defined for each process D2000 Archiv.
...