Improve company productivity with a Business Account.Sign Up

x
?
Solved

Database Links do not point to the desired domino server but to another domino server which contains a replica of the database

Posted on 2004-09-21
5
Medium Priority
?
338 Views
Last Modified: 2013-12-18
We run Domino R6.5.1 servers and Clients

We have several branch servers around the country.  The problem we have found is as follows:

I have a database at head office (Sandton JHB) on my Domino Application server, I perform a database link on this database.  Now this database has replicas on all our branch servers (Cape Town, Durban and Pretoria)

When I send users in Sandton head Office this link, and they launch it, it links them to the replica database in Cape Town, which is 1200km away.   So the link that I create at my head office and I send it to another head office user, points that user to a server in Cape Town with a replica of that database.  

I cannot seem to find out why it does not point the user to the database on our Sandton Server.

PLEASE HELP!!!!
0
Comment
Question by:RMBTechnology
5 Comments
 
LVL 15

Expert Comment

by:Bozzie4
ID: 12110049
Well, this works as designed....  It makes a lot of sense to direct the user to the server that is closest to him.  Is there a specific reason you don't want him to use this 'closeby' server ?  

cheers,

Tom
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 12110356
Tom, If I understand correctly, the users in the same building get a link to a database in CT. Which is weird. Notes opens a replica database, the original server is considered to be a "hint".

Several things I can think of:
- it might be due to the preferences in the user's Location documents
- it might be because of the connection's routing costs that are preferential for the CT server
- it might just be that the CT server connection is listed alphabetically before the JHB server

You could try to set the routing costs for the JHB-CT connection to 2, this will effectively change the order in which the connections will be tried. At least, that is what I would try to do...
0
 
LVL 14

Expert Comment

by:p_partha
ID: 12112071
Database link contains the replica ID and a hint server.

When a user clicks on a link, it will first try and locate the database from  same replica ID on the workspace. So if a user has added the replica copy at his workspace it will open that only.
The alternative would be either to remove the icon from the workspace or send a hotspot button with teh formula @Command([FileOpenDatabase];"Development":"PROBLEMS.NSF")

Partha
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 12112240
It has been a limitation for quite a while, Check this out for further info : http://www-1.ibm.com/support/docview.wss?rs=899&uid=swg21097133

~Hemanth
0
 
LVL 31

Accepted Solution

by:
qwaletee earned 1500 total points
ID: 12133923
Links are not really server-specific.  They are designed to open any available replica copy.  The source database's server is given as a "hint" so that the client can try that server first if it does not know where else to go.

But it could know where else to go.  Or, it could fail to reach the hint server, and be forced to use another copy.

How else could it know whereto go?  Local repica on workstation, icon already on workspace pointing to another copy, or the database catalog (catalog.nsf).

If you want them to only open a specific copy, send a button instead.  The button code would be:

@Command([FileOpenDatabase]; "server name" : "path to file")
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…
Watch the video to know the simple way to remove or recover or reset lost or forgotten passwords of Outlook PST file. With Kernel Outlook Password Recovery tool such operation is very easy to perform. It is a freeware with limitation to use with 500…

608 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question