http://www.informixfaq.com/wiki/ 2009-01-06T15:26:17-06:00 http://www.informixfaq.com/wiki/ http://www.informixfaq.com/wiki/lib/images/favicon.ico text/html 2008-09-26T11:37:38-06:00 Wiki FAQ http://www.informixfaq.com/wiki/doku.php/wiki:trouble?rev=1222447058&do=diff What status codes does onstat return? You can check the current mode of IDS by checking the status ($?) after onstat -. The values returned by 'onstat -' are: -1/255 Offline 0 Initialisation 1 Quiescent 2 Recovery 3 Backup 4 Shutdown 5 Online 6 Abort How can we see what's happening during a checkpoint? Versions 9.40 and later support the environment variable TRACECKPT text/html 2008-09-26T11:34:54-06:00 Wiki FAQ http://www.informixfaq.com/wiki/doku.php/wiki:howto?rev=1222446894&do=diff What is currently installed Check out the $INFORMIXDIR/etc/*cr files, this will list the various products and versions. The $INFORMIXDIR/etc/.snfile will also give you the installation order Tell if the Engine is offline command: onstat -u INFORMIX-OnLine Version 7.14.UD2 -- On-Line -- Up 00:18:03 -- 147744 Kbytes If the words 'On-Line' do not appear in the returned line then there could be a problem. Check the log directly if the engine isn't running, otherwise use onstat -m If the engin… text/html 2008-09-26T10:58:50-06:00 Wiki FAQ http://www.informixfaq.com/wiki/doku.php/wiki:pcs?rev=1222444730&do=diff Run the ilogin program, select file/run and OK. This uses the defaiult values held in the registry that are configured via Setnet32. If the PC is configured correctly then the message 'Storesxxx not found' should appear. No errors at this point implies that the Informix products are installed correctly and the database is there. If you get a -461 then you haven't got an esql runtime on the server, this is not a problem. text/html 2008-09-26T10:34:08-06:00 Wiki FAQ http://www.informixfaq.com/wiki/doku.php/wiki:locking?rev=1222443248&do=diff User stuck in transaction If a user remains within a transaction for a considerable period and locks critical areas of the database this could indicate * Poor application design * Incorrect 'lock mode' selected. Command: onstat -u onstat -u