Re: How to enable Database logging
Thanks Andrew, it works... ;-)
Regards,
Navaid Arif
Assistant Manager,
EFT Operations,
ORIX Network,
601, STSM Foundation Building
Beaumont Road, Civil Lines
Karachi 75530
Tel: +92 21 111 767 657 Ext-222
Cell: +92 333-2153515
www.access.net.pk
DISCLAIMER: This e-mail contains proprietary information some of which may be
legally privileged. It is for the intended recipient only. If an addressing or
transmission error has misdirected this e-mail, please notify the author by
replying to it. If you are not the intended recipient you may not use,
disclose, distribute, copy, print or rely on this e-mail.
----- Original Message -----
From: Andrew Ford
To: Navaid Arif ; ids@iiug.org
Sent: Wednesday, December 13, 2006 2:51 PM
Subject: Re: How to enable Database logging
You can change the logging mode from 'no logging' to 'unbuffered logging' via
the ontape command
ontape -s -L 0 -U <dbname>
If you don't really want to perform a backup to tape you can set your TAPEDEV
onconfig parameter to /dev/null, you will need exclusive access to the
database to do this.
As for the logical logs, what does your configuration look like now? When you
enable logging you will write a lot more info to the logical logs (since you
are now logging all of your changes) and you may or may not need additional
log space depending on your load and current log configuration.
Make sure you are dumping your logical logs to /dev/null (not recommended if
you want to fully recover from a failure) or backing them up with onbar or
ontape as they fill or you can hang your system.
A lot of things change when you go from no logging to logging. You can have
long transactions, your default isolation level is different and multi row
updates and deletes will roll back upon failure unlike a non logging database.
Andrew
----- Original Message -----
From: Navaid Arif
To: classics@iiug.org ; ids@iiug.org ; peoplemix@iiug.org ;
informix-list@iiug.org ; admin-tools@iiug.org
Sent: Wednesday, December 13, 2006 2:58 AM
Subject: How to enable Database logging
Hi All,
I am configuring Enterprise Replication for DR. For testing, I created a test
database with logging and successfully test replication. But for my live
database where logging is set to 'NO LOGGING', when I tried to enable the
logging using onmonitor it showed: "Cannot change logging mode from 'no
logging'. Use onarchive or ontape.". Can anybody guide me, how can I enable
database unbuffered logging. I cannot spare additional space for logging, as
disk space will be an issue for me.
Regards,
Navaid Arif
Assistant Manager,
EFT Operations,
ORIX Network,
601, STSM Foundation Building
Beaumont Road, Civil Lines
Karachi 75530
Tel: +92 21 111 767 657 Ext-222
Cell: +92 333-2153515
www.access.net.pk
DISCLAIMER: This e-mail contains proprietary information some of which may be
legally privileged. It is for the intended recipient only. If an addressing or
transmission error has misdirected this e-mail, please notify the author by
replying to it. If you are not the intended recipient you may not use,
disclose, distribute, copy, print or rely on this e-mail.
----------------------------------------------------------------------------
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list