Doug wrote:
Gurus,
Does the 'table identifier' (unsigned short, offset 4 in
DMSLogRecordHeader) relate to:
- tabname in syscat.tables
- tid in sysibm.systables
- something else?
The 2nd option is correct. But you should never use the tables in the
SYSIBM schema, so stick with:
SYSCAT.TABLES.TABLEID
It can't be the table name because (a) that would make log records longer
than necessary (= more writes = higher performance impact = not
acceptable), and (b) it is just a "unsigned short" and, thus, only 2 bytes
long (not enough to fit a name in).
--
Knut Stolze
DB2 Information Integration Development
IBM Germany