Tell command LIST_TREZOR displays a list of depository databases used by the D2000 Archiv process. Contents of the list depend on the used platform - Sybase, Oracle or PostgreSQL.
Sybase platform
For the Sybase platform, the following list will be displayed (example):
List of existing depositories: ----------------------------------------------------------------------------------------------------------- Data start | Data end |Mono|Open| File Name ----------------------------------------------------------------------------------------------------------- 2005-05-18 14:00 2005-05-18 17:00 yes no c:\D2000\D2000.V70\KS02\Trezor\Compress\Trezor_2005_05_18_15.cdb 2005-05-18 13:00 2005-05-18 16:00 yes no c:\D2000\D2000.V70\KS02\Trezor\Compress\Trezor_2005_05_18_14.cdb 2005-05-18 12:00 2005-05-18 15:00 yes no c:\D2000\D2000.V70\KS02\Trezor\Compress\Trezor_2005_05_18_13.cdb 2005-05-18 11:00 2005-05-18 14:00 yes no c:\D2000\D2000.V70\KS02\Trezor\Compress\Trezor_2005_05_18_12.cdb -----------------------------------------------------------------------------------------------------------
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):
List of existing depositories: ------------------------------------------------------------------------ ID | Data start(UTC) | Data end(UTC) | Status | Files | ------------------------------------------------------------------------ 0045 2005-05-24 10:00 2005-05-24 10:00 being used for writing 1 0044 2005-05-24 09:00 2005-05-24 10:00 used for late write 1 0043 2005-05-24 08:00 2005-05-24 09:00 offline (dismounted) 1 0042 2005-05-24 07:00 2005-05-24 08:00 offline (dismounted) 1 0041 2005-05-24 06:00 2005-05-24 07:00 offline (dismounted) 1 0040 2005-05-24 05:00 2005-05-24 06:00 offline (dismounted) 1 0039 2005-05-24 04:00 2005-05-24 05:00 offline (dismounted) 1 0038 2005-05-24 03:00 2005-05-24 04:00 offline (dismounted) 1 0037 2005-05-24 02:00 2005-05-24 03:00 offline (dismounted) 1 0036 2005-05-24 01:00 2005-05-24 02:00 offline (dismounted) 1
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.
--------------------------------------------------------------------------
ID | Data start(UTC)| Data end(UTC) | Status |Files/Segs|
--------------------------------------------------------------------------
0019 2006-09-22 12:22 2006-09-22 14:00 being used for writing 1/2
Segments 1 - 2: being used for writing
0018 2006-09-22 12:00 2006-09-22 12:22 used for late write 1/1
Segment 1: used for late write
0017 2006-09-22 11:31 2006-09-22 12:00 mounted read-only 1/1
Segment 1: offline (dismounted)
0016 2006-09-22 04:00 2006-09-22 11:30 offline (dismounted) 1
0015 2006-09-22 02:00 2006-09-22 04:00 offline (dismounted) 1
0014 2006-09-22 00:00 2006-09-22 02:00 offline (dismounted) 1
0013 2006-09-21 22:00 2006-09-22 00:00 offline (dismounted) 1
0012 2006-09-21 20:00 2006-09-21 22:00 offline (dismounted) 1
0011 2006-09-21 18:00 2006-09-21 20:00 offline (dismounted) 1
0010 2006-09-21 16:00 2006-09-21 18:00 offline (dismounted) 1
0009 2006-09-21 14:00 2006-09-21 16:00 offline (dismounted) 1
0008 2006-09-21 13:01 2006-09-21 14:00 mounted read-only 1
0007 2006-09-11 13:00 2006-09-21 13:01 mounted read-only 1
0006 2006-09-11 12:25 2006-09-11 13:00 mounted read-only 1
0005 2006-09-11 12:15 2006-09-11 12:25 offline (dismounted) 1
0004 2006-08-23 06:54 2006-09-11 12:15 mounted read-write 1
0003 2006-08-23 06:53 2006-08-23 07:00 error: create/dismount 1
0002 2006-08-23 06:51 2006-08-23 07:00 error: create/dismount 1
0001 2006-05-04 11:33 2006-08-23 06:51 error: create/dismount 1
---------------------------------------------------------------------------
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):
List of existing trezors: -------------------------------------------------------------------------- ID | Data start(UTC)| Data end(UTC) | Status | -------------------------------------------------------------------------- 0011 17-06-2014 09:00 17-06-2014 10:00 being used for writing 0010 12-06-2014 13:39 17-06-2014 09:00 used for late write 0009 12-06-2014 13:04 12-06-2014 13:39 mounted read-only 0008 12-06-2014 07:00 12-06-2014 13:04 mounted read-only 0007 10-06-2014 13:00 12-06-2014 07: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) --------------------------------------------------------------------------
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)
--------------------------------------------------------------------------
Related pages:
0 komentárov