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.