Re: Fw: Temporary space

On 20-Feb-2015 08:49 -0600, Steinmetz, Paul wrote:

On Thursday, February 19, 2015 1:14 PM rob@xxxxxxxxx wrote:

Using that SQL made it quite easy to see the worst offenders.
The question is then how to handle the largest buckets, which are
not even "jobs".

Should that SQL work on V7R1?
SYSTMPSTG in QSYS2 type *FILE not found.

I checked my temp space from PRTDSKINF.

I'd like to find the culprits.

% of Size in
Disk 1,000,000 bytes
2/20 Temporary space 1.37 38955.13
2/01 Temporary space 1.25 35608.64
1/01 Temporary space 1.12 31821.31
12/01 Temporary space .78 22186.97
11/20 Temporary space .36 10286.60
IPL
11/19 Temporary space 2.63 74903.52

So as to save anyone having to search for whatever is "that SQL" referred to in the above quoted messages, per /that SQL/ statement [as a query of SYSTMPSTG in QSYS2] not having been included either in the above quoted message from Rob nor in the archived copy of that message, the original message to which Rob presumably intended to refer:
<http://archive.midrange.com/midrange-l/201502/msg00573.html>

The document from DeveloperWorks suggests the feature is not available until IBM i 7.2:

<https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20i%20Technology%20Updates/page/Temporary%20Storage%20Consumption%20and%20DB2%20for%20i>
[ IBM i Technology Updates ->‎ IBM i Technology Updates ->‎ DB2 for i - Technology Updates ->‎ DB2 for i - Services ->‎ Temporary Storage Consumption and DB2 for i ]
_Temporary Storage Consumption and DB2 for i_
|Updated November 14, 2014 by ScottForstie|Tags: None]
"With 7.2, DB2 for i can be used to examine the IBM i temporary storage pool detail. ..."