Saving Spool Files, and Restoring Spool Files in AS/400 iSeries
Hello
Does anyone know if there is a utility program out there, that would serve in saving spool files on one AS400, and then restoring these spool files to a different AS400.
Not sure what methods are available, but I am thinking of using CPYSPLF to database file, and then from here, saving to tape. From this point, restoring from tape.
Software/Hardware used:
Software/Hardware used:
ASKED:
February 21, 2008 9:31 PM
UPDATED:
March 29, 2012 2:35 PM
Answer Wiki:
If you are on V5R4 i5/OS supports the saving and restoring of spool files. Information on this can be found in the i5/OS Information Center <a href="http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzalu/rzalusavrstsplf.htm#rzalusavrstsplf">here</a>.
Bruce Vining
<a href="http://www.brucevining.com/">http://www.brucevining.com/</a>
To see all answers submitted to the Answer Wiki: View Answer History.
Prior to V5R4 you can use BRMS software. You can try for 70 days for free. Also if you use OPS Nav and both Systems are Endpoints you should be able to copy and paste or drag and drop,
Hi Bruce
Unfortunately, the client is at V5R3., Do you happen to know the C/L commands that would enable me to save off tghe spool files to a back up tape, and then, once on the new AS400, restore these spool files to the new AS400 box.
Customer does not want to part with the spool files, and, so, I am looking for C/L program utilities that I may be able to use.
Thank you for all of your help.
-Nick
i have the same concern as Zenmaster2, i am also using OS V5R3 and i have a tape backup of the spool files but when i restore it to the same AS400, the OUTQ file is restored but the contents is not there anymore. I accidentaly performed clean up on spool files and the spoolfiles in PHASE2(this is the *OUTQ file) were gone. Luckily i have a full system backup and when i located this using DSPTAP with DATA TYPE parameter *SAVRST, *OUTQ file PHASE2 is there. When I restored this to a temporary library, i was able to do it but when using CL command WRKOUTQ PHASE2, no spooled file is shown. I’m sure that PHASE2 outq file has spooled files but I don’t see this with the restoration i performed. To Illustrate :
Library . . . . . . : QUSRSYS Release level . . . : V5R3M0
ASP . . . . . . . . : 1 File sequence . . . : 41
Volume ID . . . . . : 100325 Data compressed . . : No
Expiration date . . : *PERM Data compacted . . . : Yes
Save command . . . . : SAVLIB Objects saved . . . : 3030
Save active . . . . : *NO Access paths . . . . : 83
File label ID . . . : QUSRSYS
Save format . . . . : Serial
Save date/time . . . : 10/16/11 01:07:18
Object Type Attribute Owner Size (K) Data
PDFCREATOR *OUTQ QTCP 24 Yes
PHASE2 *OUTQ QTCP 208 Yes
So how to restore PHASE2 with its spool file contents?
So how to restore PHASE2 with its spool file contents?
At V5R3, the contents were not saved. So there is no restore.
BTW, it is not a good idea to keep any large number of spooled files on a system. Actually, it’s not a good idea ever to create a large number of spooled files at any one time. Although the spooling subsystem will clear the objects that get created to hold spooled file data (database members in QSPL) when spooled files are deleted and reclaimed, the actual objects are never deleted. They just sit there empty.
Tom
Piano,
We use a product called Save Output Queue. It is put out by WorksRight Software.
Hope that helps,
Bill Poulin
Bill, this product you are recommending, Save Output Queue, did you purchase this or just download it from WorkRight Software? Is this software applicable to the issue i mentioned below where i have a tape backup of the OUTQ file I intend to restore but upon restoration no spool files were included. And if you purchased this, roughly, how much is this product? Thanks.
I used Save Your Outq years ago
It was an excellent product
I used it to save all of our spool files on to tape and then I deleted them from our system, when we needed something I just pulled it from the tape.
I would highly recommend it, very easy to use.
Ann
If you are on V5R3 and do a OPT21, SAVSYS or savobj of Outques. It only saves the OUTQ Information. It does not save the actual spool files. If you still have V5R3 Install CD’s you can installBRMS as a 70 Day Trial. BRMS gives you the option of saving spool files.
Dantes,
I am not sure what the original purchase price was, but our annual maitenance fee is $375.
We use it to save spool files to tape, then delete the spool files off the system. If we need them back, they are relatively easy to restore.
Hope this helps,
Bill Poulin
SOQ works great for spool files. We currently use to cleanup, save & restore spool files. Good product.
Is this software applicable to the issue i mentioned below where i have a tape backup of the OUTQ file I intend to restore but upon restoration no spool files were included.
It is applicable to the new saving of spooled files.
It is not applicable to previous saves because the spooled files are not in the save in order to be recovered.
Without a product that retrieved the spooled files while they were on the system and that put them in a form that could be saved, they did not get saved at all.
Tom
Take a look at SAVOUTQ command, it will save the spooled files from an OUTQ
The SAVOUTQ command allows users to archive spool files, prepare
spool files for microfiche, tape or pass spool files to a COLD storage
solution via interfaces provided. This command is valid in both
batch and interactive environments. When executing this command i
a batch environment, the Spool files (SPLF) parameter must be
*ALL.
Only issue I see with the SAVOUTQ command is that you need the Save Output Queue product.
Hope this helps,
Bill Poulin
Do you know of any website link where i can obtain information that OSV5R3 can not save the actual spool file but only spool file information and in effect can not restore any spool file. I need to show this to my boss to convince him that our model 820 w/ OSV5R3MO is limited by OS version and can not save SPOOL file. My boss is mainframe guy and is not convinced that our current iSeries can not save actual spool file. We also don’t have the BRMS installed in our machine. Thanks.
Do you know of any website link where i can obtain information that OSV5R3 can not save the actual spool file but only spool file information and in effect can not restore any spool file.
The IBM Information Center website says it.
But a website isn’t needed. The RSTOBJ command says it on your system. Show him the <help> text. In part, it says:
No need to go to a website when the restore command says it.
However, this applies to the system save and restore commands. At V5R3 and earlier, the content of spooled files can be extracted into user spaces. The user spaces can be saved and restored. And spooled file content can be written from restored user spaces. It’s not perfect since the connections between the original job information and the spooled file are lost, as other attributes might be. But you can write programming or purchase a product that does it.
Tom
Can the two system connected via TCP/IP? If so, the easies way to move spooled files is to create a remote outq from AS/400 to AS/400. The link below has instructions for creating remote outq’s. Using this method the spooled files can be easily moved from one system to another and they can be easily directed to the appropriate outq on the target system. the concept is that a remote outq delivers the spooled file to the named outq on the target system. So the process of moving a spooled file from system a to system b is to create the remote outq on system a pointing to the appropriate outq on system b, then simply moving the spool files from their current location to the remote outq. Quick, easy and extremely reliable.