IDS Forum

RE: Informix 11.10FC2W5 hangs & crashes

Posted By: Savio Pinto (s)
Date: Tuesday, 30 September 2008, at 3:37 p.m.

In Response To: Informix 11.10FC2W5 hangs & crashes (Tim Ertl)

We had experienced hang issues when we upgraded our databases to IDS=0D=0A1=
1=2E10FC2, we had to apply the W3 patch (ids 11=2E10FC2W3)to resolve the=0D=
=0Aissue=2E No hangs after W3 patch was installed, also we have noticed=0D=
=0Abetter performance with 11=2E10fc2w3 as compared to 11=2E10fc2=2E=0D=0A =
=0D=0A=0D=0A-----Original Message-----=0D=0AFrom: ids-bounces@iiug=2Eorg [m=
ailto:ids-bounces@iiug=2Eorg] On Behalf Of=0D=0ATim Ertl=0D=0ASent: Monday,=
September 29, 2008 5:01 PM=0D=0ATo: ids@iiug=2Eorg=0D=0ASubject: Informix =
11=2E10FC2W5 hangs & crashes [13520]=0D=0A=0D=0AWe have about 6 or 7 MAJOR =
failures of Infmormix 11=2E10FC2W5 in the past =0D=0Afew days=2E I have a p=
mr going and a tech support person working on it for=0D=0A=0D=0Aseveral day=
s now=2E =0D=0A=0D=0AI am hoping someone else might have seen this problem =
and fixed it them =0D=0Aselves=2E I am all Googled out=2E =0D=0A=0D=0AWe ha=
ve had Assertions and HANGS on Blocked Check Points=2E Sometimes we =0D=0Ac=
an stay up for only 3 hours other times we stay up for a whole day=2E =0D=
=0AThis morning alone we Hang at 6am and then again at 9=2E Now we are quit=
e =0D=0Atill 17:30=2E We have restricted usage to Medical Emergencies Only =
to =0D=0Aprevent any unnecessary usage=2E We move some stuff over to M/S Sq=
l =0D=0A(something some people around here looked for excuses to do)=2E =0D=
=0A=0D=0AWe have been running 11=2E10FC2 since Aug 16th no problems=2E Then=
all of a =0D=0Asudden we have an assertion at 3 oclock last Thursday monri=
ng=2E Since =0D=0Athen we have had about 6/7 Informix Failures=2E =0D=0AIBM=
Support had us upgrade to W5 and since we did that we have had 4 =0D=0Amor=
e problems=2E IBM has added and onmode -C alice 6 for some reason I do =0D=
=0Anot understand=2E We can not continue like this=2E =0D=0A=0D=0AALL of th=
ese problems start off with about an hour of the informix log =0D=0Asaying =
Txns blocked:1 and checkpoint durations greater than 0=2E We used =0D=0Ato =
have zero all the time for these=2E During the hour before lock up we =0D=
=0Ahave slow periods of up to 5 minutes then all of a sudden things free up=
=0D=0A=0D=0Aand we go back to normal, on and off hangs=2E Then after about =
an hour of =0D=0Athis the system freezes on blocked check point=2E =0D=0A=
=0D=0APhysical log is at 1% used and there are 7 logical logs and only one =
is =0D=0Ain use=2E The others are backed up=2E =0D=0A=0D=0AI have tons of o=
nstat -a's=2E Has anyone had some experience with blocked =0D=0Acheck point=
s that might be able to shed some light on this=2E =0D=0A=0D=0AWhy would in=
formix go belly up all of a sudden like this? =0D=0A=0D=0ARunning on a Sun =
Sparc T5120 32gb memory, 64 virtual processors (cores =0D=0Aor what ever th=
ey call them)=2E Ton's of disk space now=2E We upgraded Aug =0D=0A16th and =
things have been great, then crash! =0D=0A=0D=0AThanks for any suggestions=
=2E =0D=0AWe may need to hire special help! =0D=0A=0D=0A,,,Tim =0D=0A=0D=0A=
=0D=0A*********************************************************************=
***=0D=0A******* =0D=0A Forum Note: Use "Reply" to post a response in the =
discussion forum=2E =0D=0A=0D=0AConsider our environment; please print this=
e-mail only if truly=0Anecessary=2E Thank you!

Messages In This Thread

• Informix 11.10FC2W5 hangs & crashes
  Tim Ertl -- Monday, 29 September 2008, at 6:00 p.m.
  • Re: Informix 11.10FC2W5 hangs & crashes
    Obnoxio The Clown -- Monday, 29 September 2008, at 7:07 p.m.
    • RE: Informix 11.10FC2W5 hangs & crashes
      Tim Ertl -- Monday, 29 September 2008, at 8:46 p.m.
      • Re: RE: Informix 11.10FC2W5 hangs & crashes
        ZHAN YU LIN -- Monday, 29 September 2008, at 9:39 p.m.
      • RE: Informix 11.10FC2W5 hangs & crashes
        Stuart McCann -- Monday, 29 September 2008, at 9:53 p.m.
      • AW: Informix 11.10FC2W5 hangs & crashes
        Andreas.KUTSCHE@spar.at -- Tuesday, 30 September 2008, at 3:22 a.m.
  • RE: Informix 11.10FC2W5 hangs & crashes
    Savio Pinto (s) -- Tuesday, 30 September 2008, at 3:37 p.m.
    • RE: Informix 11.10FC2W5 hangs & crashes
      Tim Ertl -- Tuesday, 30 September 2008, at 3:44 p.m.
  • Re: Informix 11.10FC2W5 hangs & crashes
    Mark Jamison -- Tuesday, 30 September 2008, at 3:59 p.m.
  • Re: Informix 11.10FC2W5 hangs & crashes
    Mark Jamison -- Tuesday, 30 September 2008, at 4:00 p.m.
    • RE: Informix 11.10FC2W5 hangs & crashes
      Tim Ertl -- Tuesday, 30 September 2008, at 4:44 p.m.
      • RE: Informix 11.10FC2W5 hangs & crashes
        LARRY SORENSEN -- Thursday, 2 October 2008, at 12:34 p.m.
        • RE: Informix 11.10FC2W5 hangs & crashes
          Schmitz, Rob B [EQ] -- Thursday, 16 October 2008, at 10:54 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.