Tell command LIST_TREZOR displays a list of depository databases used by the process D2000 Archiv process. Contents of the list depends depend on the used platform - Sybase, Oracle or PostgreSQL.
Sybase platform
For the Sybase platform, the following list will be displayed (example):
...
The list consists of the following columns:
| Column name | Description |
|---|---|
| Data start | Start time of data writing into depository database. |
| Data end | End time of data writing into depository database. |
| Mono | Time in depository database in monotonic time (older depository databases use regional time). |
| Open | Depository database is open to read. |
| File Name | Name of depository database with the full path. |
Oracle platform
For the Oracle platform, the following list will be displayed (example):
...
If depository database segments are enabled, the list also contains the number and status of the depository database segment. The column Status shows the status of depository database segment nr. 0.
Example: depository database segments were configured after the first 16 depository databases had been created, the number of segments was increased to 2 after the depository database 0018 had been created. Segment 0 of the depository database 0017 is mounted for reading, segment 1 is dismounted.
...
The list consists of the following columns:
| Column name | Description | ||||||
|---|---|---|---|---|---|---|---|
| ID | ID (number) of depository database. | ||||||
| Data start | Start time of data writing into depository tablespace. | ||||||
| Data end | End time of data writing into depository tablespace. | ||||||
| Status | Status of depository tablespace. Possible states:
|
|
| ||||||||||
| Files |
| The number of data files in depository tablespace (see the parameter TrezorCountDatafiles). |
| Segs |
| The number of depository database segments in the depository database. Missing value means that depository database segments were not enabled during the creation of the depository database. |
PostgreSQL platform
For the PostgreSQL platform, the following list will be displayed (example):
...
If depository database segments are enabled, the list also contains the number and status of the depository database segment. The column Status shows the status of depository database segment nr. 0.
Example: depository database segments were configured after the first 15 depository databases had been created, the number of segments was increased to 2 after the depository database 0017 had been created. Segment 0 of the depository database 0016 is mounted for reading, segments 1 is dismounted.
Description of all columns is identical to Oracle listing, the only difference is that column Files is missing.
--------------------------------------------------------------------------
ID | Data start(UTC)| Data end(UTC) | Status |Segments |
--------------------------------------------------------------------------
0019 17-06-2014 13:00 17-06-2014 14:00 being used for writing 2
0018 17-06-2014 11:35 17-06-2014 12:00 used for late write 2
0017 17-06-2014 11:28 17-06-2014 12:00 mounted read-only 1
0016 17-06-2014 11:14 17-06-2014 11:28 mounted read-only 1
Segment 1: offline (dismounted)
0015 17-06-2014 09:00 17-06-2014 11:14 mounted read-only
0014 12-06-2014 13:39 17-06-2014 09:00 mounted read-only
0013 12-06-2014 13:04 12-06-2014 13:39 mounted read-only
0012 12-06-2014 07:00 12-06-2014 13:04 mounted read-only
0011 11-06-2014 14:00 12-06-2014 07:00 mounted read-only
0010 11-06-2014 08:00 11-06-2014 14:00 mounted read-only
0009 11-06-2014 07:00 11-06-2014 08:00 mounted read-only
0008 10-06-2014 13:50 11-06-2014 07:00 mounted read-only
0007 10-06-2014 13:00 10-06-2014 14:00 mounted read-only
0006 10-06-2014 12:00 10-06-2014 13:00 mounted read-only
0005 10-06-2014 11:41 10-06-2014 12:00 mounted read-only
0004 10-06-2014 11:00 10-06-2014 11:41 mounted read-only
0003 10-06-2014 07:00 10-06-2014 11:00 mounted read-only
0002 09-06-2014 13:48 10-06-2014 07:00 offline (dismounted)
0001 05-06-2014 13:09 09-06-2014 13:48 offline (dismounted)
--------------------------------------------------------------------------
...