Results 1 to 5 of 5

Thread: db2exfmt

  1. #1
    Join Date
    Nov 2007
    Posts
    26

    Unanswered: db2exfmt

    Hi all
    Please let me know difference between db2expln and db2exfmt

    i am unable to genate db2exfmt

    for particular query which is in text file

    I am passing query like this

    db2exfmt -d ODSQATDB -e DLVRY02 -g -n '/home/dba/db2odsq/Offshore/EODS_Queryplan/Line_Q1.sql' -s DLVRY02 -o '/home/dba/db2odsq/Offshore/EODS_Queryplan/Line_Q1.sql.out'

    it showing that no explainplan geneted for this database like that


    I am able to generate access plan by db2expln


    Thanks and regards
    Varaprasad

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    For db2exfmt, run the following SQL:

    explain plan set queryno = 1 for select * from your-table;

    where "select * from your-table" is the SQL you want explained. Then run db2exfmt.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Nov 2007
    Posts
    26
    Thanks for the replay
    i give like that

    it is giving

    Phrase?

    what should i give here

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Type in the following at the command line:

    db2exfmt -d ODSQATDB

    then for each prompt, hit the enter key (without typing a response). You will get the last SQL explained and stored in the explain tables. To get more than the last one, you will have to study the Command Reference manual to input the options you want.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Nov 2007
    Posts
    26
    Thankyou very much

Posting Permissions

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