I will setup an Archive loging for 3 production database on a linux server. The management want me to do a dual logging having one set of logs on the server where databases resides and the other set to be created on a mounted drive from another linux server. My questions are:
1- What happens when one of the drive is not available to write (Most probably the mounted drive) ?. Does the DB2 stops ? It creates on the available drive and errors out on the not-available one but continues to run ?
2- Can I still do nightly on/off line full backups ?
If you are archiving logs with both LOGARCHMETH1 and LOGARCHMETH2, you should not be losing anything if one of them fails. It should start archiving right where it left off when the resource becomes available.