arsdb -v -y /var/backup , HOW to ADD INCLUDE LOGS switch

[lrfurtado]

Is there a way to make the online backup generated with arsdb -v -y /var/backup  use the INCLUDE LOGS switch ? This is for a instance of OnDemand using db2 v8.


I have checked a backup generated with arsdb -v -y with "db2ckbkp -h" utitlity and it does not use the INCLUDE LOGS option by default.


If this is not possible is there a special precation I should take if we decide to take this online backup directly with the db2 utilities .


Thanks in advance for your help.

[demaya]

From what I can see it's not possible. I had a look at the newest info center: http://pic.dhe.ibm.com/infocenter/cmod/v9r0m0/index.jsp?topic=%2Fcom.ibm.ondemand.administeringzos.doc%2Farsdb.htm

How about making backup via the db2 tools? I'm doing it this way.

We do it like that:

Code: [Select]

db2 BACKUP DATABASE INSTANCENAME ONLINE <bla bla> INCLUDE LOGS WITHOUT PROMPTING;

You have to run that as instance-owner...

[Justin Derrick]

Yeah, for anything other than plain old regular DB2 backups, I use the db2 command line to do the work.

You can use:
db2 "? backup database"

To get help with the backup command.  Seek advice from your DBAs, and practise your restores on another system to ensure that they'll work the way you think they do.

-JD.