História stránky

...

BACKUP [path]

Creates an archive database backup. If the parameter path is not specified, the backup will be performed into the directory, which is set in the archive configuration.
Note: this command is supported for Sybase SQL Anywhere only. To back up Oracle/PostgreSQL/MsSql databases, use their respective utilities.

Kotva

	calc_old_requests
	calc_old_requests

CALC_OLD_REQUESTS [path+filename]

Executes recalcs of old values, which were redirected to the auxiliary calc task (see the RecalcImmediateDepth archive parameter), and then instead of being performed, they were stored to the file (see the DropOldRequests archive parameter). If path+filename is not specified, the file name_ARCHIV_DROPPED_CALCS.DAT will be processed by name.ARC and then renamed to name_ARCHIV_DROPPED_CALCS.DONE (if such a file exists, it will be deleted).

Note: This command fails if the archive parameter DropOldRequests has value 1 because in this case the recalcs would be again stored to the file after being read.

Kotva

	cleanup_slices
	cleanup_slices

CLEANUP_SLICES

A command that must be run after the change of DataTableSlices parameter from value 1 to value 2 (i.e. after changing the time slices mode to time slices for structured archives only).
The archive will transfer the archived values from time slices of simple archives to the original data tables and these time slices will be deleted.
Note: for simple archives, from the start of the archive till the transfer of archived values to the original data tables, the archive will provide only data which are located in original data tables. Therefore this conversion is recommended only for systems with redundant archives and the archive performing conversion should be set as a passive instance.

CRC path\filename mask from to [step] [PO]

Parameter checks the identity of data in instance archives. Creating the file with a CRC (checking sum) for archive objects that correspond to the mask for the entered time period.
The optional parameter step (in hours) allows dividing the calculation for time period into intervals.
The PO parameter ensures the calculation will be executed only for primary archive data.

Kotva

	crc_poznamka
	crc_poznamka

Note: Values entering the CRC calculation can be "truncated" - in a 64-bit floating-point value complying with the IEEE 754 standard, the two lowest bytes will be zeroed, if a debug category DBG.ARCHIV.CRC.Z2LB is enabled. The truncation can be used to ignore minor differences (16. and higher decimal point), which can occur in floating-point calculations in archives running on different processors.

CRC_TREE path\filename name row col from to [step]

Parameter checks the identity of data in instance archives. Creating the file with CRC (checking sum) for archive objects that correspond to the mask for the entered time period.
The calculation will be realized for the object that has been defined by parameter "name row col" and for all objects that influence its value.
The optional parameter step (in hours) allows dividing the calculation for the time period into intervals.
See the note to the CRC command.

DEL mask [before]

Deletes data from the archive database as follows:

the parameter before is not defined - for individual archive objects, there will be deleted all data that are older than the history depth (the parameter History depth) defined in the configuration of the objects,
the parameter before is defined - there will be deleted all data with the timestamps older than defined by the parameter before.

Kotva

	delete_data
	delete_data

DELETE_DATA mask from [to]

Deletes data from the archive database without activation of dependent statistics evaluation (similar to the action DELETEARCHDATA).
Time format is dd-mm-rrrr hh:mi:ss.mss.

DI ON/OFF

Debug Info - shows/hides internal debug information of the D2000 Archiv process (in the process window and in the D2000 Sysconsole process).

Kotva

	di_on_mask
	di_on_mask

DI ON/OFF [HOBJ/mask [ROW [COL]]]

Debug Info for values - enables/disables displaying information about the evaluation of historical values with specified HOBJ or with the name matching the given mask. For structured historical values, you can specify the required structure item - column (if ROW=0) or row (if COL=0).

Example:
DP ON H.Test1 3 4 - enables debug information for the item of structured historical value H.Test1 on row 3 and column 4
DP ON H.Test2 - enables debug information for historical value H.Test2 (for all items if the object is a structure)
DP OFF 1234 0 4 - disables debug information for the whole column 4 in the structured historical value with HOBJ=1234

By default, debug information shows just the time and the value of historical value. Enabling the debug category DBG.ARCHIV.DATA (in the process D2000 System Console or using the start parameter /E+DBG.ARCHIV.DATA when starting the process D2000 Archiv), allows to show the complete stored data designed for the D2000 System developers:
Time (archive value time)
Value (value)
Status (a True/False array containing Valid, ProcAlarm, NoAckPAlarm, PrAlSilent, Weak, NoAckValue, Transient, Default, Manual, AlCrit, Unknown values)
Limits (one of the value of InLimit, VL_Limit, L_Limit, H_Limit, VH_Limit, LimitsProblem)
ArchFlags (a True/False array containing Start, Stop, Block, UnBlock, Deleted, UserModify, OldVal, ProcesModify, LoadData, MONO_TIME, K, L, M, N, O, Ver1 values)

DI ONREC/OFFREC HOBJ/mask [ROW [COL]]

Debug Info for values - recursive. The command extends the functionality of the previous commands with the possibility of showing / hiding the debug information for historical values that depend on specified historical values (e.g. minute averages).

Kotva

	dismount_trezor0
	dismount_trezor0

DISMOUNT_TREZOR path+trezor_name

Sybase platform: The parameter path+trezor_name specifies the path and the name of the depository database to dismount. The * and ? characters for mask definition can be used in the depository database name. If more files match to entered mask, all these ones will be dismounted.

For more information see the topic On-line access to data from depository databases.

Kotva

	dismount_trezor_ora0
	dismount_trezor_ora0

DISMOUNT_TREZOR Id [SEGMENT seg]
DISMOUNT_TREZOR trezor_name [SEGMENT seg]
DISMOUNT_TREZOR IdFrom IdTo [SEGMENT seg]

Oracle platform: The parameter Id or trezor_name defines the number (name) of the depository database to dismount.
The name of the depository database is the name of the depository tablespace (e.g. MYAPP_TS_TREZOR15 or MYAPP_TS_TREZOR15_02) or the name of the tablespace's datafile (e.g. MYAPP_TS_TREZOR0015_S02_20040801.ORA).
You can also dismount all depository databases (except the ones that are currently being filled) by using the parameter all. The parameters IdFrom and IdTo allow dismounting a sequence of depository databases.
The parameter SEGMENT seg (where seg is the number of depository database segment) allows dismounting just the segment. Seg is the number between 0 and TrezorCountSegments. If the DISMOUNT_TREZOR command is used without the SEGMENT Seg parameter for depository database with segments enabled, the process D2000 Archiv attempts to dismount all segments of specified depository database/s.

For more information see the topic On-line access to data from depository databases.

Kotva

	dismount_trezor_pg
	dismount_trezor_pg

DISMOUNT_TREZOR Id [SEGMENT seg]
DISMOUNT_TREZOR IdFrom IdTo [SEGMENT seg]

PostgreSQL platform: The parameter Id defines the number of depository databases to dismount.
You can also dismount all depository databases (except the ones that are currently being filled) by using the parameter all. The parameters IdFrom and IdTo allow dismounting a sequence of depository databases.
The parameter SEGMENT seg (where seg is the number of depository database segment) allows dismounting just the segment. Seg is the number between 0 and TrezorCountSegments. If the command DISMOUNT_TREZOR is used without the parameter SEGMENT Seg for depository database segments enabled, the process D2000 Archiv attempts to dismount all segments of specified depository database/s.

For more information see the topic On-line access to data from depository databases.

DP ON/OFF

Debug Pipe - shows/hides the course of communication with D2000 Server (only if the process window is displayed on the desktop).

Kotva

	drop_list
	drop_list

DROP_LIST path+filename

Creates the file (defined by the parameter path+filename) containing SQL commands to delete tables, which are not used by the archive configuration. If the time slices are enabled, the file will contain also the commands to delete respective rows of the table ARC_SLICE, which contain information about the time slices corresponding to tables that are to be deleted.

Kotva

	fill_cache
	fill_cache

FILL_CACHE

Manual loading of archive cache (only available for isochronous cache mode) by reading values from the archive database.
Archive cache loading can be also automatic after startup - for more information see the description of parameter IsoCacheAutoFill.

Kotva

	force_clear
	force_clear

FORCE_CLEAR HOBJ/mask

For the selected object(s), their ClearTime is set to a value of several hours in the past, which means that a periodic delete of object's data should occur shortly - within a minute (unless it is disabled for some reason, e.g. if the time slices are enabled, it can depend on parameters DeleteInSlice0 and DeleteInSlices).

Kotva

	freeze
	freeze

FREEZE freeze_seconds [report_seconds]

UNFREEZE

FREEZE command causes the writing and calculating tasks of the archive stop processing the requests for a period freeze_seconds. Within this time, another task (deleting) will list the number of requests (primary and calculated) in the queues. After the elapsing of the freeze_seconds time, the processing of values will be restored. If the report_seconds parameter is entered, the deleting task continues to list the number of requests in the queues for this period.
FREEZE command is primarily used for performance tests (testing the maximum speed for processing the requests under load). Before its use, you should realize that it does not influence reading from the archive, but during its execution, the writing to the archive (so the newest values are not available when reading) and the calculations are not executed for the freeze_seconds period. In redundant systems with 2 and more archives, we recommend executing the FREEZE command on a passive instance, so that the functionality of the archiving subsystem will not be affected.
UNFREEZE command (without parameters) is used for aborting inactivity that was caused by the FREEZE command.

Kotva

	list_trezor
	list_trezor

LIST_TREZOR [all]
LIST_TREZOR id

The parameter allows showing the list of depository databases used by the process D2000 Archiv. The contents of the list depend on the used platform - Sybase, PostgreSQL, or Oracle.
Parameter id:

for Sybase - name of a depository database
for Oracle - number of depository tablespace
for PostgreSQL - number of a depository database

LOAD_TREZOR path+filename [mask] [from] [to]

On-line depository database import (Sybase only)

Kotva

	mount_trezor0
	mount_trezor0

MOUNT_TREZOR path+trezor_name

Sybase platform: The path+depository_name parameter defines the path and name of the depository database to be mounted. The name may contain "*" and "?" characters to define a mask. If more files match the specified mask, all these will be mounted.

For more information see the topic On-line access to data from depository databases.

Kotva

	mount_trezor_ora
	mount_trezor_ora

MOUNT_TREZOR Id [SEGMENT seg] [WRITE]
MOUNT_TREZOR trezor_name [SEGMENT seg] [WRITE]
MOUNT_TREZOR IdFrom IdTo [SEGMENT seg] [WRITE]

Oracle platform: The parameter Id (trezor_name) defines the number (name) of a depository database to be mounted.
The name of the depository database is the name of depository tablespace (e.g. MYAPP_TS_TREZOR15 or MYAPP_TS_TREZOR15_02) or the name of tablespace's datafile (e.g. MYAPP_TS_TREZOR0015_S02_20040801.ORA).
The IdFrom and IdTo parametersallow mounting a sequence of depository databases.
The SEGMENT Seg parameter (where Seg is the number of the depository database segment) allows mounting a single depository database segment. If the MOUNT_TREZOR command is used without the SEGMENT Seg parameter for depository database with segments enabled, the process D2000 Archiv attempts to mount on all segments of specified depository database/s.
The parameter Write can be used to mount the depository database (s) for writing (for depository database synchronization through the Arcsynchro tool).

For more information see the topic On-line access to data from depository databases.

Kotva

	mount_trezor_pg
	mount_trezor_pg

MOUNT_TREZOR Id [SEGMENT seg] [WRITE]
MOUNT_TREZOR IdFrom IdTo [SEGMENT seg] [WRITE]

PostgreSQL platform: The parameter Id specifies the number of a depository database to be mounted. The parameter SEGMENT Seg (where Seg is the number of the depository database segment) allows mounting a single depository database segment. If the MOUNT_TREZOR command is used without the SEGMENT Seg parameter for depository database with segments enabled, the process D2000 Archiv attempts to mount on all segments of specified depository database/s.
The parameter Write can be used to mount the depository database (s) for writing (for depository database synchronization through the Arcsynchro tool).

For more information see the topic On-line access to data from depository databases.

OPTIMIZE_QUEUE

Reduction of the number of calc requests in the archive queue. If for some reason, the number of requests in the archive queue has increased (for example, due to the arrival of old values from the communication), this TELL command can reduce duplicate requests.

Kotva

	pending_requests
	pending_requests

PENDING_REQUESTS path+filename

Creates a file containing the descriptions of pending requests.

Kotva

	recalc
	recalc

RECALC Mask [Row [Col]] From [To] [BACKGROUND]

Recalculates the values in the statistical archive.
Mask - defines the list of objects, which are to be recalculated. If the specific row and/or column of the structured archive is recalculated, it is possible to specify parameters Row and Col (if unspecified, their default value is 0, meaning "whole row/column").
The parameters <From, To> define a time interval to be recalculated. If the end time is not entered, the current time will be used. Time format is dd-mm-yyyy [hh[:mi[:ss[.mss]]]].
Optional parameter BACKGROUND puts the recalculation to the auxiliary calc task (see the archive parameter RecalcImmediateDepth). The parameter is recommended for long-lasting recalculation of historical values that are supposed to be performed in the background while the archive still continues archiving real-time data.

Note: If the parameter RecalcTimeIntervalLimit has a non-zero value and the time interval <From, To> is longer than RecalcTimeIntervalLimit hours, the parameter BACKGROUND is mandatory, to ensure that the recalculation will be performed by auxiliary calc. This behavior is implemented as a protection against overloading the main task by recalculations.

Kotva

	release_trezor
	release_trezor

RELEASE_TREZOR

Premature disconnection of the current depository database.

Kotva

	reload_values
	reload_values

RELOAD_VALUES mask SCRIPT|PRIMARY|STATISTIC|EVAL|ALL

The command is used to force the reading of the last values of the specified objects from the archive database. Objects can be specified by name/mask and by type:

SCRIPT - script
PRIMARY - primary archive objects
STATISTIC - statistical archive objects
EVAL - calculated archive objects
ALL - all types of archive objects

If e.g. in the test environment the inserting of values of script-filled archives is not possible, but these are inserted into the archive database by the arcsynchro utility, it is possible to execute this command after the insertion is completed (e.g. RELOAD_VALUES * STATISTIC). Subsequently, a read (e.g. of all script-filled archive objects) is performed and recalculations of archive objects that depend on the read objects can be initiated.

Kotva

	rem_empty_slices
	rem_empty_slices

REM_EMPTY_SLICES HOBJ|mask

If the time slices are activated, the command causes the archive to review all time slices of simple archive objects according to the defined HOBJ or mask and to delete the time slices without data.
The command is used to clean up the archive database from empty time slices that were created due to the error of the archive. This error was repaired in the supported versions on June 8, 2015.

Kotva
reorganize
reorganize
REORGANIZE

On-line reorganization of archive database. The command compacts all archive tables (same as the Oracle command ALTER TABLE MOVE or the Sybase command REORGANIZE TABLE INDEX or the PostgreSQL command VACUUM - see the PG_ReorganizeSlice parameter).

Note: For Oracle, PostgreSQL, and Sybase 8.0 (and above) platforms only.

Kotva

	reorganize_slice
	reorganize_slice

REORGANIZE HOBJ|mask [SLICE slice] [tablespace]

On-line reorganization of archive table of an object with specified HOBJ or with a name matching the specified mask. If the parameter tablespace is also defined, the given archive table will be moved to the specified tablespace. If time slices are on, all slices of one archive object will be reorganized/moved unless a slice number slice is specified.

Note 1: The parameter tablespace can be used on Oracle and PostgreSQL platforms only.
Note 2: The slice number, except for ordinary values, supports special values:

value -1 means "all slices"
value -2 means "slice for current time"
value -3 means "previous time slice"
value -4 means "all slices older than current time slice"
value -5 means "only those archive objects that do not have time slices" (if time slices are configured only for structured archives, then only simple ones will be reorganized)

REORGANIZE ON

Enables the reorganization of the archive database (same as running the process D2000 Archiv with the /DBCY parameter).

REORGANIZE OFF

Enables the reorganization of the archive database (same as running the process D2000 Archiv without the /DBCY parameter).

REORGANIZE ACTIVE

Enables the reorganization of the archive database in the active mode only (same as running the process D2000 Archiv with the /DBCA parameter).

REORGANIZE PASSIVE

Enables the reorganization of the archive database in the passive mode only (same as running the process D2000 Archiv with the /DBCP parameter).

REORGANIZE SHRINK

Enables the alternate mode of the reorganization of the archive database - only for Oracle 10g and above (dame as running the process D2000 Archiv with the /DBCS parameter).
Note: To enable the original mode, use the REORGANIZE MOVE command.

REORGANIZE TableRowLimit rowLimit

On-line change of the parameter ReorganizeTableRowLimit is used for the automatic reorganization of the archive database.

REORGANIZE TableTimeLimit timeLimit

On-line change of the parameter ReorganizeTableTimeLimit is used for the automatic reorganization of the archive database.

Kotva

	set_cache
	set_cache

SET_CACHE size [MB]

The command allows the user to change the dynamic cache size to speed up the calculation of statistical historical values while the process D2000 Archiv is still running.

Note 1: The initial cache size can be specified by the parameter MaxCacheSize in the process D2000 Application Manager.
Note 2: The command SET_CACHE also changes the value of the parameter MaxCacheSize in the registry.

Kotva

	set_option
	set_option

SET_OPTION
name_parameter
value_parameter

The SET_OPTION command controls the following configuration and start-up parameters of the process D2000 Archiv:

name_parameter

value_parameter

description

AlmostZero
ALMOST_ZERO

positive real number (e.g. 1e-10)

Setting the tolerance for comparing two numbers in the archive (default is 1e-10).
See the description of the parameter AlmostZero.

ChainedReadPrio
CHAINED_READ_PRIO

string

Set the priorities of the statistical functions used in chained reading from the archive.
See the description of the ChainedReadPrio parameter.

CommitCountActive
COMMIT_COUNT_ACTIVE

positive number

The number of values inserted into the archive database by an active D2000 Archiv after which a COMMIT is triggered (default is 1000).
See the description of the parameter CommitCountActive.

CommitCountPassive
COMMIT_COUNT_PASSIVE

positive number

The number of values inserted into the archive database by a passive D2000 Archiv after which a COMMIT is triggered (default is 1000).
See the description of the parameter CommitCountPassive.

CommitTimeActive
COMMIT_TIME_ACTIVE

positive number

Interval after which a periodic COMMIT is triggered by an active D2000 Archiv process (default is 60 s).
See the description of the parameter CommitTimeActive.

CommitTimePassive
COMMIT_TIME_PASSIVE

positive number

Interval after which a periodic COMMIT is triggered by a passive D2000 Archiv process (default is 60 s).
See the description of the parameter CommitTimePassive.

DBPO

ON/OFF

Only primary data processing. Calculations of statistics and evaluated archives will not be performed.

RX

ON/OFF

No delete. Periodic deletes (for removal of data beyond configured history depth) will not be performed.

RO

ON/OFF

Read-only.

RS

ON/OFF>

Backup on the Sybase platform will be performed by copying the database file.

Kotva

	read_archive_depth
	read_archive_depth

READ_ARCHIVE_DEPTH

"dd-mm-yyyy hh:mi:ss"

OFF

Limitation of the reading depth from the archive.

If the depositories are ON, the data older than the specified date will be read from the depository databases. This parameter can be used for checking if the depositories truly contain all data (e.g. after the patching by arcsynchro).
The value OFF deactivates the limitation.
When the limitation is active, every reading from the archive (in which the limitation is applied) produces the following note in the archive log file:
Start time for reading values from archive is before READ_ARCHIVE_DEPTH, limiting

DiskUsageWarning
DISK_USAGE_WARNING

ON/OFF

Calling with parameter OFF disables the archive warning about low disk free space.
See the description of the parameter DiskUsageWarning.

DropOldRequests
DROP_OLD_REQUESTS

ON/OFF

Requests for recalc of data older than RecalcImmediateDepth will be discarded.
See the description of the parameter DropOldRequests.

IsochronousCache
ISOCHRONOUS_CACHE

ON/OFF

Activation of the IsochronousCache.
See the description of the parameter IsochronousCache.

IsoCacheFullDepth
ISOCACHE_FULL_DEPTH

ON/OFF

Setting the depth of the IsochronousCache for objects with a period greater than the current cache depth.
See the description of the parameter IsoCacheFullDepth.

IsoCacheDepth
ISOCACHE_DEPTH

a positive number (seconds)

Manual setting of the depth of the IsochronousCache.
See the description of the parameter IsoCacheDepth.

OldValIgnoreAge

a positive number (hours)

Values older than a specified number of hours will be discarded.
See the description of the parameter OldValIgnoreAge.

OldValOnAuxTask
OLD_VAL_ON_AUX_TASK

ON/OFF

Old values from the communication (having the OldVal flag set) will be processed by the auxiliary calc task.
See the description of the parameter OldValOnAuxTask.

OneThreadForGraph
ONE_THREAD_FOR_GRAPH

ON/OFF

Read requests for all objects in a single Graph will be serialized on one read task.
See the description of the parameter OneThreadForGraph.

PG_ReorganizeSlice
PG_REORGANIZE_SLICE

0-2

The parameter determines how time slices on the PostgreSQL platform will be reorganized (VACUUM/VACUUM FULL/CLUSTER).
See the description of the parameter PG_ReorganizeSlice.

PG_ReorgSliceTime
PG_REORGSLICE_TIME

seconds

The parameter defines a time interval after which previous time slices will be reorganized on the PostgreSQL platform.
See the description of the parameter PG_ReorgSliceTime.

PG_TrezorFileMulti
PG_TREZORFILEMULTI

number

The parameter defines a multiplicator for the CommitCount parameter if also the PG_TrezorFilePath parameter is specified.
See the description of the parameter PG_TrezorFileMulti.

RecalcImmediateDepth
RECALC_IMMEDIATE_DEPTH

seconds/OFF

Time depth of the recalcs of computed historical values, which are performed by main archive tasks.
See the description of the parameter RecalcImmediateDepth.

RecalcOptimize
RECALC_OPTIMIZE

ON/OFF

Parameter zapína optimalizáciu prepočtu intervalu hodnôt.
See the description of the parameter RecalcOptimize

RecalcParallelInterval
RECALC_PARALLEL_INTERVAL

seconds/OFF

The parameter defines a minimum size of recalculated time interval intended for parallelization.
See the description of the parameter RecalcParallelInterval.

RecalcTimeIntervalLimit
RECALC_TIME_INTERVAL_LIMIT

hours/OFF

The parameter defines a limit for the time interval for recalculation of statistics and evaluated archives.
See the description of the parameter RecalcTimeIntervalLimit.

RecalcUseTrezor
RECALC_USE_TREZOR

ON/OFF

The parameter defines whether the archive will read also data from the depository databases during recalculations.
See the description of the parameter RecalcUseTrezor.

ReadTimeBeforeStart
READ_TIME_BEFORE_START

seconds/OFF

The parameter shifts the start time of reading from the archive by the specified number of seconds so that the last value before the start of the specified interval can be found within one reading.
See the description of the parameter ReadTimeBeforeStart.

ReorganizeOffset
REORGANIZE_OFFSET

hh:mi

An offset of the periodic reorganization starts in the given period.
See the description of the parameter ReorganizeOffset.

ReorganizePeriode
REORGANIZE_PERIODE

hours

The parameter specifies the period of periodic reorganization in hours.
See the description of the parameter ReorganizePeriode.

ReorganizeTableRowLimit
REORGANIZE_TABLE_ROW_LIMIT

rows

The parameter defines the number of deleted rows after which an automatic reorganization of an archive table is performed.
See the description of the parameter ReorganizeTableRowLimit.

ReorganizeTableTimeLimit
REORGANIZE_TABLE_TIME_LIMIT

hours

The parameter defines the minimum time interval between two automatic reorganizations of an archive table.
See the description of the parameter ReorganizeTableTimeLimit.

ReportLongRecalc
REPORT_LONG_RECALC

seconds/OFF

The parameter activates the logging of recalcs of intervals greater than the specified number of seconds.
See the description of the parameter ReportLongRecalc.

SystemLogging
SYSTEM_LOGGING

ON/OFF

The parameter activates the logging of information on completed recalcs in the log database.
See the description of the parameter SystemLogging.

Tablespace_Name
TABLESPACE_NAME

name_of_tablespace

The parameter defines the name of the archive tablespace (only on the Oracle platform).
See the description of the parameter Tablespace_Name.

TrezorCompress
TREZOR_COMPRESS

ON/OFF

The parameter activates depository data compression.
See the description of the parameter TrezorCompress.

TrezorCompressKeep
TREZOR_COMPRESS_KEEP

ON/OFF

The parameter is used to test depository data compression.

See the description of the parameter TrezorCompressKeep.

TrezorCompressReorg
TREZOR_COMPRESS_REORG

ON/OFF

The parameter activates the reorganization of the depository data before depository data compression
See the description of the parameter TrezorCompressReorg.

TrezorCompressCmt
TREZOR_COMPRESS_CMT

positive integer number

The parameter specifies the number of archive objects after the compression of which a COMMIT will be executed.
See the description of the parameter TrezorCompressCmt.

TrezorCompressOrder
TREZOR_COMPRESS_ORDER

ON/OFF

The parameter indicates whether time sorting is required when reading data from a compressed depository.
See the description of the parameter TrezorCompressOrder.

TrezorReadSegment0
TREZOR_READ_SEGMENT0

ON/OFF

The parameter causes D2000 Archiv to read also from depository segment 0 when reading from any other depository segment.
See the description of the parameter TrezorReadSegment0.

TrezorReadSinceCreate
TREZOR_READ_SINCE_CREATE

ON/OFF

The parameter causes the depositories that are older than Create Time of historical value not to be read.
See the description of the parameter TrezorReadSinceCreate.

Kotva

	watch_old_vals
	watch_old_vals

WATCH_OLD_VALS

"dd-mm-yyyy hh-mi-ss"

OFF

Activation of monitoring of primary values that are older than the specified parameter. The following are monitored:

object values
values that come as old values (OLDVAL)
values entered or changed in HI
values inserted through INSERTARCHARR and UPDATEARCHVAL actions

Monitoring is deactivated by the OFF parameter.

WorkingHoursStart
WORKING_HOURS_START

non-negative integer number

The parameter defines an hour marking the beginning of working hours, during which time-consuming archive operations are minimized.
See the description of the parameter WorkingHoursStart.

WorkingHoursEnd
WORKING_HOURS_END

non-negative integer number

The parameter defines an hour marking the end of working hours, during which time-consuming archive operations are minimized.
See the description of the parameter WorkingHoursEnd.

Note: For parameters that are stored in the Registry database the SET_OPTION command will change the value of configuration parameters not only in the archive but also in the Registry database.

Kotva

	show_dyn_info_archiv
	show_dyn_info_archiv

SHOW_DYN_INFO HOBJ/name [ROW [COL]]

Shows dynamic information on the specified object (current value, last sent value, time of next calculation for periodically archived objects, time of periodic deleting, parameters, and content of cache) on the text console of the D2000 Archiv process.

Note: The command is mainly intended for D2000 system diagnostic purposes.

Kotva

	show_cache
	show_cache

SHOW_CACHE count

If the archive cache is enabled, the result is a list of top count historical values having the most values in the archive cache.
For every value, the following properties are displayed: HOBJ, name, number of items, and time interval of values in the archive cache.

Kotva

	show_config_arc
	show_config_arc

SHOW_CONFIG

Shows configuration information of the process D2000 Archiv and archive database.
This information covers:

start parameters of the process specified in the configuration of the archive process (if the archive process is run by process D2000 Server), or archive service (if the archive process is run by its own watchdog), or command-line parameters (if the archive process is run manually),
parameters for archive specified in Windows registry,
parameters stored directly in the archive database in the LOG_DATA table (see the parameter /CLD of arcsynchro utility),
specific parameters of the database (currently only for the Oracle platform).

Note: By comparing information, obtained by this TELL command, it is possible to find out whether the redundant archives are configured identically or if any parameter was omitted during the migration of archive, database, etc.

Kotva

	show_info
	show_info

SHOW_INFO

Shows various information about the D2000 Archiv process and the archive database.

Kotva

	statistics
	statistics

STATISTICS path+filename hours

Creates the file path+filename with statistical information, i.e. number of values for individual historical values from the last n-hours.
The path+filename file will be created by the D2000 Archiv process, so its naming is OS-dependent (e.g. D:\stat.txt on Windows, /tmp/stat.txt on Linux).

Kotva

	arc_stdout
	arc_stdout

STDOUT output

The command redirects the standard output to a new output.

Example:
D2000 on OpenVMS platform: STDOUT "_TNA2:" (output is redirected to the terminal _TNA2:)
D2000 on Windows platform: STDOUT C:\output.txt (output is redirected to the file output.txt)
Note: If a D2000 process is running on the Windows platform as a service, the console output is disabled. Therefore if this functionality is required, it is necessary for a D2000 process to be started by D2000 Server without /X parameter.

Kotva

	stop_import_data
	stop_import_data

STOP_IMPORT_DATA

Deactivates a feature of the process D2000 - import of external data.

STOP [NOQUEUE]

Stops the process D2000 Archiv. All unsaved values from the request queue are to be automatically stored on the disk and during the next start of the process, the values will be read from the disk. The current values of historical values are to be stored in the table SAVED_LAST_ROWS to quicken the next start of the process.
If the NOQUEUE parameter is used, the unsaved values from the request queue will not be stored in the file (it speeds up stopping the process with a large number of unprocessed values).

TIMESTAT START
TIMESTAT RESTART
TIMESTAT SHOW
TIMESTAT SHOWLONG
TIMESTAT SHOWSTART
TIMESTAT STOP

Starts (START), stops (STOP), restarts (RESTART), shows (SHOW), shows and restarts (SHOWSTART) or shows the time statistics of reading task(s) in long time format, including the days (SHOWLONG). After starting the statistics, the database reading task(s) will start the measuring time, spent in various parts of the reading procedure. These values can be used for tuning by system specialists. Time statistics are displayed per reading task and if ReadThreadsCount > 1, also totals for all read tasks are shown.
Note: When time statistics are on, reading from the archive may be several per cent slower due to time measuring.

Kotva

	trezorcompress
	trezorcompress

TREZOR COMPRESS Id [SEGMENT seg]

PostgreSQL platform: The command is used to compress the data of existing depository databases. See the Depository Data Compression chapter for more information.

The Id parameter specifies the number of a depository database whose data is to be compressed. The SEGMENT seg parameter, where seg is the number of the depository database segment (between 0 and TrezorCountSegments), allows you to compress a specific depository segment if depository segment creation is enabled.
Note: The compression of a depository is possible if it is mounted for writing (see MOUNT_TREZOR command with WRITE parameter).

Kotva

	trezordecompress
	trezordecompress

TREZOR DEMPRESS Id [SEGMENT seg]

PostgreSQL platform: The command is used to decompress the data of existing depository databases. See the Depository Data Compression chapter for more information.

The Id parameter specifies the number of a depository database whose data is to be decompressed. The SEGMENT seg parameter, where seg is the number of the depository database segment (between 0 and TrezorCountSegments), allows you to compress a specific depository segment if depository segment creation is enabled.
Note: The decompression of a depository is possible if it is mounted for writing (see MOUNT_TREZOR command with WRITE parameter).

...

Strom stránky

Porovnávané verzie

Stará verzia 68

Nová verzia 69

Kľúč