News
Abstract
Visual Explain ability to drill into a UDTF
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Performance Enhancements > Visual Explain ability to drill into a UDTF
Visual Explain is enhanced to allow the database performance analyst to "drill down" into a User Defined Table Function (UDTF).
The statements display may include statements unrelated to the query execution being studied within Visual Explain. The UDTF library and program/service program name are used to extract active statements. This extraction will yield different results based upon whether the Visual Explain was launched from an SQL Performance Monitor, an SQE Plan Cache Snapshot or from the live SQE Plan Cache.
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Was this topic helpful?
Document Information
Modified date:
21 January 2020
UID
ibm11171120