Porovnávané verzie

Kľúč

  • Tento riadok sa pridal
  • Riadok je odstránený.
  • Formátovanie sa zmenilo.

...

Kotva
audit_info
audit_info
AUDIT_INFO [REINIT [USER|RESGROUP]]
The process command without parameters writes out the status of monitoring , or storing of auditing information (see also Object Group - monitoring changes in configuration).
Parameter REINIT USERS causes the writing of the current configuration of all objects of *User* type into the monitoring database.
Parameter REINIT RES_GROUP causes the writing of the current configuration of necessary objects of *Object group* type into the monitoring database.
In any object type is not stated in the command, both type types of objects will be written into the monitoring database.
BACKUP SYSCFG pathCreates a configuration database backup in a directory specified by the parameter paththe path parameter (Sybase SQL Anywhere and PostgreSQL platforms).
Note 1: The backup can be influenced by the setting of parameter of ConfigBackUpTimeout parameter.Note 2: This functionality can not be used for databases built on PostgreSQL. Such databases can be backed up according to this instruction.
BACKUP LOGFILE pathCreates a log database backup in the directory specified by the parameter path.
Note 1: This functionality can not be used for databases built on PostgreSQL. Such databases can be backed up according to this instruction.
BACKUP VALUES pathCreates the backup of the database VALUES. DB in the directory specified by the parameter path.by the path parameter (Sybase SQL Anywhere and PostgreSQL platforms). 
CFGSYNCHROAUTO ON/OFFEnables/disables the automatic synchronisation synchronization of configuration databases after a new SBS (stand-by standby server) is connected.

Note 1: The command can be applied to the HOT server only.
Note 2: The synchronization can be influenced by the setting of the parameter ConfigSynchroTimeout.
CHECK_ARCHIVEChecks a value type consistency between the primary archive object and the archival archive one and shows the errors (writes it into the log). The error is , if the value type of the primary archive object is different than from the value type of the archival objecthistorical value.
Kotva
deploy_java_shared
deploy_java_shared
DEPLOY_JAVA_SHARED

If some files - the external and user libraries for Java, placed in directory %lt;appldirgt;/java/shared are changed, the D2000 Server will send these files to all running clients.

DI ON/OFF

DI /E+dbginfo

DI /E-dbginfo

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

The command allows show/hide viewing debug information by category as the SysConsole user interface allows.

Example 1: Show debug information

DI /E+DBG.CFG_RQ

Example 2: Hide debug information

DI /E-DBG.CFG_RQ

DP ON/OFFDebug Pipe - enables/disables the displaying of the communication of the D2000 Server with client processes (only if the D2000 Server's window is displayed on the desktop).
INSTANCE SET|GET ACTIVE|PREFERRED|USABLE ...

It is used to determine and set the active instance, preferred instance, and instance mode in a load-balancing mode.

INSTANCE GET PREFERRED process_nameShows the number of the preferred process instance.
Kotva
set_pref_inst
set_pref_inst
INSTANCE SET PREFERRED process_name instance_number

Sets a preferred process instance.
It is used to set the preferred archive if the archives run as an instance (for more information see the chapter Redundant archiving). By default, the instance with a minimal number is active.
This parameter can be used also for setting up the D2000 KOM process (for more information see the chapter Redundancy of communication process KOM).

The command writes the number of the preferred instance into the system registers:

HKEY_LOCAL_MACHINE\Software\Ipesoft\D2000V70\cfg_Meno_Aplikacie\Kernel\SELF.ARC_PreferredActiveInstance

Warning: If the preferred value is 0, the process instances are not switched actively while the terminated active instance is started. I.e. when some active instance is finished, other another existing instance will be a new active instance. If there are more process instances, the active one will be that with the minimum instance number. This process instance remains active even if other another one is started (it had to be active before termination).

Incorrect termination of the active and preferred instances may change the preferred process instance. If the active instance crashes while other another instance is operating, it becomes a new preferred active instance (with the minimum number).

INSTANCE GET ACTIVE process_nameEnables to display of the number of the active process instance.
Kotva
set_act_inst
set_act_inst
INSTANCE SET ACTIVE process_name instance_number

Sets the active instance of a given process.
The parameter is used for setting up the active instance of the archive process , if all the instances are running as instances (for more information see the chapter Redundant archiving). By default, the instance with a minimal instance number is active.
This parameter can be used also for setting up the D2000 KOM process (for more information see the chapter Redundancy of communication process KOM).

The command switches the active instance of the process.

INSTANCE GET USABLE process_name instance_numberEnables to display '1' if a process of a given instance is active in load-balancing mode. If not, then '0'.
Kotva
set_inst_usable
set_inst_usable
INSTANCE SET USABLE process_name instance_number 1|0
Sets the instance of the process as active or passive in Load balancing mode (see the chapter Redundant archiving - Load balancing).


MESSAGE Message_Text process_nameBroadcasts (sends) a text message to client processes. The process name can be entered as a mask (e.g. *.HIP - for all processes D2000 HI). If the return code is Success, it contains the number of clients, and the message from the D2000 Server was sent to.
LIC_PostponeLicWrnToUsers
0 až 240 [hod], default 24
Delay of license warnings for common users. The administrators of D2000 will get the license warning always and immediately.
LIC_DoNotAllowConsoleOverLimit
0|1, default 0
When setting 1, the system will not allow to connect connecting consoles (HI) over the scope of the license.
LIC_DoNotAllowSysProcOverLimit
0|1, default 0
When setting 1, the system will not allow the system processes (CALC, EVENT, KOM,...) over the scope of the license.
RD_SET_HOT serverNameSets the hot HOT server in the redundant system. The parameter serverName is the name of the server within the frame of the redundant group.
Kotva
refresh_licence
refresh_licence
REFRESH_LICENCE
On-line refresh of the information about the licence license range (from file LicenceRun.code or LicenceDev.code) and information about the network clients (from file ConsolesInfo.txt). It enables to change changing the licence license range without any need to stop the system - as well as re-reading the list of network clients after it has been manually edited.

Note 1: In redundant systems, it is necessary to replace the files LicenceRun.code or LicenceDev.code on all redundant servers.
Note 2: In redundant systems, it is necessary to modify the file ConsolesInfo.txt only on the active (HOT) server. The changes will be transferred to all SBS servers.
Note 3:
The information about the licence license is sent to the client processes when connecting to D2000 Server. For that reason, if the change of licence license affects even other processes than D2000 Server, they must be restarted. For example, when a user add adds a new communication protocol, it influences the D2000 CNF process. To enable this protocol in D2000 CNF, it must be restarted. Also, when adding a new communication station and I/O tags with the given protocol to the D2000 KOM process, it must be restarted.
RELOAD_PARAMSLoads Reloads all parameters for kernel D2000 Server (except the parameters for saving the monitoring database to the depository). The D2000 System may not be restarted) from the registry (Windows) or from the configuration file (Linux) without restarting the D2000 system.
RELOAD_SECURITYSets the new configuration of Security Policy with no need to restart without restarting the D2000 System.
REPAIR_ARCHIVEChecks a the consistency of value type consistency between primary archive the object and archival onebeing archived and the historical value. If some error occurs, it will repair it be repaired immediately and write information will be written into the log. The error is if the value type of the primary archive object being archived is different than from the value type of the archival objecthistorical value.

Kotva
repository
repository
REPOSITORY INIT [path]

Initialize the path to the repository. If the directory does not exist, a new one will be created. If there is a repository on a given path, this one will be used for storing object history. History capturing must be disabled.

REPOSITORY DISCONNECT

Remove the setup path to the repository. History capturing must be disabled.

REPOSITORY ON|OFF

Enable/disable history capturing. A path to the repository must be set. 

RESTART process_nameRESTART process_nameStops the given process and then starts it correctly.

Note: If the process is stopped (Stop or Crash status), the command just starts it.

Kotva
set_load_bal_mode
set_load_bal_mode
SET_LOAD_BAL_MODE
process_name mode
Activates/deactivates Load balancing mode (see the chapter Redundant archiving - Load balancing).

Example:
SET_LOAD_BAL_MODE SELF.ARC 1 - activates Load balancing mode for SELF.ARC process.
Kotva
show_access_list
show_access_list
SHOW_ACCESS_LIST

The command writes the list of the names registered by the GETACCESS action GETACCESS within the application (with the keyword PUBLIC) into the text console and to the log file (kernel.log) of the process D2000 Server process.
The list contains the owner of register the registered name as follows:
computer_name;process_name;event_name/activepicture_name

Example:
ACCESS LIST BEGIN
GETACCESS : "RegisteredName" is locked by : ComputerName;SELF.EVH;E.EventName
GETACCESS : "RegisteredName2" is locked by : ComputerName;ComputerName.HIP;S.PictureName
ACCESS LIST END

SHOW_ARC_STAT
process_name
Shows the statistical information about the running instances of the archive - the maximum number and sum of the read requests that are being processed.
Kotva
show_config
show_config
SHOW_CONFIG
Shows configuration information of the process D2000 Server.
This information covers:
  • start parameters of process D2000 Server,
  • configuration parameters of D2000 system installation common for all applications,
  • parameters of process D2000 Server specified in Windows registry (specific for running application),
  • in redundant systems parameters of redundancy specified in Windows registry (specific for running application),
  • parameters specific for ODBC and OCI versions of process D2000 Server.
  • detailed information on the number and structure of the tags
    For Structured Variables: Object Name; the number of tags; the number of tags according to the methodology into the version D2000 V11
    ;D2RECORD;SV.DaE_Export_Head; 0; 11
    For Structured Eval Tags: Object Name; the number of tags;
    ;CLC_VAL Struct;P.TASK_SUM_Pending; 13

    Summary information on the contribution to the total number of tags for each object types:
    Number of tags for structured variables from V11 and to V11
    ;D2RECORD;Summary V11+; 9126
    ;D2RECORD;Summary OLD; 49044

    Number of tags for structured eval tags
    ;CLC_VAL Struct;Summary; 314

    Number of tags for eval variables
    ;CLC_VAL;; 98
    Number of tags for I/O tags
    ;POINT;; 25
    Number of tags for user variables
    ;USER_VAR;; 2095
    Number of tags for remote objects
    ;REM_OBJ;; 2
    The total number of application tags
    ;TOTAL TAGS;; 11510

Note: By comparing the information, obtained by this tell commandTELL command, it is possible to find out whether D2000 Server processes in a redundant group are configured identically, resp. if any parameter was omitted during the migration of the application server.
Kotva
show_dyn_info
show_dyn_info
SHOW_DYN_INFO object_name or HOBJ

Shows dynamic information on the specified object (list of objects that dynamically or statically use the object) on the text console of the process D2000 Server process.

Note:
The command is intended to be used mainly for the D2000 System system diagnostic purposes.

SHOW_DYNO_LIST idFirst idLastThe command dumps the list of current dynamic objects (ID and object name) to the text console of the process based on the defined interval.

Note: The command is mainly intended for diagnostic purposes.
SHOW_TRANS_LISTLists internal transactions of the D2000 system.

Note: The command is intended to be used mainly for the D2000 System diagnostic purposes.

SHUTDOWN D2000Stops the D2000 Systemsystem.
SHUTDOWN RESTART_D2000Restarts the D2000 system.
SHUTDOWN RESTARTStops the D2000 system Stops D2000 System and restarts the operating system.
SHUTDOWN SHUTDOWNStop the D2000 system and shutdown shutdowns the operating system.
SHUTDOWN WINNTStops D2000 System and restarts the operating system.
START process_nameStarts the specified process.
STDOUT outputThe command redirects the standard output to a new output specified by 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 run on the Windows platform as a service, the console output is disabled.

STOP process_name [FORCE]It stops a process. When using the optional parameter FORCE, the termination of the process will be forced.
*SUSPEND* SLEEP [WAKEUP yyyy-mm-ddThh:mi:ssZ]|HIBERNATEIt causes , that the operating system switches to switch into sleep mode (SLEEP) or hibernation (HIBERNATE). If the OS switches into sleep mode, the user may define a time of its automatic awakening by the parameter WAKEUP yyyy-mm-ddThh:mi:ssZ, where yyyy-mm-ddThh:mi:ssZ defines UTC time of awakening. The string must be in ISO 8601 format (http://sk.wikipedia.org/wiki/ISO_8601).

Example: *SUSPEND SLEEP WAKEUP 2015-02-11T12:00Z* - causes putting the computer to sleep and automatic awakening at noon, February 11th, 2015 (UTC).
Kotva
tcp_no_delay
tcp_no_delay
TCP_NO_DELAY process_name|process_mask [FALSE|TRUE|QUERY]
EnablesIt enables, disables, or queries the delay of data transfer between the process D2000 Server process and the client connected via TCP/IP protocol. Setting the parameter TCP_NO_DELAY to TRUE disables TCP delay before sending TCP packets (setsockopt function setsockopt with parameter TCP_NODELAY - see Nagle's algorithm). The delay improves the efficiency of TCP/IP networks by reducing the number of packets that need to be sent over the network. On the other hand, if the communicating partners wait for each other's response (e.g. remote procedure calls between two EVENT processes or between HI and EVENT), this delay can significantly slow down the execution of scripts and other interactions.
By default, TCP delay is on (TCP_NO_DELAY = FALSE).
This tell command TELL command is intended only for tuning and debugging purposes.

Note 1: When registering a TCP/IP client, the process D2000 Server queries the value of parameter TCP_NO_DELAY, and, depending on this value, it does or does not change the parameter TCP_NO_DELAY for client connection. This value is then sent to the client, which also changes the TCP_NODELAY parameter of its TCP connection to the server.
Warning: In the current implementation, the tell command TCP_NO_DELAY command does not cause any change in the setting on the client's side!
Note 2: Besides the parameter TCP_NO_DELAY parameter, there is also another parameter which that influences sending TCP delayed acknowledgments acknowledgements (it can be set on OpenVMS and *nix system by calling sysconfig -r inet tcpnodelack). This parameter induces a 200 ms delay before sending TCP acknowledgments acknowledgements and it can interact with the TCP_NODELAY parameter.
Kotva
xml_export0
xml_export0
XML_EXPORT
Warning: Since the version V8.00.001, the command is not supported.

XML file(s) export from the directory, which is defined by the parameter path, together with the following parameters:

  • Path –  defines the directory where the objects will be exported; required parameter.
    It must contain the complete path, e.g. c:\XML. The path must exist. If it does not exist, the export is not allowed.
    Instead of a fixed path, the user can select the default directory - by entering the value "*" into the parameter.
    The default directory is placed in "[APP_DIR]\XML_EXPORT", where APP_DIR defines the application directory, e.g. c:\D2000\D2000.APP\application_name\XML_EXPORT" ".
  • Mask – defines the mask, which correspond corresponds to the list of objects that are to be exported; the required parameter.
  • optional settings of XML_SETTINGS

The path for the file export on VMS must be written in Unix format.

Correct syntax: /DKB0/d2000/d2000-app/RIS_ROVE/XML/ mask
Incorrect syntax: DKB0:[d2000.d2000-app.RIS_ROVE.XML] mask - this syntax is not supported, export ends with an error.

Kotva
xml_export_table
xml_export_table
XML_EXPORT_TABLE 
The configuration parts export exported to the XML files, which is not the part of the object configuration.
The parameters: [Path, FileName, TableName].
  • Path - defines the path for saving the configuration.
  • FileName - defines the name of the output file. E.g. for the file "systemtxt" file, there is created the a file with the name "systemtxt.xml" is created.
  • TableName - defines the table of the database, from which the configuration is to be exported from.
    TableName can acquire the following values: SYS_COLORS, SYSTEM_TEXT, TRANS_MASKA, DICTIONARY, LANGUAGES, LOGDEF, NAME_RULES.

Warning: Extension ".xml" is added automatically, do not write explicitly specify it.

Kotva
xml_import0
xml_import0
XML_IMPORT
Warning: This command is not supported for OpenVMS.

XML file(s) import from the directory, which is defined by the parameter Path.
The parameter:[ of a specific file or of all XML files from specified directory, depending on path_to_dir / path_to_file]file parameter:

path_to_dir - directory name with XML files (eg D:\temp). Note - the directory is searched for xml files recursively.

path_to_file - absolute path to the XML file (eg D:\temp\H.Sec.xml)

For this TELL command to be executed, a configuration key must be present!The initialization of tell command is conditioned by using a configuration key.

The path for the file import on VMS should be entered in Unix format.
Correct syntax: /DKB0/d2000/d2000-app/RIS_ROVE/XML/
Incorrect syntax: DKB0:[d2000.d2000-app.RIS_ROVE.XML] - this syntax is not supported, import of directory containing XML files ends with an error

The import of one file supports the both records:
Correct syntax: /DKB0/d2000/d2000-app/RIS_ROVE/XML/file.xml
Correct syntax: DKB0:[d2000.d2000-app.RIS_ROVE.XML]file.xml

Note: The command belongs to the "security" TELL commands. I.e., it can be activated only from interactive processes with configuration key or from process D2000 Event Handler.

Kotva
xml_import_table
xml_import_table
XML_IMPORT_TABLE
Import of the configuration parts that is are not the part of the object configuration from XML files.
The parameter [Path, FileName, TableName[, CleanTable]]
  • Path - defines the path from which the configuration will be read.
  • FileName - defines the name of the input file without xml XML extension. For example, "systemtxt" for the file with the name "systemtxt.xml".
  • TableName - defines the table of the database to which the configuration is to be imported.
    TableName can acquire the following values: SYS_COLORS, SYSTEM_TEXT, TRANS_MASKA, DICTIONARY, LANGUAGES, LOGDEF, NAME_RULES.
  • CleanTable - defines whether the table in the database will be cleaned before import.
    This parameter is optional, the default value is FALSE.
    Parameter The parameter can acquire two values: TRUE - clean table, FALSE - the table is updated.

The initialization of tell the TELL command is conditioned by using the configuration key.

Note: The command belongs to the "security" TELL commands. I.e., it can be activated only from interactive processes with configuration key or from process D2000 Event Handler.

Kotva
xml_settings
xml_settings
XML_SETTINGS
Warning: Since the version V8.00.001, the command is not supported.

Sets the parameters for TELL commands XML_IMPORT a and XML_EXPORT commands.

The command without parameter displays the default parameters of the D2000 Server.

Kotva
xml_update
xml_update
XML_Update
Partial update of the objects by XML from the directory, which is defined by parameter Path.
The parameter:
[path_to_dir / path_to_file]

Note: The command belongs to the "security" TELL commands. I.e., it can be activated only from interactive processes with configuration key or from process D2000 Event Handler.

...

remempty_slicesremempty_slicesREM_EMPTY_SLICES HOBJ|maskIf the time slices are activated, the command causes that archive will review all time slices of simple archive objects according to the defined HOBJ or mask and deletes the time slices without data.
purify from empty time slices that were created due to error of archive. This error was repaired in the supported versions in June 8, 2015.REORGANIZE REORGANIZE HOBJ|mask [SLICE slice] [tablespace]

On-line reorganization of archive table of object with specified HOBJ or with name matching specified mask. If the parameter tablespace is also defined, given archive table will be moved to 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 platform 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"
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 value of the parameter MaxCacheSize in registry.SET_OPTION
name_parameter
value_parameterTell command SET_OPTION controls the following configuration and start-up parameters of the process D2000 Archiv:READ_ARCHIVE_DEPTH"dd-mm-yyyy hh-mi-ss"
OFF

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

SHOW_DYN_INFO HOBJ/name [ROW [COL]]SHOW_CACHE countSHOW_CONFIGSHOW_INFOSTDOUT output STOP_IMPORT_DATA
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 archive the RecalcImmediateDepth archive parameter RecalcImmediateDepth), and then instead of being performed, they were stored to the file (see the DropOldRequests archive parameter DropOldRequests). 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 DataTableSlices from value 1 to value 2 (i.e. after changing the time slices mode to time slices for structured archives only).
Archive 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 the archiv archive till the transfer of archived values to the original data tables, the archiv 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

identity

in instance archives. Creating the file with a CRC (checking sum) for archive objects that correspond to the mask for the entered time period.

Optional

The optional parameter step (in hours) allows

to divide

dividing the calculation for time period into intervals.
The PO parameter

PO

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 identity 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.
Optional The optional parameter step (in hours) allows to divide 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/OFFDebug Info - shows/hides internal debug information of the process D2000 Archiv process (in the process window and in the process 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.
Name 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 to dismount dismounting a sequence of depository databases.
The parameter SEGMENT seg (where seg is the number of of depository database segment) allows to dismount dismounting just the segment. Seg is the number between 0 and TrezorCountSegments. If the command DISMOUNT_TREZOR command is used without the parameter 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 Id defines the number of depository database 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 to dismount dismounting a sequence of depository databases.
The parameter SEGMENT seg (where seg is the number of of depository database segment) allows to dismount dismounting just the segment. Seg is the number between 0 and TrezorCountSegments. If the command DISMOUNT is _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/OFFDebug Pipe - shows/hides the course of communication with D2000 Server (only if the process window is displayed on the desktop).
DROP_LIST path+filenameCreates 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, the next another task (deleting) will list the number of requests (primary and calculated) in the queues. After the elapsing of the time freeze_seconds time, the processing of values will be restored. If the parameter the report_seconds parameter is entered, the deleting task continues to list the number of request 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 usinguse, 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 period freeze_secondsseconds period. In the redundant systems with 2 and more archives, we recommend to execute 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 an inactivity that was caused by the FREEZE command.
Kotva
import_data
import_data
IMPORT_DATA
Activates the process D2000 Archiv process to import external data, e.g. Importing archive databases from D2000 V3.65 (OS/2).
Kotva
list_trezor
list_trezor
LIST_TREZOR
[all]
LIST_TREZOR id
The parameter allows to shows showing the list of depository databases used by the process D2000 Archiv. The contents of the list depends depend on the used platform - Sybase, PostgreSQL, or Oracle.
Parameter id:
LOAD_TREZOR path+filename [mask] [from] [to]On-line line depository database import. (Sybase only)
Kotva
mount_trezor0
mount_trezor0
MOUNT_TREZOR path+trezor_name
Sybase platform: The parameter 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.
Name 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 parameters IdFrom and IdTo parametersallow to mount the mounting a sequence of depository databases.
The parameter The SEGMENT Seg parameter (where Seg is the number of the the depository database segment) allows to mount on just one mounting a single depository database segment. If the MOUNT_TREZOR command MOUNT is used without the parameter 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 databases 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 to mount on just one mounting a single depository database segment. If the MOUNT_TREZOR command MOUNT is used without the parameter 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 databases database synchronization through the Arcsynchro tool).

For more information see the topic On-line access to data from depository databases.
OPTIMIZE_QUEUEReduction 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 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  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 (implemented in version 7.02.006) puts the recalculation to the auxiliary calc task (see the archive parameter RecalcImmediateDepth). The parameter is recommended for long-lasting recalculation of historical values which that are supposed to be performed on 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 behaviour behavior is stated implemented as a protection against overloading the main task by recalculations.

Kotva
release_trezor
release_trezor
RELEASE_TREZOR

Early 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

Kotva
reorganizereorganizeOn-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).

Note: For Oracle, PostgreSQL and Sybase 8.0 platforms or later only.

Kotva
reorganize_slicereorganize_slice
REORGANIZE ONEnables the reorganization of archive database (same as running the process D2000 Archiv with the /DBCY parameter).
REORGANIZE OFFEnables the reorganization of archive database (same as running the process D2000 Archiv without the /DBCY parameter).
REORGANIZE ACTIVEEnables the reorganization of archive database in the active mode only (same as running the process D2000 Archiv with the /DBCA parameter).
REORGANIZE PASSIVEEnables the reorganization of archive database in the passive mode only (same as running the process D2000 Archiv with the /DBCP parameter).
REORGANIZE SHRINKEnables the alternate mode of reorganization of 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 tell command REORGANIZE MOVE.
REORGANIZE TableRowLimit rowLimitOn-line change of the parameter ReorganizeTableRowLimit used for the automatic reorganization of archive database.
REORGANIZE TableTimeLimit timeLimitOn-line change of the parameter ReorganizeTableTimeLimit used for the automatic reorganization of archive database.
Kotva
set_cacheset_cache
Kotva
set_optionset_option
name_parametervalue_parameterdescription

AlmostZero
ALMOST_ZERO

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

See description of the parameter AlmostZero.
CommitCountActive
COMMIT_COUNT_ACTIVE
positive numberSee description of the parameter CommitCountActive.
CommitCountPassive
COMMIT_COUNT_PASSIVE
positive numberSee description of the parameter CommitCountPassive.
CommitTimeActive
COMMIT_TIME_ACTIVE
positive numberSee description of the parameter CommitTimeActive.
CommitTimePassive
COMMIT_TIME_PASSIVE
positive numberSee description of the parameter CommitTimePassive.
DBPOON/OFFOnly primary data processing.
RXON/OFFNo delete.
ROON/OFFRead only.
RSON/OFF>Backup by copying.
DBRTON/OFFCalculation of the computed historical values in real time.
Kotva
read_archive_depthread_archive_depthLimitation of the reading depth from the archive.

If the saving to the depository is ON the older data 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/OFFSee description of the parameter DiskUsageWarning.
DropOldRequests
DROP_OLD_REQUESTS
ON/OFFSee description of the parameter DropOldRequests.
IsochronousCache
ISOCHRONOUS_CACHE
ON/OFFSee description of the parameter IsochronousCache.
IsoCacheFullDepth
ISOCACHE_FULL_DEPTH
ON/OFFSee description of the parameter IsoCacheFullDepth.

IsoCacheDepth
ISOCACHE_DEPTH

positive number (seconds)

See description of the parameter IsoCacheDepth.
OldValIgnoreAgepositive number (hours)See description of the parameter OldValIgnoreAge.
OldValOnAuxTask
OLD_VAL_ON_AUX_TASK
ON/OFFSee description of the parameter OldValOnAuxTask.
OneThreadForGraph
ONE_THREAD_FOR_GRAPH
ON/OFFSee description of the parameter OneThreadForGraph.
PG_ReorganizeSlice
PG_REORGANIZE_SLICE
0-2See description of the parameter PG_ReorganizeSlice.
PG_ReorgSliceTime
PG_REORGSLICE_TIME
secondsSee description of the parameter PG_ReorgSliceTime.
PG_TrezorFileMulti
 PG_TREZORFILEMULTI
numberSee description of the parameter PG_TrezorFileMulti.
RecalcImmediateDepth
RECALC_IMMEDIATE_DEPTH
seconds/OFFSee description of the parameter RecalcImmediateDepth.
RecalcParallelInterval
RECALC_PARALLEL_INTERVAL
seconds/OFFSee description of the parameter RecalcParallelInterval.
RecalcTimeIntervalLimit
RECALC_TIME_INTERVAL_LIMIT
hours/OFFSee description of the parameter RecalcTimeIntervalLimit.
RecalcUseTrezor
RECALC_USE_TREZOR
ON/OFFSee description of the parameter RecalcUseTrezor.
ReadTimeBeforeStart
READ_TIME_BEFORE_START
seconds/OFFSee description of the parameter ReadTimeBeforeStart.
ReorganizeOffset
REORGANIZE_OFFSET
hh:miSee description of the parameter ReorganizeOffset.
ReorganizePeriode
REORGANIZE_PERIODE
hoursSee description of the parameter ReorganizePeriode.
ReorganizeTableRowLimit
REORGANIZE_TABLE_ROW_LIMIT
rowsSee description of the parameter ReorganizeTableRowLimit.
ReorganizeTableTimeLimit
REORGANIZE_TABLE_TIME_LIMIT
hoursSee description of the parameter ReorganizeTableTimeLimit.
Tablespace_Name
TABLESPACE_NAME
name_of_tablespaceSee description of the parameter Tablespace_Name (only on Oracle platform).

TrezorReadSegment0
TREZOR_READ_SEGMENT0

ON/OFF

See description of the parameter TrezorReadSegment0.

WorkingHoursStart
WORKING_HOURS_START

non-negative integer number

See description of the parameter WorkingHoursStart.

WorkingHoursEnd
WORKING_HOURS_END

non-negative integer number

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

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

Kotva
show_cacheshow_cacheIf archive cache is enabled, the result is a list of top count historical values having the most values in archive cache.
For every value the following properties are displayed: HOBJ, name, number of items and time interval of values in archive cache.
Kotva
show_config_arcshow_config_arcShows configuration information of the process D2000 Archiv and archive database.
This information covers:
  • start parameters of process specified in the configuration of 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 archive database in LOG_DATA table (see the parameter /CLD of arcsynchro utility),
  • specific parameters of database (currently only for Oracle platform).
Note: By comparing information, obtained by this tell command, there is possible to find out whether the redundant archives are configured identically or if any parameter was omitted during migration of archive, database etc.
Kotva
show_infoshow_infoShows various information about the process D2000 Archiv and the archive database.
STATISTICS path+filename hoursCreates the file path+filename with statistical information, i.e. number of values for individual historical values from the last n-hours.
Kotva
arc_stdoutarc_stdoutThe 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 runing on Windows platform as a service, 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_datastop_import_dataDeactivates 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 starting 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 parameter NOQUEUE is used, the unsaved values from the request queue will not be stored in the file (it quickens stopping the process with a large amount 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 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 tasks are shown.
Note: When time statistics are on, reading from archive may be several percent slower due to time measuring.

...

. 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"


REORGANIZE ONEnables the reorganization of the archive database (same as running the process D2000 Archiv with the /DBCY parameter).
REORGANIZE OFFEnables the reorganization of the archive database (same as running the process D2000 Archiv without the /DBCY parameter).
REORGANIZE ACTIVEEnables the reorganization of the archive database in the active mode only (same as running the process D2000 Archiv with the /DBCA parameter).
REORGANIZE PASSIVEEnables the reorganization of the archive database in the passive mode only (same as running the process D2000 Archiv with the /DBCP parameter).
REORGANIZE SHRINKEnables 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 rowLimitOn-line change of the parameter ReorganizeTableRowLimit is used for the automatic reorganization of the archive database.
REORGANIZE TableTimeLimit timeLimitOn-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_parametervalue_parameterdescription

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
stringSet 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 numberThe 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 numberThe 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 numberInterval 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 numberInterval after which a periodic COMMIT is triggered by a passive D2000 Archiv process (default is 60 s).
See the description of the parameter CommitTimePassive.
DBPOON/OFFOnly primary data processing. Calculations of statistics and evaluated archives will not be performed.
RXON/OFFNo delete. Periodic deletes (for removal of data beyond configured history depth) will not be performed.
ROON/OFFRead-only.
RSON/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/OFFCalling with parameter OFF disables the archive warning about low disk free space.
See the description of the parameter DiskUsageWarning.
DropOldRequests
DROP_OLD_REQUESTS
ON/OFFRequests for recalc of data older than RecalcImmediateDepth will be discarded.
See the description of the parameter DropOldRequests.
IsochronousCache
ISOCHRONOUS_CACHE
ON/OFFActivation of the IsochronousCache.
See the description of the parameter IsochronousCache.
IsoCacheFullDepth
ISOCACHE_FULL_DEPTH
ON/OFFSetting 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.
OldValIgnoreAgea 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/OFFOld 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/OFFRead 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-2The 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
secondsThe 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
numberThe 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/OFFTime depth of the recalcs of computed historical values, which are performed by main archive tasks.
See the description of the parameter RecalcImmediateDepth.
RecalcParallelInterval
RECALC_PARALLEL_INTERVAL
seconds/OFFThe 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/OFFThe 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/OFFThe 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/OFFThe 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:miAn offset of the periodic reorganization starts in the given period.
See the description of the parameter ReorganizeOffset.
ReorganizePeriode
REORGANIZE_PERIODE
hoursPeriodic reorganization period is given in hours.
See the description of the parameter ReorganizePeriode.
ReorganizeTableRowLimit
REORGANIZE_TABLE_ROW_LIMIT
rowsThe 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
hoursThe 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/OFFThe 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/OFFThe 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_tablespaceThe 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/OFFThe 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/OFFThe 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 numberThe 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/OFFThe 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/OFFThe 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).


Kotva
kom
kom
D2000 KOM


DI ON/OFF HOBJ/maskGETOLDVAL StationName [M:PointMask] [NORECALC] "BeginTime" ["EndTime"]Reads historical values from a device - station StationName. The values from defined interval will be read. The parameter EndTime is optional and if is not entered, the current time will be used.
Time format ("BeginTime", "EndTime") is "dd-mm-yyyy hh:mi:ss".
This feature is supported only by some communication protocols (Datalogger ESC8800, ESC8816, UNIP_TS ...).
Warning: This is not a function of KOM Archiv but it is the reading values directly from a device!
NORECALC parameter causes the archive does not execute the calculation of calculated archive objects, the values of which are calculated just from the values acquired by this calling of tell command. For some protocols (OPC DA, OPC HDA and IEC 870-5-104), there can be used a parameter of mask "M:", which is used to read the archive values only for selected I/O tags from the station StationName, which match the mask.

LNSTAT OPEN/CLOSE LineName

Kotva
kom_di
kom_di
DI ON/OFF HOBJ/mask

Debug Info for values - enables/disables displaying information about the evaluation of:
  • I/O tag with specified HOBJ,
  • all I/O tags on the station with specified HOBJ,
  • I/O tags with the name matching the given mask,
  • all I/O tags on the stations with the names matching the given mask.
DP ON/OFFDebug Pipe - shows/hides the course of communication with the D2000 KOM (only if the process window is displayed on the desktop).
GETKOMARCDEPTHGets the timestamp of the oldest data stored in the KOM Archive.
Kotva
getoldval
getoldval
GETOLDVAL StationName [M:PointMask] [NORECALC] "BeginTime" ["EndTime"]
Reads historical values from a device - StationName station. The values from the specified interval will be read. The parameter EndTime is optional and if is not entered, the current time will be used.
Time format ("BeginTime", "EndTime") is "dd-mm-yyyy hh:mi:ss".

This feature is supported only by some communication protocols (Datalogger ESC8800, ESC8816, UNIP_TS ...).
Warning: This is not a function of KOM Archiv but it is the reading values directly from a device!

NORECALC parameter causes the archive to not execute the calculation of calculated archive objects, the values of which are calculated from the values acquired by this calling of a TELL command. For some protocols (OPC DA, OPC HDA, and IEC 870-5-104), a parameter mask "M:" can be used, which is used to read the archive values only for selected I/O tags which match the mask, from the StationName station.

Kotva
lnalterpath
lnalterpath
LNALTERPATH LineName ON|OFF|PRIMARY|BACKUP|QUERY [1|2|3|4]

The command allows switching between the primary (OFF or PRIMARY) and backup (ON or BACKUP) devices for lines of categories "SerialOverUDP Device Redundant", "SerialOverUDP Line Redundant", and "SerialOverUDP System&Line Redundant", or discovering the active device (QUERY). The active device is used to write UDP packets and packets received from it are processed. Data received from the inactive device is ignored.

The third parameter (numbers 1-4) specifies the subline. For a line of category "SerialOverUDP Device Redundant", it need not be specified or must be equal to 1. For a line of category "SerialOverUDP Line Redundant", it can be equal to 1 (the device on the Primary line is set) or 2 (the device on the Secondary line is set). For a "SerialOverUDP System&Line Redundant" category line, it can be equal to 1 - 4 (the device on the Primary/Secondary line of the system A/B is set). If an active device is detected (QUERY) and the third parameter is not entered, all active devices are listed (1, 2, or 4 depending on the line type).

Examples of use:
LNALTERPATH L.MyLine ON 3
LNALTERPATH L.MyLine BACKUP 3
LNALTERPATH L.MyLine QUERY

Kotva
lnstat
lnstat

DEBUGWIN DEBUG/REQ/KOMARCThe Debug window of the process D2000 KOM displays:
  • DEBUG - trace communications with devices (implicit setting),
  • REQ - current processed communication request + requests in queue,
  • KOMARC - trace readings/writings into the archive file of KOM Archiv.
Kotva
kom_dikom_diDebug Info for values - enables / disables displaying information about the evaluation of:
  • I/O tag with specified HOBJ,
  • all I/O tags on the station with specified HOBJ,
  • I/O tags with the name matching given mask,
  • all I/O tags on the stations with the names matching given mask.
DP ON/OFFDebug Pipe - shows / hides the course of communication with D2000 KOM (only if the process window is displayed on the desktop).
GETKOMARCDEPTHGets the timestamp of oldest data stored in the KOM Archive.
Kotva
getoldvalgetoldvalThe command can be used only for the lines of Serial category  (asynchronous serial lines) and RFC2217 Client categories. The command stops the communication (CLOSE) and disconnects the communication port. Then the port can be used by other programs, e.g. diagnostic or configuration tools. Stations on the line are to be in the Communication error state. The communication will be recovered either using the command LNSTAT OPEN or after restarting the whole communication process.
LNTRACE DEC/HEXEnables the decimal/hexadecimal format of line listening. Default The default format is hexadecimal.
READKOMARC ["BeginTime"] ["EndTime"]Reads the values from KOM Archiv. There are transferred all old values from given the specified interval. The parameter BeginTime is optional and if it is not entered, the data from all history depth of KOM Archiv will be read there. The parameter EndTime is optional and if it is not entered, the current time will be used. If the parameters BeginTime and EndTime are not defined, there will be sent just the values, which have not been sent. If at least the parameter BeginTime is defined, there will be sent all values within given interval.

Return codes:

  • SUCCESS - transaction successful, data transfer to the system finished,
  • IGNORED - the process D2000 KOM is not running in the mode of KOM Archiv,
  • ERROR - invalid parameters (time format: dd-mm-yyyy hh:mi:ss), wrong sequence of entered times - BeginTime > EndTime.the specified interval.

    Return codes:

    • SUCCESS - transaction successful, data transfer to the system finished,
    • IGNORED - the process D2000 KOM is not running in the mode of KOM Archiv,
    • ERROR - invalid parameters (time format: dd-mm-yyyy hh:mi:ss), wrong sequence of entered times - BeginTime > EndTime.

    Kotva
    reload
    reload
    RELOAD StationName | StationHOBJ | LineName | LineHOBJ

    The command de-configures the object (line or station) and its descendants (stations, I/O tags) and reloads them. The command can be used to apply configuration changes that would otherwise require restarting the KOM process. The command is currently implemented for protocols:

    Kotva
    resetperf
    resetperf
    RESETPERF LineName/StationName

    Resets the statistics of given line / station - the system structured variable SV._System_LinePerformance / SV._System_LinePerformance. It is executed immediately but it will be visible after the process D2000 KOM sends new statistics to the process D2000 Server (periodically in each every 10 seconds).

    Kotva
    setptaddr
    setptaddr
    SETPTADDR name "address1" "address2"

    Dynamic change of the I/O tag address. The parameter name specifies the I/O tag. It can be entered as the object name (e.g. "M.CoolantTemperature") or the object HOBJ (the syntax requires the character '$' before HOBJ, e.g. "$278"). The parameters address1 and address2 defines define the new I/O tag address.
    Change of address will become evident be performed only in internal data structures of the KOM process. It is not sent, in a centralized way, to the server, i.e. changed address is valid until the restart of the KOM process. After this, the value from the initial configuration will be used again.

    Return codes:

    • SUCCESS - changed address (the value of the I/O tag is invalid till until it is read from the new address).
    • IGNORED - process D2000 KOM process does not support dynamic address change - licence limitationfor the specified protocol.
    • ERROR
      1. duplicate address
      2. point not found
      3. bad address format

    Dynamic change of the I/O tag address is implemented only for a limited group of communication protocols:

    SETSTADDR StationName|StationHOBJ "address"Dynamic change of station address. The first parameter specifies the station. It can be entered as the object name StationName (e.g. "B.Station") or station ID StationHOBJ. Parameter The "address" parameter defines its new address. Change of station address will become evident be performed only in internal data structures of the KOM process. It is not sent, in a centralized way, to the server, i.e. changed address is valid until the restart of the KOM process. After this, the value from the initial configuration will be used again.

    Return codes:

    • SUCCESS - changed address,
    • IGNORED - D2000 KOM does not support a dynamic change of address for given the specified protocol,
    • ERROR
      1. object not found
      2. invalid number of parameters

    Dynamic change of address is implemented only for a limited group of communication protocols:

    SHOW TAG TagName/TagHOBJ
    SHOW NAN
    Enables debug information for given the specified I/O tag. The command requires either the name or HOBJ of the I/O tag. The debug information is usable for D2000 System developers.
    The SHOW NAN command displays all I/O tags whose value (current, last telemetry, or last valid) is NaN (unspecified type).
    SHUTDOWN WINNTRestarts the computer with the process D2000 KOM process (the process must be running).

    Kotva
    stalterpath
    stalterpath
    STALTERPATH name  StationName ON|OFF

    For the Microtel 700 protocol, it explicitly activates (ON) or deactivates (OFF) an alternative communication route for a station named name StationName (e.g., "B.Station").

    Kotva
    start_record
    start_record
    START_RECORD dir_name_only [begin_time] end_time

    Starts a data recording into a subdirectory (application directory) with the name dir_name_only. If the directory does not exist, it will be created.
    The start of tell command from D2000 Server - at firstIf this TELL command is run from the D2000 Server, firstly, the file dodm_values.dat containing the initialization values of DODM objects dodm_values.dat is recorded and then the D2000 Server will send this command to clients.
    Data are recorded within the time period <begin_time, end_time>. If <begin_time> is not set, data are recorded immediately.

    Example:
    Data files, recorded by tell the TELL command:
    START_RECORD DirName "01-12-2008 08:22:27" "01-12-2008 11:02:07"

    These four data files (it relates to four hourly intervals) are the result of recordrecording:
    KOM-SELF_2008_12_01_08.dat < 01-12-2008 08:22:27 ; 01-12-2008 09:00:00 >
    KOM-SELF_2008_12_01_09.dat < 01-12-2008 09:00:00 ; 01-12-2008 10:00:00 >
    KOM-SELF_2008_12_01_10.dat < 01-12-2008 10:00:00 ; 01-12-2008 11:00:00 >
    KOM-SELF_2008_12_01_11.dat < 01-12-2008 11:00:00 ; 01-12-2008 11:02:07 >

    Note: Tell  The TELL command uses the format "dd-mm-rrrr hh:mm:ss" format for the parameters of datetime DateTime type.
    It is possible to start up this tell initialize this TELL command from the D2000 Server, as well as directly from the clients (currently only from KOM clientthe D2000 KOM and Gateway Client processes).
    Data are recorded into chosen the specified subdirectory in the application directory, in the form of data files representing where a separate data file is created for every hourly time period.

    Kotva
    stop_record
    stop_record
    STOP_RECORD

    Stops a data recording immediately, it is not necessary to wait for end_time. If the recording does is not workin progress, the an error will occurbe returned.

    Note: It is possible to start up this tell command TELL command from the D2000 Server, as well as directly from the clients (currently only from KOM clientthe D2000 KOM and Gateway Client processes).

    Kotva
    start_replay
    start_replay
    START_REPLAY dir_name_only [begin_time [/NOW]]
    or
    START_REPLAY dir_name_only /LOOP

    Starts a data replaying from a subdirectory (of application directory) with the name dir_name_only. If the directory does not exist, the an error will occurbe returned.
    The start of tell command from If the command is run from the D2000 Server - at first, the dodm_values.dat file containing the initialization values of DODM objects dodm_values.dat is recorded will be recorded by the D2000 Server, and then the D2000 Server will send this command to the clients with /NOW parameter /NOW.
    It replays all data (in data files) with the time stamp >= begin_time. Time stamp The timestamp of data represents the a particular time from the recorded time period. Time The time of data replaying must be from the range of the recorded time period.

    Example of data replaying:
    Time Stamp (TS) - blue color, current time (CT) - red color

    begin_time/NOWDescription
    nono
    • data are replayed immediately
    • if CT = 02-12-2008 14:11:02, data are replayed from TS >= 01-12-2008 09:11:02
    • if CT = 02-12-2008 14:33:55, data are replayed from TS >= 01-12-2008 08:33:55
    yesno
    • if begin_time = 01-12-2008 08:27:27, data are replayed from time so that this time corresponds with a shift from hour
    • if CT = 02-12-2008 14:11:02, data are replayed from TS >= 01-12-2008 08:27:27, when CT = 02-12-2008 14:27:27
    • if CT = 02-12-2008 14:33:55, data are replayed from TS >= 01-12-2008 08:27:27, when CT = 02-12-2008 15:27:27
    yesyes
    • if begin_time = 01-12-2008 08:27:27, the command finds the nearest time (time stamp) so that data could be replayed immediately
    • if CT = 02-12-2008 14:11:02, data are replayed from TS >= 01-12-2008 09:11:02
    • if CT = 02-12-2008 14:33:55, data are replayed from TS >= 01-12-2008 08:33:55
    In this situation, also data, recorded before TS, are replayed. This data are replayed at the beginning.
    Time Stamp (TS) - blue color, current time (CT) - red color


    If /LOOP is used, data replaying will be again started automatically. It can be stopped by the Tell command STOP_REPLAYREPLAY command.

    Note: Tell  This TELL command uses the format the "dd-mm-rrrr hh:mm:ss" format for the parameters of datetime DateTime type.
    It is possible to start up this tell command TELL command from the D2000 Server, as well as directly from the clients (currently only from KOM client).
    Process The  D2000 KOM process can be started up in replay mode only with the start parameter /Replay. It causes , the process D2000KOM does not to communicate with devices.

    Kotva
    stop_replay
    stop_replay
    STOP_REPLAY

    Stops a data replaying immediately. If the replaying does not work, the error will occur.

    Note: There is possible to start up this tell command TELL command from the D2000 Server, as well as directly from the clients (currently only from KOM client).

    STDOUT outputThe command redirects the standard output to a new one.

    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: See a note for STDOUT command for D2000 Archiv.

    STOPStops the process D2000 KOM process.

    Kotva
    ststat
    ststat
    STSTAT START/STOP StationName

    Enables the communication (the parameter START) or disable disables the communication (parameter STOP) on with the StationName station StationName. The station will get the value StON (START) or StOFF (STOP) value.

    Kotva
    stwatch
    stwatch
    STWATCH StationName ["Number"]

    For protocols based on periodic polling of I/O tags (request-response protocols): the command generates one or several requests for priority reading of all I/O tags on given a specified station. The parameter The Number defines parameter defines the number of requests, possible value is within 1...5. If the parameter is not specified, a single request will be generated.

    For protocols based on sending of changes (change-based protocols): the command generates one or several requests for the reading of all data. The command is implemented for a selected set of communication protocols:

    • BACnet (sends ReadProperty, ReadPropertyMultiple, and Subscribe messages depending on the configuration of I/O tags)
    • DNP3  (sends requests for reading of all configured Poll Classes specified in the configuration of station parameters and for reading of values of all objects with "Explicit read" enabled)
    • IEC 60870-6 ICCP/TASE.2 (sends requests for reading values of all I/O tags)
    • IEC 61850 (sends requests for reading values of all I/O tags)
    • IEC 870-5-101 (sends Interrogation Command/Counter Interrogation Command depending on station protocol parameters)
    • IEC 870-5-104 (sends Interrogation Command/Counter Interrogation Command depending on station protocol parameters)
    • IEC 870-5-104 Server (sends Interrogation Command/Counter Interrogation Command depending on station protocol parameters)
    • IEC 870-5-104 Sinaut (sends Interrogation Command/Counter Interrogation Command depending on station protocol parameters)
    • OPC Data Access (sends requests for synchronous reading values of all I/O tags)
    • OPC UA (sends requests for reading values of all I/O tags)

    ...

    Kotva
    event
    event
    D2000 EVENT


    DYNAMIC_INFOTell TELL command for the processes with the name *.EVH and *.HIS.
    Tell This TELL command does not contain have any parameters.

    After receiving the command, the process writes, into proper its log file, information about:

    - list of all running instances of ESL scripts
    Format: ESL;ESL name

    ESL - text identifying the next information
    ESL name - script identification1

    - registered text strings (GETACCESS action)
    Format: ACCESS;ESL name;String;time of GetAccess;bGlobal;userComment;status

    ACCESS - text identifying the next information
    ESL name - script identification1
    String - registered text string
    time of GetAccess - time of string registration
    bGlobal - flag defining the string to be global
    userComment - comment
    status - text "IN PROGRESS", if the global string has been registered, otherwise empty text ""

    - list of all open XML documents (%XML_CreateDocument, %XML_OpenDocument)
    Format: XML;ESL name;handle

    XML - text identifying the next information
    ESL name - script identification1
    handle - unique numerical identifier of XML document; it is identical to handle which is used by functions %XML_* 

    - list of objects that have been opened by function %OpenRefToObject
    Format: REFOBJ;Esl Name;Synchro;Obj HOBJ;Obj Name;Open In Progress

    REFOBJ - text identifying the next information
    ESL name - script identification1
    Synchro - value of parameter _bSynchro at calling of the function %OpenRefToObject
    Obj HOBJ - unique identifier of opened object
    Obj Name - unique name of opened object
    Open In Progress - flag defining if the object is just being opened

    - list of active database connections (by the actions the DB_TRANS_OPEN, DB_CONNECT, PG_CONNECT, and SQL_CONNECT actions)
    Format: DBCONNECT;ESL name;DB TRANS HANDLE;SUB CONNECT HANDLE;TYPE;OBJNAME;Prepared SQL Command;Last SQL Prepare; Comment

    DBCONNECT - text identifying the next information
    ESL name - script identification1
    DB TRANS HANDLE - identifier of transaction connections (it is created by calling the action DB_TRANS_OPEN action), or 0, if the connection is not implemented transactional
    SUB CONNECT HANDLE - identifier of connection (it is created by calling the actions DB_CONNECT, PG_CONNECT, or SQL_CONNECT actions)
    TYPE - type of connection (SUB CONNECT HANDLE)
    OBJNAME - object name, on which the connection is joining
    Prepared SQL Command - flag of the existence of prepared SQL command
    Last SQL Prepare - form format of the last SQL command which has been prepared by calling the action SQL_PREPARE action
    Comment - the position where the action SQL_PREPARE action was called

    - list of files which have been opened by functions %FIO_*
    Format: FIO;ESL name;file name

    FIO - text identifying the next information
    ESL name - script identification1
    file name - file namefilename

    - list of created data containers (CNT_CREATE action)
    Format: CNT;ESL name;handle;NR;valTyp;is array

    CNT - text identifying the next information
    ESL name - script identification1
    handle - unique numerical identifier of data container
    NR - number of elements
    valTyp - a type of key which identifies the items in the data container uniquely
    is array - flag determining whether the action CNT_CNVTOARRAY is applied on proper the respective data container

    1 - script identification: text string uniquely identifying the running ESL scrip. It contains the object name (HOBJ)[instance number] unique numerical identifier.
    Example: E.Script(728)[105]1872
    (%GetSelfInstanceId, %GetSelfHBJ)

    SHOW_TRANS_LIST idInstanceIf idInstance = 0, the command shows both the list of all instances of events that are pending to finish the transaction , and the list of transactions. If idInstance <> 0, the command shows the information about the particular instance (you can find the list of instances in the dialog window ESL Diagnostic Pack or by the tell command TASK_STATUS command).
    STATISTICS path+fileWrites data about the processor time consumption according to individual events into a file.
    STDOUT outputThe command redirects the standard output to a new one.

    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: See a note for STDOUT command for D2000 Archiv.

    TASK_STATUS path+filenameWrites just currently executed line lines of all the script running in given a specified process into a file (*.EVH or *.HIS). The command also supplies the information about whether the ESL script is currently executing the external function. If yes, the file will contain the name of the function and the line number of the script calling the functionwhether the ESL script is currently executing the external function. If yes, the file will contain the name of the function and the line number of the script calling the function.
    ON_CHANGE_INFO [idInstance]The command writes all active ESL ON CHANGE actions within the process to the log file. If the optional idInstance parameter is specified, only the actions of the given instance of the ESL script (idInstance described in the ESL Diagnostic Pack tab Event Instances) will be listed.


    Kotva
    calc
    calc
    D2000 CALC


    DP ON/OFFDebug Pipe - shows/hides the course of information about communication with D2000 Calc (only if the process window is displayed on the desktop).
    RESET_STATISTICSResets the counters for evaluating the statistical data.
    STATISTICS path+fileWrites statistical data about individual I/O tags into a file. The file contains the following information: I/O tag name, number of recalculations and number of new values broadcasted into the system. The counters are reset while starting the process D2000 Calc or using the command RESET_STATISTICS.
    STDOUT outputThe command redirects the standard output to new one.

    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: See a note for STDOUT command for D2000 Archiv.

    CALCINFO ON|OFF clcName [row]

    The command is used to determine the reason for calculating the eval tag that has the Calculation method parameter set to At change or Trigger value.

    The command ensures (CALCINFO ON) that into the LOG file of the process will be continually written information about the reason for the calculation of the eval tag. The CALCINFO OFF command terminates the continuous log to the LOG file. It is used for the eval tags that have the Calculation Method parameter set to At change or Trigger value.

    Record in the LOG file contains:

    • the identification of the object that caused the conversion and its value
    • the output value of the eval tag that was sent to the server


    ParametresParameters:

    clcName - the name of eval tag

    row - specifies a row number for a structured eval tag. If not specified, the replacement value is 0 and all rows will be tracked.

    Example (the content of LOG file):

    Tell TELL command: CALCINFO ON P.OnSec

    In the LOG file, there is a record  that that the information is about the calculation of the calculated P.OnSec object. The value of the object changed from HOBJ=20 (VALUE IN $20). Next, the individual attributes of the input value are displayed. Output value attributes are displayed after a row containing VALUE OUT content.

    Blok kódu
    CALCINFO: P.OnSec[ 0]
    VALUE IN $20
    GValTyp : INT (Integer)
    Status : VALID
    LimitStatus : INLIMIT
    ProcAlarmStatus : NOALARM
    ValTyp : INT
    Flags : F,F,F,F,F,F,F,F,F,F,F,F,F,F,F,F
    ValTime : 20.11.2017 16:39:59.000
    AlarmTime : (null)
    Value : 59
    VALUE OUT
    GValTyp : INT (Integer)
    Status : VALID, NOACKVALUE
    LimitStatus : INLIMIT
    ProcAlarmStatus : NOALARM
    ValTyp : CE
    Flags : F,F,F,F,F,F,F,F,F,F,F,F,F,F,F,F
    ValTime : 20.11.2017 16:39:59.001
    AlarmTime : (null)
    Value : 60


    Kotva
    check_destid_values
    check_destid_values
    CHECK_DESTID_VALUES
    [DestId [ColIndex]] [FlagList]
    The command enables to compare the values of destination columns (of structured variables), configured in the eval tags, with the values that were calculated by D2000 Calc.

    When specifying the particular object of Structured variable type, for which the comparison should be done, the value of parameter DestId, or also ColIndex for the particular column, must be a non-zero. It is followed by the optional key words keywords from the list: Detail, Debug, Ignore_Time, ReCalc0s, ReCalc1m.
    You may find the detailed information in the document Checking values of destination columns.

    Note 1: This command is mainly used for the diagnostic purposes in D2000 Systems.
    Note 2: Command is supported only in version D2000 V8.0.5.
    SHOW_DYN_INFO {Mask|HOBJ} [Row]It enables to display displaying a configuration and the current status of a particular eval tag. The eval tag is defined as an input parameter either through its ID (HOBJ) or mask. If several eval tags match the mask, the first 20 tags will be displayed. If Row parameter is different than 0, it must be the eval tag, the values of which are written to a destination column of the structured variable. For common eval tags (those that have not a destination column) the Row parameter must be 0 or not specified.

    The log format is identical with the format [Calc], which is stated in the article Checking values of destination columns, Example 3.

    Note: This command is mainly used for the diagnostic purposes in D2000 Systemssystems.

    GET_SOURCE_VALUE HOBJ Row ColIt enables to display the displaying of the inputs into the calculation providing they are the inputs from the structured variables.

    The log format is identical with the format [DestVal] Checking values of destination columns, Example 3.

    Note: This command is mainly used for the diagnostic purposes in the D2000 Systemssystems.



    Kotva
    dbmanager
    dbmanager
    D2000 DBMANAGER

    ...

    SHOW_HANDLE [table/database/structure_definition HOBJ] or [table mask]Shows information on open descriptors. For more information see the chapter DBManager - debugging.
    SHOW_CONNECT [database HOBJ [connect/transaction ID]] or [database mask [connect ID]] [DETAIL]Shows information on open connections. For more information see the chapter DBManager - debugging.
    SET_WATCHDOG database_mask seconds [NONTRANS]Switches on the monitoring of connections that perform SQL commands longer than the specified time seconds. This information can be used for the profiling of applications and and for the detection of slow SQL commands. If a NONTRANS clause is specified, transactional connections are not monitored.
    Starting with version 10.1.39, after the long-running SQL is finished, detailed info about it is written to a log file.
    More information can be found in chapter D2000 DBManager - debugging.
    SET_WATCHDOG_QUEUE database_mask seconds [NONTRANS]Switches on the monitoring of database actions which that take longer to be processed (including waiting in queues of DBManager) than the specified time seconds.
    After such a database action is finished, detailed info about it is written to a log file. If a NONTRANS clause is specified, transactional connections are not monitored.
    More information can be found in chapter D2000 DBManager - debugging.

    MONITOR_TRANS SHOW {ALL/<id>} [<file_path>]

    / ON <history

    MONITOR_TRANS ON <history_depth_sec>

    / OFF / RESET

    MONITOR_TRANS OFF

    MONITOR_TRANS RESET

    The mechanism for monitoring of

    Monitoring

    the transactions.

    ON - activates the monitoring.

    <history

    <history_depth_

    sec>

    sec> means a time-depth history of closed transactions.
    OFF - deactivates the monitoring
    RESET - resets the list of transactions (including the opened ones)
    SHOW - shows either the list of transactions including the history (ALL)

    ,

    or the particular transaction (<id>) to a console or file <file_path> in

    csv

    CSV format separated by ";"

    Columns in the list:
    - ID (transaction identifier)
    - time, task, traceback (time the last operation within the group of identical ones, task, traceback in the internal code)
    - comment, count (the last comment and the number of consecutive identical operations) (the identical operations has the same task and traceback)

    Note: After starting DBManager, the monitoring is

    switch

    switched off.

    MONITOR_CONNECTS SHOW {ALL/<id>} [<file_path>]

    / ON <history

    MONITOR_CONNECTS ON <history_depth_sec>

    / OFF /

    MONITOR_CONNECTS OFF

    MONITOR_CONNECTS RESET

    Monitoring the connections.

    ON - activates the monitoring. <history_depth_sec> represents the time-depth history of closed connections.
    OFF - deactivates the monitoring
    RESET - resets the list of connections (including the opened ones)
    SHOW - shows either the list of connections including the history (ALL), or the particular connection (<id>) to a console or file <file_path> in

    csv

    CSV format separated by ";"

    Columns in the list:
    - ID (auxiliary identifier of connection)
    - logon_time, logon_task, logon_traceback (time of connection, task and traceback in internal code)
    - logoff_time, logoff_task, logoff_traceback (time of disconnection, task, and traceback in internal code)
    - comment (the last written comment

    for the given connection, e.g. traceback in ESL code)
    Note: After starting DBManager, the monitoring is activated with the time-depth history of closed connections which is 3 hours (10 800 seconds)

    for the given connection, e.g. traceback in ESL code)

    Note: After starting DBManager, the monitoring is activated with the time-depth history of closed connections which is 3 hours (10 800 seconds).

    REFRESH_TABLES secondsThe command is intended for use on the PostgreSQL platform. It is used to close and reopen cursors used in page access to tables so they don't block table vacuuming if these cursors are open for too long. Typically, these are schemes with browsers, which are e.g. open for several days. The parameter seconds is the minimum age of the cursor in seconds to be reopened (e.g. 86400).
    TIME_STATISTICS database_mask [DETAIL]Displays statistics of execution of individual database action types per-database or per-table (if a DETAIL parameter DETAIL is specified).
    For more information see the chapter DBManager - debugging.

    ...

    DI ON/OFF [HOBJ/mask]Debug Info for alarm objects - enables/disables displaying the information about the evaluation of alarm objects with specified HOBJ or with the name matching given mask. If neither HOBJ or nor mask is specified, all alarm objects will be affected.
    Kotva
    show_dyn_info
    show_dyn_info
    SHOW_DYN_INFO HOBJ / mask
    Shows dynamic information on the specified alarm object(s) on the text console of the process D2000 Alarm.
    Note: The command is mainly used for D2000 system diagnostic purposes.

    ...

    SHOW_TOPOLOGY HOBJ or topology_name [DETAIL]Shows the information about topology. For more information - see the chapter Topology - Topology debugging chapter.
    DEBUG_TOPOLOGY HOBJ or topology_mask ON/OFFTurns on/off writing out detailed information on topology evaluation. For more information - see the chapter Topology - Topology debugging.
    SHOW_ASYMETRIC TERMINALS or TRANSFORMERS [topology_mask]Lists asymmetric Terminals or Transformers in the topology. For more information - see the chapter Topology - Topology debugging chapter.


    Kotva
    gateway
    gateway
    D2000 GateWay Client

    ...

    Kotva
    getoldval_gtw
    getoldval_gtw
    GETOLDVAL remoteTagName "BeginTime" ["EndTime"] ["NORECALC"]

    GETOLDVAL "remoteTagName[row]^item "BeginTime" ["EndTime"] ["NORECALC"]

    Reads the values of the remote tag within a specified interval. If the the EndTime parameter EndTime is not specified, the current time will be used as the default value.
    Time format ("BeginTime", "EndTime") is "dd-mm-yyyy hh:mi:ss".

    The command may be used for example after a failure or stoppage of the application, which the process D2000 GateWay Client process belongs to. It allows user to transfer transferring the values from the archive of the remote application to the archive of the application. The only requirements requirement of the value transfer is that the values of corresponding objects have been stored in the archive of the remote application.

    The first declaration form of the command reads all values transferred by given specified remote tag tags (as well as structured objects).

    The second declaration reads the values of structured objects partially. The parameter item specifies a column of the destination structure (see the parameter Destination structure parameter in the configuration of the remote tag). When just one a single row (column) must be read, use the following:

    • reading row 10 - GETOLDVAL RemoteTagName[10], …
    • reading the column named Values - GETOLDVAL RemoteTagName[0]^ Values^Values, …


    The Tell TELL command must always be executed in the transaction mode - the the COMMAND action COMMAND (within the process D2000 System Console process, the command is automatically executed in the transaction mode). After the command is executed, the values that was were transferred , are to will be stored in the archive and the D2000 System Archive automatically recalculates corresponding statistics.

    The NORECALC parameter NORECALC can be set at the end of the GETOLDVAL. In this case, the possible statistic calculations will not be backward executed by the process D2000 Archiv process.

    DI ON/OFF [HOBJ/mask]

    Debug Info for remote objects - enables/disables displaying the information about processing the values of objects with specified HOBJ or with the name matching the given mask.

    Note:if the gateway client is run in a transparent gateway mode, use the TRGTW command to display debug information.

    Kotva
    show_dyn_info
    show_dyn_info
    SHOW_DYN_INFO HOBJ / mask
    Shows dynamic information on the specified remote object(s) on the text console of the process D2000 Gateway.
    Note: The command is mainly used for D2000 system diagnostic purposes.
    TRGTWDebug command for transparent gateway mode. The command lists the names of objects and their HOBJ on the local and remote systems.
    START_RECORD dir_name_only [begin_time] end_time

    Starts recording of values read from theGateWay Server. For details see the command description for the D2000 KOM process.

    Note: Replaying of recorded values can be replayed by the D2000 KOM process , is possible if the GateWay Client was running in a transparent gateway mode during the recording.

    STOP_RECORD

    Instantly stops recording of values read from the GateWay Server. For details see the command description for the D2000 KOM process.

    START_REPLAY dir_name_only [begin_time [/NOW]]
    or
    START_REPLAY dir_name_only /LOOP
    Starts replaying of data recorded by command START_RECORD. For details see the command description for the D2000 KOM process.
    STOP_REPLAYInstantly stops the replaying of data. For details see the command description for the D2000 KOM process.


    Kotva
    workbook
    workbook
    D2000 WorkBook

    ...

    OBJECTS_INFOThe process writes the list of all objects that are or was were used in reports into its .log file.

    ...