× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.




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

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





As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.