Hi All,

We have 2 versions of Db2 running on the same box. Db2 v7.1 and db2v8.2

Now I need to drop databases and instances from the DB2 v7.1.

Unfortunately the name of databases and instances are same in both the versions.

The user that I use to connect to DB2, by default connect to the DB2 V8.2 as the db2profile it uses that has DB2 v8.2 location as DB2DIR.

1) How I can I be sure that I drop the right database and instance.

2) One more thing. When we use db2imigr to migrate the instance does the instance in old db2 version ceases to exist or it MOVES from old to new version.

We are on AIX 4.3

Regards,
Divakar

When issuing the "db2 connect to ..." command, this returns a line of the formor something like that.
So first parse this output before proceeding with a subsequent "db2 drop database ..."

(I'm assuming that your "db2 ..." commands are put in a script.)

db2level in the instance where the db should be dropped would indicate also the version