D2000 System contains several predefined objects of Structure definition type.


SD._System_ArchivPerformance

Item nameDescription
NameName of a process of D2000 Archiv type.
PendingDbRequestThe number of queued write requests waiting for the archive database.
PendingStatReqestThe number of waiting requests for the archives.
PerformedDbRequestThe number of write requests performed per second for the archive database (10-second average).
PerformedCalcRequestThe number of performed calculated and statistical calculations per second  (10-second average).
TotalItemsInCacheThe number of items in an internal archive cache.
CacheEffectivityCache usage in % (if it is 100%, the system does not need to read source data from disk for evaluation of statistical historical values - the data are in the memory).
DatabaseSize
Database size [MB].
AutoExtensible
If TRUE, then at least one of the datafiles is extensible (for ORACLE databases only).
FreeSpace
For Sybase/PostgreSQL: Free disk space.
For Oracle: Free space in existing datafiles.
PendingClearRequestThe number of waiting requests for deleting old data from the archive database.
ActiveTrue - the instance of D2000 Archiv is active (performs writing as well as reading for users and ESL scripts).
False - the instance of D2000 Archiv is passive (performs only writing).
LatestCommandDescription of the last executed command – a database request or statistics evaluation request in the process D2000 Archiv.
DataSizefor Sybase/PostgreSQL: DataSize = DatabaseSize
for Oracle: DataSize = DatabaseSize - FreeSpace
ReadyTrue - the instance of D2000 Archiv is ready (the initial recalc has been executed). It may become active.
False - the instance of D2000 Archiv is not ready.
DepositoryStatus

The status of depositories:

  • 0 - depositories are off
  • 1 - depositories are on and functional
  • 2 - depositories are on and non-functional



SD._System_EDAServerPerformance2

Item nameDescription
NameName of process EDA Server.
DatabaseTaskCountThe number of database connections to DBS Oracle.
WorkerTasksCountThe number of computing threads of the EDA Server.
clientsCountThe number of connected clients.
triggersCountThe number of connected triggers.
gcTotalBlocksThe number of pre-allocated data blocks of the global cache.
gcTotalVectorsThe number of pre-allocated vector definitions of the global cache.
gcTotalGroupsThe number of pre-allocated group definitions of the global cache.
gcTotalScenariosThe number of pre-allocated scenario definitions of the global cache.
gcUsedBlocksThe number of used data blocks of the global cache.
gcUsedVectorsThe number of used vector definitions of the global cache.
gcUsedGroupsThe number of used group definitions of the global cache.
gcUsedScenariosThe number of used scenario definitions of the global cache.
ccTotalBlocksThe number of pre-allocated data blocks of the client cache.
ccTotalVectorsThe number of pre-allocated vector definitions of the client cache.
ccTotalGroupsThe number of pre-allocated group definitions of the client cache.
ccTotalScenariosThe number of pre-allocated scenario definitions of the client cache.
ccUsedBlocksThe number of used data blocks of the client cache.
ccUsedVectorsThe number of used vector definitions of the client cache.
ccUsedGroupsThe number of used group definitions of the client cache.
ccUsedScenariosThe number of used scenario definitions of the client cache.
lpqLengthLength of message queue with a lower priority.
npqLengthLength of message queue with a normal priority.
ipqLengthLength of message queue with an internal priority.
lpqMsgsThe number of processed messages with a lower priority.
lpqAvgWaitTimeAn average wait time of the message in a queue with a lower priority.
lpqMaxLengthThe maximum length of a queue with a lower priority.
npqMsgsThe number of processed messages with a normal priority.
npqAvgWaitTimeThe average wait time of a message in a queue with a normal priority.
npqMaxLengthThe maximum length of a queue with a normal priority.
ipqMsgsThe number of processed messages with an internal priority.
ipqAvgWaitTimeThe average wait time of a message in a queue with an internal priority.
ipqMaxLengthThe maximum length of a queue with an internal priority.
transTimeTime spent on transactions for EDA Server synchronization.
transCountThe number of transactions for EDA Server synchronization.
triggerTransTimeTime spent on transactions for EDA Server synchronization from a trigger.
triggerTransCountThe number of transactions for EDA Server synchronization from a trigger.
msgProcessingTimeTime spent on processing messages.
processedMsgCountThe number of processed messages.
statementExecTimeTime spent on processing EDA-L commands.
statementExecCountThe number of executed EDA-L commands.
compilationTimeTime spent on EDA-L compilations.
compilationCountThe number of EDA-L compilations.
descVectorCalcTimeTime spent on the calculation of descriptive vectors.
descVectorCalcCountThe number of calculations of descriptive vectors.
archiveTransTimeTime spent on transactions with the archive.
archiveTransCountThe number of transactions with the archive.
dbTaskRequestWaitTime spent on waiting for a database thread.
dbTaskRequestCountThe number of requests for a database thread.
dbActionsTimeTime spent on database actions.
dbActionsCountThe number of database actions.
sqlActionsTime Time spent on executing SQL commands.
sqlActionsCountThe number of executed SQL commands.
cCacheMissCountThe number of queries on client cache which do not contain data.
cCacheHitCountThe number of queries on client cache which contains data.
ncCacheFullCountThe number of attempts to write to the full client cache.
cCacheBypassCountThe number of attempts to write to the client cache of entities that have the "non-cacheable" temporary flag.
cCacheNoncacheableCountThe number of non-cacheable access to the client cache.
gCacheMissCountThe number of queries to global cache, which do not contain data.
gCacheHitCountThe number of queries to global cache, which contains data.
gCacheFullCountThe number of attempts to write to the full global cache.
gCacheBypassCountThe number of attempts to write to the global cache of entities, that have the "non-cacheable" temporary flag.
gCacheNoncacheableCountThe number of non-cacheable access to the global cache.


SD._System_FileInfo

A structure contains the information about the files which have been returned by FIND_FILES action.

Item nameDescription
IsFile@TRUE - in case of a file, @FALSE - in case of a directory.
CreateTimeThe time when the file or directory was created.
AccessTimeTime of the last access to the file (writing or reading).
ModifyTimeTime of the last file modification.
SizeFile size in bytes.
NameFilename.
AttribsFile attributes.

The parameter Attribs contains file (directory) attributes, so as they were returned by an operating system. The following table contains the list of the attributes and their values from the file winnt.h.

AttributeValue
FILE_ATTRIBUTE_READONLY0x00000001
FILE_ATTRIBUTE_HIDDEN0x00000002
FILE_ATTRIBUTE_SYSTEM0x00000004
FILE_ATTRIBUTE_DIRECTORY0x00000010
FILE_ATTRIBUTE_ARCHIVE0x00000020
FILE_ATTRIBUTE_ENCRYPTED0x00000040
FILE_ATTRIBUTE_NORMAL0x00000080
FILE_ATTRIBUTE_TEMPORARY0x00000100
FILE_ATTRIBUTE_SPARSE_FILE0x00000200
FILE_ATTRIBUTE_REPARSE_POINT0x00000400
FILE_ATTRIBUTE_COMPRESSED0x00000800
FILE_ATTRIBUTE_OFFLINE0x00001000
FILE_ATTRIBUTE_NOT_CONTENT_INDEXED0x00002000


SD._System_LinePerformance

Item nameDescription
NameLine name. Name is entered by the D2000 system user (configurator) - the name of a line to be tracked.
In systems with redundant application servers, the Name can be of the form KernelName::LineName (e.g. MesA::L.Something).
For communication processes in active-active instance mode, the Name can be in the form [Instance]_LineName (e.g. [2]_L.Something).
StatusLine status (True / False).
StatusTimeRelative time from last line status change.
BytesInThe number of received bits on the line from the start of process D2000 KOM or from the time when the data are set to zero by using the Tell command RESETPERF.
BytesOutThe number of sent bits on the line from the start of process D2000 KOM or from the time when the data are set to zero by using the Tell command RESETPERF.
FramesInThe number of received datagrams/packets on the line from the start of process D2000 KOM or the time when the data are set to zero by using the Tell command RESETPERF.
FramesOutThe number of sent datagrams/packets on the line from the start of process D2000 KOM or the time when the data are set to zero by using the Tell command RESETPERF.
RetryErrorThe number of datagram request retry error (no response) on the line from the start of process D2000 KOM or the time when the data are set to zero by using the Tell command RESETPERF.
LastErrorTimeLast line error time.
LastErrorTextLast line error report.
ChangesThe number of changes of I/O tags on the line that were sent to process D2000 Server during the last 10-second period.
ChangesTotalThe total number of changes of I/O tags on the line that were sent to process D2000 Server from the start of process D2000 KOM or the time when the data are set to zero by using the Tell command RESETPERF.
StationsNumberThe number of stations on the line.


SD._System_NetStatus

Item nameDescription
IP_AddressThe IP address or hostname to be tested using the PING network service.
Both IPv4 and IPv6 addresses and names are supported.
PeriodPING messages sending period (seconds).
TimeoutWait time (milliseconds) for device response.
ResetSetting the parameter to TRUE resets the parameter listed below.
StatusNetwork status.
StatusTimeThe elapsed time of given status.
PktRcvThe number of successfully transferred packets.
PktLostThe number of lost packets.
SuccRatioNetwork transfer ratio.
LastPingTimeThe time when the last message was sent.


SD._System_ObjectInfo

The structure contains the basic information about the objects which have been returned by LST_CREATE action.

Item nameDescription
IDHOBJ of the object.
NameObject name.
DescObject description.
TypeObject type.
RowsThe number of rows in case of the structured variable, otherwise 0.
ColsThe number of columns in case of the structured variable/structure definition, otherwise 0.
ParentHOBJ of the parent object.

It is possible to use a structure extended by 2 more columns with their types and meanings:

UUIDUnique object identifier.
ModifyTimeTime of the last modification of the object.

SD._System_Proces

Item nameDescription
NameName of D2000 system process.

In the case of a process instance, the object name must be written with the prefix [instNr]_, in which instNr is the instance number.
For example [2]_SELF.ARC for the instance archive (instance 2).

Note 1: The parameter also allows defining a process running on another server (connected to another D2000 Server process) within a redundant system. To define such a process, define the parameter as follows: server_name::process_name (e.g. DS15A::SELF.KOM)
Note 2: The parameter is not case sensitive.

IDProcess ID.
StatusProcess status.
ComputerNameName of the computer where the specified process is running.
ClientTypeType of the connection of specified process to process D2000 Server.
IPAddr1The IP address of a specified process if it is connected to D2000 Server using TCP/IP or DUAL TCP/IP.
CommStatus1 1)Status of the connection using the parameter IPAddr1.
IPAddr2The IP address of a specified process. The parameter is shown if the process is connected to D2000 Server using DUAL TCP/IP.
CommStatus2 1)Status of the connection using the parameter IPAddr2.
SentMessagesThe number of messages that were sent by the D2000 Server to a client.
ReceivMessagesThe number of messages that were received by the D2000 Server from a client.
AllocatedMemorySize (in bytes) of memory allocated by the specified process.
FreeMemoryfor Windows/Linux/Raspberry PI: Free memory size of the computer (kilobytes) where the specified process is running
for OpenVMS: Size of memory (kilobytes) that can be allocated by a specified process
CpuLoadCPU load of the specified process.
ActiveIndicates whether the instance is active or not. Possible values:
  • True - process instance is active
  • False - process instance is inactive
StartTimeStart time of the process.
Handlesfor Windows: The number of the process handles.
ThreadsThe number of the process threads.
SendBytesThe number of bytes that were sent by the D2000 Server to a client.
ClientSendBytesThe number of bytes that were sent by a client to the D2000 Server.
AvailVirtualThe amount of unreserved and uncommitted memory currently in the user-mode portion of the virtual address space of the process, in bytes.
PrivateUsageThe Commit Charge value in bytes for this process. Commit Charge is the total amount of memory that the memory manager has committed for a running process.
ModuleInfoStructured process information in JSON format. Example:
{
   "name":"cli.EVH",
   "basename":"cli",
   "ext":"EVH",
   "descript":"New Process",
   "state_value":"RUN",
   "state_ts":"2017-06-02T08:47:25.113Z",
   "run_counter":2,
   "transport":{
      "type":"SharedMemory",
      "tls":"None"
},
   "client_data":{
      "host_name":"PC1A3",
      "platform":"w32",
      "os_info":"",
      "d2000_version":"BASIC V11.00.053 (A000000000-00) [s150] - DEBUG",
      "image_path":"C:\\D2000\\D2000_EXE\\bin\\event.exe",
      "image_ts":"2017-06-02T08:29:48.000Z",
      "image_size":67027508,
      "command_line":"event.exe /Wcli /DW",
      "log_path":"C:\\D2000\\D2000_EXE\\Log\\",
      "log_file":"EVH-cli.log"
   }
}

1) The variable contains the status of the TCP/IP connection. TRUE means that the connection has been established and is active. FALSE means that the connection has not been established or has been already ended. If the client process is connected to D2000 Server via one or several active network components (gateway, router...), the status of the connection can, in the specific situations (the fault conditions, a physical cut-off of the wiring network), acquire this value belatedly by tens of seconds up to several minutes.


SD._System_Redundancy

Item nameDescription
NameName of the server (process D2000 Server) within a redundant group.
ComputerNameName of the computer where the specified server is running.
UpTimeRun time of the specified server.
StatusServer status in redundancy. For numerical values see the table of server states
StatusTimeThe elapsed time of specified status.


SD._System_StationPerformance

Item nameDescription
NameStation name. The Name is entered by D2000 system user (configurator) - the name of a station to be tracked.
In systems with redundant application servers, the Name can be of the form KernelName::StationName (e.g. MesA::B.Something).
For communication processes in active-active instance mode, the Name can be in the form [Instance]_StationName (e.g. [2]_B.Something).
FramesInThe number of received datagrams/packets on the station from the start of process D2000 KOM or the time when the data are set to zero using the Tell command RESETPERF.
FramesOutThe number of sent datagrams/packets on the station from the start of process D2000 KOM or the time when the data are set to zero using the Tell command RESETPERF.
LastCommActivityTime of last communication with the station (e.g. data reading time in the communication of request/response type).
LastTimeSynchroTime of the real-time station synchronization.
LastErrorTimeLast station error time.
LastErrorTextLast station error report.
ChangesThe number of changes of I/O tags on the station that were sent to the D2000 Server process during the last 10-second period.
ChangesTotalThe total number of changes of I/O tags on the station that were sent to the process D2000 Server from the start of process D2000 KOM or the time when the data are set to zero by using the Tell command RESETPERF.
WaitReqNumberThe number of station communication requests postponed.
PointsNumberThe number of I/O tags on the station.


SD._System_TCTSPerformance

Item nameDescription
NameName of process.
ClientsNrThe number of clients.
TotalOutMsgTotal outgoing messages.
TotalInMsgTotal incoming messages.
TotalOutBytesTotal outgoing bytes.
TotalInBytesTotal incoming bytes.
ServletQTotalSizeServlet queue total size.
ServletQTotalCountServlet queue total count.
Napíšte komentár