Mirroring active logs via NFS? 
Author Message
 Mirroring active logs via NFS?

DB2 7.2 on Solaris:

I edited and compiled the sample archiving user exit. Now every closed
log gets archived in a special directory that is exported with NFS. An
archiving machine checks every minute for logs in that directory and
copies it to a safe place.

But if the database machine explodes/vanishes/get_stolen/whatever then
all the completed transactions in the current log are lost.
But my db contains financial transactions that should not get lost, even
if I need a day or two to restore them.

Can I have db2 mirror the active logs, one on the local disk and one on
NFS on another machine, so I lose only the last, non-commited
transaction? In fact I'd lose nothing because an uncommited transaction
isn't displayed as "complete" in an application dialog, either.

Any suggestions?



Tue, 17 Aug 2004 03:51:51 GMT
 Mirroring active logs via NFS?

Hi, Holger,
You can try to set NEWLOGPATH2 registry variable.
I set it on two local disks, nerver try it on NFS. But I think it is no
reason we can't make it.
Regards,
Fan Ruo Xin
Quote:

> DB2 7.2 on Solaris:

> I edited and compiled the sample archiving user exit. Now every closed
> log gets archived in a special directory that is exported with NFS. An
> archiving machine checks every minute for logs in that directory and
> copies it to a safe place.

> But if the database machine explodes/vanishes/get_stolen/whatever then
> all the completed transactions in the current log are lost.
> But my db contains financial transactions that should not get lost, even
> if I need a day or two to restore them.

> Can I have db2 mirror the active logs, one on the local disk and one on
> NFS on another machine, so I lose only the last, non-commited
> transaction? In fact I'd lose nothing because an uncommited transaction
> isn't displayed as "complete" in an application dialog, either.

> Any suggestions?



Tue, 17 Aug 2004 11:09:33 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. How to replace an active log device without mirroring

2. Problems with SQL-Server 2000 Active/Active Cluster accessing via DNS name

3. active/active w/ log shipping

4. Ingres database via NFS ?

5. Ingres database via NFS ?

6. mount remote dir via nfs?

7. which logs are active logs?

8. Linux NFS with HP-UX NFS

9. NFS and Oracle archive logs

10. Adding a Mirrored DBSPACE via Onmonitor

11. Cost associated with going from SQL active/passive to Active/active

12. Convert Active/Passive to Active/Active - SQL 7.0


 
Powered by phpBB® Forum Software