09-08-2005 01:49 AM
I want to enable automatic logical logs backup on informix IDS, but ontape -a gives this error:
Performing automatic backup of logical logs.
Logbackup failed - Log backup to device '/dev/null' not allowed
LTAPEDEV is set to /dev/null in onconfig
I found a technical case on IBM site with the same problem http://www-1.ibm.com/support/docview.wss?rs=0&q1=L
But I've restarted Informix many times, it doesn't help :(
Maybe you have some ideas?
Informix Dynamic Server Version 7.31.UD6W5
B.11.11 U 9000/800
Solved! Go to Solution.
09-08-2005 01:54 AM
You must change the LTAPEDEV to a valid tape device and restart the Informix server.
09-08-2005 01:56 AM
On another HP machine LTAPEDEV is set to /dev/null and everything is ok. I can't understand why it can't work on this machine...
09-08-2005 02:00 AM
Change TAPEDEV to /dev/null
not LTAPEDEV and try the ontape again.. LTAPEDEV must not be /dev/null
09-08-2005 02:04 AM
I just double checked.. Neither should be /dev/null.
You can send them to a file, then delete the file.. This was a change I think at 7.31 we could at 7.24, not since..
09-08-2005 02:13 AM
I don't see what you want to accomplish.
I want to enable automatic logical logs backup on informix IDS
but I don't want to backup logical logs.
Please tell us what your goal exactly is
09-08-2005 03:22 AM
You may have an unprintable character in the onconfig file at that line which is causing it to mis-read it.
Completely delete the entire LTAPEDEV line using dd in vi, then re-enter
LTAPEDEV /dev/null # Log tape device path
Also put /dev/null next to TAPEDEV
Then bounce it again. Run ontape -s -L 0, then change TAPEDEV back to your normal device and bounce it again.
09-08-2005 08:36 PM
Ok, I will set LTAPEDEV to /dev/null and will no run onatpe -a, let's see will logical logs overflow or not. Thanks!
09-09-2005 04:08 AM
You can write your logical logs to /dev/null using 'ontape -c' not 'ontape -a'. Just change your LTAPEDEV /dev/null. By the way,
when you change your tape device for either LTAPEDEV or TAPEDEV you don't need to bounce IDS as these two parameters are read when you perform a database backup or logical log backup.
09-09-2005 04:13 AM
I should have said that the 'ontape -c' or ontape -a is not needed. Your logical logs will continuously backup to /dev/null, which is what you want. We have two of our dev server running this way, no problems.
09-12-2005 02:04 AM
TAPEDEV to /dev/null, LTAPEDEV still runs transactions logs, in order maintain record rollback transactions have to go to log. I don't think there is a way around and personally I'd not recommend it.
My nutsack would be hanging on my door if something happened and a database got some whacked data.. ontape takes very little CPU or memory but could well be a butt saver, from personal experience in having to recover from a mirror crash recently YOU DO want archives in addition to your exports. disk and tapes are cheap compared to getting 500 pissed off educators breathing down your throat.
You can set your transaction logging and archive to run to an NFS mount, Tape or local disk, but IMHO don't go with out..