| DP ON/OFF | Debug Pipe - shows/hides the information about communication with D2000 Calc (only if the process window is displayed on the desktop). | ||||||
| RESET_STATISTICS | Resets the counters for evaluating the statistical data. | ||||||
| STATISTICS path+file | Writes 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 output | The command redirects the standard output to new one. Example: | ||||||
| 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:
Parameters: 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 command: CALCINFO ON P.OnSec In the LOG file, there is a record 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.
| ||||||
| 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 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 : This command is mainly used for diagnostic purposes in D2000 Systems. | ||||||
| It enables 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. | ||||||
| GET_SOURCE_VALUE HOBJ Row Col | It enables 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 diagnostic purposes in the D2000 systems. |
...
MONITOR_TRANS SHOW {ALL/<id>} [<file_path>]
MONITOR_TRANS ON <history_depth_sec>
MONITOR_TRANS OFF
MONITOR_TRANS RESET
...
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 switched off.
...
MONITOR_CONNECTS SHOW {ALL/<id>} [<file_path>]
MONITOR_CONNECTS ON <history_depth_sec>
MONITOR_CONNECTS OFF
MONITOR_CONNECTS RESET
...
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).
...
The command allows you to close and reopen connections to the database that are not currently in use (there is no transaction in progress or a cursor in use).
Note: This command was implemented to work with temporary tables in PostgreSQL. These are only dropped when the database connection ends, and while they exist, the data in them is not visible outside the database connection that inserted them, so they cannot be accessed by vacuum, and therefore internal transaction IDs (XIDs) can be exhausted if a connection is open for a long time.
...
The command will cause the execution of the SQL statement DISCARD TEMPORARY in the PostgreSQL database with the specified name/ID on all connections, or on a specific one.
Note: This command was implemented to work with temporary tables in PostgreSQL. These are only dropped when the database connection ends, and while they exist, the data in them is not visible outside the database connection that inserted them, so they cannot be accessed by vacuum, and therefore internal transaction IDs (XIDs) can be exhausted if a connection is open for a long time.
...
GETOLDVAL remoteObjectMask "BeginTime" ["EndTime"] [NORECALC]
GETOLDVAL "remoteTagName[row]^item" "BeginTime" ["EndTime"] [NORECALC]
...
The command may be used for example after a failure or stoppage of the application, which the D2000 GateWay Client process belongs to. It allows transferring the values from the archive of the remote application to the archive of the application. The only requirement of the value transfer is that the values of corresponding objects have been stored in the archive of the remote application.
The first form of the command reads all values transferred by specified remote tags (as well as structured objects).
The second form of the command reads all the values of several objects according to the mask.
The third form reads the values of a part of the structured object. The parameter item specifies a column of the destination structure (see the Destination structure parameter in the configuration of the remote tag) and it must be specified within quotes. When a single row (column) needs to be read, use the following:
- reading row 10 - GETOLDVAL "RemoteTagName[10]" …
- reading the column named Values - GETOLDVAL "RemoteTagName[0]^Values" …
The TELL command must always be executed in the transaction mode - the COMMAND action (within the D2000 System Console process, the command is automatically executed in the transaction mode). After the command is executed, the values that were transferred will be stored in the archive and the D2000 Archive automatically recalculates corresponding statistics.
The NORECALC parameter can be set at the end of the GETOLDVAL. In this case, the statistic calculations will not be executed by the D2000 Archiv process.
...
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: Replaying of recorded values by the D2000 KOM process is possible if the GateWay Client was running in a transparent gateway mode during the recording.
...
Instantly stops recording of values read from the GateWay Server. For details see the command description for the D2000 KOM process.
...
| Info | ||
|---|---|---|
| ||