Hi,

I am usign DB2 V8.1 solaris.

I have two instances created inst1 and inst2

Inst1 is the current instance, i want to change current instance to isnt2 so that i can work with db in it.

when i give $db2 get instance it returns "isnt1"
Now i want to change the current instance to "Inst2"

I have given this command $db2 attach to inst2 user inst2usr1 using inst2usr

now when i give $db2 get instance it is still returning "inst1"

what i am missing here?

Thx

if attached to an instance : you are not that instance : you can execute commands that need an attachment to this instance.
If the db list is needed : export DB2INSTANCE:inst2 or execute the profile of the other instance and you will think as the other instance
Best Regards, Guy Przytula

Before you set the profile of the other instance, do a 'db2 terminate' ... This refreshes the directory cache .. Otherwise, you will be able to list the db directory of the other instance but when you connect, you may get 'db not found' error

Cheers
Sathyaram