By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,721 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,756 IT Pros & Developers. It's quick & easy.

Instance Question

P: n/a
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.

--

Rhino
Nov 25 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Ian
rhino wrote:
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.)
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


Nov 27 '07 #2

P: n/a

"Ian" <ia*****@mobileaudio.comwrote in message
news:47**************@mobileaudio.com...
rhino wrote:
>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.)

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...
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
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
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
>


Nov 27 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.