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:
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.