Errors during installing the TBSM 6.1 metric history database

Technote (troubleshooting)


Problem(Abstract)

How do I resolve errors that occurred during the TBSMHIST db installation

Symptom



UPDATE DATABASE CONFIGURATION FOR TBSMHIST USING LOGBUFSZ 384
DB20000I The UPDATE DATABASE CONFIGURATION command completed
successfully.
SQL1363W One or more of the parameters submitted for immediate
modification
were not changed dynamically. For these configuration parameters, all
applications must disconnect from this database before the changes
become
effective.

UPDATE DATABASE CONFIGURATION FOR TBSMHIST USING LOGFILSIZ 32000
DB20000I The UPDATE DATABASE CONFIGURATION command completed
successfully.
SQL1363W One or more of the parameters submitted for immediate
modification
were not changed dynamically. For these configuration parameters, all
applications must disconnect from this database before the changes
become
effective.

UPDATE DATABASE CONFIGURATION FOR TBSMHIST USING LOGPRIMARY 6
DB20000I The UPDATE DATABASE CONFIGURATION command completed
successfully.
SQL1363W One or more of the parameters submitted for immediate
modification
were not changed dynamically. For these configuration parameters, all
applications must disconnect from this database before the changes
become
effective.

UPDATE DATABASE CONFIGURATION FOR TBSMHIST USING NEWLOGPATH 'E:/'
SQL5099N The value "E:\" indicated by the database configuration
parameter
"NEWLOGPATH" is not valid, reason code "4". SQLSTATE=08004

The schema was not created successfully. Check the log for SQL errors
(such as DB21034E SQL errors).


Resolving the problem

To drop the TBSMHIST db ONLY.

1. Launch the db2 control center

2. Select the TBSMHIST db and select drop

3. cd to cd \IBM\tivoli\tbsmdb\bin

4. Create the database with the command: tbsm_db.bat -s mh -c

6. Load the Schema: tbsm_db.bat -s mh -f c -U db2admin -P tbsm01bm

The end result should be DB20000I The SQL DISCONNECT command completed successfully.

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

Reference #:

1622867

Modified date:

2013-01-21

Translate my page

Machine Translation

Content navigation