Step by Step GUIDE Db2 BACKUP Restore Production server to Quality Server (Db2 Database Refresh with Production Offline Backup)

Login in To Production db2 Data base Server .

Login User ID: SIDadm

# run beloow command 

brdb6brt -bm RETRIEVE -es –replace <Proudction SID>=<Quality SID>,db2ecp=db2ecq,/db2/<ProductionSID>=/db2/<QualitySID>

Output file Created with File extension is .scr

Open and check the file

Login telnet in Quality Server

Output file and Db2 backup are mounted or copied in Quality Server

Change Permission of files

Stop the SAP in Quality server.

Stopsap all

>cat ECP_NODE0000.scr---à to view the file

In below screen we can view the file

Now we have to edit the “ECP_NODE0000.scr” file.

To edit this copy the ECP_NODE0000.scr file to your system using FileZilla.

Open the file with NOTEPAD and edit the file.

Save and copy the above file to the /qabackup.

Login in Quality server with db2SID user

Run below commands.

      db2set DB2_RESTORE_GRANT_ADMIN_AUTHORITIES=NO

      db2set DB2_WORKLOAD=SAP

   db2set –all | grep –I db2 restore grant

   db2 –tvf  ECP_NODE0000.scr (Output file .scr file)

Now open new session(192.168.1.67) and check the file systems.

To check the status

Successfully completed.

And create user id in Quality server with <ProductionServerSID>adm

Run below  command

dscdb6up –create <password of SIDadm user>  <sapsid user password>

if it will give error like not a valid user then

edit dscdb6.conf file from  /usr/sap/SID/global

write production server Username SIDadm .

Regards,

Alihamed.sa