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.
Good Afternoon All. I have been working on a DR project that moves production libraries from one box to another. I have it working pretty well, but have some questions about copying the user data across. I am saving the production box's user profiles using the USRSECDTA command, then ftp'ing that file across to the DR box. Here is where my question comes in. Can the RSTUSRPRF command be used in batch mode? I know you have to be in a restricted state. My plan is to submit the job to QCTL, end all subsystems, then run the RSTUSRPRF command. Has anyone done something like this before?
Yep. I do it. Using a save file into which the users were saved.
RSTUSRPRF DEV(*SAVF) USRPRF(*NEW) SAVF(&SAVLIB/&SAVSECDATA) ALWOBJDIF(*ALL)
Then you need to restore the user profile authority.
RSTAUT USRPRF(*ALL)
RSTUSRPRF does not have to be run in a restricted state unless you're doing USRPRF(*ALL) or SECDTA(*DCM). RSTAUT does not have to be run in a restricted state in any case.
If you're doing other things, you still may need to restrict the system. If you're only restoring user profiles, it may not be necessary.