Re: Logical Logs problem

This is a multi-part message in MIME format. --------------CF613D91E69 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit odsharma@hclc.hclc-ggn.hcla.com wrote: > > We are developing a project using Informix 5.0 Online and Visual Basic > 4.0. > We are facing a problem quite frequently. Informix goes in 'recovery > mode' fails to become online saying that logical logs are full. Usually > this happens if server goes down due to some problem. > > We have 5 logical logs. Each logical log file is of size 1500K. > Size of logical log buffers is 32K. > Size of root dbspace is 20000 pages and a BlobSpace of 10000 pages ( > page size 2K). > "tbstat -l" shows 100% full for lal the logs. > Logical log tape device pathname & Archive tape device pathname is > /dev/null. > > When we try to take backup it just goes into a wait state and does not > come out. The status id shown as 'recovery' all the time. ( Device > /dev/null is working fine ) > > Is there a way out? Please help. A detailed reply including some > information on working Logical Logs would be appreciated. Gees, I think a training course would be a good start. It sounds as though you have a long transaction (A single transaction that spans all logs). The solution is to either add more logs, or reduce the size of your transaction. In version 5.x the high water mark parameters (LTXHWM & LTXEHWM) are set to 80% and 90% by default. In version 7.x these are 50% and 60% by default. You may need to reduce these in order for OnLine to automatically detect a long transaction and roll it back instead of getting stuck with all logs full. Remember that even though you have backed up your logs, they will only free once they no longer contain active transactions, or are prior to the last checkpoint record (status flag L). So downing OnLine is not the solution. As you have discovered, you just get stuck in recovery mode. Hope that helps, -- --------------CF613D91E69 Content-Type: text/plain; charset=us-ascii; name="ATT_SIG.TXT" Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="ATT_SIG.TXT" Mark. +------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +-----------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work, force it! | |Fax: +27 11 803 2189 |If it breaks, it needed replacing anyway!| |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+-----------------------------------------+ --------------CF613D91E69--