Solution : https://service.sap.com/sap/support/notes/124268 (SAP Service marketplace login required)
Key words :
transaction st04 detail analysis menu -> db2-applications -> click, sql requestor transaction st05 -> list trace -> click, tp addtobuffer <expl-tr> <sapsid> u1 5, button 'index statistics' displays additional statistics values, tp import <expl-tr> <sapsid> u1 6, db2 bind $insthome/sqllib/bnd/db2exfmt, cd /usr/sap/trans/bin 4, db2db6 bind %db2path%\bnd\db2exfmt, /general/3rdparty/db2/db6_common/note, explain work process stops locks
Related Notes :
| 374757 | DB6: EXPLAIN - Field "SQLT_RECTYP_MEM" unknown |
| 373151 | DB6: SQL0104 when executing EXPLAIN |
| 372228 | DB2 UDB: runtime error PERFORM_NOT_FOUND with EXPLAIN |
| 300828 | DB6: DBA Cockpit and Remote Monitoring for Releases < 6.10 |
| 208797 | DB6: DB02 -> No EXPLAIN- and ADVISE tab in the dictionary |
| 158268 | Migration on DB2 version 6 |
| 156829 | DB6: DB2-Explain with db2exfmt |
| 139286 | DB6: Evaluation of accum. DBSL trace |
| 102200 | DB6: db2look: DDL and statistics information |