DB2 online backup problem

[Former Member]

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.

[former_member182505]

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

[Former Member]

Hi Terry,

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

Best regards,

Joachim