Does "get statistics" meet your requirement? Get statistics for qid <qid> default; Get statistics for qid <qid> progress; Get statistics for qid <qid> accumulated.
-----Original Message----- From: liyun <[email protected]> Sent: Wednesday, August 22, 2018 10:24 PM To: [email protected]; [email protected] Subject: sql explain for formart detail Hi expert, I recently encountered SQL performance issues in my project. In Esgyndb, you can simply output the execution plan access , but this info doesn't help me see SQL performance issues. So please ask if you can provide some tools to format explain. ex: db2 database provide to use db2exfmt tool from package cache I would like to know some performance metrics, such as parsing time, physical reads, logical reads, sort overflows, and the cost of executing the plan selection path. Thanks pual
