News
Abstract
QSYS2.SysPackageStmtStat catalog
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Performance Enhancements > QSYS2.SysPackageStmtStat catalog
In the tradition of providing Db2 for i statistical catalogs per object type, SQL statement level detail is available via a catalog.
The QSYS2/SYSPACKAGESTMTSTAT operates upon *SQLPKG object types, surfacing details about prepared SQL statements such as the number of executions and much more.
[{"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
ibm11171174