...
| The process 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 types of objects will be written into the monitoring database. | ||||||||||||||||||||||||||||||
| BACKUP SYSCFG path | Creates a configuration database backup in a directory specified by the parameter path. Note 1: The backup can be influenced by the setting of parameter ConfigBackUpTimeout. 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 path | Creates 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 path | Creates the backup of the database VALUES. DB in the directory specified by the parameter path. | ||||||||||||||||||||||||||||||
| CFGSYNCHROAUTO ON/OFF | Enables/disables the automatic synchronization of configuration databases after a new SBS (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 parameter ConfigSynchroTimeout. | ||||||||||||||||||||||||||||||
| CHECK_ARCHIVE | Checks a value type consistency between the primary archive object and the 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 from the value type of the archived objecthistorical value. | ||||||||||||||||||||||||||||||
| 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/OFF | Debug Pipe - enables/disables the displaying of the communication of 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.
| ||||||||||||||||||||||||||||||
| MESSAGE Message_Text process_name | Broadcasts (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, 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 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 serverName | Sets the HOT server in the redundant system. The parameter serverName is the name of the server within the redundant group. | ||||||||||||||||||||||||||||||
| On-line refresh of the information about the license range (from file LicenceRun.code or LicenceDev.code) and information about the network clients (from file ConsolesInfo.txt). It enables changing the 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 license is sent to the client processes when connecting to D2000 Server. For that reason, if the change of license affects even other processes than D2000 Server, they must be restarted. For example, when a user 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_PARAMS | Reloads all parameters for D2000 Server (except the parameters for saving the monitoring database to the depository) from the registry (Windows) or from the configuration file (Linux) without restarting the D2000 system. | ||||||||||||||||||||||||||||||
| RELOAD_SECURITY | Sets the new configuration of Security Policy without restarting the D2000 System. | ||||||||||||||||||||||||||||||
| REPAIR_ARCHIVE | Checks the consistency of value type between primary archive the object and archived onebeing archived and the historical value. If some error occurs, it will be repaired immediately and information will be written into the log. The error is if the value type of the primary archive object being archived is different from the value type of the archived objecthistorical value. | ||||||||||||||||||||||||||||||
| Initialize the path to the repository. If the directory does not existsexist, 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 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_name | Stops the given process and then starts it correctly. Note: If the process is stopped (Stop or Crash status), the command just starts it. | ||||||||||||||||||||||||||||||
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. | ||||||||||||||||||||||||||||||
| The command writes the list of the names registered by the GETACCESS action within the application (with the keyword PUBLIC) into the text console and to the log file (kernel.log) of the D2000 Server process. Example: | ||||||||||||||||||||||||||||||
| 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. | ||||||||||||||||||||||||||||||
| Shows configuration information of the process D2000 Server. This information covers:
| ||||||||||||||||||||||||||||||
| Shows dynamic information on the specified object (list of objects that dynamically or statically use the object) on the text console of the D2000 Server process. | ||||||||||||||||||||||||||||||
| SHOW_DYNO_LIST idFirst idLast | The 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_LIST | Lists internal transactions of the D2000 system. Note: The command is intended to be used mainly for D2000 System diagnostic purposes. | ||||||||||||||||||||||||||||||
| SHUTDOWN D2000 | Stops the D2000 system. | ||||||||||||||||||||||||||||||
| SHUTDOWN RESTART | Stops the D2000 system and restarts the operating system. | ||||||||||||||||||||||||||||||
| SHUTDOWN SHUTDOWN | Stop the D2000 system and shutdowns the operating system. | ||||||||||||||||||||||||||||||
| SHUTDOWN WINNT | Stops D2000 System and restarts the operating system. | ||||||||||||||||||||||||||||||
| START process_name | Starts the specified process. | ||||||||||||||||||||||||||||||
| STDOUT output | The command redirects the standard output to a new output specified by output. Example: | ||||||||||||||||||||||||||||||
| 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]|HIBERNATE | It causes the operating system 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). | ||||||||||||||||||||||||||||||
| It enables, disables, or queries the delay of data transfer between the 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 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 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 TCP_NO_DELAY tell command does not cause any change in the setting on the client's side! Note 2: Besides the TCP_NO_DELAY parameter, there is also another parameter that influences sending TCP delayed acknowledgments (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 and it can interact with TCP_NODELAY parameter. | ||||||||||||||||||||||||||||||
| 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:
The path for the file export on VMS must be written in Unix format. | ||||||||||||||||||||||||||||||
| The configuration parts export to the XML files, which is not part of the object configuration. The parameters: [Path, FileName, TableName].
Warning: Extension ".xml" is added automatically, do not explicitly specify it. | ||||||||||||||||||||||||||||||
| Warning: This command is not supported for OpenVMS. XML file(s) import of a specific file or of all XML files from specified directory, depending on path_to_dir / path_to_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 the tell command to be executed, a configuration key must be present!. The path for the file import on VMS should be entered in Unix format. 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. | ||||||||||||||||||||||||||||||
| Import of the configuration parts that are not part of the object configuration from XML files. The parameter [Path, FileName, TableName[, CleanTable]]
The initialization of 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. | ||||||||||||||||||||||||||||||
| Warning: Since the version V8.00.001, the command is not supported. Sets the parameters for TELL commands XML_IMPORT a XML_EXPORT. The command without parameter displays the default parameters of the D2000 Server. | ||||||||||||||||||||||||||||||
| 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. |
...
| 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. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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. The optional parameter step (in hours) allows to dividedividing the calculation for time period into intervals. ensures the calculation will be executed only for primary archive data. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 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 time period into intervals. See the note to the CRC command. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| DEL mask [before] | Deletes data from the archive database as follows:
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Deletes data from the archive database without activation of dependent statistics evaluation (similar to the action DELETEARCHDATA). Time format is dd-mm-rrrr hh:mi:ss.mss. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| DI ON/OFF | Debug Info - shows/hides internal debug information of the process D2000 Archiv process (in the process window and in the process the D2000 Sysconsole process). | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 given mask. For structured historical values, you can specify the required structure item - column (if ROW=0) or row (if COL=0). Example: | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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). | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 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). 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. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DISMOUNT_TREZOR IdFrom IdTo [SEGMENT seg] | PostgreSQL platform: The parameter Id Id defines the number of depository database 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 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/OFF | Debug Pipe - shows/hides the course of communication with D2000 Server (only if the process window is displayed on the desktop). | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| DROP_LIST path+filename | Creates the file (defined by the parameter path+filename) containing SQL commands to delete tables, which are not used by the archive configuration. If the time slices are enabled, the file will contain also the commands to delete respective rows of the table ARC_SLICE, which contain information about the time slices corresponding to tables that are to be deleted. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 description of parameter IsoCacheAutoFill. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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). | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
UNFREEZE | FREEZE command causes the writing and calculating tasks of 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. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Activates the process D2000 Archiv process to import external data, e.g. Importing archive databases from D2000 V3.65 (OS/2). | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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) | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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_QUEUE | Reduction of the number of calc requests in the archive queue. If, for some reason, the number of requests in the archive queue has increased (for example, due to the arrival of old values from the communication), this tell command can reduce duplicate requests. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| PENDING_REQUESTS path+filename | Creates a file containing the descriptions of pending requests. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 are supposed to be performed on the background while archive still continues archiving real-time data. Note: If the parameter RecalcTimeIntervalLimit has 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 is stated as a protection against overloading the main task by recalculations. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Early disconnection of current depository database. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| If 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. The command is used to purify the archive database from empty time slices that were created due to error of archive. This error was repaired in the supported versions in June 8, 2015. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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). Note: For Oracle, PostgreSQL and Sybase 8.0 platforms or later only. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 and PostgreSQL platforms only.
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| REORGANIZE ON | Enables the reorganization of archive database (same as running the process D2000 Archiv with the /DBCY parameter). | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| REORGANIZE OFF | Enables the reorganization of archive database (same as running the process D2000 Archiv without the /DBCY parameter). | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| REORGANIZE ACTIVE | Enables the reorganization of archive database in the active mode only (same as running the process D2000 Archiv with the /DBCA parameter). | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| REORGANIZE PASSIVE | Enables the reorganization of archive database in the passive mode only (same as running the process D2000 Archiv with the /DBCP parameter). | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| REORGANIZE SHRINK | Enables the alternate mode of 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 rowLimit | On-line change of the parameter ReorganizeTableRowLimit used for the automatic reorganization of archive database. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| REORGANIZE TableTimeLimit timeLimit | On-line change of the parameter ReorganizeTableTimeLimit used for the automatic reorganization of archive database. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
name_parameter value_parameter | Tell command SET_OPTION controls the following configuration and start-up parameters of the process D2000 Archiv:
Note: For parameters which that are stored in the Registry database the tell command SET_OPTION will change the value of configuration parameters not only in the archive but also in the Registry database. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Shows 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. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| If 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. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Shows configuration information of the process D2000 Archiv and archive database. This information covers:
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Shows various information about the process D2000 Archiv and the archive database. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 command redirects the standard output to a new output. Example: | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 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. |
...