How to restore files to a different library
Recently this user wrote the editors at Search400.com with this question: "I'm trying to restore files (which are currently journeyed) to a different library, but I don't want them to be journaled, as I'm just using them for testing. Once I've restored them, I have to stop the journalling for each of these files. Is there a quick way to do it?"
Does anyone have any ideas?
-- Michelle Davidson, editor, Search400.com
Software/Hardware used:
Software/Hardware used:
ASKED:
October 17, 2005 9:01 PM
UPDATED:
November 15, 2009 8:19 AM
RELATED QUESTIONS
Answer Wiki:
Write a CL with the library name being passed to it. Do a DSPOBJD OBJTYPE(*FILE) to an output file for that library. Process that file and do an ENDJRNPF on each physical file.
======================================================
The solution is not to restore the files. Use CPYF MBROPT(*REPLACE) CRTFILE(*YES) instead. If they are SQL tables, use INSERT with SELECT from the originals.
A "restore" is designed to recreate things as they were when saved. Don't use it if that's not what you want done.
Tom
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
