RE: Temporary storage movement over a day -- MIDRANGE-L

I've been watching this thread and thought some reference information about
the temporary storage accounting changes that were made in the IBM i 7.2
release might be helpful for many readers.
We completely revamped how we track temporary storage in the 7.2 rekease
and it is significantly improved from prior releases.
It was a pretty major change within the operating system, which is why none
of this support could be taken back to an earlier release.

This series of blogs covers the changed support in 7.2:

http://ibmsystemsmag.com/blogs/i-can/archive/72-improved-temporary-storage-tracking-part-1-/
http://ibmsystemsmag.com/blogs/i-can/archive/72-improved-temporary-storage-tracking-part-2/
http://ibmsystemsmag.com/blogs/i-can/archive/ibm-i-72-improved-temporary-storage-tracking-part-/
http://ibmsystemsmag.com/blogs/i-can/january-2015/ibm-i-7-2-improved-temporary-storage-tracking-(par/
http://ibmsystemsmag.com/blogs/i-can/april-2015/ibm-i-7-2-improved-temporary-storage-tracking/
http://ibmsystemsmag.com/blogs/i-can/july-2015/ibm-i-7-2-improved-temporary-storage-tracking-par/
http://ibmsystemsmag.com/blogs/i-can/april-2016/ibm-i-7-2-improved-temporary-storage-tracking-(par/

Dawn May
Program Manager: Large User Group (LUG), COMMON Americas Advisory Council (CAAC),
COMMON Europe Advisory Council (CEAC)
IBM i

From: "Steinmetz, Paul" <PSteinmetz@xxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'"
<midrange-l@xxxxxxxxxxxx>
Date: 11/10/2017 02:11 PM
Subject: RE: Temporary storage movement over a day
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>

Rob,

Is that for V7R2 or V7R3?
V7R1 yeields

select * from qsys2.systmpstg
SYSTMPSTG in QSYS2 type *FILE not found

Paul

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rob
Berendt
Sent: Friday, November 10, 2017 7:41 AM
To: Midrange Systems Technical Discussion
Subject: Re: Temporary storage movement over a day

I was wondering when someone was going to refer to select * from
qsys2.systmpstg; (I took yesterday off.)

Also, keep up to date on the "recommended fixes", especially those dealing
with temporary storage.
http://www-01.ibm.com/support/docview.wss?uid=nas8N1021480

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail
to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
https://urldefense.proofpoint.com/v2/url?u=http-3A__www.dekko.com&d=DwICAg&c=jf_iaSHvJObTbx-siA1ZOg&r=WPXn3xLhtgUIAgwXe1_2bw&m=JzbneZIx-B_rPQ5AJcmihXFvGDuZ8YlxziqMNOEDsMM&s=4xqj5JeBs2lRp0UxdONXzEhStmlLtG0-iyb5kI6KjoQ&e=

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

Take a look at

select * from qsys2.systmpstg;

Charles

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

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://urldefense.proofpoint.com/v2/url?u=https-3A__code.midrange.com_4ee5e6d1d6.html&d=DwICAg&c=jf_iaSHvJObTbx-siA1ZOg&r=WPXn3xLhtgUIAgwXe1_2bw&m=JzbneZIx-B_rPQ5AJcmihXFvGDuZ8YlxziqMNOEDsMM&s=pvA8qqmh34ykJn1ltFDMPojr0f2Etcf5FoFx8r8vdDg&e=
<

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://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.com_mailman_listinfo_midrange-2Dl&d=DwICAg&c=jf_iaSHvJObTbx-siA1ZOg&r=WPXn3xLhtgUIAgwXe1_2bw&m=JzbneZIx-B_rPQ5AJcmihXFvGDuZ8YlxziqMNOEDsMM&s=qK4cGU5j7JGv1RG0wcxfjYvxIpZEv5kGmXnXIcSd5HU&e=

or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at

https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_midrange-2Dl&d=DwICAg&c=jf_iaSHvJObTbx-siA1ZOg&r=WPXn3xLhtgUIAgwXe1_2bw&m=JzbneZIx-B_rPQ5AJcmihXFvGDuZ8YlxziqMNOEDsMM&s=mcbUeR7IUPi-mftoJFqTHI6gl1G8hFZemua5yQZDevk&e=
.

Please contact support@xxxxxxxxxxxx for any subscription related

questions.

Help support midrange.com by shopping at amazon.com with our

affiliate

link:

https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_2dEadiD&d=DwICAg&c=jf_iaSHvJObTbx-siA1ZOg&r=WPXn3xLhtgUIAgwXe1_2bw&m=JzbneZIx-B_rPQ5AJcmihXFvGDuZ8YlxziqMNOEDsMM&s=1xJ5S4cGddzAlPSWwcniIkMsvQfhdfDp4pT8geFAGqg&e=

--
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:

or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link:

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

service.

For more information please visit

https://urldefense.proofpoint.com/v2/url?u=http-3A__www.symanteccloud.com&d=DwICAg&c=jf_iaSHvJObTbx-siA1ZOg&r=WPXn3xLhtgUIAgwXe1_2bw&m=JzbneZIx-B_rPQ5AJcmihXFvGDuZ8YlxziqMNOEDsMM&s=JpyLZUm6vaSCaqU4M6e3tXwdheFHxyRghW452vuAsFk&e=

______________________________________________________________________

--
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:

or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link:

--
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:

or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link:

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

service.

For more information please visit

______________________________________________________________________

--
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:

or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: