multiple instances - DB2 Database

Yasaswi Pulavarti

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

Subscribe Reply

3717

Fan Ruo Xin

CATALOG NODE ...

"Yasaswi Pulavarti" <ya*****@encfor .com> wrote in message
news:aa******** *************** ***@posting.goo gle.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

Nov 12 '05 #2

Yasaswi Pulavarti

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*****@sbcglo bal.net> wrote in message news:<%m******* **********@news svr17.news.prod igy.com>...

CATALOG NODE ...

"Yasaswi Pulavarti" <ya*****@encfor .com> wrote in message
news:aa******** *************** ***@posting.goo gle.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

Nov 12 '05 #3

Pierre Saint-Jacques

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*****@sbcglo bal.net> wrote in message news:<%m******* **********@news svr17.news.prod igy.com>...
CATALOG NODE ...

"Yasaswi Pulavarti" <ya*****@encfor .com> wrote in message
news:aa****** *************** *****@posting.g oogle.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

Mark

ya*****@encfor. com (Yasaswi Pulavarti) wrote in message news:<aa******* *************** ****@posting.go ogle.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

Similar topics

2215

Multiple instances ready for Production prime-time?

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 currently separate SQL Server's onto one machine with two CPU's. Of the current two servers, one is for OLTP (~800Mb) and the other for

Microsoft SQL Server

6003

Multiple Instances of Windows Services

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 original service under a new name but the SCM complains that the executable does not have this service implemented. Please note that I need to have distinct instances of executables installed not merely multiple windows services defined within...

.NET Framework

5319

Configuring Multiple Instances DB2 WINNT

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 should configured to work, how memory is shared or not, etc. I can not seem to find any good links to this information. Thanks, Mike

DB2 Database

21004

Running multiple instances of a program

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 executable I can not run another instance as long as the first instance is running. How can I change this behavior? Thanks.

Visual Basic .NET

2602

Identify multiple running instances of an application

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 user to inform him that only one instance is permit and then close the second instance after that. I am able to do this when the user run the application on his PC whit this : Process.GetProcessesByName(Process.GetCurrentProcess.ProcessName) ...

.NET Framework

1478

PHP memory for multiple websites

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 instance, each instance uses the same source files but has its own database and private file storage area.

PHP

1916

Data caching with multiple HTTPApplication instances

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 the data in the cache expires (either due to expiration or due to dependency change) do all instances of the Http Application replace the cached data at the same time. Thus what I am essentially asking is, in a single server scenario if multiple...

ASP.NET

6917

Multiple instances of same object ?

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 user actions, I want to create n number instances of those classes, which is obviously unknown at compile time. What is the easiest way to create and then manage these kinds of objects? Using an array seems intuitive but it also seems like it...

Visual Basic .NET

9181

Multiple python interpreters within the same process

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 arguments that would tell on which interpreter to run the string...? Marcin

Python

3311

Working With Multiple Form Instances

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 the forms all at once, I'm opening them as needed. I have a main form with multiple records; and then I have a pop-up form that the user opens with button. The pop-up form contains one record relating to the current record in the main form (but...

Microsoft Access / VBA

9618

What is ONU?

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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10038

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8933

AI Job Threat for Devs

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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6710

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5354

Trying to create a lan-to-lan vpn between two differents networks

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 last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5482

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4007

transfer the data from one system to another through ip address

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 we have to send another system

C# / C Sharp

3609

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2849

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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 can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General