This SQL should work for any job which generates those message id's. Including
Job 074809/ROB/QPADEV0002 started
Job 074809/ROB/QPADEV0002 ended on
If you want, you can remove this line:
and l.from_user not like ('Q%')
If you want to include jobs like these
Job 074449/QUSER/QRWTSRVR
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Bob Cagle
Sent: Monday, February 11, 2019 11:25 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: Hosted LPAR performance
This I have not done. So I don't have any data from the old box to compare to.
I will run this query and see what I can see. But this will only work for Batch jobs, correct?
Thanks
Bob
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob Berendt
Sent: Monday, February 11, 2019 9:51 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: Hosted LPAR performance
The usual performance recommendations apply, like did you capture performance data before/after to do comparisons?
Did you capture any QHST data to compare job run times?
SELECT
L.FROM_JOB, L.MESSAGE_ID, L.MESSAGE_TIMESTAMP, R.MESSAGE_ID, R.MESSAGE_TIMESTAMP, INT(R.MESSAGE_TIMESTAMP - L.MESSAGE_TIMESTAMP) as YYYYMMDDHHMMSS FROM TABLE (QSYS2.HISTORY_LOG_INFO( START_TIME => CURRENT TIMESTAMP - 2 days
)) AS l
left outer join
TABLE (QSYS2.HISTORY_LOG_INFO(
START_TIME => CURRENT TIMESTAMP - 2 days
)) AS r
on l.from_job = r.from_job
where l.message_id = 'CPF1124' and r.message_id = 'CPF1164'
and l.from_user not like ('Q%')
order by 6 desc;
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Bob Cagle
Sent: Monday, February 11, 2019 10:41 AM
To: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
Subject: Hosted LPAR performance
I just recently switched my users off of our old System i5 520 to a new hosted LPAR.
The old 520 was 600 CPW with 1GB RAM and 175GB DASD. It wasn't lightning fast, but it ran fine for our needs.
The new hosted LPAR is 960 CPW with 4GB RAM and 500GB DASD. A slice of an 8286-42A. Running over gigabit fiber.
My users are complaining the new system is very slow in comparison to the old box. Why would that be?
I'm fairly certain it's not the internet connection: menu travel flows fine, screens switch quickly enough; the cursor moves as expected without delays. It's just when running a longer process - interactive or batch - it takes longer than before.
Further info: we did a slip upgrade in December, and then when we went live, I FTPd save files of our production data and performed manual restores.
Any suggestions of what to look at? It just seems to me that this new machine should be at least somewhat noticeably quicker - but it's not.
Thanks
Bob Cagle
IT Manager
Lynk
--
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
midrange.com
