Re: Logical Logs problem

On 16 Jan 97 at 14:35, odsharma@hclc.hclc-ggn.hcla.c wrote: > 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. Detailed information can be found in TFM. What I guess might be happening is that you have a long transaction open which is spanning all your logs. Check for a missing COMMIT WORK or ROLLBACK WORK somewhere in your system. -- Ciao, Billy I'd be in favour of apathy, but I just couldn't be bothered...