Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170

    Unanswered: Type 2 Indexes in V8

    How to find which index is type1 and which is type2 in a v8 database that have been migrated from V7.
    I know when you migrate from v7 to v8 the indexes will not be converted from type1 to type2.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    You can use the INSPECT Command.

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

  3. #3
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170
    what tells an Index is Type 1 or Type2

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Did you try the inspect command ?

    The output very clearly will say, among other things, whether an index is type1 or type2 ?

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

  5. #5
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170
    Thank You.
    It worked !!
    But i think this process involves too much of effort.
    (1.Run Inspect
    2.Format the output)
    On mainframe you can query system catalogs to find out the index is Type1 or Type2.
    Iam trying to figure out similar way on UDB too

Posting Permissions

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