Hi All,

I found some steps for PeopleSoft Refresh and I want to ensure all these steps are valid for PS Refresh and it's also one of the main activities performed by PS Admin.

Please add your comments and give me some valuable suggestions on the below :


1) Stop the Application server,Web Server,Process Scheduler and before that ensure no user are connected to the application.

2) Backup the Security definition tables.This can be done using exproles.dms script found under the pshome/scripts folder.right ?

3) DBA task in DB refresh i.e., the process of dropping and restoring the database, using the most recent backup of the Production environment.

Once DBA task is done.

4) Import the Security Definition tables using improles.dms script found under the pshome/scripts folder.right ?So,that there will not be any user access issue.

5) Restart the application by re-importing the security definitions.
Starting the PeopleSoft environment; Web Sever, Application Server and Report Server. Re-Configure the Report Node Definition.Verify the configuration of the Report Node Definition.

6) After the DBA task is done,cannot login to datamover with VP1 id so by using the access id/database id SYSADM to login.

7) once login,then should update the VP1 id and also accessID,symbolic id there are tables which has this info
psstatus. psoprdefn psacccessprfl.

8) After updating u should encrypt the passwords using encrypt.dms


9) Run a test report to ensure that evrything is working good.Here any sample report will do right ?