Retrieve temporary storage used for individual active jobs

In most cases the reason was that the job got into a loop. The amount of temporary storage increases dramatically and can theoretically bring your system down by filling up your disk space up to 100%.

To reduce this exposure, I wrote the RTVJBTSPC CL program that can be scheduled regularly. It scans user active jobs -- interactive and batch -- independently in the subsystems in which they are running.

If a predefined limit (in Kilobytes) is reached (stored in *DTAARA *LIBL/ TMPSTGLMTJ) an appropriate action can be started.

For example, sending information (e-mail, SMS) or/and set the job to Hold or ending it immediately.

Be aware to create *DTAARA *LIBL/TMPSTGLMTJ to store your defined limit in kilobytes.

DTAARA creation for 1 GB limit with:
CRTDTAARA DTAARA(AWDPFILE/TMPSTGLMT1) TYPE(*DEC) LEN(15 0)
VALUE(1000000)
TEXT('Limit temporary storage for single job in KB')

View the program here.

Code

Rate this Tip To rate tips, you must be a member of Search400.com. Register now to start rating these tips. Log in if you are already a member. Digg This!     StumbleUpon     Del.icio.us    RELATED CONTENT Performance Will overloaded discs impact iSeries performance? Extend storage capacity on an IBM i without negatively effecting system performance Database drivers on the i: MySQL vs. IBM Toolbox Performance tuning for IBM i: The basics and beyond IBM releases new Power products for the midrange Top System i admin tips for 2006 Catholic Charities keeps track of homeless with iSeries i5 error messages: What you need to know IBM races for clock speed System shutting down after cleanup iSeries administrator tips Analyze the health of your IBM i server with iScore Researching high availability for your System i shop Translating Linux for IBM i admins: Using GUI to make it easy Translating Linux for IBM i admins: Working with jobs and networking OpenOffice: What to know before making the transition from Microsoft Office OpenOffice: An enterprise open source solution Database performance comparisons on IBM i Translating Linux for IBM i admins: User profile commands Modern System i reports using Client Access Tips for installing Lotus Domino server on a System i partition Systems Management Can you trust all those trigger programs? Are your backups complete? Controlling remote command processing Watch your profiles Avoid locking issues Send message to users at a remote site Security journal receiver management Top 10 backup commands Create an iSeries Access image and update it with the latest Service Pack Tracking critical file access in real time RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.