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

Praveen_db2 wrote:
> 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.
Thsi article will interest you. It is squarely aimed at simplifying you
choices:
http://www.ibm.com/software/data/db2bi/bcu/

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

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

dotyet wrote:

> 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
>
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

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

rgds,
dotyet

"dotyet" <dotyet@yahoo.com> wrote in message
news:1140466457.435331.153340@z14g2000cwz.googlegr oups.com...
> 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.