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

multiple instances

P: n/a
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
Share this Question
Share on Google+
4 Replies


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

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

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

P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.