Information and Events on the Running of Statements¶
RequestsManagementInfo MBeans provide information about the
“read only” and Data Manipulation Language (DML) queries processed by a
database of the Server. These MBeans are located in
Attributes of the RequestsManagementInfo MBeans¶
There is a
RequestsManagementInfo MBean for each database and they
have the following attributes:
DatabaseName. Name of the database.
MaxRequests. Maximum number of requests exported at the same time in the MBean. Each request appears as an attribute of the form
TotalRequests. Total number of requests processed since the launch of the Server.
ActiveRequests. Number of active requests.
Request<i>(compound value). Contains information about the request #i sent to this database. These MBeans are added as children of the
RequestsManagementInfoMBean of the database. To see them, expand the node of this MBean in the MBeans browser. If there are no
Requestnodes, it means that this database has not received any request yet. These MBeans have the following properties:
AccessInterface. Type of client that performed the request. Possible values of the attribute “access interface” lists the possible values of this attribute.
trueif the query has accessed the cache during its execution.
trueif the query finished correctly.
DatabaseName. Name of the database on which the statement is executed.
Elements. Name of the views and/or stored procedures referenced in the query.
EndTime. Moment at which the statement finished its execution.
Identifier. Transaction identifier.
NumRows. Number of rows returned by the query.
Trueif this query has been queued because the limit of maximum number of concurrent queries has been reached.
RequestType. This indicates the type of statement. It can take the following values:
SELECT BASE VIEW,
SessionId. Id of the session that this request belongs to.
StartTime. Instant at which the Server received the query.
State. This attribute stores the state of the top node of the execution plan and its value can be
PROCESSING. Note that the state of the top node can be
OKand the state of other nodes be
ERROR. For example, if one of the branches of a JOIN query fails and does not return results, its state is
ERROR. However, as the JOIN operation finishes correctly, its state is
OK. In this scenario, the attribute
Trueif the server swapped the intermediate results to disk during the execution of the query.
UserAgent. Name of the application that performed the request. Setting the user agent in the application is useful to know which application opens each connection. The section Setting the User Agent of an Application explains how to set this.
UserName. ID of the user running the statement.
VQLQuery. VQL code for the statement.
WaitingTime. Number of milliseconds the query was waiting in the queue of queries before the Server began executing it. A query is hold in the queue of queries when the limit of concurrent requests is reached. See more about this limit and how to increase it in the section Limiting the Number of Concurrent Requests.
Notifications of the RequestsManagementInfo MBeans¶
There is a
RequestsManagementInfo MBean for each database. Every
time a DML statement is run on the database, two notifications are sent:
one, indicating the beginning of the request and the other indicating
Timestamp. Instant at which the notification is generated in the JMX server.
Type. This type of notification includes the string
endRequestas the type indicator.
UserData. Compound element. Its subproperties are the same as those of the
Request<i>property described above.
SeqNum. Identifier of the notification.
Message. In this type of notification, it takes the value
Started the requestor
Finished the request.
Event. This will be
javax.management.Notification[source=com.denodo.vdb.management.mbeans:type=RequestsManagementInfo,databaseName=<dbname>][type=endRequest][message=Finished the request '<i>']
<dbName>is the name of the Virtual DataPort database and
<i>is the statement identifier.
Source. MBean name.