dbload ...

Hi, can we use dbload to insert data across servers ... I need to extract data from a server(srvr1) and insert to another(srvr2). Can I do something like dbload -d tstdb@Srvr2 ...... What all things should be taken care of before doing the above ???? Thanks krishnakumar Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.

krishnakn@my-deja.com wrote: > > Hi, > > can we use dbload to insert data across servers ... > > I need to extract data from a server(srvr1) and insert to > another(srvr2). > > Can I do something like > dbload -d tstdb@Srvr2 ...... Most likely that will work just fine. HOWEVER, if doing that will route all of the messages through the local engine and out the network to the remote server. To get a direct connection, avoiding the overhead of the passthrough and reducing the load on the local server, modify the INFORMIXSERVER to point to the remote server. If you are using ksh or bash you can do that directly on the commandline preceding the dbload command which will just affect the one task and not change your default for the rest of the login session: INFORMIXSERVER=Srvr2 dbload -d tstdb ...... Art S. Kagel

Seems to me that "insert into database:remote_table@informixserver select * from local_table" would be easier ... if you are able to establish an exclusive lock on the remote table AND don't have to worry about having a long transaction. Take care. Clifton Bean Art S. Kagel <kagel@bloomberg.net> wrote in message news:37A08E9F.E0E76FCB@bloomberg.net... > krishnakn@my-deja.com wrote: > > > > Hi, > > > > can we use dbload to insert data across servers ... > > > > I need to extract data from a server(srvr1) and insert to > > another(srvr2). > > > > Can I do something like > > dbload -d tstdb@Srvr2 ......> > Most likely that will work just fine. HOWEVER, if doing that will route all > of the messages through the local engine and out the network to the remote > server. To get a direct connection, avoiding the overhead of the passthrough > and reducing the load on the local server, modify the INFORMIXSERVER to point > to the remote server. If you are using ksh or bash you can do that directly > on the commandline preceding the dbload command which will just affect the one > task and not change your default for the rest of the login session: > > INFORMIXSERVER=Srvr2 dbload -d tstdb ......> > Art S. Kagel

"Clifton M. Bean" wrote: > > Seems to me that > > "insert into database:remote_table@informixserver select * from local_table" > > would be easier ... if you are able to establish an exclusive lock on the > remote table AND don't have to worry about having a long transaction. Those are two non-trivial if's. Add to them: o If you do not need access to the remote table from other applications so you can afford to lock the table. o If the load file does not have hex escapes in it. o If you can afford the load on the local server, if any, of passing all those records through it's communications buffers to the remote server. Overall dbload is usually a better choice than the dbaccess LOAD verb. Art S. Kagel > Take care. > Clifton Bean > > Art S. Kagel <kagel@bloomberg.net> wrote in message > news:37A08E9F.E0E76FCB@bloomberg.net... > > krishnakn@my-deja.com wrote: > > > > > > Hi, > > > > > > can we use dbload to insert data across servers ... > > > > > > I need to extract data from a server(srvr1) and insert to > > > another(srvr2). > > > > > > Can I do something like > > > dbload -d tstdb@Srvr2 ......> > > > Most likely that will work just fine. HOWEVER, if doing that will route > all > > of the messages through the local engine and out the network to the remote > > server. To get a direct connection, avoiding the overhead of the > passthrough > > and reducing the load on the local server, modify the INFORMIXSERVER to > point > > to the remote server. If you are using ksh or bash you can do that > directly > > on the commandline preceding the dbload command which will just affect the > one > > task and not change your default for the rest of the login session: > > > > INFORMIXSERVER=Srvr2 dbload -d tstdb ......> > > > Art S. Kagel