Skip to main content

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

Copyright and trademark information

IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.

Rate this page:


(0 users)Average rating

Add comments

Document information

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

Content navigation