IBM Support

QSYS2.SysProgramStmtStat catalog

News


Abstract

QSYS2.SysProgramStmtStat catalog

Content


In the tradition of providing DB2 for i statistical catalogs per object type, SQL statement level detail is available via a catalog.

The QSYS2/SYSPROGRAMSTMTSTAT view operates upon *PGM, *SRVPGM, and *MODULE object types, surfacing details about embedded SQL statements such as the number of executions and much more.

The SYSPROGRAMSTMTSTAT view contains one row for each embedded SQL statement in a program, module, or service program.

For more information, see the Knowledge Center: SYSPROGRAMSTMTSTAT

[{"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"}}]

Document Information

Modified date:
21 January 2020

UID

ibm11171180