Porovnávané verzie

Kľúč

  • Tento riadok sa pridal
  • Riadok je odstránený.
  • Formátovanie sa zmenilo.
DYNAMIC_INFOTELL command for the processes with the name *.EVH and *.HIS.
This TELL command does not have any parameters.

After receiving the command, the process writes, into 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 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 DB_TRANS_OPEN action), or 0, if the connection is not transactional
SUB CONNECT HANDLE - identifier of connection (it is created by calling the 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 - format of the last SQL command which has been prepared by calling the SQL_PREPARE action
Comment - the position where the 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 - filename

- 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 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 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 currently executed lines of all the script running in 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 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.

...

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.

...

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

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.

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

...

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
titleRelated pages:

D2000 Tell
Work with D2000 Tell