Information and Events on the Running of Statements

The 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 com.denodo.vdb.management.mbeans > RequestsManagementInfo > database name.

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 Request<i>.
  • 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 RequestsManagementInfo MBean of the database. To see them, expand the node of this MBean in the MBeans browser. If there are no Request nodes, 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.
    • Cache. true if the query has accessed the cache during its execution. false otherwise.
    • Completed. true if the query finished correctly. false otherwise.
    • DatabaseName. Name of the database on which the statement is executed.
    • Elements. Name and database of the views/stored procedures referenced in the query. This property has the format “<database of the view/stored procedure>”.”<name of the view/stored procedure>”.
    • EndTime. Moment at which the statement finished its execution.
    • Identifier. Transaction identifier.
    • NumRows. Number of rows returned by the query.
    • Queued. True if this query has been queued because the limit of maximum number of concurrent queries has been reached. False otherwise.
    • RequestType. This indicates the type of statement. It can take the following values: SELECT BASE VIEW, SELECT VIEW, QUERY WRAPPER, CALL STOREDPROCEDURE, INSERT, UPDATE or DELETE.
    • 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 OK, ERROR or PROCESSING. Note that the state of the top node can be OK and 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 State is OK and Completed is false.
    • Swap. True if the server swapped the intermediate results to disk during the execution of the query. False otherwise.
    • 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 the end.

  • Timestamp. Instant at which the notification is generated in the JMX server.

  • Type. This type of notification includes the string startRequest or endRequest as 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 request or 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>']
    

    , where <dbName> is the name of the Virtual DataPort database and <i> is the statement identifier.

  • Source. MBean name.