Results 1 to 3 of 3

Thread: DB2 optimizer

  1. #1
    Join Date
    Feb 2002
    Location
    Hamilton
    Posts
    150

    Unanswered: DB2 optimizer

    We are running DB2 EEE V7.2 FP6 on AIX 5.1 on 2 servers with 3 nodes.

    We are trying to find out when a query will use table scans and or indexes to get it's result set back. Is there a way to see the access path taken by the query using native DB2 utilities? If so how?

    thanks in advance

    mark

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Mark,
    You can use EXPLAIN. Also you could use the Command Center, turn on the option to generate an access plan.

    HTH

    Andy

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

    Re: DB2 optimizer

    There are a couple of options :

    1) Visual Explain
    Explain output is in graphical format. USe Command Centre.
    2) db2expln
    Explains the contents of a package. Issued from OS command line
    3) dynexpln
    Explains dynamic statements. The input to the command is a set of SQL Statements.
    4) db2exfmt
    Formats the contents of the EXPLAIN Tables ... Text 'Equivalent' of visual explain ...


    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
  •