Create Replica database on the same server

Hi,I want to create a replica of my database on the same server. is it possible? if yes, what do i need to schedule the replication (a document connection) ?

Thanks

Subject: Create Replica database on the same server

I do not think that this is possible.

Subject: Create Replica database on the same server

Hello Cyril,

As described in the Technote referenced below, creating replicas on the same server is not recommended:

http://www.ibm.com/support/docview.wss?rs=899&uid=swg21096344

Subject: Create Replica database on the same server

What possible reason could you have for wanting 2 replicas on the same server (and i assume you dont mean copies)? This is potentially dangerous let alone confusing.

Subject: RE: Create Replica database on the same server

Well, i need to create.I have a database named “globalDB.nsf”. I have other databases (“country1DB.nsf”, “country2DB.nsf”, “country3DB.nsf”, …) located on other servers in other countries and these databases are created by replicating “globalDB.nsf”.

But i have to create a “countryXDB.nsf” on the same server where “globalDB.nsf” is.

Are you understanding my problem?

Subject: RE: Create Replica database on the same server

You absolutely DO NOT want to have two or more replicas of one database on the same server. Yes, it can be done. Yes, you WILL spend most of your time fixing the problems this will cause.

Subject: RE: Create Replica database on the same server

Stan, I’m agree with you. But how can i fix my issue?

Do you understand what i want to do? Do you want me to give more details?

I have a this topology :

  • A global database stored on a server in a country as a subregion

  • Some databases located in different countries (those countries are part of the subregion), one database by country

  • Databases of companies which are in a specified country (one or more companies by country, so you could have more databases on same sever).

Now the “subregion” database is located on a server in France (for example). This server hosts the databases of the country (France) and French companies (as Company1, company2…)

So i may have two or more replicas of the databae on the same server.

Do you have an other idea for resolving my problem?

Subject: RE: Create Replica database on the same server

What part of “don’t have more than one replica of a database on a single server” is hard to understand? Use the SAME database (and see Carl’s answer).

Subject: Could you solve your problem by having a datbase link in each folder?

Lookin in Admin help for Database and File Link

Subject: RE: Could you solve your problem by having a datbase link in each folder?

Carl,Can you give me more details on your idea please? I looked in Admin Help but i didn’t see something interesting for resolving my problem!

Tx!

Subject: Not sure what I can add above the help

A database link is a text file that can point to a database on a different drive/folder etc.

So in your case.

You have the main DB “globalDB.nsf”

Then you have other databases “country1DB.nsf”, “country2DB.nsf”, “country3DB.nsf”, …

For the databases country1DB.nsf, 2DB etc. just make them database links that point back to the globalDB.nsf, so you only have a single DB and you don’t get messed up by having multiple replicas of the same db.