I used the Create Database Wizard in CC to create a quick test
database. However, I screwed up when it asked about what
database path (DFTDBPATH) to use. Rather than using the DFTDBPATH
that is the default in my dbm cfg, I specified a database path
one subdir *under* my default DFTDBPATH.

So now I have 2 database dirs w/ SQL00001 dirs in them. One is
the test DB, the other is my production DB. If I drop the test
DB, will DB2 actually drop my production DB?

How can I safely drop that test DB so that I can recreate it under
the correct default DFTDBPATH?

Any help appreciated.

aj

Yes, I know -- it was a newbie question. But I create and drop
DB's infrequently, so I was skittish.

I found a very helpful post by Larry Menard:
http://tinyurl.com/8epwg

Using the System and Local Database Directory, and the
db2 list database directory
command, I could see that DB2 knew what was what and where
with the test DB.

thanks

aj


aj wrote:
> I used the Create Database Wizard in CC to create a quick test
> database. However, I screwed up when it asked about what
> database path (DFTDBPATH) to use. Rather than using the DFTDBPATH
> that is the default in my dbm cfg, I specified a database path
> one subdir *under* my default DFTDBPATH.
>
> So now I have 2 database dirs w/ SQL00001 dirs in them. One is
> the test DB, the other is my production DB. If I drop the test
> DB, will DB2 actually drop my production DB?
>
> How can I safely drop that test DB so that I can recreate it under
> the correct default DFTDBPATH?
>
> Any help appreciated.
>
> aj