By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,851 Members | 1,729 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,851 IT Pros & Developers. It's quick & easy.

table identifier for db2ReadLog

P: n/a
Gurus,

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

Doug

Mar 23 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Mar 23 '06 #2

P: n/a
Thanks Knut :-)

Mar 23 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.