Clustered Environment Newbie Queries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Praveen_db2 - 20 Feb 2006 07:48 GMT

Hi All
We are about to use Clustered Environment in db2 v8.2 .I have a few basic
queries about it.

1.What are the system software requirements for cluster environment?

2.How to configure database for cluster / distributed environment?

3.How to configure application for database on two servers?

4.Are there any database design level changes required to suit cluster
environment?

5.Are there any other issues which should be taken care of?

Also please tell if Distributed and Clustered environment are same or
different?

Any inputs on above queries or any article or link which can clarify these
things will be of great help.

TIA

Praveen

Reply to this Message

Serge Rielau - 20 Feb 2006 12:29 GMT

> Hi All
> We are about to use Clustered Environment in db2 v8.2 .I have a few basic
[quoted text clipped - 16 lines]
> Any inputs on above queries or any article or link which can clarify these
> things will be of great help.

Thsi article will interest you. It is squarely aimed at simplifying you
choices:
http://www.ibm.com/software/data/db2bi/bcu/

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

dotyet - 20 Feb 2006 18:50 GMT

it depends on your platform...

we are on windows x64 env, and we are using microsoft cluster.
it would be different on aix (rsct maybe), solaris (sun cluster or
veritas) and linux (tivoli, steel eye).

rgds,
dotyet

Reply to this Message

Larry - 20 Feb 2006 19:14 GMT

> it depends on your platform...
>
[quoted text clipped - 4 lines]
> rgds,
> dotyet

Actually, the first order of business is to find out the business
objectives. What is generating the need for the clustering? Why is the
OP not clear on clustering vs. distributing? I guess it would be helpful
if the OP posted a statement of what he/she is trying to accomplish first.

Larry Edelstein

Reply to this Message

dotyet - 20 Feb 2006 20:14 GMT

very true.... cluster and distributed computing are two separate
streams altogether.

rgds,
dotyet

Reply to this Message

Mark A - 20 Feb 2006 20:21 GMT

> very true.... cluster and distributed computing are two separate
> streams altogether.
>
> rgds,
> dotyet

There are several things that can be meant by clustering in DB2:

1. Defining a cluster index.

2. Using MDC (Multi-Dimensional Clustering) with the organize by statement.

3. DPF - Parallel processing with multiple logical and/or physical nodes for
a given table.

4. A cluster of 2 servers which includes a backup server managed by HADR (no
shared disk databases) or HACMP/Veritas/etc (shared disk for databases) that
requires some type of failover if the first server is no longer available.

Reply to this Message