Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    Phoenix, AZ
    Posts
    42

    Unanswered: db2inspect question

    All,

    I was using the db2 utility db2inspect to identify those indexes that had not yet been converted from type 1 to type 2. After formatting the results, the results listed certain Object ID's (tables) that are referenced back to it's indexes.

    Does anyone know of a way to find out what the table name is based on an object id? I need to know the table name to re-launch the convert index script.

    Example of output:

    Table phase start (ID Signed: 4, Unsigned: 4; Tablespace ID: 0) :

    Data phase start. Object: 4 Tablespace: 0
    The index type is 2 for this table.
    DAT Object Summary: Total Pages 7 - Used Pages 7 - Free Space 13 %
    Data phase end.

    Thx

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Use the tablespaceid and tableid columns in the syscat.tables table to identify the table.

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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