db2 explain format command example

Put your query on a file query.sql like this:

set current explain mode yes;
your query here; 
set current explain mode no;

Then run:

db2batch -d DBNAME -f query.sql -i complete -ISO CS | tee /tmp/output_batch.txt

db2exfmt -d DBNAME -1 -o /tmp/output_exfmt.txt