ROWID functionality

Posted in 2005

Topics: Performance & Tuning, Storage & Space Management, Transactions, Locking & Isolation, Logging & Checkpoints

venkateswarag@gmail.com — 29 Aug 2005 14:35:14 -0700 — source: Usenet: comp.databases.informix

Hi, I am trying to fetch information of all records updated/inserted/deleted in the Informix data base tables since the last back up. I am trying to use the logical log files - transaction log file. I am trying to get the Rowid of the updated/inserted/deleted record of the tblspace from the logical log records. Later I am using the Systables to get the table name using partnum(tblspace ID). I have the following questions - - can I use the rowid (which I fetch from transaction log) to get the impacted row from the table (table name fetched from systables table using tblspace ID)? - Will this affect the performance if avg size of DB is 50 GB and daily load is 1MB? - Can the uniqueness of Rowid be trusted. Please help me out. Thanks

↪ replying to venkateswarag@gmail.com

david@smooth1.co.uk — 30 Aug 2005 12:19:34 -0700 — source: Usenet: comp.databases.informix

rowid is not unique for fragmented tables. but then maybe the logical log record will include the fragment id for fragmented tables?

Glossary

logical log