RE: Spool files that won't delete -- MIDRANGE-L

No, it definitely does not delete them.

It processes each spool file and ensures that the status of them agrees
with what the system thinks it is.

For example:
 If a spool file is deleted, and consequently the file member in the
database file in QSPL is removed, but the entry is not removed from the
output queue, or the job is not updated to say that the spool file has
gone, or any other type of mismatch or out of synch condition, then this
program is supposed to correct that.

This is how it was explained to me, and every time I have used it, it has
worked.

I once had a spool file whose status was 'HLD' for Held.  I put a 6 to
release it, and it would return the message, 'spool file not released, file
not held'.
After running the QSPFIXUP pgm, then I released it, and it printed.

I saw from one of your previous posts that the spool files in question had
now disappeared.  Did you try this program?  Had you also tried RCLSPLSTG?
Or did they just 'disappear' on their own.  
(Its not like the AS/400 to make things disappear, I thought that special
magic was reserved for PC's).

Neil
 
At 12:01 PM 9/1/98 -0500, you wrote:
>What do you mean it corrects them?  Its not going to delete all spool files
>is it?
>
>-----Original Message-----
>From: Neil Clark [mailto:nclark@barsaconsulting.com]
>Sent: Tuesday, September 01, 1998 11:00 AM
>To: MIDRANGE-L@midrange.com
>Subject: RE: Spool files that won't delete
>
>
>Try this:
>
>Signon as QSECOFR, or other user with *ALLOBJ authority.
>
>CALL  QSPFIXUP
>
>The length of time it takes to run is dependant on the number of spool
>files on the system, not just the job with the 'FIN' spool files.  
>This program checks the status of each spool file on the system and
>corrects them where necessary.
>
>See if this makes those 'FIN' spool files go away.
>
>Neil
>
>
>At 09:47 AM 9/1/98 -0500, you wrote:
>>The thing is, its a program I wrote.  The program is OEPE02B.  The user is
>>myself.  I mean its happened before with other programs.  I do a SBMJOB to
>>run most of my programs.  
>>
>>-----Original Message-----
>>From: Rob Berendt [mailto:rob@dekko.com]
>>Sent: Tuesday, September 01, 1998 8:40 AM
>>To: MIDRANGE-L@midrange.com
>>Subject: RE: Spool files that won't delete
>>
>>
>>What is the job name and user?  Maybe we can look for a similar job on our
>>systems.
>>
>>
>>
>>
>>Gary_Lehman@mail.mchcp.org on 09/01/98 08:35:23 AM
>>Please respond to MIDRANGE-L@midrange.com@Internet
>>To:   MIDRANGE-L@midrange.com@Internet
>>cc:    
>>Subject:      RE: Spool files that won't delete
>>
>>I've tried this.  It tells me the job has completed, but it still shows up
>>as having FIN jobs.  In fact I usually kill it with *IMMED and that is not
>>working.
>>
>>
>>
>>-----Original Message-----
>>From: Neil Palmer [mailto:npalmer@NxTrend.com]
>>Sent: Monday, August 31, 1998 7:59 PM
>>To: 'MIDRANGE-L@midrange.com'
>>Subject: RE: Spool files that won't delete
>>
>>
>>Try ENDJOB JOB(xxx/xxx/xxx) SPLFILE(*YES)
>>(works for jobs that are in OUTQ status - deletes all spool files)
>>
>>
>>
>>Neil Palmer                                AS/400~~~~~      
>>NxTrend Technology - Canada   ____________          ___  ~     
>>Thornhill, Ontario,  Canada   |OOOOOOOOOO| ________  o|__||=   
>>Phone: (905) 731-9000  x238   |__________|_|______|_|______)   
>>Cell.: (416) 565-1682  x238    oo      oo   oo  oo   OOOo=o\   
>>Fax:   (905) 731-9202       ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 
>>mailto:NPalmer@NxTrend.com    AS/400  The Ultimate Business Server      
>>http://www.NxTrend.com
>>
>>> -----Original Message-----
>>> From:       Gary Lehman [SMTP:Gary_Lehman@mail.mchcp.org]
>>> Sent:       Monday, August 31, 1998 4:08 PM
>>> To: Neil Palmer
>>> Cc: 'MIDRANGE-L@midrange.com'
>>> Subject:    RE: Spool files that won't delete
>>> 
>>> Thats just the thing.  I deleted all the joblogs and the spool files
>>> and it
>>> just hangs out there.  The job completed a long time ago.  Is there
>>> anything
>>> else I can try?
>>> 
>>> -----Original Message-----
>>> From: Neil Palmer [mailto:npalmer@NxTrend.com]
>>> Sent: Monday, August 31, 1998 2:28 PM
>>> To: 'MIDRANGE-L@midrange.com'
>>> Cc: 'Gary_Lehman@mail.mchcp.org'
>>> Subject: RE: Spool files that won't delete
>>> 
>>> 
>>> That's normal.  Any printer/cancelled spool files for a job will show
>>> as
>>> FIN as the job keeps track of all output.  When the job is completed,
>>> and ALL output for the job is deleted (including the job log) the job
>>> will disappear from your list of submitted jobs.
>>> 
>>> 
>>> 
>>> Neil Palmer                                AS/400~~~~~      
>>> NxTrend Technology - Canada   ____________          ___  ~     
>>> Thornhill, Ontario,  Canada   |OOOOOOOOOO| ________  o|__||=   
>>> Phone: (905) 731-9000  x238   |__________|_|______|_|______)   
>>> Cell.: (416) 565-1682  x238    oo      oo   oo  oo   OOOo=o\   
>>> Fax:   (905) 731-9202       ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 
>>> mailto:NPalmer@NxTrend.com    AS/400  The Ultimate Business Server
>>> 
>>> http://www.NxTrend.com
>>> 
>>> > -----Original Message-----
>>> > From:     Gary Lehman [SMTP:Gary_Lehman@mail.mchcp.org]
>>> > Sent:     Monday, August 31, 1998 2:11 PM
>>> > To:       'MIDRANGE-L@midrange.com'
>>> > Subject:  Spool files that won't delete
>>> > 
>>> > Hello,
>>> > 
>>> > I have seen this strange occurrence and wondered if anyone has
>>> either.
>>> > Has
>>> > anyone ever deleted spool files from a submitted job, but when you
>>> do
>>> > that
>>> > the spool files still remain as FIN.  Meaning they are finished, but
>>> I
>>> > can't
>>> > get rid of the job entry when I do a WRKSBMJOB and the spool files
>>> > show up
>>> > as FIN.  I can't do anything with them because even the system says
>>> > they
>>> > don't exist yet they still show as finished.  How can I get rid of
>>> > these?
>>> > 
>>> > Thanks
>>> > Gary Lehman
>>> > Programmer Analyst II
>>> > Missouri Consolidated Health Care Plan
>>> > 
>>> 
>>+---
>>| This is the Midrange System Mailing List!
>>| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
>>| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
>>| To unsubscribe from this list send email to
>MIDRANGE-L-UNSUB@midrange.com.
>>| Questions should be directed to the list owner/operator:
>>david@midrange.com
>>+---
>>+---
>>| This is the Midrange System Mailing List!
>>| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
>>| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
>>| To unsubscribe from this list send email to
>MIDRANGE-L-UNSUB@midrange.com.
>>| Questions should be directed to the list owner/operator:
>>david@midrange.com
>>+---
>>
>>
>>+---
>>| This is the Midrange System Mailing List!
>>| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
>>| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
>>| To unsubscribe from this list send email to
>MIDRANGE-L-UNSUB@midrange.com.
>>| Questions should be directed to the list owner/operator:
>>david@midrange.com
>>+---
>>+---
>>| This is the Midrange System Mailing List!
>>| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
>>| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
>>| To unsubscribe from this list send email to
>MIDRANGE-L-UNSUB@midrange.com.
>>| Questions should be directed to the list owner/operator:
>david@midrange.com
>>+---
>>
>>
>Neil Clark
>Barsa Consulting, LLC
>Tel: (914) 251-9400  Fax: (914) 251-9406
>
>
>+---
>| This is the Midrange System Mailing List!
>| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
>| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
>| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator:
>david@midrange.com
>+---
>+---
>| This is the Midrange System Mailing List!
>| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
>| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
>| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator: david@midrange.com
>+---
>
>
Neil Clark
Barsa Consulting, LLC
Tel: (914) 251-9400  Fax: (914) 251-9406


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---