|
midrange.com
> Does odbc start and stop a new job on the as400 for each odbc request?
ODBC will start a job when database connection is established. After that
all ODBC activity within the same connectoin will relay to the same job.
This is a prestart job, so job start time is minimal.
> Any estimate on how much cpu is needed for each odbc rqs, rltv to say a
custom written tcp/ip socket pgm?
My personal opinion is that SQL when written carefully is not much worse
than native I/O (RPG-style) - if at all.
You should not be too much concerned about server side. The amount of data
flowing between server and client and number of exchanges between them -
this is what you should be concerned about. But this is also the case with
a socket program.
Alexei Pytel
"Steve Richter"
<srichter@AutoCoder To: <MIDRANGE-L@midrange.com>
.com> cc:
Sent by: Subject: odbc. reliable, a
performance hit?
owner-midrange-l@mi
drange.com
05/18/2001 09:41 AM
Please respond to
MIDRANGE-L
Here is the question: How trouble free a connection and how as400 cpu
efficient is odbc in a CA windows to As400 setting? In the appl in
question, there will be frequent polling of an as400 database ( once a
minute ) from each of 7 remote win95 pc's, each in a diff branch location.
The comm topology is a central as400 model 720 (V4R4) and 7 remote offices
( branches ). Each branch has an avg of 10 CA win 5250 users. Each remote
branch has a 64kb line and cisco router that connects to the comm cloud.
The central 720 has a T1 connection to the cloud.
The odbc appl is a proposed win95 pc based imaging system. The odbc
tranported data will be a print request file on the as400 that will be
polled every minute by each branch located imaging station pc. A 2nd use of
odbc will be a data rcd ( 100 bytes ) sent to the as400 when an image is
scanned. About 400 images will be scanned each day.
Our comm lines can and will be upgraded, so the increase in comm traffic is
not a concern.
Our first concern is that odbc will not ramp up very well.
Does odbc start and stop a new job on the as400 for each odbc request?
Any estimate on how much cpu is needed for each odbc rqs, rltv to say a
custom written tcp/ip socket pgm? The current proposal will call for 7 x 60
= 420 odbc transactions per hour.
The 2nd concern is the reliability of odbc.
Do odbc jobs on the as400 hang from time to time, requiring as400 operator
intervention?
Will the image system pc lock up from time to time because of odbc,
especially when there are comm hits on the branch 64kb connection to the
cloud?
Thanks a lot,
Steve Richter
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
