Re: Bizarre sysmaster/IDS 10 problem
> -----Original Message----- > From: tgirsch@gmail.com [mailto:tgirsch@gmail.com] > Posted At: 27 February 2007 17:06 > Posted To: comp.databases.informix > Conversation: Bizarre sysmaster/IDS 10 problem > Subject: Re: Bizarre sysmaster/IDS 10 problem > > > I have opened a PMR with technical support. You think that will help ? We've had a down/unuseable dev server for the last three weeks, if you run 'Drop Database' the instance cores. After three weeks IBM response is 'reinitialise - that will drop the database' Sometimes I wonder if they live in the same world as the rest of us :-) Cheers Paul Paul Watson Tel: +44 1414161772 +1 913-400-2620 Mob: +44 7818003457 +1 913-636-2858 Web: www.oninit.com Failure is not as frightening as regret. Attend IDUG 2007 San Jose, North America May 6-10, 2007 Visit http://www.iiug.org/conf for more information.
My luck with support hasn't been THAT bad! Wow. In other news, I've done some more testing on this issue, and have narrowed things down. The memory hole doesn't involve database objects in general -- it involves indexes in particular. You can create tables until you're blue in the face -- these only take about 1.5K of rsam memory each. But when you start building indexes, THAT's the problem. I broke out the "create table" and "create index" steps, and checked individually. Creating tables, even in large numbers, only allocated at most 1.8K per object. Creating indexes allocated _35K-40K_ of rsam pool memory _per object_. Yikes! IBM support has identified a couple of older bugs that seem to match, except that these bugs are supposed to be fix in 9.40.xC6, and we're on 10.00.xC5. Paul Watson wrote: > You think that will help ? > > We've had a down/unuseable dev server for the last three weeks, if you > run 'Drop Database' the instance cores. After three weeks IBM response > is 'reinitialise - that will drop the database' Sometimes I wonder if > they live in the same world as the rest of us :-)
Hello Paul, a obnoxio the clown responce: have you tryed update statistics???????? WOEHA.... sorry mate i could not help it, itś friday and i drank a lot of beer. if you have an issue with support, then let scottispoet know he will care and take care of it ( that is the way i know him...) you should raise priority or start complaining because you did not get the help you needed/deserved. Superboer. On 1 mrt, 20:43, "Paul Watson" <p...@oninit.com> wrote: > > -----Original Message----- > > From: tgir...@gmail.com [mailto:tgir...@gmail.com] > > Posted At: 27 February 2007 17:06 > > Posted To: comp.databases.informix > > Conversation: Bizarre sysmaster/IDS 10 problem > > Subject: Re: Bizarre sysmaster/IDS 10 problem > > > I have opened a PMR with technical support. > > You think that will help ? > > We've had a down/unuseable dev server for the last three weeks, if you > run 'Drop Database' the instance cores. After three weeks IBM response > is 'reinitialise - that will drop the database' Sometimes I wonder if > they live in the same world as the rest of us :-) > > Cheers > Paul > > Paul Watson > Tel: +44 1414161772 +1 913-400-2620 > Mob: +44 7818003457 +1 913-636-2858 > Web:www.oninit.com > > Failure is not as frightening as regret. > > Attend IDUG 2007 San Jose, North America > May 6-10, 2007 > Visithttp://www.iiug.org/conffor more information.
Superboer wrote: > Hello Paul, > > > a obnoxio the clown responce: > > have you tryed update statistics???????? > > WOEHA.... > > sorry mate i could not help it, itś friday and i drank a lot of beer. > > if you have an issue with support, then let scottispoet know he will > care and take care of it > ( that is the way i know him...) > you should raise priority or start complaining because you did not get > the help you needed/deserved. > > Superboer. > > > On 1 mrt, 20:43, "Paul Watson" <p...@oninit.com> wrote: >>> -----Original Message----- >>> From: tgir...@gmail.com [mailto:tgir...@gmail.com] >>> Posted At: 27 February 2007 17:06 >>> Posted To: comp.databases.informix >>> Conversation: Bizarre sysmaster/IDS 10 problem >>> Subject: Re: Bizarre sysmaster/IDS 10 problem >>> I have opened a PMR with technical support. >> You think that will help ? >> >> We've had a down/unuseable dev server for the last three weeks, if you >> run 'Drop Database' the instance cores. After three weeks IBM response >> is 'reinitialise - that will drop the database' Sometimes I wonder if >> they live in the same world as the rest of us :-) >> >> Cheers >> Paul >> >> Paul Watson >> Tel: +44 1414161772 +1 913-400-2620 >> Mob: +44 7818003457 +1 913-636-2858 >> Web:www.oninit.com >> >> Failure is not as frightening as regret. >> > >> Attend IDUG 2007 San Jose, North America >> May 6-10, 2007 >> Visithttp://www.iiug.org/conffor more information. > > Well, if it is so important you would have a valid backup strategy ... wouldn't you? Anyways ... what happened to it 3 weeks ago?