Re: Blob space gets FULL on machine reboot. Any Suggestions?

In article <Jun.22.08.47.38.1994.8346@gauss.rutgers.edu> manmetha@gauss.rutgers.edu (Rajesh Malhotra) writes: >From: manmetha@gauss.rutgers.edu (Rajesh Malhotra) >Subject: Blob space gets FULL on machine reboot. Any Suggestions? >Keywords: Normal blob has plenty of space. Rebooting machine fills it. >Date: 22 Jun 94 12:47:39 GMT >Fellow Informix'ers, > Seen a strange one lately. Our system is set up with a few blob >spaces, with one particular space that sees the most amount of traffic >(inserts and deletes). Under a normal running system, we have no problems, >and our inserts and deleted work fine. > But when we reboot the machine, the blob space gets full with 0 >pages free. Now inserts into this space come up with errors. After a few >inserts though, the epace goes back to its original size. > What is going on here? We did a greceful shutdown of Informix >before we rebooted the machine, but we get the same results. > We are running Informix 5.0 on an IBM RS6000 AIX 3.2.4. We are using >raw disks for all the informix chunks, including this blob space. Anybody >have an idea of what is going on here? > Any and all responses on this matter appreciated. >Thanx, >Raj. We have exactly the same problem. It looks like Informix marks them as in use in the log pages. The work around is to move the current log page to next one by using: tbmode -l; then archive the database to /dev/null tbtape -a; you might have to repeat the above steps couple of times. We are also on 5.02 on NCR. We move 1 Gb of Raster images into and out of the databse every day.