IBM Tivoli Monitoring, Version 6.3 Fix Pack 2

Populating the data warehouse's ManagedSystem table

If your site runs the Tivoli Data Warehouse, each time you install one or more monitoring agents, you must update the warehouse's ManagedSystem table; the populate_agents.sql script is provided for this purpose.

If your site uses DB2 Database for Linux, UNIX, and Windows to manage its Tivoli Data Warehouse, call this stored procedure:
```
db2 call ITMUSER.POPULATE_OSAGENTS();
```
If your site uses Microsoft SQL Server to manage its Tivoli Data Warehouse, run this script at the MS SQL command-line:
```
sqlcmd -i populate_agents.sql [-U my_username -P my_password] [-H my_host])
```
If your site uses Oracle to manage its Tivoli Data Warehouse, start this procedure:
```
POPULATE_OSAGENTS('ITMUSER');
```

where:

ITMUSER: Is the database user for Tivoli® Data Warehouse.
my_username: Is the user ID for the Tivoli Data Warehouse (in most cases the same as ITMUSER).
my_password: Is the password for the user.
my_host: Is the optional computer name.

Feedback