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.
| 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.
|
||
| 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. |