RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms

2007-10-25 Thread Baker Hughes
Glen, Good thoughts here as always, thanks. Right now, the UV db is not fully replicated to the MSSQL tables, rather the other way around (for the most part). The ISAM WCS tables also update UV. Therefore, at present, the UV db comes closest to being the reference, and it still runs the business.

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms (AD)

2007-10-25 Thread Baker Hughes
users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms (AD) Hello Baker, We have a customer who is processing tens of thousands of transactions a day. These transactions are centralized on SQL Server so that the Oracle ESB, UniVerse and Web System

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms (AD)

2007-10-25 Thread Janet Bond
25, 2007 12:54 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms Baker, Given the scenario you have just outlined, and my imaginings of the way that each of the 3 systems SHOULD work, you have no likelihood of deadlock collisions (this cou

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD}

2007-10-25 Thread Janet Bond
s, -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Janet Bond Sent: Wednesday, October 24, 2007 1:35 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD} As promised here is Robert Houb

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms

2007-10-25 Thread Glen B
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Ross Ferris > Sent: Thursday, October 25, 2007 4:42 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and > non-MV dbms >

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms

2007-10-25 Thread Glen B
> Well, I was actually only tasked with making the ATS more real time for > our Asia sales office. Since they're entering orders during our night, > they always get the short end of the stick, ATS may or may not be right; > the batch updates are all timed/tuned for US timezone (and work pretty > ac

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms

2007-10-25 Thread Ross Ferris
are Visage > Better by Design! >-Original Message- >From: [EMAIL PROTECTED] [mailto:owner-u2- >[EMAIL PROTECTED] On Behalf Of Baker Hughes >Sent: Thursday, 25 October 2007 3:11 AM >To: u2-users@listserver.u2ug.org >Subject: RE: [U2] Fastest Bi-Directional data transfer b

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms

2007-10-25 Thread Ross Ferris
That would be an [ad] ... but there are some people that may convince us to port Visage.DRS to UV as well --> slight "tweak" would go a long way to a proving parts of a "solution" for this scenario (but how did you know we were looking at replication to "foreign" databases?) Ross Ferris Stamina So

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms

2007-10-25 Thread Ross Ferris
[/ad] >-Original Message- >From: [EMAIL PROTECTED] [mailto:owner-u2- >[EMAIL PROTECTED] On Behalf Of Baker Hughes >Sent: Thursday, 25 October 2007 12:20 AM >To: u2-users@listserver.u2ug.org >Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non- >MV

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms

2007-10-25 Thread Ross Ferris
8 PM >To: u2-users@listserver.u2ug.org >Subject: Re: [U2] Fastest Bi-Directional data transfer btwn MV and non >MV dbms > >Sockets are just the pipe you push/pull things through. One of the >features they bring to the table is that you get to (yes, I actually >said that) design your own p

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD}

2007-10-24 Thread Baker Hughes
nesday, October 24, 2007 1:35 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD} As promised here is Robert Houben's input to your question Baker!!! :) For anyone who doesn't know me, I was the lead designer and developer of t

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD}

2007-10-24 Thread Janet Bond
[mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Tuesday, October 23, 2007 12:15 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms Janet, I can setup a conference call with one of Developers. We have been in the transferring Multi

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms

2007-10-24 Thread Baker Hughes
Glen, You always get the good ones, doncha? What does the warehouse control system use as a database? How many different O/S are we looking at here? The first idea that comes to mind is transactional queuing and inspection. A FIFO updating situation will not work, since you have logic that is u

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms

2007-10-24 Thread Glen Batchelor
> -Original Message- > From: [EMAIL PROTECTED] [mailto:owner-u2- > [EMAIL PROTECTED] On Behalf Of Baker Hughes > Sent: Wednesday, October 24, 2007 10:20 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-M

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms

2007-10-24 Thread Baker Hughes
ns to this science. -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross Ferris Sent: Wednesday, October 24, 2007 1:58 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms Baker, How

Re: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms

2007-10-24 Thread Jeff Schasny
007 2:36 AM >> To: u2-users@listserver.u2ug.org >> Subject: Re: [U2] Fastest Bi-Directional data transfer btwn MV and non >> MV dbms >> >> Is it just me or does it smell like troll in here all of a >> sudden >> >> Since the question as defined in

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms

2007-10-24 Thread Hona, David S
Well, you'll setting you requirements "high". But that's the thing to do... What business requirements do you have? What what constraints do you have? Budget? Deadlines? Can you afford to be bleeding-egde with no experienced in-house expertise to diagnose or support this "ideal" soltuon you'r

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms

2007-10-24 Thread Ross Ferris
d (or emerge) Ross Ferris Stamina Software Visage > Better by Design! >-Original Message- >From: [EMAIL PROTECTED] [mailto:owner-u2- >[EMAIL PROTECTED] On Behalf Of Baker Hughes >Sent: Wednesday, 24 October 2007 5:05 AM >To: u2-users@listserver.u2ug.org >Subject: RE: [U2]

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms

2007-10-24 Thread Ross Ferris
Sent: Wednesday, 24 October 2007 2:36 AM >To: u2-users@listserver.u2ug.org >Subject: Re: [U2] Fastest Bi-Directional data transfer btwn MV and non >MV dbms > >Is it just me or does it smell like troll in here all of a >sudden > >Since the question as defined in the sentence be

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD]

2007-10-23 Thread Janet Bond
ECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George R Smith Sent: Tuesday, October 23, 2007 3:13 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD] Gee Janet all you had to do was put "This is not an ad, it's a fact

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD]

2007-10-23 Thread George R Smith
y, October 23, 2007 1:37 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV > dbms [AD] > > I added it in the Subject should it be somewhere else? > > Please accept my apologies if I have offended anyone. > > J

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms

2007-10-23 Thread Tony G
> What is the fastest and lowest cpu overhead method of > transferring data between U2/MV databases, and other data sources? Our esteemed colleague and moderator Chuck Barouch has/had a product called Zeus which does/did transfers like this. If he can avoid self-censorship for a moment I would i

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms

2007-10-23 Thread Baker Hughes
Janet, I can setup a conference call with one of Developers. We have been in the transferring MultiValue data to other data sources since the early 80's (PK Harmony to start with, anyone remember). We may have some good input for you. I'm not in a position to buy anything, really just trying

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms

2007-10-23 Thread Baker Hughes
12:10 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms Not likely, Baker Hughes has been in the PICK arena for many moons and is one of the founders of the Texas users group. -Original Message- From: Jeff Schasny [mailto:[

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD]

2007-10-23 Thread Janet Bond
Subject: Re: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD] Janet, When posting as a vendor or service provider, please use [AD] brackets [/AD] in your response as a courtesy to others. - Charles Barouch, Moderator Janet Bond wrote: > I can setup a conference c

Re: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD]

2007-10-23 Thread Moderator
Janet, When posting as a vendor or service provider, please use [AD] brackets [/AD] in your response as a courtesy to others. - Charles Barouch, Moderator Janet Bond wrote: I can setup a conference call with one of Developers. We have been in the transferring MultiValue data to other

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms [AD]

2007-10-23 Thread Janet Bond
Hello Baker, Please email me. I can setup a conference call with one of Developers. We have been in the transferring MultiValue data to other data sources since the early 80's (PK Harmony to start with, anyone remember). We may have some good input for you. Thanks, Janet Bond FusionWare Corp

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms

2007-10-23 Thread Jerry Banker
Not likely, Baker Hughes has been in the PICK arena for many moons and is one of the founders of the Texas users group. -Original Message- From: Jeff Schasny [mailto:[EMAIL PROTECTED] Is it just me or does it smell like troll in here all of a sudden --- u2-users mailing list u2-user

Re: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms

2007-10-23 Thread Kevin King
Sockets. If you have a consumer that can accept a socket connection, I believe that'll provide the most efficient throughput. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms

2007-10-23 Thread Glen Batchelor
Baker, There is a happy medium between CPU overhead and bandwidth usage. If you use compression of some kind, then CPU overhead is going to be higher than an uncompressed stream. Cached disk writes are normally going to be faster than network writes, unless you have a fiber backbone or dedicated

Re: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms

2007-10-23 Thread Jeff Schasny
Is it just me or does it smell like troll in here all of a sudden Since the question as defined in the sentence below is pretty generic I'll respond in kind. Sockets. Inter process communication across disparate platforms and applications is just what they were made for. Low overhead, high thr