SIGN UP MEMBER LOGIN:
   
  • Home
  • »
  • DB2
  • »
  • How to change the active instance in db2 ?
AuthorQuestion
How to change the active instance in db2 ?
Posted on: 06 Apr 2011
Currently, I am working in the default instance i.e. DB2 (created at the time of installation of Express-C).
Now, I create a new instance but not able to create database in it. Every time I create a new database it stored in previous instance-DB2, but I need to create database in my new instance i.e. "vrinst".

can somebody help !

thanks in advance...

AuthorReply
Deepak Kumar
  • 14
  • 0
accepted
Re: How to change the active instance in db2 ?
Posted on: 06 Apr 2011   Accepted Answer
hi veerbhadra,

As I understand you want to change the currently active instance. So you can use "set db2instance=<instance_name>" to do so.

For demonstration, see this article

click here to navigate to the article.

Re: How to change the active instance in db2 ?
Posted on: 06 Apr 2011  
Hello Deepak!

Thanks a lot for your answer and posting such a nice article.