...
DYNAMIC_INFO | TELL 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 scriptsFormat: 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 XML - text identifying the next information REFOBJ - text identifying the next information DBCONNECT - text identifying the next information FIO - text identifying the next information CNT - text identifying the next information 1 - script identification: text string uniquely identifying the running ESL scrip. It contains the object name (HOBJ)[instance number] unique numerical identifier. |
SHOW_TRANS_LIST idInstance | If 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+file | Writes data about the processor time consumption according to individual events into a file. |
STDOUT output | The command redirects the standard output to a new one. Example: |
TASK_STATUS path+filename | Writes 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. |
Kotva | ||||
---|---|---|---|---|
|
...
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 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 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>] MONITOR_TRANS ON <history_depth_sec> MONITOR_TRANS OFF MONITOR_TRANS RESET | The mechanism for monitoring of the transactions. Columns in the list: 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 | Monitoring the connections. Columns in the list: 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 seconds | The 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 is specified). For more information see the chapter DBManager - debugging. |
...