Midrange News for the IBM i Community


Posted by: Bob Cozzi
Rogue Programmer
Cozzi Productions, Inc.
www.cozTools.com/qryfile
Chicagoland
How to Save/Restore Spool Files and OUTQs
has no ratings.
Published: 27 Sep 2011
Revised: 23 Jan 2013 - 3964 days ago
Last viewed on: 29 Nov 2023 (9737 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

How to Save/Restore Spool Files and OUTQs Published by: Bob Cozzi on 27 Sep 2011 view comments(9)

Like the topic indicates... I need to save the spool files and output queues on one system and restore it onto another (we're doing a half-ass migration/upgrade). Are spool files part of one of the SAVxxx commands or do I need to do something like a remote output queue and move them that way?

Return to midrangenews.com home page.
Sort Ascend | Descend

COMMENTS

(Sign in to Post a Comment)
Posted by: Paulster
Premium member *
Sweden and The Netherlands
Comment on: How to Save/Restore Spool Files and OUTQs
Posted: 12 years 2 months 4 days 18 hours 14 minutes ago

Hi Bob,

Dunno bout the SAV/RSTOBJ (can't check where I am now) but if there's not too many spooled files you might consider sending them with SNDNETSPLF (option 1 on the WRKSPLF screen).

 

Good luck,

Paulster

Posted by: DaleB
Premium member *
Reading, PA
Comment on: How to Save/Restore Spool Files and OUTQs
Posted: 12 years 2 months 4 days 16 hours 56 minutes ago
Edited: Wed, 28 Sep, 2011 at 07:51:40 (4447 days ago)

Think we got this in V5R4; see SPLFDTA() keyword on SAV* commands. Without this, you only save the *OUTQ definition, not the contents (like pre-V5R4). On the restore side, the related job isn't there, so they're detached (see system value QSPLFACN).

Posted by: DaleB
Premium member *
Reading, PA
Comment on: How to Save/Restore Spool Files and OUTQs
Posted: 12 years 2 months 4 days 16 hours 54 minutes ago

btw, if you use SNDNETSPLF, make sure you specify DTAFMT(*ALLDATA).

Posted by: bobcozzi
Site Admin ****
Chicagoland
www.cozTools.com/qryfile
Comment on: How to Save/Restore Spool Files and OUTQs
Posted: 12 years 2 months 4 days 16 hours 34 minutes ago

I know about the splfdtA(*YES) on V5R4 and later... we're move from v5r2 and the client tends to archive stuff in spool files...  I thought of the sndnetsplf, but having used SNADS in a century--don't know if its set up. I'll check. Thanks guys!

Posted by: DaleB
Premium member *
Reading, PA
Comment on: How to Save/Restore Spool Files and OUTQs
Posted: 12 years 2 months 4 days 16 hours 1 minutes ago

Hmm... unless you've got an SNA connection, SNADS will need AnyNet. Somewhere along the line we switched from AnyNet to *HPRIP, but I don't know if that's available in V5R2.

 

Another option would be QSPCLOSP, QSPCRTSP, QSPGETSP, QSPPUTSP, QSPOPNSP, but that could be a lot of work, and complicated if any AFP involved.

Posted by: DaleB
Premium member *
Reading, PA
Comment on: How to Save/Restore Spool Files and OUTQs
Posted: 12 years 2 months 3 days 16 hours 55 minutes ago
Edited: Thu, 29 Sep, 2011 at 07:50:03 (4446 days ago)

Wow - it helps if you reread the original post. Remote *OUTQ would be easier than SNDNETSPLF (no SNA if you don't want to, no directory entries, no SNADS, ...). You give up user association on the target, but DTAFMT(*ALLDATA) is implied.

Posted by: JOHND1
Premium member *
Milford, Ma
Comment on: How to Save/Restore Spool Files and OUTQs
Posted: 12 years 2 months 2 days 9 hours 43 minutes ago

Save object lets you save outq and spool files

 

            Spooled file data (SPLFDTA) - Help          
                                                        
Specifies whether to save spooled file data and attribute
for output queues that are saved.                       
                                                        
*NONE                                                   
    No spooled file data is saved.                      
                                                        
*ALL                                                    
    For each output queue that is saved, all available  
    spooled file data on the output queue is saved.     
                                                    Botto

Posted by: bobcozzi
Site Admin ****
Chicagoland
www.cozTools.com/qryfile
Comment on: How to Save/Restore Spool Files and OUTQs
Posted: 12 years 2 months 2 days 3 hours 5 minutes ago

John, yep we know about that on V5R4 an later.

It's not on our old V5R2 machine Cry that we're moving to V5R4 and then up to a v7r1 system in a month or two. 

Thanks!

Posted by: bobcozzi
Site Admin ****
Chicagoland
www.cozTools.com/qryfile
Comment on: How to Save/Restore Spool Files and OUTQs
Posted: 11 years 10 months 26 days 13 hours 45 minutes ago

FYI, I used SNDTCPSPLF to send the spool files--it works great.