Re: Temporary storage movement over a day

Thanks Charles

Any ideas how would one get the temporary storage used by SQL per job in
an attempt to reconcile back to the current temporary storage in use ?



Don Brown





From: "Charles Wilt" <charles.wilt@xxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Date: 10/11/2017 08:50 AM
Subject: Re: Temporary storage movement over a day
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



No.

Much of the SQL related temp storage is not scooped to a job.

Charles

On Thu, Nov 9, 2017 at 3:28 PM, Don Brown <DBrown@xxxxxxxxxx> wrote:

Should the Current temporary storage used = the sum of Temporary storage
shown on the WRKACTJOB (press F11 twice) display ? at V7R2 or V7R3



Don Brown





From: "B. Dietz" <bdietz400@xxxxxxxxx>
To: "Midrange Systems Technical Discussion"

<midrange-l@xxxxxxxxxxxx>

Date: 10/11/2017 08:24 AM
Subject: Re: Temporary storage movement over a day
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



here is a good doc:
http://www-01.ibm.com/support/docview.wss?uid=nas8N1019501 <
http://www-01.ibm.com/support/docview.wss?uid=nas8N1019501>

I used this formula in the simple CL program

https://code.midrange.com/4ee5e6d1d6.html <
https://code.midrange.com/4ee5e6d1d6.html>

Bryan

On Nov 8, 2017, at 10:34 PM, Don Brown <DBrown@xxxxxxxxxx> wrote:

Hello All,

I was wondering if I could get some feedback in relation to the

temporary

storage values on busy systems from the WRKSYSSTS display. Both

current

and peak.

I have check about 10 systems and all are under 10000 but none of

these

systems are very large or very heavily utilised.

One system though has a figure of 130,640 and looking at a performance
graph this grows through the day and decreases overnight - just seemed
rather high to me but may be normal on a busy system. The system has

3450

active jobs currently.

Appreciate any comments.

Thank you

Don Brown

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
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: http://amzn.to/2dEadiD

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
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: http://amzn.to/2dEadiD

______________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud

service.

For more information please visit http://www.symanteccloud.com
______________________________________________________________________


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
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: http://amzn.to/2dEadiD