Good suggestion.
We got tired of dealing with this and simply purge off all spool files over 90 days. No exceptions.
Been doing this for years. Small grumbling at first but people adapt.
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Paul Roy
Sent: Tuesday, March 19, 2019 11:20 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: How many spool files per user ?
see the exemple in the documentation just add COUNT(*) in the example
SELECT USER_NAME, COUNT(*), SUM(SIZE) AS TOTAL_SPOOL_SPACE
FROM QSYS2.OUTPUT_QUEUE_ENTRIES_BASIC
WHERE USER_NAME NOT LIKE 'Q%'
GROUP BY USER_NAME
ORDER BY TOTAL_SPOOL_SPACE DESC LIMIT 10;
https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_73/rzajq/rzajqviewoutqentriesbasic.htm
From: B Stone <bvstone@xxxxxxxxx>
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxxxxxxxx>
Date: 19/03/2019 16:14
Subject: Re: How many spool files per user ?
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxxxxxxxx>
Cyndi,
There is no doubt some SQL function that you can use. One other option is our SPLTOOL software (www.bvstools.com/spltool.html) has a FREE option/command named List Spooled File Attributes (SPLATT).
This command can be used to build a PF based on any selection criteria you want, including user. So, you could use it to list all spooled files on the system, then sql/count using user id as the level break.
List Spooled File Attributes (SPLATT)
Type choices, press Enter.
Output queue . . . . . . . . . . Name, *ALL
Library . . . . . . . . . . . *LIBL Name, *LIBL
Spooled File . . . . . . . . . . *ALL, generic*, Name
User name . . . . . . . . . . . *CURRENT, *ALL, Name
Job Name . . . . . . . . . . . . *ALL, generic*, Name
Job Number . . . . . . . . . . . *ALL, 000000-999999
Spooled File Number . . . . . . *ALL, 1-999999
User data . . . . . . . . . . . *ALL, User data
Form type . . . . . . . . . . . *ALL, Form type
From Date (MMDDYYYY) . . . . . . *ALL Number, *ALL
To Date (MMDDYYYY) . . . . . . . *ALL Number, *ALL
To file . . . . . . . . . . . . To file
Library . . . . . . . . . . . *CURLIB Name, *CURLIB
To member . . . . . . . . . . . Name, *FIRST
Replace or Add records . . . . . *ADD *ADD, *REPLACE
Create file . . . . . . . . . . *NO *NO, *YES
Bottom
F3=Exit F4=Prompt F5=Refresh F12=Cancel F13=How to use this
display
F24=More keys
Just one option.
Bradley V. Stone
www.bvstools.com
MAILTOOL Benefit #22 <
https://www.bvstools.com/mailtool.html>: Cost starting at under $300 a year per partition!
On Tue, Mar 19, 2019 at 10:10 AM Cyndi Bradberry <CyndiB@xxxxxxxx> wrote:
I'm looking for a way to tell individual user's how many spool files
exist
in their name on our iSeries.
Previously, this hasn't been too big of an issue. But we have more
locations and more staff and they don't know how to clean up after
themselves. I would like to be able to target the worst offenders
first
and
go from there.
Currently on V7R2. Only IT has ACS, users have client access, but not
iNav.
Cyndi Bradberry | Application Developer Idaho Housing and Finance
Association PO Box 7899, Boise, ID 83707-1899 Phone 208-331-4775 |
CyndiB@xxxxxxxx<mailto:CyndiB@xxxxxxxx>
www.idahohousing.com<http://www.idahohousing.com>
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
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:
https://amazon.midrange.com
midrange.com
