Depositories on the Sybase platform

The configuration of 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 no longer exists, and compressed databases are considered obsolete. Therefore, if you use Sybase SQL Anywhere 12, the depository databases are not compressed, but they remain in the directory specified by configuration 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.

Offline analysis of the data from the depository database is possible without performing any decompression. The support for 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.

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.

Configuration parameters for the Sybase platform:

  • AutoMountPath - path to a directory from which all the depositories will be mounted automatically after the start of the D2000 Archiv process 
  • TrezorPath - path to the directory where the depository databases are created
  • TrezorCompressPath - path to the directory for storing the compressed depository databases
  • TrezorPeriod - the period of the depository creation. It is specified in the format NX, where N is an integer number and X defines a time unit.
    Permitted time units are:
    • H - hour
    • D - day
    • W - week
    • M - month.
      Note: Setting the parameter either to an empty value or to 0H disables the functionality of depository databases.
  • TrezorCompressTime - time defining the compression of the released depository database. The database is available for writing delayed data during this time. The value of TrezorCompressTime must be less than the value of TrezorPeriod.
  • TrezorCompressOffline - value 1 (default) means that the compressed depository database will remain offline. Value 0 means that the compressed depository database will be reconnected and available for reading.

The parameters TrezorPeriod and TrezorCompressTime can be given in hours, days, weeks, or months. The syntax is e.g.:

  • 4H - four hours
  • 2D - two days
  • 1W - one week
  • 1M - one month

Note: It is possible to query the configuration of depository databases and currently mounted depository databases by the Tell command LIST_TREZOR.

Warning: When a depository database is created or if it does not exist, the process D2000 Archiv of database templates copies the template of the depository database and initializes its structure. Because of this, it is not allowed to copy the templates of the depository database manually since the D2000 Archiv process does not initialize the depository database when it finds it in the Trezor subdirectory of the application directory.


Napíšte komentár