[comp.unix.wizards] uucp for a database application

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