Re: [Info-Ingres] NETUTIL question



Thanks Grant
Your suggestion helped and worked.
In order to enable connecting to the remote node we had to undefine the local logical. If we left it we would still connect only to the local node.
Only problem is that then we can ONLY connect to the remote node.
Is there any way we can enable connections to both local AND remote nodes ?

Thanks

David Greenberg


Grant Croker wrote:
David,

In newer Ingres releases there is a CBF parameter remote_vnode that does
this - see http://docs.ingres.com/connectivity/DefaultRemoteNodes
In older releases, perhaps this includes 2.0, the same was achieved via
a logical in the symbol table. I believe the symbol was
II_GCNxx_RMT_VNODE where 'xx' is your installation id. Use ingsetenv to
set this to NODENAME and you will get the desired behaviour. You might
have to undefine II_GCNxx_LCL_VNODE first...

regards

grant

On 03/03/08 12:23, David Greenberg wrote:

Hi
We use an older version of Ingres ( II 2.0/0011 ) on VMS.

We have set up netutil in a way that I of our servers can access another 1, serving as local & remote.
Our database , lets say is called MYDB, so now we can access the database from the local server as "NODENAME::MYDB".
The problem with that is that I'll have to change all references to the database in command procedures from MYDB to NODENAME::MYDB.
Is there a definition I can set somewhere in Ingres which will let me continue referencing my database by its name and without the nodename ?

Thnaks

David Greenberg
_______________________________________________
Info-Ingres mailing list
Info-Ingres@xxxxxxxxxxxxxxxxxxxxxxxxx
http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres



.