View Single Post

   
  #2 (permalink)  
Old 02-26-2008, 06:22 PM
Serge Rielau
 
Posts: n/a
Default Re: Combine 2 databases into 1 database?

Joost Kraaijeveld wrote:
> Hi all,
>
> I have 1 database that is required for several applications (the data must
> be shared ). They also have there own database. Is it possible to combine 2
> databases into 1 database in DB2 7.x?
>

Is the datasharing between the two DBs massive (lots of data, often and
for many tables?)
If you read up of federated (tons of material on developerWorks) you may
be able to get away by creating a few nicknames.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Reply With Quote