Re: Database and RAID

David Williams <djw@smooth1.demon.co.uk> offerred: + PS How do you freeze Online??? + + onlog ... | more and pause it. + + It holds a latch... + + Next CKPINTVL is reached an the checkpoint can't proceed because of + the latch and nothing can proceed (enter critical sections) because + the checkpoint is in progress. Nasty.... Yup. This has been long time behavior. Discovered it myself while on a customer site back in the 5.0 days. Seems my perusing of the logs (looking for a problem) caused their system to enter a "hung" state. Oops! Never made that mistake again. I always make a point of this when I teach the IDS Internals class (the only class where onlog is taught). I suggest sending onlog output to a file and then using more to view the file (assuming enough disk space is available to hold the output - if not, you have to use head/tail to limit the file size and examine the results in pieces). Dave ** Dave Kosenk <davek@summitdata.com> ** Director of Training Services (732) 469-4070 ** Summit Data Group (an Informix Authorized Education Center) ** Find my advice useful? Let me teach you everything I know about ** Informix. Sign up for OFFICIAL Informix training at SDG. ** For details, see http://www.summitdata.com/training