Re: [help again!]Informix Server no response! ✗ Answered: red (solid confidence) — The reported problem (server-wide hang under heavy transaction load with ~200 Enterprise Replication replicates, requiring an NT reboot) never receives a technical diagnosis in the visible thread; Informix's own list contact only pushes the user toward opening a formal tech-support case.

Advisory only.

I don't understand. 7.31TC2 is a supported release. Are you saying that tech support refused to open a case? paul wrote: > We tried, but they told us they did not have the same version, so they can't > help, but we do not have time to wait ! > > help, please! > > Madison Pruet <mpruet@informix.com> wrote in message > news:3880DD91.AB3744D3@informix.com... > > Paul, > > > > I'm assuming that ER is somehow involved in this problem. Have you opened > a > > case with tech support? If so, do you have the case number? I can't tell > what > > is going on from your description here in the news group, but there might > be > > some information in the case to aid in the diagnosis of the problem. > > > > Thanks > > > > paul wrote: > > > > > Dear sir > > > We tried to find the solutions about no response of Informix server 7.31 > TC2 > > > for a long time! Our server now is NT4 server,sp4 with dual P-III550 > CPU, > > > 512MB RAM, five 9GB hard disks with raid card, we tried to simulate the > same > > > situation and got some idea. > > > Sometimes, when some one issue a heavy transaction , it will > lock > > > all Informix server connections include Informix server > itself(e.g > > > onmode, ontape , cdr list server, dbaccess and logical log > stop > > > backup, but the transaction still work!) , the only way it > reboot > > > the nt server, why? our server had been ran smoothly more > than > > > one year, until last week ,we issue more tables to do the > > > replicates(we have 200 replicates through our local LAN) > > > > > > We do need some one to help, we ask for help to our local Informix > > > consultant but they told us they do not have this version of Informix > server > > > (it's really strange, this version was bought from them) wish we can > make a > > > copy and let them try to find the problem, but we do not have the time , > our > > > mis system have to work everyday!! before yesterday, we wish a new > powerful > > > server can resolve this problem , but we failed, I do not sleep until > now to > > > find the solution! > > > > > > Thanks! > > > > > > Spec. > > > NT4 Server, Sp4, Informix 7.31 TC2, Data replication about 200 > > > replicates! > >

Paul, Where are you located? What is the name of your company? Who is your sales rep? Madison Pruet wrote: > I don't understand. 7.31TC2 is a supported release. Are you saying that tech > support refused to open a case? > > paul wrote: > > > We tried, but they told us they did not have the same version, so they can't > > help, but we do not have time to wait ! > > > > help, please! > > > > Madison Pruet <mpruet@informix.com> wrote in message > > news:3880DD91.AB3744D3@informix.com... > > > Paul, > > > > > > I'm assuming that ER is somehow involved in this problem. Have you opened > > a > > > case with tech support? If so, do you have the case number? I can't tell > > what > > > is going on from your description here in the news group, but there might > > be > > > some information in the case to aid in the diagnosis of the problem. > > > > > > Thanks > > > > > > paul wrote: > > > > > > > Dear sir > > > > We tried to find the solutions about no response of Informix server 7.31 > > TC2 > > > > for a long time! Our server now is NT4 server,sp4 with dual P-III550 > > CPU, > > > > 512MB RAM, five 9GB hard disks with raid card, we tried to simulate the > > same > > > > situation and got some idea. > > > > Sometimes, when some one issue a heavy transaction , it will > > lock > > > > all Informix server connections include Informix server > > itself(e.g > > > > onmode, ontape , cdr list server, dbaccess and logical log > > stop > > > > backup, but the transaction still work!) , the only way it > > reboot > > > > the nt server, why? our server had been ran smoothly more > > than > > > > one year, until last week ,we issue more tables to do the > > > > replicates(we have 200 replicates through our local LAN) > > > > > > > > We do need some one to help, we ask for help to our local Informix > > > > consultant but they told us they do not have this version of Informix > > server > > > > (it's really strange, this version was bought from them) wish we can > > make a > > > > copy and let them try to find the problem, but we do not have the time , > > our > > > > mis system have to work everyday!! before yesterday, we wish a new > > powerful > > > > server can resolve this problem , but we failed, I do not sleep until > > now to > > > > find the solution! > > > > > > > > Thanks! > > > > > > > > Spec. > > > > NT4 Server, Sp4, Informix 7.31 TC2, Data replication about 200 > > > > replicates! > > >

Taiwan, PAN International Industrial Corp. Madison Pruet <mpruet@informix.com> wrote in message news:3881E38B.E46300E@informix.com... > Paul, > > Where are you located? What is the name of your company? Who is your sales rep? > > Madison Pruet wrote: > > > I don't understand. 7.31TC2 is a supported release. Are you saying that tech > > support refused to open a case? > > > > paul wrote: > > > > > We tried, but they told us they did not have the same version, so they can't > > > help, but we do not have time to wait ! > > > > > > help, please! > > > > > > Madison Pruet <mpruet@informix.com> wrote in message > > > news:3880DD91.AB3744D3@informix.com... > > > > Paul, > > > > > > > > I'm assuming that ER is somehow involved in this problem. Have you opened > > > a > > > > case with tech support? If so, do you have the case number? I can't tell > > > what > > > > is going on from your description here in the news group, but there might > > > be > > > > some information in the case to aid in the diagnosis of the problem. > > > > > > > > Thanks > > > > > > > > paul wrote: > > > > > > > > > Dear sir > > > > > We tried to find the solutions about no response of Informix server 7.31 > > > TC2 > > > > > for a long time! Our server now is NT4 server,sp4 with dual P-III550 > > > CPU, > > > > > 512MB RAM, five 9GB hard disks with raid card, we tried to simulate the > > > same > > > > > situation and got some idea. > > > > > Sometimes, when some one issue a heavy transaction , it will > > > lock > > > > > all Informix server connections include Informix server > > > itself(e.g > > > > > onmode, ontape , cdr list server, dbaccess and logical log > > > stop > > > > > backup, but the transaction still work!) , the only way it > > > reboot > > > > > the nt server, why? our server had been ran smoothly more > > > than > > > > > one year, until last week ,we issue more tables to do the > > > > > replicates(we have 200 replicates through our local LAN) > > > > > > > > > > We do need some one to help, we ask for help to our local Informix > > > > > consultant but they told us they do not have this version of Informix > > > server > > > > > (it's really strange, this version was bought from them) wish we can > > > make a > > > > > copy and let them try to find the problem, but we do not have the time , > > > our > > > > > mis system have to work everyday!! before yesterday, we wish a new > > > powerful > > > > > server can resolve this problem , but we failed, I do not sleep until > > > now to > > > > > find the solution! > > > > > > > > > > Thanks! > > > > > > > > > > Spec. > > > > > NT4 Server, Sp4, Informix 7.31 TC2, Data replication about 200 > > > > > replicates! > > > > >

Paul, I was able to find PAN, but was unable to find any cases concerning this problem. You need to contact tech support and open a case with them. Even if the person that you talk to currently does not have 7.31TC2, they can get it Also, the case notes act as a 'folder' of the case. Onstats and log output are placed in it. If the tech support person working the case is unable to immediatly resolve the issue, then he can get help from other people in the company, including R&D. Without having a case, case notes, and diagnostic information, there is very little to work with. paul wrote: > Taiwan, PAN International Industrial Corp. > > Madison Pruet <mpruet@informix.com> wrote in message > news:3881E38B.E46300E@informix.com... > > Paul, > > > > Where are you located? What is the name of your company? Who is your > sales rep? > > > > Madison Pruet wrote: > > > > > I don't understand. 7.31TC2 is a supported release. Are you saying > that tech > > > support refused to open a case? > > > > > > paul wrote: > > > > > > > We tried, but they told us they did not have the same version, so they > can't > > > > help, but we do not have time to wait ! > > > > > > > > help, please! > > > > > > > > Madison Pruet <mpruet@informix.com> wrote in message > > > > news:3880DD91.AB3744D3@informix.com... > > > > > Paul, > > > > > > > > > > I'm assuming that ER is somehow involved in this problem. Have you > opened > > > > a > > > > > case with tech support? If so, do you have the case number? I > can't tell > > > > what > > > > > is going on from your description here in the news group, but there > might > > > > be > > > > > some information in the case to aid in the diagnosis of the problem. > > > > > > > > > > Thanks > > > > > > > > > > paul wrote: > > > > > > > > > > > Dear sir > > > > > > We tried to find the solutions about no response of Informix > server 7.31 > > > > TC2 > > > > > > for a long time! Our server now is NT4 server,sp4 with dual > P-III550 > > > > CPU, > > > > > > 512MB RAM, five 9GB hard disks with raid card, we tried to > simulate the > > > > same > > > > > > situation and got some idea. > > > > > > Sometimes, when some one issue a heavy transaction , it > will > > > > lock > > > > > > all Informix server connections include Informix server > > > > itself(e.g > > > > > > onmode, ontape , cdr list server, dbaccess and logical > log > > > > stop > > > > > > backup, but the transaction still work!) , the only way > it > > > > reboot > > > > > > the nt server, why? our server had been ran smoothly > more > > > > than > > > > > > one year, until last week ,we issue more tables to do > the > > > > > > replicates(we have 200 replicates through our local LAN) > > > > > > > > > > > > We do need some one to help, we ask for help to our local Informix > > > > > > consultant but they told us they do not have this version of > Informix > > > > server > > > > > > (it's really strange, this version was bought from them) wish we > can > > > > make a > > > > > > copy and let them try to find the problem, but we do not have the > time , > > > > our > > > > > > mis system have to work everyday!! before yesterday, we wish a new > > > > powerful > > > > > > server can resolve this problem , but we failed, I do not sleep > until > > > > now to > > > > > > find the solution! > > > > > > > > > > > > Thanks! > > > > > > > > > > > > Spec. > > > > > > NT4 Server, Sp4, Informix 7.31 TC2, Data replication about 200 > > > > > > replicates! > > > > > > >