IBM Tivoli Monitoring, Version 6.3

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