198 Tivoli Business Systems Manager Version 2.1: End-to-End Business Impact Management
The running of the program in our environment is shown in Example 6-1.
Example 6-1 Running HistoryServerSetup.ksh
C:> sh
$ HistoryServerSetup.ksh -N ibmtiv6 -R sa -W sa_ibmtiv6
Setting up BCP managed History Server database on REMOTE IBMTIV6
**********************************************************************************
******************* S E T U P H I S T O R Y S E R V E R **********************
**********************************************************************************
Done!
Done!
**********************************************************************************
******************* S E T U P P R I M A R Y S E R V E R **********************
**********************************************************************************
Could not find table eventbcpOLD. Will try to resolve this table name later.
Could not find table event_lastbcpOLD. Will try to resolve this table name later.
Creating bcp version of view event_V
Done!
History Server Setup Done!
8. To complete and enable the reporting system, be sure the new jobs Copy
Backups from Live DB Server and Restore Databases for Reporting System
are on the history server.
9. Delete any old reporting system jobs, such as Copy Backups to History
Server and Update Object and Meta Databases.
You can search for these jobs on the history server by using SQL Enterprise
Manager. Click Management -> SQL Server Agent -> Jobs.
10.Run a SQL database backup job on the live database server if one has not
been run recently. Be sure that the user ID associated with the
SQLServerAgent on both the live and history servers has
TBSM_Administrator authority. This is to ensure that the Move events to
History Database job on the live database server will run successfully.
11.Run the Copy Backups from Live DB Server job on the history server. Verify
that the database backups have arrived on the history server. Currently these
are the backup files of the Meta, Object, and RODM databases.
12.Run the Restore Databases for Reporting System job on the history server.
13.Setting up the reporting system:
Use the Reporting System Database Configuration program found in the
Tivoli Manager programs folder to set up the DefaultData and PrimaryData
databases with the parameters shown in Table 6-4 on page 199.