RE: Archiving Spooled Files

["Goodbar, Loyd (ETS - Water Valley)" <LGoodbar@xxxxxxxxxxxxxx>]

To catch the held ones, you could periodically run a job to scan the output
queue(s) to grab files not already archived.

I've seen a situation where an writer-attached spooled file goes from OPEN
to READY to PENDING so quickly it was missed by the data queue program
(entry was not sent). Don't remember the exact conditions to make that
happen.

What we did for RVI was modify the report programs to place a copy of the
report in a specific output queue not attached to a writer. It was
periodically scanned.

The only catch I've seen is using the spooled file APIs on an output queue
with more than 33000 or so entries, it tends to bomb.

Loyd

Loyd Goodbar
Senior programmer/analyst
BorgWarner
E/TS Water Valley
662-473-5713
-----Original Message-----
From: Fisher, Don [mailto:Dfisher@xxxxxxxxxxxxxxxxx] 
Sent: Tuesday, September 28, 2004 13:32
To: 'midrange-l@xxxxxxxxxxxx'
Subject: Archiving Spooled Files

This has been discussed before, but I have been unable to find a solution
that meets my requirements.  Note that we are on V5R2.

I would like to save a spooled file to a physical file when it is placed on
an output queue and in a status other than "OPN" or "SAV".  I know the
output queue can be set to send an entry to a data queue when a spooled file
becomes "RDY", but I need the ones that are in "HLD" also.  The trouble, of
course, is the program that created the spooled file may still be running so
I need a way to determine whether that spooled file is still open. 

The user defined driver program parameter on the output queue looks
promising, but I've been unable to find any documentation on how to use it.
I've searched the archives and InfoCenter to no avail, except for the
TSPLPRD program, which appears to do far more than I require and I can
barely understand it since it's written in C. 

A commercial product is, unfortunately, not an option.  I really miss ROBOT
Reports, which would handle all this quite easily.  I don't know Java, but
I'm willing to learn if that's the right answer here. 

Any advice or suggestions on which manual to read will be greatly
appreciated.

Donald R. Fisher, III
Project Manager
Roomstore Furniture Company
(804) 784-7600 extension 2124
DFisher@xxxxxxxxxxxxx