DB2 online backup problem

Terry Chiang May 24, 2012 8:15 AM

Currently Being Moderated

Hi all,

My system is AIX 6.1.0.0

DB is "DB2 v9.1.0.10"

I want to use DB13 run ONLINE BACKUP

When I use command：update db cfg for <DB> using logarchmeth1 logretain

and db2start is success

But I become cann't connect to SAP

>startsap r3

Checking db6 db Database
------------------------------
Database is not available via R3trans
Database db6 db must be started first

And I use command：update db cfg for <DB> using logarchmeth1 off

It can connect to SAP.

Anybody know how to set ONLINE BACKUP? Thank you.

Re: DB2 online backup problem

Joachim Müller May 24, 2012 11:29 AM (in response to Terry Chiang)

Currently Being Moderated

Hi Terry,

After changing the logmethode to archiving mode the first thing you have to do is a full offline backup.

Best regards,
Joachim
Report Abuse

Like (0)
Re: DB2 online backup problem

Sadiq Iqbal May 25, 2012 3:48 PM (in response to Terry Chiang)

Currently Being Moderated

Hi

When you will set the LOGARCHETH1 Then it will required a full offline backup.
if you don,t want to take backup you can use the command
db2dart <dbname> /CHST /WHAT DBBP OFF

to deactivate the pending status.
but we will recommend to take a full backup
hope its will help you

Thanks
Sadiq
Report Abuse

Like (0)