Testing 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.
    • 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 Using the Agent Editor to modify the agent.

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

  2. Optional: Before you start testing, you can set environment variables, configuration properties, and Java™ information.
    For more 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.
    Note: 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 change the JDBC statement, you must add, remove, or reorder the attributes to match the columns returned by the statement.
  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.