Previous Topic: SQL_MISC_STATS (SQM)Next Topic: SQL_SQLCODES (SQQ)


SQL_PROC_DETAIL (SQZ)

This table lists the procedure activity since MUF startup.

Column Name

SQL Data Type

Nullable

Description

EXEC_SECONDS

 

INTEGER

No

The number of seconds of execution, rounded up to the next second.

MUF_NAME

 

CHAR(8)

No

Logical name for this MUF.

PROC_NAME

CHAR(8)

No

Shows the procedure name.

PROC_STARTS

INTEGER

No

Shows the procedure starts.

PROC_TCB_FAILURES

INTEGER

No

Shows the procedure failures.

SQL_STATEMENTS

INTEGER

No

Shows the SQL statements.