Tell command LIST_TREZOR displays a list of depository databases used by the process D2000 Archiv. Contents of the list depends on the used platform - Sybase, Oracle or PostgreSQL.


Sybase platform

For 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 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 depository database segment. The column Status shows the status of depository database segment nr. 0.
Example: depository database segments were configured after 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:

0 being created Depository tablespace is now being created.
20 being used for writing Depository tablespace  is used for writing.
30 used for late write Depository tablespace is still used for writing delayed data (see the parameter TrezorCompressTime).
40 mounted read-only Depository tablespace is mounted for reading.
45 mounted read-write Depository tablespace is nounted for reading and writing (for depository databases synchronisation through the Arcsynchro tool).
50 offline (dismounted) Depository tablespace is dismounted.
-1 error: create/dismount Error in creating or dismounting depository tablespace.
-2 error: mount Error in mounting depository tablespace.

Files Number of data files in depository tablespace (see the parameter TrezorCountDatafiles).
Segs Number of depository database segments in depository database. Missing value means that depository database segments were not enabled during creation of the depository database.

PostgreSQL platform

For 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 depository database segment. The column Status shows the status of depository database segment nr. 0.
Example: depository database segments were configured after 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:

Depository databases

Napíšte komentár