Instance Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rhino - 25 Nov 2007 07:31 GMT

I am trying to create a second instance on a Windows XP machine that has DB2
Personal Edition installed. It's not going awfully well so I thought I'd ask
some questions here.

My 'db2icrt db2test' command was successful.
My db2ilist command shows my two instances, db2 and db2test

However, Control Center shows only ONE instance, db2. Is there anything
special I need to do to make the instance visible to the Control Center?
I've tried db2stop/db2start, net start db2test, and a few other things
besides but nothing makes db2test visible in Control Center. (Yes, I do
View/Refresh each time I try something. I've also tried exiting and
restarting Control Center.)

Also, how do I create the Sample Database in the new db2test instance? I
assume I need to do something like "connect" or "attach" to point to the
db2test instance, then execute my db2sampl command there. I'm not sure what
verb/command I need for this task though. I haven't found the answers in the
manuals either.

Signature

Rhino

Reply to this Message

Ian - 27 Nov 2007 03:46 GMT

> I am trying to create a second instance on a Windows XP machine that has DB2
> Personal Edition installed. It's not going awfully well so I thought I'd ask
[quoted text clipped - 9 lines]
> View/Refresh each time I try something. I've also tried exiting and
> restarting Control Center.)

You need to add the new instance: Expand the "All Systems" folder, and
expand the folder corresponding to your machine, right click on
instances, then click "Add". Fill in the appropriate information...

> Also, how do I create the Sample Database in the new db2test instance? I
> assume I need to do something like "connect" or "attach" to point to the
> db2test instance, then execute my db2sampl command there. I'm not sure what
> verb/command I need for this task though. I haven't found the answers in the
> manuals either.

In DB2 command window,

set DB2INSTANCE=db2test
db2 terminate
db2sampl

Reply to this Message

rhino - 27 Nov 2007 07:36 GMT

>> I am trying to create a second instance on a Windows XP machine that has
>> DB2 Personal Edition installed. It's not going awfully well so I thought
[quoted text clipped - 13 lines]
> expand the folder corresponding to your machine, right click on
> instances, then click "Add". Fill in the appropriate information...

I eventually figured that out on my own and didn't get back here to note
that.

>> Also, how do I create the Sample Database in the new db2test instance? I
>> assume I need to do something like "connect" or "attach" to point to the
[quoted text clipped - 7 lines]
> db2 terminate
> db2sampl

Oh, so THAT'S how I do that!! Thank you very much!

That's the best approach I've seen yet.

Thanks again, Ian!

--

Rhino

Reply to this Message