RE: Fw: Temporary space

Upgrade planning has started.
Our major 3rd party vendors not yet certified on V7R2.
I hope be there by 3rd or 4th quarter.

Paul

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Friday, February 20, 2015 10:03 AM
To: Midrange Systems Technical Discussion
Subject: RE: Fw: Temporary space

Upgrade.

https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20i%20Technology%20Updates/page/DB2%20for%20i%20-%20Services


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
http://www.dekko.com





From: "Steinmetz, Paul" <PSteinmetz@xxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'"
<midrange-l@xxxxxxxxxxxx>
Date: 02/20/2015 09:50 AM
Subject: RE: Fw: Temporary space
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Rob,

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

Paul

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
rob@xxxxxxxxx
Sent: Thursday, February 19, 2015 1:14 PM
To: Midrange Systems Technical Discussion
Subject: Re: Fw: Temporary space

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".


Rob Berendt