RE: [Bulk] CPI1468 - System job tables nearing capacity

The new process was related to joblogs created from QSH.

DLTSPLF FILE(*SELECT) SELECT(*ALL *ALL *ALL QZSHSH)
129277 files deleted. 0 files not deleted.
DLTSPLF FILE(*SELECT) SELECT(*ALL *ALL *ALL QP0ZSPWP)
130365 files deleted. 0 files not deleted.

Freed up 250,000+ job table entries.

Available . . . : 259686
Total . . . . . : 438531

I need to identify which jobds are being used when QSH is called, change these to *NOLIST.
I would also like to find where QSH is called and/or submitted, review that process.

Paul

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Monnier, Gary
Sent: Wednesday, October 29, 2014 12:46 PM
To: Midrange Systems Technical Discussion
Subject: RE: [Bulk] CPI1468 - System job tables nearing capacity

Paul,

Try WRKJOBLOG JOBLOGSTT(*PENDING). If any are listed consider deleting them.

Gary

On 10/29/2014 11:26 AM, Steinmetz, Paul wrote:
We launched a new app several weeks ago, each occurrence of this creates a new job and job log.
We previously ran about 4,000 jobs per day, now we are now up to 18,000 jobs per day, on the average.
I keep joblogs for 90 days.
We now hit 90% of job tables,
WRKSYSVAL SYSVAL(QMAXJOB) already set at max, cannot be increased. I wish this could be increased.
DSPJOBTBL
Total . . . . . : 436831
Maximum . . . . : 485000

I think my only option is to change the new app not to create a job
log,

Any other thoughts from the group.

Thank You
_____
Paul Steinmetz
IBM i Systems Administrator

Pencor Services, Inc.
462 Delaware Ave
Palmerton Pa 18071

610-826-9117 work
610-826-9188 fax
610-349-0913 cell
610-377-6012 home

psteinmetz@xxxxxxxxxx
http://www.pencor.com/

--
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: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.

--
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: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.