Re: IDS 9.30 on a virtualised HP-UX platform; "Checkpoint Stalled"

I'm taking from what I remember... The situation you describe matches what I remember. It was a problem on CREATE INDEX. That's probably why you see the "X" in the flags... It's in a critical section. It should be in/out instantaneously but due to a timing issue it never gets out. The checkpoint cannot complete while there is any thread in a critical section. That's why you see the checkpoint hang... This, and the other issue I had, can be considered a bug in Informix... question is, nearly no customer ever hit them on the "real thing", and it seems that on the virtual environment it's 100% of the time. I think one of them was solved in 9.x something... So it could help if you move to the latest fixpack/patch ever built for that version on PA-RISC. But I'd have to dig up some infomation to check this. As I mentioned I didn't follow up the situation to the end... I was overloaded at the time and a Spanish colleague took the situation. I can try to check. But in short, given these situations and the one I heard from Oracle it seems that the emulation is not like the real thing. I suppose you considered moving to a newer version on IA64? It's really a waste of technology to use IA64 to emulate old stuff (and trust me, I'm not a very big fan of IA64). If you have maintenance/support active, I think you could try to open a PMR. Explain that you're trying to move... I believe Support Pilot would apply to that situation and you could get the latest fixpack/patch for the old platform. It's possible that would help, but tech support should be able to find the bugs. That first one is pretty easy to match. The other one was not that easy I believe. Regards. On Mon, Feb 18, 2013 at 8:09 PM, malc_p <iiug@perrior.net> wrote: > > On 18/02/2013 19:47, Fernando Nunes wrote: > >> You mentioned an HP-UX virtualized environment... Do you mean an IA64 >> machine emulating an older PA-RISC architecture? >> If yes, it will probably not work properly... you may try to use just one >> CPU VP if you're not doing that already... But you'll most likely hit other >> issues... >> If all this matches up, I can dig a bit more information.... >> >> By the way, I know of customers trying more or less the same with Oracle >> and they also had problems... Apparently the emulation is a bit >> "different"... >> One thing you may try, is to disable all the optimizations introduced by >> the newer architecture... things like CPU cache, pre-fetch or whatever >> sounds similar... I had a situation similar to that one with a customer, >> but I haven't followed the situation trough the whole process... >> Regards. >> >> >> Yes, it is virtualized as you guess...hmm. > > I'll try going to single CPU VP, but that's going to be a problem when we > try to get the production system running as it really needs all the CPU we > can throw at it! > I'll speak to their tech admins about the emulation, but it's getting well > out of my comfort zone... > > Thanks > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...