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