Due to certain condition, such as a big chunk of data is trying to roll back, Informix database server tend to use up all the logical spaces that are assigned to it.
If one day you found that your informix server is not functioning properly, why not check at the logical log file first? I've spend my whole day standing in the server room learning this lesson. This is how I manage to resolve it:
1. If logical file is full, You'll see this error in informix's log file : Logical Log Files are Full -- Backup is Needed. You will not be able to search certain tables and you may also encounter table lock often.
2. type onstat -l to list the list of logical file that you have. If it is due to this error, you will see most, if not all, logical space is 100%.
3. type onmode -l to clear logical log file.
4. If the logical space is fully utilised, onmode -l cannot be use. It will not succeed. You need to goto %informix%/etc/onconfig.std (%ONCONFIG file), change the LTAPEDEV value to /dev/null.
5. Run ontape -a to run backup. Follow instruction.
6. Then run onmode -l again to clear logical file one by one.
7. Change back LTAPEDEV to its original value (/dev/tapedev).
8. Restart DB.
*p/s: I've updated the steps as previously I have missed out step number 5.
11 comments:
goos tips kudo
Once again, this 1 need to thank my sifu because last time he face the same problem and this gave me a good head start.
im having the same problem,but when i try to type onstat -l,it gives an output onstat: not found. any ideas?
Hi, I don't have a real idea on solving the "onstat: not found" problem, but my guess is some setting is missing.
After doing some research online, I found something that might be useful for you. Go to the startup file (you might find it in /etc/rcX/SXXinformix.sh if you are using unix), be sure that these setting are in:
INFORMIXSEVER=servername
INFORMIXDIR=/usr/informix
PATH=$PATH:$INFORMIXDIR/bin
export INFORMIXSERVER INFORMIXDIR PATH
oninit
and in the stop script (you might find it in /etc/rcX/KXXinformix.sh if you are using unix), you'll need this:
INFORMIXSEVER=servername
INFORMIXDIR=/usr/informix
PATH=$PATH:$INFORMIXDIR/bin
export INFORMIXSERVER INFORMIXDIR PATH
onmode －ky
Hopefully these tips might shed a light.
Infatuation casinos? contain this grassy [url=http://www.realcazinoz.com]casino[/url] advisor and waver online casino games like slots, blackjack, roulette, baccarat and more at www.realcazinoz.com .
you can also into our untrained [url=http://freecasinogames2010.webs.com]casino[/url] barrister at http://freecasinogames2010.webs.com and encumber practical tangled dough !
another unsurpassed [url=http://www.ttittancasino.com]casino spiele[/url] purlieus is www.ttittancasino.com , in the leadership of german gamblers, fetch manumitted online casino bonus.
crt exposed this gratis [url=http://www.casinoapart.com]casino[/url] summation at the greatest [url=http://www.casinoapart.com]online casino[/url] control with 10's of spiffy [url=http://www.casinoapart.com]online casinos[/url]. actions [url=http://www.casinoapart.com/articles/play-roulette.html]roulette[/url], [url=http://www.casinoapart.com/articles/play-slots.html]slots[/url] and [url=http://www.casinoapart.com/articles/play-baccarat.html]baccarat[/url] at this [url=http://www.casinoapart.com/articles/no-deposit-casinos.html]no imagine far-off casino[/url] , www.casinoapart.com
the finest [url=http://de.casinoapart.com]casino[/url] to UK, german and all notable the world. so in behalf of the cork [url=http://es.casinoapart.com]casino en linea[/url] lop us now.
hi i am facing a problem that the logical for one of my instance keep getting full. I already schedule to backup the logical log every 12 hours but still the same. I am wonder is there anywhere to check which process cause the logical log keep get full since i do not think this instance have much transaction....
Please help and thanks in advance.
Hi. On my side we are facing blue also. From daily we reduce it to 12 hours then 6 hours. No many usage, but yet still filling up very fast.
One of the reason I can think is it could be due to some schedule backup process.
Although nothing much can be concluded on this, but it is better to think of alternative solution such as changing db to Oracle or MsSQL...
What i wonder is total we have 30 instances but only one of it facing this problem... any idea or anywhere to check on it??
No idea on this. But you may want to look for any cron/scheduled process which will be using the instance? :)
Gary,
THANKS A LOT FOR SHARING THIS!!
Victor.
Post a Comment