Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Milan, Italy

    Unanswered: DB2 Index Advisor

    Well folks,
    strange things happen in my DB2 for Linux and Windows boxes.

    I've created a simple SQL workload, made of 5 SQL statements, just to test the tool.
    Well, the advisor doesn't recommend any index, it just goes blank.

    The funny thing is that the equivalent command line tool, db2advis, works wery well;

    this is the syntax I used:

    db2advis -d MYDBNAME -w WKLNAME -o DDLFILE.TXT

    The workload WKLNAME is the SAME I created via the GUI advisor !

    So, it DOES recommend indexes, it says how much I will gain in performance percentage, then, last but not least, it create the DDL job containing the CREATE INDEX statements.

    Very nice indeed.

    So, in your opinion, what can be wrong with the GUI advisor ?

    Thanks in advance. Bye.

  2. #2
    Join Date
    Nov 2002
    I use the index advisor alot, but as a DBA, I don't rely 100% on it. I have found times that I have thought of the index the way I want to create it but the advisor has said something else. I then found out through testing that my way showed a better performace improvement(and vice versa) . So I wouldn't rely 100% on it, its a tool and like all tools, its not going to be perfect, just like us humans.

  3. #3
    Join Date
    Jan 2003
    Hi wasowsky,

    I think there is a problem if <enter>, <tab> or any other unusual character is used. Try do remove all that kind of characters and try again.

    Hope this helps,

  4. #4
    Join Date
    Aug 2001
    quigleyd is right ... Index advisor doesn't always give the correct indexes,in particular, the performance imporvement projection ...

    I normally test with the indexes i think is useful and also the indexes suggested by the advisor ... Whichever gives better performance, I take that one ....

    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