DB2 view execution plan

DB2 view execution plan

In DB2, it is not convenient to view the SQL Execution Plan for other databases. Several steps are required. Here I organize the steps into shell scripts for ease of use, as shown below:

#! /Bin/sh
 
Db2 connect to <db>
Db2-tvf $ HOME/sqllib/misc/EXPLAIN. DDL
Db2 set current explain mode explain
 
Db2"
<SQL>
"
 
Db2 set current explain mode no
 
Db2exfmt-d <db>-g TIC-w-l-s %-n %-o explain. out

Replace db and SQL in the script.

This article permanently updates the link address: