Re: stupid question re informix version

Danny >I recently switched jobs and don't understand what version of Informix >'m running.... To check the version of Informix, try onstat -V or tbstat -V. >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). Ask your DBA why transactions are not setup. He may have switched it off for some good reason, ie if your application is a datawarehouse type of application. To check this, run an onmonitor:status:databases, it will give you a list of databases with its logging mode. >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. Many installations move the online.log to a seperate larger directory. The path is given by MSGLOG in the onconfig file. >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? SE uses file-system files. I may be wrong, but AFAIK the format is C-ISAM. They are definitely not flat files. AFAIK, SE does not use raw-disk space. Although there have been some renewed interest in SE because of the free port of SE 7.24 on Linux among other things (It was judged the best database ported tor Linux in 1998, so lots of people including me are using it at home and I would imagine that some commercial apps that were previously running on the free PostgreSQL would have switched too). HTH Sujit