Developer develop script for db2 which is sometimes take huge load so need to take necessary action which is tuned the script. For tuning purpose DBA has to generate the execution plan to understand the load of script on server. [Both steps valid in db2] 

$db2 set current explain mode explain
$db2 –tvf <filename>.sql
$db2exfmt -1 –d <database name> –o db2exfmt.out
$ db2 set current explain mode no

$db2advis -d <database name> -i <filename>.sql –o output.out