$('a[name]').remove(); $('#ic-homepage__footer').before('

'); $("#tabs").tabs({ selected: 1 }); $("#ic-homepage__ic-tips").append( quickTipHTML() ); unhideOneProductTip(); $("#ic-homepage__product-tips").wrapInner('

'); $("#ic-homepage__feed-tips").wrapInner('

'); });

IBM Tivoli Monitoring > Version 6.3 > User's Guides > Agent Builder User's Guide > Monitor data from Java Database Connectivity (JDBC) IBM Tivoli Monitoring, Version 6.3

Test JDBC attribute groups

You can test the JDBC attribute group that you created, within Agent Builder.


Procedure

  1. You can start the Testing procedure in the following ways:

    • During agent creation click Test on the JDBC Information page (Figure 7).

    • After agent creation, select an attribute group on the Agent Editor Data Source Definition page and click Test. For more information about the Agent Editor, see (The Tivoli Monitoring Agent Editor).

    After you click Test in one of the previous two steps, the Test JDBC Statement window Figure 1 is displayed

    Figure 1. Test JDBC statement window

  2. Optional: Before you start testing, you can set environment variables, configuration properties, and Java information. See (Attribute group testing). For more about JDBC configuration properties, see (JDBC configuration).

  3. Click Start Agent. A window indicates that the Agent is starting.

  4. To simulate a request from Tivoli Enterprise Portal or SOAP for agent data, click Collect Data. The agent queries the database with the specified SQL query. The Test JDBC Statement window collects and shows any data in the agent's cache since it was last started.

    The order of the returned data is significant; for example, the data value in the first returned column is always assigned to the first attribute. If you reorder the attributes, you must rebuild your query to have a matching order.

  5. Optional: Click Check Results if the returned data is not as you expected. The Data Collection Status window opens and shows you more information about the data. The data that is collected and displayed by the Data collection Status window is described in Performance Object Status node

  6. Stop the agent by clicking Stop Agent.

  7. Click OK or Cancel to exit the Test JDBC Statement window. Clicking OK saves any changes that you made.


Parent topic:

Monitor data from Java Database Connectivity (JDBC)

Related concepts:

Test and debugging your agent

+

Search Tips   |   Advanced Search