Home > IT Answers > AS/400 > Deleting PJ QZDASOINIT jobs after inactivity
AS400 - Ask the Expert
485 pts.
 Deleting PJ QZDASOINIT jobs after inactivity
AS/400, AS/400 jobs, QUSRWRK, QZDASOINIT
We have a lot of PJ QZDASOINIT jobs in QUSRWRK. Many are from the same 'user' and Server IP address. Is there a way to delete these jobs after a period of odbc/jdbc inactivity - or should we keep them?

Software/Hardware used:
ASKED: July 29, 2009  9:08 PM
UPDATED: September 27, 2010  2:39 PM
RELATED QUESTIONS
Answer Wiki:
I'm sure that someone will correct me but I think these will be reused by the next web request and don't need to be deleted. Phil
Last Wiki Answer Submitted:  July 29, 2009  9:43 pm  by  philpl1jb   44,180 pts.
All Answer Wiki Contributors:  philpl1jb   44,180 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

The QZDASOINIT jobs are meant to end and will service outside requests like you are using (ODBC etc). They are most likely running in QUSRWRK on your system.

DSPSBSD SBSD(QUSRWRK)

- Option 10 – Display Prestart Job Entries
- Option 5 – Display details on QZDASOINIT

These entries will let you know how many jobs will be started and how many times a particular job will be used before it ends.

Maximum number of jobs . . . : xx
Maximum number of uses . . . : yy

To see how the prestart jobs are currently used type command
DSPACTPJ SBS(QUSRWRK) PGM(QZDASOINIT)

Satsho
 1,245 pts.
 

Quite informative Satsho…thanks a ton

harisudhan21
 995 pts.
 

I have around 200 QZDASOINIT jobs sitting on TIMW. However, on occasions files can be locked by one of these jobs when the file is being updated or cleared down from within overnight batch work, causing the job to fail.
What would be the best way to remove these jobs before we start the overnight batch processing.
From my understanding they will just recreate themselves when required.

Melv
 20 pts.
 

The application should be closing the connections when complete.

cenpark
 10 pts.
 

Melv

Please enter this as a new question, then it will get the attention it deserves.

Phil

philpl1jb
 44,180 pts.
 

Cenpark, unfortunately it doesn’t always.

Splat
 5,670 pts.