DB2 Version 9.7 for Linux, UNIX, and Windows

SYSSTAT.ROUTINES catalog view

Each row represents a user-defined routine (scalar function, table function, sourced function, method, or procedure). Does not include built-in functions.

Table 1. SYSSTAT.ROUTINES Catalog View
Column Name Data Type Nullable Updatable Description
ROUTINESCHEMA VARCHAR (128)     Schema name of the routine if ROUTINEMODULENAME is null; otherwise schema name of the module to which the routine belongs.
ROUTINEMODULENAME VARCHAR (128)     Unqualified name of the module to which the routine belongs. The null value if not a module routine.
ROUTINENAME VARCHAR (128)     Unqualified name of the routine.
ROUTINETYPE CHAR (1)     Type of routine.
  • F = Function
  • M = Method
  • P = Procedure
SPECIFICNAME VARCHAR (128)     Name of the routine instance (might be system-generated).
IOS_PER_INVOC DOUBLE   Y Estimated number of inputs/outputs (I/Os) per invocation; 0 is the default; -1 if not known.
INSTS_PER_INVOC DOUBLE   Y Estimated number of instructions per invocation; 450 is the default; -1 if not known.
IOS_PER_ARGBYTE DOUBLE   Y Estimated number of I/Os per input argument byte; 0 is the default; -1 if not known.
INSTS_PER_ARGBYTE DOUBLE   Y Estimated number of instructions per input argument byte; 0 is the default; -1 if not known.
PERCENT_ARGBYTES SMALLINT   Y Estimated average percent of input argument bytes that the routine will actually read; 100 is the default; -1 if not known.
INITIAL_IOS DOUBLE   Y Estimated number of I/Os performed the first time that the routine is invoked; 0 is the default; -1 if not known.
INITIAL_INSTS DOUBLE   Y Estimated number of instructions executed the first time the routine is invoked; 0 is the default; -1 if not known.
CARDINALITY BIGINT   Y Predicted cardinality of a table function; -1 if not known, or if the routine is not a table function.
SELECTIVITY DOUBLE   Y For user-defined predicates; -1 if there are no user-defined predicates.