IBM Tivoli Business Service Manager Database Updater and Initalization Utilities

Downloadable files


Abstract

The TBSM Database Updater and Initialization Utilities provides the following functionality
1. Allow TBSM Database configuration updates
2. Initialization of TBSM Databases

Download Description


The TBSM Database Updater and Initialization Utilities provides the following functionality
1. Allows configuration settings for TBSM Databases to be updated (TBSMUpdateDatasource)
2. Initializes new TBSM Databases (TBSMInitDB)

1. Allows configuration settings for TBSM Databases to be updated (TBSMUpdateDatasource)
Post Install is is likely that a need will arise to change TBSM Database connection information. The prime example is the password, but the database user ID, hostname, or perhaps even the database name itself might change. In general, this would require updates to one or more of the TBSM_TBSM*.ds files on the data server and restarting the data server to pick up the changes. The TBSMUpdateDatasource utility handles these updates based on an input properties file, including handling the password encryption, updating the XML toolkit connection property and credentials, and checking the connection to the database after update.

2. Initializes new TBSM Databases (TBSMInitDB)
In the case where a new TBSM database is to be employed (created using the DbConfig utility post install), the database is not functional without adding the BSM templates and the TBSM xml files. This is normally done by the installer when installing the data server. The TBSMInitDB utility calls two functions to initialize a newly created database, in the case where a database is created outside of an install senario.

Prerequisites

IBM Tivoli Business Service Manager Version 6.1

Installation Instructions

Deployment

The TBSM Database Updater and Initialization Utilities zip file (TBSMDBUpdaterAndInitializer_61GA.zip) is attached to this document under Download Package. The TBSM Database Updater and Initialization Utilities zip file must be unzipped into the tbsm directory of the Data Server, under the install directory, i.e. %TBSM_HOME%. This defaults to /opt/IBM/tivoli/tbsm on Unix or C:\ibm\tivoli\tbsm on Windows. The contents must be unzipped into the "tbsm" directory and will add a new "tools" subdirectory.

Note: The files attached to this DCF will also be shipped with FP1 for TBSM 6.1.0 (6.1.0-TIV-BSM-FP0001). The files have the same initial contents. However, if changes are made to the files (i.e. to the properties files in the xml directory) these will be overwritten when FP1 is applied.

Usage
The TBSM Database Updater and Initialization Utilities are found in the tbsm\tools\bin directory relative to the install directory.

1. TBSMUpdateDatasource: Allows configuration settings for TBSM Databases to be updated
TBSM provides four datasources that are used by the product to access the TBSM DB2 databases. These datasources are called TBSMDatabase, TBSMComponentRegistry, TBSMMetricHistory, and TBSMMarker and provide the connection information for the one or more DB2 databases you configured for TBSM. These datasources are affected by changes to the database configuration, for example the common scenario where the DB2 database password is changed on a required interval. Other scenarios where these datasources are affected include changing the user ID that accesses the database, or changes to connection information (like database name, hostname, and port) that result from moving the database to a new DB2 server.

TBSM provides a utility that can be used to update the TBSM DB2 datasources and test the new connection when the connection information must change. These datasources should be updated while the Data server is stopped and the changes become effective on the next start of the Data server. This utility will also update connection information used by the Discovery Library Toolkit as required. Datasources TBSMDatabase and TBSMComponentRegistry require the same updates when the base TBSM database connection information is changed and this is handled automatically by the utility. Each datasource must be updated separately, using the following instructions:

a) Stop the Data server and the Toolkit

b) Update the %TBSM_HOME%\tools\etc file for the datasource to be updated, for example,
TBSMDatabase_ds_update.properties.

Properties files have comments about required values and optional values.

c) cd to %TBSM_HOME%\tools\bin and execute the following

Windows: TBSMUpdateDatasource TBSMDatabase
Unix: "./TBSMUpdateDatasource.sh TBSMDatabase

where TBSMDatabase can be replaced with TBSMMetricHistory, TBSMMarker, or TBSMComponentRegistry, depending on the datasource to be updated

d) Start the Data server and the Toolkit

**Note: Datasources TBSMDatabase and TBSMComponentRegistry require the same connection information so updates are made to both when TBSMDatabase is specified for update.

2. TBSMInitDB: Initializes new TBSM Databases
In some instances, it may be required to create a new database for use with a TBSM Data server using the DbConfig database installer. Or the tbsm_db utility may be used to reset an existing TBSM database, clearing all the data, including the data loaded at install time to initialize the database. In this scenario, the TBSM database is not sufficiently initialized for the TBSM servers and the Discovery Library Toolkit to function correctly.

TBSM provides a utility that can be used to initialize a newly defined database or one that has been reset. This utility will perform the functions that are normally performed during the installation of the Data server. This utility assumes the database is already connected to the Data server, and requires the Data server to be active so that the rad_radshell utility can load required templates and services.

Run the utility as follows:

a) Make sure the Data server is started, as the utility will fail if the rad_radshell utility cannot connect to the Data server. The Discovery Library Toolkit will be stopped by the utility.

b) cd to %TBSM_HOME%\tools\bin (Unix - ${TBSM_HOME}/tools/bin) and execute TBSMInitDB.(bat/sh) dbpassword, where dbpassword is optional and specifies the password used by the TBSM data server to connect to the TBSM database. This password can be omitted and you will be prompted for the value.

c) Restart the TBSM Data server and start the Discovery Library toolkit.

Rate this page:

(0 users)Average rating

Document information


More support for:

Tivoli Business Service Manager

Software version:

6.1

Operating system(s):

AIX, Linux, Linux zSeries, Solaris, Windows

Software edition:

All Editions

Reference #:

4032245

Modified date:

2012-05-17

Translate my page

Machine Translation

Content navigation