473,320 Members | 1,724 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,320 software developers and data experts.

How to administer multiple DB2 instances

What is a good tool to administer a couple of hundred DB2 databases,
each running on its own Linux server, over a WAN? Ideally the tool
would run on Windows.

In SQL Server, Enterprise Manager is able to do it. I was wondering if
there is a similar type tool for DB2/Linux.

Nov 6 '06 #1
5 1661
ilanwajs...@gmail.com wrote:
What is a good tool to administer a couple of hundred DB2 databases,
each running on its own Linux server, over a WAN? Ideally the tool
would run on Windows.

In SQL Server, Enterprise Manager is able to do it. I was wondering if
there is a similar type tool for DB2/Linux.
DB2 Control Center. There are also 3rd party tools such as DBArtisan
and Quest for DB2.

Nov 6 '06 #2
Take a look at Tivoli Monitoring for DB2:

http://www-306.ibm.com/software/tivo...ts/monitor-db/

Larry Edelstein

il*********@gmail.com wrote:
What is a good tool to administer a couple of hundred DB2 databases,
each running on its own Linux server, over a WAN? Ideally the tool
would run on Windows.

In SQL Server, Enterprise Manager is able to do it. I was wondering if
there is a similar type tool for DB2/Linux.
Nov 7 '06 #3

Mark A wrote:
ilanwajs...@gmail.com wrote:
What is a good tool to administer a couple of hundred DB2 databases,
each running on its own Linux server, over a WAN? Ideally the tool
would run on Windows.

In SQL Server, Enterprise Manager is able to do it. I was wondering if
there is a similar type tool for DB2/Linux.

DB2 Control Center. There are also 3rd party tools such as DBArtisan
and Quest for DB2.
On DB2 Control Center, I've tried connecting to more than one Database.
The problem is that all my databases have the same name, and Control
Center gives me an error saying the database name is already in use
when I try to add one. Am I doing something wrong or is this a
limitation of Control Center?

Nov 7 '06 #4
When you use the CC to add databases, each alias you choose must be unique.
In fact, for that instance, any alias has to be unique, whether from the CC
or command line or what.
In the CC, when you add db's which true names are all the same, you will
have to give each a unique alias.
If you have THEDB in Server1, THEDB in Server2, THEDB in Server3, .....
Then in your CC, you should add THEDB of Server with an alias of THEDBSV1
and then add THEDB of Server2 with an alias of THEDBSV2 and so on.

By the way, if the db's are all the same structure in each server and only
the data differs, you might want to read and investigate using the Satellite
Control functions of you Control Center.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<il*********@gmail.coma écrit dans le message de news:
11**********************@b28g2000cwb.googlegroups. com...
>
Mark A wrote:
>ilanwajs...@gmail.com wrote:
What is a good tool to administer a couple of hundred DB2 databases,
each running on its own Linux server, over a WAN? Ideally the tool
would run on Windows.

In SQL Server, Enterprise Manager is able to do it. I was wondering if
there is a similar type tool for DB2/Linux.

DB2 Control Center. There are also 3rd party tools such as DBArtisan
and Quest for DB2.

On DB2 Control Center, I've tried connecting to more than one Database.
The problem is that all my databases have the same name, and Control
Center gives me an error saying the database name is already in use
when I try to add one. Am I doing something wrong or is this a
limitation of Control Center?
Nov 7 '06 #5
Thanks that was very helpful, it worked. I'll investigate the Satellite
Control function. Hoping this provides as good a tool as Enterprise
Manager.

Pierre Saint-Jacques wrote:
When you use the CC to add databases, each alias you choose must be unique.
In fact, for that instance, any alias has to be unique, whether from the CC
or command line or what.
In the CC, when you add db's which true names are all the same, you will
have to give each a unique alias.
If you have THEDB in Server1, THEDB in Server2, THEDB in Server3, .....
Then in your CC, you should add THEDB of Server with an alias of THEDBSV1
and then add THEDB of Server2 with an alias of THEDBSV2 and so on.

By the way, if the db's are all the same structure in each server and only
the data differs, you might want to read and investigate using the Satellite
Control functions of you Control Center.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<il*********@gmail.coma écrit dans le message de news:
11**********************@b28g2000cwb.googlegroups. com...

Mark A wrote:
ilanwajs...@gmail.com wrote:
What is a good tool to administer a couple of hundred DB2 databases,
each running on its own Linux server, over a WAN? Ideally the tool
would run on Windows.

In SQL Server, Enterprise Manager is able to do it. I was wondering if
there is a similar type tool for DB2/Linux.

DB2 Control Center. There are also 3rd party tools such as DBArtisan
and Quest for DB2.
On DB2 Control Center, I've tried connecting to more than one Database.
The problem is that all my databases have the same name, and Control
Center gives me an error saying the database name is already in use
when I try to add one. Am I doing something wrong or is this a
limitation of Control Center?
Nov 8 '06 #6

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...
6
by: google | last post by:
I have a few general questions. I am working on a new database to be used within my company. I would like to give a couple of people, particularly HR, the ability to add and delete Access users,...
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: 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...
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...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.