Re: How many spool files per user ?

We delete spool files after a day :o

Charles

On Tue, Mar 19, 2019 at 9:41 AM Rob Berendt <rob@xxxxxxxxx> wrote:

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