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

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.

Thanks for the replay
i give like that

it is giving

Phrase?

what should i give here

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.

Thankyou very much