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 - 4110 days ago
Last viewed on: 23 Apr 2024 (9908 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 6 months 28 days 23 hours 28 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 6 months 28 days 22 hours 10 minutes ago
Edited: Wed, 28 Sep, 2011 at 07:51:40 (4593 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 6 months 28 days 22 hours 7 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 6 months 28 days 21 hours 47 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 6 months 28 days 21 hours 14 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 6 months 27 days 22 hours 9 minutes ago
Edited: Thu, 29 Sep, 2011 at 07:50:03 (4592 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 6 months 26 days 14 hours 56 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 6 months 26 days 8 hours 19 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: 12 years 3 months 21 days 18 hours 58 minutes ago

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