Gurus,

Does the 'table identifier' (unsigned short, offset 4 in
DMSLogRecordHeader) relate to:
- tabname in syscat.tables
- tid in sysibm.systables
- something else?

Doug

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

Thanks Knut :-)