Re: Multiple instances of SE?

In article <35C1F431.3CDB6E35@garpac.com>, Jacob Salomon <jake@garpac.com> wrote: > Hi Family, > > is it possible to have multiple instances of SE defined on one SQLHOSTS > file? I blindly started set up for a second instance as follows: > > garpacse seipcpip scosysv sqlexec > javase seipcpip scosysv duuuuhh? You should use tcp/ip and corresponding entries in /etc/services. But see below. > > Say, what *would* I put in the service name for a second SE instance? Or > does it not really need to be sqlexec? > > My situation is that I want the database name (yutzdb for the purposes > of examples) to be the same on both "instances". > > I know I can change which yutzdb database a program is referencing by > playing with the DBPATH environment variable. I might have a yutzdb > database under directory /dbs and another yutzdb database under > directory /jvdbs; by setting DBPATH to one of these directory names > (before starting the program) I can be certain of which yutzdb database > I am referencing. This will solve the basic existence problem. > > Now I want to be able to copy data from one of these databases to the > other, prefereably without the intermediate .unl files. I need to be > able to do it in a single SQL statement - > insert into yutzdb.orders -- in local /dbs/yutzdb database > select * from yutzdb.orders; -- from /jvdbs/yutzdb database> AFAIK SQL syntax for SE prevents usage of database:table and database@dbserver:table forms. And I don't know why you suppose that 'yutzdb' refers to different databases in the same SQL statement. > (Yes, I suppose I would have to run two instances of sqlexecd in order > for this to work.) > Actually I don't know, is this possible. I suppose yes. You should use different dbservernames when starting sqlexecd and it seems should not be problem with memory usage. > Hence, my desire to use the more familiar syntax with server names as > part of the table names: > > insert into orders -- in local garpacse-/dbs/yutzdb > select * from yutzdb@javase.orders -- The one in /jvdbs/yutzdb> > Is such a cross-server addressing scheme even possible in SE? How would > the server name (garpacse, javase) even relate to the different > directories containing the respective databases? > > Or am I cluelessly off the deep end on this one? (I realize some of my > questions are based on the dubious assumption that it is possible.) > > Thanks much. > -- > -- Jake (Retrospectively realizes there is no future in hindsight) > +------------------------------------------------------------+ > | The expedient performance of a task with excessive concern | > | regarding its duration-to-completion engenders a virtual | > | certainty of diminished benefit therefrom. | > | -- Benjamin Franklin (but he said it in 3 words) | > +------------------------------------------------------------+ > -- Vardan Aroustamian -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum