473,218 Members | 1,809 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,218 software developers and data experts.

multiple instances

I have a Aix 5.2 server with DB2 UDB 8.1
I created three different instances using the db2setup utility three
times. The default instance is db2inst1. When I su - db2inst2 and su -
db2inst3 and run the db2cc to see the command center I do not see any
instances. All I see in the left window is the top level directory. Is
this normal?
How can I see all the instances?
Also how can I start all three instances?
Please inform me.
Thanks,
Yasaswi
Nov 12 '05 #1
4 3681
CATALOG NODE ...

"Yasaswi Pulavarti" <ya*****@encfor.com> wrote in message
news:aa**************************@posting.google.c om...
I have a Aix 5.2 server with DB2 UDB 8.1
I created three different instances using the db2setup utility three
times. The default instance is db2inst1. When I su - db2inst2 and su -
db2inst3 and run the db2cc to see the command center I do not see any
instances. All I see in the left window is the top level directory. Is
this normal?
How can I see all the instances?
Also how can I start all three instances?
Please inform me.
Thanks,
Yasaswi

Nov 12 '05 #2
Hi Fan:
I am not sure what CATALOG NODE... means.
How can I run multiple instances on the same AIX 5.2 pSeries server?
Can I sent more than one DB2INSTACE environment variable? Please
advise.
Thanks,
Yasaswi
"Fan Ruo Xin" <fa*****@sbcglobal.net> wrote in message news:<%m*****************@newssvr17.news.prodigy.c om>...
CATALOG NODE ...

"Yasaswi Pulavarti" <ya*****@encfor.com> wrote in message
news:aa**************************@posting.google.c om...
I have a Aix 5.2 server with DB2 UDB 8.1
I created three different instances using the db2setup utility three
times. The default instance is db2inst1. When I su - db2inst2 and su -
db2inst3 and run the db2cc to see the command center I do not see any
instances. All I see in the left window is the top level directory. Is
this normal?
How can I see all the instances?
Also how can I start all three instances?
Please inform me.
Thanks,
Yasaswi

Nov 12 '05 #3
When you launch the db2cc command it looks for the DB2INSTANCE system
environment variable to find the instance name against which it will
run. (If it does not exist it looks for the db2 global profile
DB2INSTDEF and if it doesn't find that, I think it starts empty.)

The instance name it finds then looks in its NODE and SYSTEM DATABASE
directories to identify which db's and instances it is aware of.
Those instances are identified as a NODE, thus Fan's suggestion to
catalog a node.
You can get them to start automatically by using the db2iauto -i
<instance name> command.

As you start with DB2 INST1 , start the Control Center.
Then on the system name shown in the CC left panel, right click and
choose to add.
On the following screen, click DISCOVER and follow on from there.
HTH, Pierre.

Yasaswi Pulavarti wrote:
Hi Fan:
I am not sure what CATALOG NODE... means.
How can I run multiple instances on the same AIX 5.2 pSeries server?
Can I sent more than one DB2INSTACE environment variable? Please
advise.
Thanks,
Yasaswi
"Fan Ruo Xin" <fa*****@sbcglobal.net> wrote in message news:<%m*****************@newssvr17.news.prodigy.c om>...
CATALOG NODE ...

"Yasaswi Pulavarti" <ya*****@encfor.com> wrote in message
news:aa**************************@posting.google .com...
I have a Aix 5.2 server with DB2 UDB 8.1
I created three different instances using the db2setup utility three
times. The default instance is db2inst1. When I su - db2inst2 and su -
db2inst3 and run the db2cc to see the command center I do not see any
instances. All I see in the left window is the top level directory. Is
this normal?
How can I see all the instances?
Also how can I start all three instances?
Please inform me.
Thanks,
Yasaswi


--
Pierre Saint-Jacques - Reply to: sescons at attglobal dot net
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.
Nov 12 '05 #4
ya*****@encfor.com (Yasaswi Pulavarti) wrote in message news:<aa**************************@posting.google. com>...
Hi Fan:
I am not sure what CATALOG NODE... means.
How can I run multiple instances on the same AIX 5.2 pSeries server?
Can I sent more than one DB2INSTACE environment variable? Please
advise.
Thanks,
Yasaswi

You should have created each instance with a different port number.
See the Command Reference for creating an instance.

Port number is one of the parms in the catalog node command. When
cataloging a node in DB2, the node is really a combination of the
server (host name) and the port number. Then you catalog each database
to the node (which is really the instance on a particular server).
Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Martin V. | last post by:
Hello, Is the multiple instances capability of SQL2K mature enough for a Production system? We're looking at upgrading our hardware but the proposed solution calls for consolidating two...
1
by: Vlad | last post by:
Is there any way to install multiple instances of the same windows service designed with VS.NET 2003? I tried copying the binaries into a separate folder and then copying registry entries for the...
11
by: Mike | last post by:
Looking to find any information on how to properly configure multiple instances of DB2. This is on Win2k db2 ver 7.2. I am basically looking for information on how the multiple instance settings...
11
by: Clark Stevens | last post by:
I just finished a WinForms app in VB.NET. I want to allow the user to be able to run multiple instances of the program like you can with Notepad and Wordpad. The way it is now, once I run the...
3
by: Michel | last post by:
Hi, I wrote an app in .Net and I whant only 1 instance of this app open for the user; the user open my app, do some works and try to open another instance of my app, I whant to show a message to...
0
by: CNN_news | last post by:
I would like to run multiple instances of TYPO3 (a cms written in PHP) on a single server. You can run multiple websites in two methods: multisite or multiple instances. In multiple...
0
by: rbg | last post by:
Have a web application which uses Data Cache. I need to understand what happens when a new instance of the same web application is created for for serving concurrent clients. What happens when...
6
by: Bugs | last post by:
Does anyone have any recommendations on the best way to create multiple instances of the same class when the final number of instances is unknown? For example, I have a class and based on some...
3
by: Marcin Kalicinski | last post by:
How do I use multiple Python interpreters within the same process? I know there's a function Py_NewInterpreter. However, how do I use functions like Py_RunString etc. with it? They don't take any...
5
by: Neil | last post by:
"lyle" <lyle.fairfield@gmail.comwrote in message news:48c3dde7-07bd-48b8-91c3-e157b703f92b@f3g2000hsg.googlegroups.com... Question for you. I'm doing something similar, only, instead of opening...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

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.