stupid question re informix version
This is kind of stupid (so please don't flame me) 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. 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. 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? 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.
On Sat, 29 May 1999 00:03:56 -0500, Danny Wright <danwright@cmpmail.com> wrote: >This is kind of stupid (so please don't flame me) > > >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). Turbo didn't understand dirty read. It does support commit/rollback and begin work. >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. SQL-Turbo is old. > >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. No, Turbo was the predicessor to On-Line. Oh, and before you slam SCO, Informix runs better on it than it does on NT among others. We've no complaints from our customers running SCO. >I could be wrong, but I thought Standard Engine always used flat files >for DB storage Flat files? Yes, you're wrong. >I also though SE was so old, noone would even consider >it). Another incorrect statement. >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? No, you're running turbo. Sqlturbo gives it away. In the directory specified in the turbo config files in the INFORMIXDIR directory. >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... No, you should quit your job and dig ditches instead. > >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! Transactions? Turbo supports transactions. >The thiings you are (or at least just me) are too scared to ask when >you're new. Look at the manuals. You do have manuals, right?
In article <3751111b.4649217@nntpd.databasix.com>, Gary L. Burnore <gburnore@databasix.com> wrote: >>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. Well, the logs could be written anywhere, regardless of version. >>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? > >No, you're running turbo. Sqlturbo gives it away. In the directory >specified in the turbo config files in the INFORMIXDIR directory. Not necessarily -- sqlturbo was always the name of the separate backend process when there was such a thing, even in OnLine 4.X and 5.X. >>The thiings you are (or at least just me) are too scared to ask when >>you're new. > >Look at the manuals. You do have manuals, right? And even if you don't, you can get them on-line for free, so there's not much excuse for not RTFM in this situation. -- Alan Denney yosemite at accesscom.com I killed Einstein. I had to -- he knew too much.