Larry,
Reminds me of my boss asking me what I knew about ODBC. "Heck, I can't even
spell it," I replied.
Anyway, he, too, was having sloooow processing getting data off of our
System i (Power 5). A couple of years later, his PC was upgraded. That
four hour job went down to minutes.
Jerry C. Adams
You are about to exceed the limits of my medication.
IBM i Programmer/Analyst
--
NMM&D
615-832-2730
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of
DrFranken
Sent: Friday, December 06, 2019 7:51 AM
To: Midrange Systems Technical Discussion
Subject: Re: Reducing ODBC connection impact
So this had me laughing out loud. I just cranked up an old 170 to assist a
customer migrating S/36 programs, OCL, and data to IBM i. As they only had
ancient QIC I needed the old girl to read that tape.
I was SHOCKED at how slow it was and I remember installing that very machine
brand new 'some years ago' and thinking how impressively fast it was back
then! Just restoring the S/36 source and OCL (about a dozen
libraries) took overnight. Including the customer's data the *SAVF I created
for them was a gargantuan ginourmous hugemoungous 375MB. Yes MB.
So while I do suspect there are some things you can do to assist a bit in
lowering the impact of these inserts, such as lowering the priority in the
COSD as others have suggested, I'm glad it's a hobby machine and not running
real production!!
- Larry "DrFranken" Bolhuis
www.Frankeni.com
www.iDevCloud.com - Personal Development IBM i timeshare service.
www.iInTheCloud.com - Commercial IBM i Cloud Hosting.
On 12/6/2019 7:07 AM, Patrik Schindler wrote:
Hello,
I'm doing some data transfers between my 150 (running V4R5) and a Linux VM
elsewhere via ODBC. Especially INSERTs are very costly and slow down other
(interactive) tasks on the box considerably. For that reason I want to
lessen impact of the QZDASOINIT PJs in the QSERVER Subsystem. Also I'd
prefer to do that in a way that the setting(s) survive an IPL.
I still didn't get a solid grip about jobs and work management. I have a
rough idea about relative job priorities and time slices. My understanding
of subsystems is even more terse. How would you achieve the described goal?
No detailed steps necessary. Primarily I want to collect ideas how to do it
(properly).
Please refrain from comments like "get a current machine" or likewise.
I'm a hobbyist in Midrange terms with a tendency to retrocomputing.
Thank you. :-)
:wq! PoC
PGP-Key: DDD3 4ABF 6413 38DE - https://www.pocnet.net/poc-key.asc
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
As an Amazon Associate we earn from qualifying purchases.