By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,589 Members | 2,276 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,589 IT Pros & Developers. It's quick & easy.

db2 toolsdb

P: n/a
Is there a way I can drop and recreate the toolsdb?

I already have a toolsdb in our server but somehow it is kind of messed up.
Whenever I try to drop the following message:

SQL1035N The database is currently in use

What is the command to recreate the toolsdb?
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
See the IBM Information Center for the following command:

CREATE TOOLS CATALOG command

Do a list applications on your server, then perform a Force Application
on each ID that is connected to the Tools database.

Then recreate it with the above command.

Hope that helps!!!!!

Martin

Nov 12 '05 #2

P: n/a
Sorry - Drop the old tools database after forcing off all connections
to it.

Then use the command to recreate it...

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.