Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    64

    Answered: db2 LUW clustering index identify

    Hi,

    db2 Linux 10.5.

    In db2 z/OS there are two columns in catalog called clustering and clustered. Here clustering identifies the index on which you gave the "cluster" key word while creating the index. I don't see such a thing in db2 luw. In LUW all indexes in catalog have a cluster factor, which is fine, but how do we identify which index is the clustering index?

    Regards,
    xamar

  2. Best Answer
    Posted by db2mor

    "syscat.indexes.indextype (CLUS)"


  3. #2
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18
    syscat.indexes.indextype (CLUS)

  4. #3
    Join Date
    Apr 2004
    Posts
    64
    Thanks db2mor, I somehow missed seeing that column.

Posting Permissions

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