IBM Tivoli Composite Application Manager for Microsoft Applications, Version 6.3.1

Configuration parameters in the Database Server Properties window

Use the Configure Database Agents window to select the database that you want to monitor.

  1. Click Start > All Programs > IBM Tivoli Monitoring.
  2. Click Manage Tivoli Enterprise Monitoring Services. The Manage Tivoli Enterprise Monitoring Services window opens.
  3. In the Manage Tivoli Enterprise Monitoring Services window, right-click Monitoring Agent for Microsoft SQL Server (for Template).
  4. Click Configure Using Defaults. The Configure Database Agents window opens.
  5. In the Configure Database Agents window, from the Database Servers Available list, select the server that you want to monitor, and move the server to the Server to Monitor list. The Database Server Properties window opens.
    The following fields are populated in the Database Server Properties window:
    • Server Name
    • Database Version
    • Home Directory
    • Error Log File
    The following fields in the Database Server Properties window are optional:
    • Windows Authentication
    • Support Long Lived Database Connections
    • Extended Parms
    • Monitor all Databases
    • Include
    • Day(s) Frequency
    • Weekly Frequency
    • Monthly Frequency
    • Collection Start Time
    • Table Detail Continuous Collection
  6. If you do not select the Windows Authentication field, enter your user ID and password in the Login and Password fields by using only ASCII characters.
  7. In the Extended Parms field, type one of the following options to disable the data collection, and then click OK.
    • koqtbld for the Table Detail attribute group.
    • koqdbd for the Database Detail attribute group.
    • koqtbld,koqdbd for disabling the Table Detail and Database Detail attribute groups.
  8. If you clear the Monitor All Databases check box, specify the list of databases for which you want to enable or disable monitoring, in the text field that is present in the Databases group area.
    Remember: If you select the Monitor All Databases check box and also specify the databases that you want to monitor in the text field that is present in the Databases group area, then priority is given to the value of the Monitor All Databases check box. The list of the databases that you specify in the text field is ignored.
  9. Specify a daily, weekly, or monthly frequency for the collection of the MS SQL Table Detail attribute group.
  10. Select the Table Detail Continuous Collection check box to enable continuous collection of the MS SQL Table Detail attribute group. If you select the Table Detail Continuous Collection check box, enter a value in the Interval Between Two Continuous Collection (in minutes) field.
  11. In the Configure Database Agents window, click OK, and then start the agent.


Feedback