473,503 Members | 13,285 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Instance Question

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
2 2028
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

"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

30
3427
by: Joost Ronkes Agerbeek | last post by:
Why is it allowed in C++ to call a static member function of an object through an instance of that object? Is it just convenience? tia, Joost Ronkes Agerbeek
0
1942
by: cat | last post by:
HiFolks, I am newbie in DB2 ESE. Here is the question, I already created an instance db2inst1 under file system /db2home/db2inst1 ( actually the instance has been created after installation.)...
5
3621
by: allison | last post by:
Can someone point me to a guide on when to use static methods versus instance methods in a class? For instance, is it bad design to have a static method that creates an instance of another class? ...
6
4637
by: Dmitry Karneyev | last post by:
Hi! I guess this question have been asked a lot of times, but please be tolerant and if you have any ideas share it. The question is: how to make availibale only one instance of application and...
20
27729
by: Shawnk | last post by:
I would like to get the class INSTANCE name (not type name) of an 'object'. I can get the object (l_obj_ref.GetType()) and then get the (l_obj_typ.Name) for the class name. I there any way of...
4
1531
by: Tony Johansson | last post by:
Hello! I have a class definition called MyClass see below. I create an instance of this class MyClass I also want this instance to be able to modify the test instance that exist in this...
9
1624
by: manstey | last post by:
Hi, My question probably reflects my misunderstanding of python objects, but I would still like to know the answer. The question is, is it possible for an instnace to have a value (say a...
12
1365
by: Analizer1 | last post by:
Hi.... when i use the new keyword myobject obj1 = new myobject() myobject obj2 = new myobject() myobject obj3 = new myobject() does each of the object have a complete instance of myobject,...
5
1884
by: Andy B | last post by:
I am trying to figure out how to make an object instance available for all methods of a class. I tried to do something like this: public class test { TheObject Instance = new TheObject();...
19
1910
by: =?Utf-8?B?WWFua2VlIEltcGVyaWFsaXN0IERvZw==?= | last post by:
I'm doing my c# more and more like i used to code c++, meaning i'm casting more often than creating an instance of objects. like : protected void gvOrderDetailsRowDataBound(object sender,...
0
7212
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7098
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7364
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
5604
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
3186
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3174
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1524
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
751
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
405
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.