sap online backup configuration with DB2 database

[Former Member]

Hi,

Kindly help us to configure our IBM db2 database for online backup. Our Sap is running on Windows.

The information found on net is to modify the log parameter. If some one provides step by step guidance, it will really help.

IBM db2 behavior is something new for us.

Regards,

Hema

[Former Member · Accepted solution]

Hi Hema,

Please check below notes:-

https://docs.google.com/viewer?a=v&q=cache:NR3MlYSuiuAJ:www.ibm.com/developerworks/wikis/download/at...

http://www.ibm.com/developerworks/data/library/techarticle/pworld/0112mccluney.html

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/80e61772-e471-2c10-60b1-9529b69b50c5

http://www.ibm.com/developerworks/wikis/download/attachments/116426414/IBM-Backup-and-Recovery-Guide...

http://help.sap.com/saphelp_wp/helpdata/en/b5/25014faba011d283e60000e829fbbd/content.htm

[Former Member · Accepted solution]

Dear Ms. Hema,

Backup the database shoud be in a LOGARCHMETH1 ON / LOGRETAIN mode.

Follow following steps....

Login through SIDadm,

1.       >stopsap r3

2.       >get db cfg                                                                                                                                                                

(verify current configuration before you change it)

3.       >db2  update db cfg for <SID> using LOGARCHMETH1 LOGRETAIN

4.       >db2  backup db <SID> to /dev/rmt/0mn

(A full OFFLINE backup is mendatory)

5.       >get db cfg

(verify the parameter’s new value)

6.       Take a online backup to verify the configuration. (t-code=DB13)

Kind rgds,

Ashwin Mane