RE: HELP!!!! informix now freezes on weekly basis why???
I couldn't help but notice the following line in your logfile
08:16:22 dynamically allocated new shared memory segment (size 8388608)
How many extra shared memory segments are allocated within a given week?
I'm not sure how that would affect performance on UnixWare, but in the HP
world, I tend to eliminate them (increase SHMVIRTSIZE) wherever possible.
> -----Original Message-----
> From: Chuck Renaud [mailto:crenaud@informix.com]
> Sent: Friday, September 15, 2000 3:48 PM
> To: informix-list@iiug.org; Simbarashe.Pangeti@icl.com
> Subject: Re: HELP!!!! informix now freezes on weekly basis why???
>
>
> Okay,
>
> My observations.
>
> First, I think you need to give more background. Maybe you've
> done this in a previous post, but I don't see much detail.
>
> What version of UnixWare are you running? What kind of machine
> is this running on (CPUs, RAM, disk)?
>
> What exactly is happening when you "freeze"? What error
> messages are you getting in your online.log and at the console?
> What happens when you run onstat commands? What do the
> machine resources look like at the time of the freeze (CPU,
> memory and disk utilization)? Have you verified that you aren't
> running out of space? Long transaction?
>
> Also, you say you're running 7.31, yet you've included information
> on a 7.30 engine.
>
> You have DBSPACETEMP going to rootdbs. Why?
>
> Are you running multiple instances with the same server number?
>
> --Chuck
>