SEO

#1 (**permalink**) 04-20-2008, 09:06 AM

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

#2 (**permalink**) 04-20-2008, 09:06 AM

rowid is not unique for fragmented tables.

but then maybe the logical log record will include the fragment id for
fragmented tables?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

ROWID functionality