Query Service Test
The Query Service is responsible for executing dynamic query mode queries. If the service is unavailable or fails to process the requests, then, the execution of dynamic queries will be affected. This will increase the query processing queue and will impact the performance of the target server. To ensure that the performance of the target server remains at peak, it is essential for the administrators to periodically monitor the Query Service. The Query Service test helps administrators in this regard!
This test monitors the Query Service and reports the current status of the service. This test also throws light on the number of query service requests that were successful/failed. This test helps administrators initiate troubleshooting to determine the reason for request failures and resolve the same at the earliest.
Target of the test : An IBM Cognos Business Intelligence
Agent deploying the test : An internal/remote agent
Outputs of the test : One set of results for the target IBM Cognos Business Intelligence suite being monitored
Parameter |
Description |
---|---|
Test period |
How often should the test be executed . |
Host |
The host for which the test is to be configured. |
Port |
The port number at which the specified host listens. By default, this is NULL. |
JMX Remote Port |
Here, specify the port at which the JMX listens for requests from remote hosts. Ensure that you specify the same port that you configured in the p2pd.deploy_defaults.properties file available in the <IBM_COGNOS_BI_HOME>\webapps\p2pd\WEB-INF folder used by the target application server. |
JMX User, JMX Password, and Confirm Password |
By default, JMX requires no authentication or security (SSL). This is why, by default, the JMX User and JMX Password parameters are set to none. If JMX requires authentication only (but no security), then ensure that the JMX User and JMX Password parameters are configured with the credentials of an authorized user with access to JMX using the JMX Remote Port. Confirm the password by retyping it in the Confirm Password text box. |
Measurement | Description | Measurement Unit | Interpretation | ||||||
---|---|---|---|---|---|---|---|---|---|
Status |
Indicates the current status of the service. |
|
The values that this measure can report and their corresponding numeric values are listed in the table below:
Note: By default, this measure reports the Measure Values listed in the table above to indicate the current status of the service. In the graph of this measure however, the same is represented using the numeric equivalents only i.e., 0 or 100. |
||||||
Processed requests |
Indicates the number of requests that were processed during the last measurement period. |
Number |
|
||||||
Successful requests |
Indicates the number of service requests that were successful during the last measurement period. |
Number |
A high value is desired for this measure. |
||||||
Percentage of successful requests |
Indicates the percentage of processed requests that were successful during the last measurement period. |
Percent |
A value close to 100 percent denotes that most of the requests were processed successfully. |
||||||
Failed requests |
Indicates the number of service requests that failed during the last measurement period. |
Number |
A high value is a cause of concern. Administrators must analyze why the requests are failing frequently and initiate troubleshooting measures at the earliest. |
||||||
Percentage of failed requests |
Indicates the percentage of processed requests that failed during the last measurement period. |
Percent |
A value close to 100 is a cause of concern. A sudden / gradual increase in the value of this measure warrants administrators to initiate troubleshooting at the earliest. |
||||||
Successful requests per second |
Indicates the rate at which the requests were processed successfully during the last measurement period. |
Requests/sec |
|