?
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
?
330 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

752 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