467,179 Members | 1,269 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,179 developers. It's quick & easy.

table identifier for db2ReadLog

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
  • viewed: 1824
Share:
2 Replies
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
Thanks Knut :-)

Mar 23 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Ville Rontti | last post: by
5 posts views Thread by joshua.nicholes@gmail.com | last post: by
3 posts views Thread by chandra.krothapalli@gmail.com | last post: by
9 posts views Thread by Miro | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.