Results 1 to 5 of 5

Thread: Table ID

  1. #1
    Join Date
    Nov 2002
    Location
    Rio de Janeiro - Brazil
    Posts
    78

    Unanswered: Table ID

    Heys

    Is there any unique identifier for tables, other than TabSchema.TabName, that the DB2 uses/create??
    If so, how can I get that id? Iīve gone through the catalogue tables and havenīt found naught.

    TIA
    Fernando

  2. #2
    Join Date
    Feb 2003
    Posts
    22
    Use BDID and OBID. You can find it in sysibm.systables and sysibm.systablespace.
    Read with care what these value mean, because they are not obvious!
    Cristiana
    Data Base Administrator
    Bologna
    Italy

  3. #3
    Join Date
    Nov 2002
    Location
    Rio de Janeiro - Brazil
    Posts
    78
    Thanks,

    About BDID and OBID, I didnīt find much.
    Iīm sorry, but I forgot to place the info about my environment.
    Iīm running DB2 V7.2 on AIX 4.3.3

    About the OBID, I found only a note at the glossary saying that, in DB2 UDB for OS/390, it is the data object identifier.
    I didnīt find anything about BDID.

    But reading carefully the catalog once again I found on the syscat.tables one row for the TABLEID, that I might have skipped before.

    Fernando.

    Originally posted by chris72
    Use BDID and OBID. You can find it in sysibm.systables and sysibm.systablespace.
    Read with care what these value mean, because they are not obvious!

  4. #4
    Join Date
    Jul 2003
    Posts
    2

    unique identify table

    Hi Fernando,

    to identify the table you can use TBSPACEID in combination with TABLE_ID.

    OBID and BDID don't exist in DB2 UDB V7 on AIX.

    I hope this will help you.

    Doreen

  5. #5
    Join Date
    Jul 2003
    Posts
    2

    Re: unique identify table

    Hi,


    I forgot this that this is only possible in system tables (f.e. SYSCAT.TABLES).

    To have an other identification you can create nicknames for this table.

    Doreen

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •