table identifier for db2ReadLog

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Doug - 23 Mar 2006 09:06 GMT

Gurus,

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

Doug

Reply to this Message

Knut Stolze - 23 Mar 2006 21:39 GMT

> Gurus,
>
[quoted text clipped - 3 lines]
> - 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).

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message

Doug - 23 Mar 2006 22:10 GMT

Thanks Knut :-)

Reply to this Message