Re: stupid question re informix version

From: Danny Wright <danwright@cmpmail.com> > >This is kind of stupid (so please don't flame me) Well, it's not a repeated job ad or a advert for a product, so it's not *that* stupid. :-) >I recently switched jobs and don't understand what version of Informix >I'm running.... > >Out of habit I implemented a couple of scripts which I included "set >isolation to dirty read" (an unload and a count scipt) and I was >surprised to see these returned errors (apparently there is no support >for transactions the way it is set up). > >I also see sqlturbo's running, and notice that there is no >online????.log in the $INFORMIXDIR. This scares me.....I am used to >running Informix 7.24.UCsomething-or-other. Sounds like you're running OnLine 5.x >We're running on SCO-UNIX (which is scary enough), and performance is >very bad (I write that off to the kind of machine we're running on, and >the fact that Informix version seems to be outdated), it almost seems >like we're running Standard Engine, instead of Online. All your on* utilities will still work, they're just called tb* instead of on*. >I could be wrong, but I thought Standard Engine always used flat files >for DB storage (I also though SE was so old, noone would even consider >it). Anyway, unless SE has been upgraded to use raw disk space I think >we may be running it. Also where could the Informix logs be? Check $INFORMIXDIR/etc/tbconfig. >I know I should ask this of our DBA, and I'm wondering if I should have >even considered working under these conditions, but that's life and >where I find myself now... > >Of course I'm also asking why the hell our database doesn't support >transaction when there will obviously be multiple users on the system! >The thiings you are (or at least just me) are too scared to ask when >you're new. :-) It's not just you. Believe me! ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com