Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    1

    Unanswered: determine UDB index type (1 or 2)

    Any ideas on how to determine whether an UDB 8 index is a type 1 or type 2 index?

    Thanks...

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: determine UDB index type (1 or 2)

    Use the INSPECT Command

    INSPECT CHECK TABLE EMPLOYEE INDEX NORMAL RESULTS KEEP INSP_EMP

    This file will be created in the DIAGPATH (the dbm cfg parameter)

    You will have to format the above file using

    db2inspf INSP_EMP INSP_EMP_FMT.txt

    The formatted output will say the type of index ...

    HTH

    Sathyaram


    Originally posted by mjm2386
    Any ideas on how to determine whether an UDB 8 index is a type 1 or type 2 index?

    Thanks...
    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
  •