harris@reavin.UUCP (Harris) (08/02/89)
I realize this should probably have been posted to comp.databases but I do not subscribe to that group. I am involved in the evaluation of a fairly large database management system application which uses Oracle and runs under System V UNIX on Unisys 5000/80 and 5000/95 minicomputers. The system will use uucp to transfer table data from about 180 computers with Telebit 9600bps modems to a single 5000/95 with 10 modems. All the transfers take place at night, when a maximum of 300,000 bytes is tranferred from each site, loaded into the central database, sorted, processed, and sent out to each of the 180 sites with a maximum of 300,000 bytes. I would like to hear from anyone who has any good or bad experiences or knowledge of a database application which transfers data via uucp. I am concerned that the system may be prone to error even though there are complex shell scripts which check for errors. I am also aware of the difficulty in maintaining uucp connections with a large number of relatively inexperienced system administrators. A test on a 5000/80 with four 9600bps lines showed a throughput of about 4800bps per line, I do not know what to expect for throughput with 10 lines on a 5000/95. Loading about 50meg of test data into the Oracle database on a 5000/80 took 5 hours, processing and sorting have not yet been tried. As is obvious there many other questions I could enumerate. I would greatly appreciate E-mail with relevant experiences or suggestions. Thanks. Harris Reavin EER/SofTech Phone: 703-761-2467 Tysons Corners, VA UUCP: uunet!pyrdc!reavin Harris Reavin EER/SofTech Phone: 703-761-2467 Tysons Corners, VA UUCP: uunet!pyrdc!reavin
rob@phavl.UUCP (Robert Ransbottom) (08/03/89)
From article <1.UUL1.3#903@reavin.UUCP>, by harris@reavin.UUCP (Harris): > > I realize this should probably have been posted to comp.databases but I > do not subscribe to that group. Since you realize it, why don't you lift your fingers can and act on it. Possibly(?) you belong to the select group which should post to c.u.w; but it is also obvious that you beyond to a very unselective group also, i.e. those with the moral stature of a snake. You also do YOURSELF a disservice by not going where you'll get good info. Don't bother to go to the mountain to talk to a wise man just stay where you are and ask who ever happens by. They trust you to handle this system your asking about!!!!??? I'm sorry that my mother raised me to be polite. ---- I sent more by mail basicly pointing Harris to the places where the many issues he raised are profitably addressed. I post this hopefully to limit his corruption of this news database. -- ...!uunet!phavl!rob Robert Ransbottom