Several questions ...

Hi, community Are you having a good day? I've several question about Informix: 1. Anyone know where I can find some information about #users and #licenses of Informix database product line(IDS, IDS with AD&XP options) vs. Oracle, DB2, MS SQL Server database products. In other words, what is the market position of Informix engine? 2. This question is about Informix instance's fast recovery mechanism. I know for each update operation, the affecting pages' before images are copied to physical log. But a. what is happening when I delete a table? Does Informix copy all the pages in that table to physical log as "before images"? I know this is not possible because when I execute the following lines: begin work; delete table xyz;(let's say it has 1 million rows) Table is deleted immediately!!! run $onstat -d and I see the increased size of dbsapce free space rollback work; The table is recoverd within seconds!!! So I'm sure it's not a real rollback row by row from logical log. What is happening then? b. What is happening when I insert a new row to a table? For an INSERT operation is there a 'before image'? If there is what is it? c. Is SELECT statement(single or cursor, inside or outside a transaction) ever involved in the fast recovery mechanism? Thanks Dong _______________________________________________________________ Get Free Email and Do More On The Web. Visit http://www.msn.com