Is there ann trick/nice way to do this ?
Here is the thngs:
2 UDB database on different box running instance.

Any connection from client may go to either one of the two.

also need to consider what if one box go down , can the second continue ? ??
transaction 'll b ein syn for first an second ?
sorry guys , need ideas ...

Thanks in advance!

Are talking about partitioning a database, That would create 1 instance and you can put it accross different servers?

David,
thanks for quick response!
If it is a solution applicable can you explain how ?
we wanna consider all posible scenario..

partitioning a database means part of the table are residing on each box.
this to benefit of the power of both boxes or for really big databases.
There are scenarios - where if a partition goes down, another box can take over. See db2 documentation : backup-recovery - high availability that documents some scenarios...
Best Regards, Guy Przytula

Data Partitioning (DPF) is technique that splits tables across multiple partitions (on the same DB server or on different DB servers). It was designed to induce query parallelism on SQL statements on data warehouse systems that read large portions of the table wach time. It does not work as well on OLTP systems where only a few rows are accessed via an index.

Even though DB2 DPF can be made to provide some semblance of failover protection and high availability, there are other DB2 facilities such as HADR (which is new in version 8.2) which are more appropriate to OLTP systems and high availability.

However, none of these DB2 features provide a good solution for high availability and scalability in an OLTP environment, such as might be better provided by Oracle RAC. This is because with DPF, the overhead for DB2 figuring out which partition has the data is too high for most OLTP systems, and the HADR solution requires that the backup server be a passive standby system.

DB2 version 8.2 on LUW has introduced HADR just like Oracle standby/dataguard.
The replication is anothe way of doing the same thing.
Also DB2 ver 8.2 also introduce client redirect, if one server is down,
It will redirect to another server.

Regards & thanks

Mujeeb

Is partitioning anyway applies to these scenario ?

Any other way than HADR can achieve load balancing ?

anyone know or have done in past ? I couldn't find exact scenario where LB and FO is needed.