Re: Problem with DSA 7.2 + Hp UX 10.20

In article <33141D84.741@porsche.co.at>, Peter Kolmhofer <"Peter Kolmhofer"@porsche.co.at> writes >Cesar Alexandre de Souza wrote: >> >> I have a problem with DSA 7.2 running on a K250 with 256 Mb >> I hope anyone could help me. >> >> Sometimes the database server seems to 'freeze', it is, >> it is still on-line and running, there are no error messages on the log >> but nobody can access it thru shared memory, and >> it is possible to access it thru a network connection (soctcp). >> We were told by a Informix Vendor hewre in Brazil that the problem was >> with the HP-UX 10.20 and that we should install an appropriate patch. >> We installed the shared memory patch, but the problem ocurred again. >> >> PLease help!! >> >> Cesar Souza - Brazil - casouza@usp.br > >We too had the same situation (on AIX however). The problem could be >located in the NETTYPE parameter; there is a value for max. connections. >You could try to increase this value or find out if this is the problem. >(onmode -z some of the SHM-connections and try to connect again). > >The example of the according $ONCONFIG-Line (20 concurrent connections): >NETTYPE ipcshm,1,20,CPU # Override sqlhosts nettype parameters> >Hope this helps, >Peter Possibly a long checkpoint is running whilst Online freezes? I would check the checkpoint durations times in online.log. Or logical logs become full - also check for messages in online.log. Also try running onstat -g ath whilst Online is frozen. -- David Williams