db2 offlline backup

[former_member201054]

Hi,

Need to take db2 offline backup on linux platform

after stopping SAP services, the db2 should also be stopped and it should be started again before trigerring the offline backup ?

please resolve the query.

Thanks a ton

[Former Member · Accepted solution]

Hello Daniel,

I guess you are Windows platform.

Just stop SAP and SAP Services. No need to stop DB2 or DB2 services.

However if you do stop SAP and DB2 both in one go, then DB2 needs to be started again before executing the offline backup.

Just to start DB2 before offline backup -

command prompt> db2start

prompt> db2 backup ..(complete the string for offline backup)

Or I think you open DB2 CLP in windows, then, >db2start

Sorry, now I read you are on Linux -

Do,

1. sidadm> stopsap (it will stop sap+db2)

2. db2sid> db2start

3. db2sid> db2 backup ..

Thanks

Edited by: DatabaseSAP on Nov 3, 2011 7:32 AM

[former_member201054 · Accepted solution]

Hi ,

How to check both SAP and DB2 are configured to stop in one go.

is it mandatory to restart the DB for offline backup on linux

Thanks a ton

[former_member188883 · Accepted solution]

Hi daniel,

you can login with sidadm user.

Then type command stopsap.

This will stop sap application as well as database.

Hope this helps.

Regards,

Deepak Kori

[Former Member · Accepted solution]

> How to check both SAP and DB2 are configured to stop in one go.

'stopsap' command is configured by default to stop both - sap and database. When you execute it , it will show you both the actions on your terminal screen as well as in the logs.

>> is it mandatory to restart the DB for offline backup on linux

It is not mandatory to 'restart' the DB. But you need to keep DB up during the backup. Either you do stopsap --> then db2start OR you do just 'stopsap r3' and then no need of 'db2start' before backup execution.

Thanks

[former_member182505 · Accepted solution]

Hi,

login to db2<SID>

start the db2 if it is stop.

and use the command

db2 backup database <SID> to /sapbackupPATH with 2 buffers buffer 1024 parallelism 3 compress without prompting

if its a first backup after installation then also activate the LOGARCHMETH1 PARAMETER the do the offline backup .

thanks

sadiq

[former_member201054 · Accepted solution]

Perfect..