Contains a row for each userdefined function (scalar or aggregate).
Does not include builtin functions.
Table 98. SYSSTAT.FUNCTIONS Catalog View
Column Name  Data Type  Nullable  Description  Updatable 

FUNCSCHEMA  CHAR(8) 
 Qualified function name. 

FUNCNAME  VARCHAR(18) 

 
SPECIFICNAME  VARCHAR(18) 
 Function specific (instance) name. 

IOS_PER_INVOC  DOUBLE 
 Estimated number of I/Os per invocation; 1 if not known (0
default).
This column can only be updated with the following values:
 Yes 
INSTS_PER_INVOC  DOUBLE 
 Estimated number of instructions per invocation; 1 if not known (450
default).
This column can only be updated with the following values:
 Yes 
IOS_PER_ARGBYTE  DOUBLE 
 Estimated number of I/O's per input argument byte; 1 if not known
(0 default).
This column can only be updated with the following values:
 Yes 
INSTS_PER_ARGBYTE  DOUBLE 
 Estimated number of instructions per input argument byte; 1 if not known
(0 default).
This column can only be updated with the following values:
 Yes 
PERCENT_ARGBYTES  SMALLINT 
 Estimated average percent of input argument bytes that the function will
actually read; 1 if not known (100 default).
This column can only be updated with the following values:
 Yes 
INITIAL_IOS  DOUBLE 
 Estimated number of I/O's performed the first/last time the function
is invoked; 1 if not known (0 default).
This column can only be updated with the following values:
 Yes 
INITIAL_INSTS  DOUBLE 
 Estimated number of instructions executed the first/last time the
function is invoked; 1 if not known (0 default).
This column can only be updated with the following values:
 Yes 
CARDINALITY  INTEGER 
 The predicted cardinality of a table function. 1 if not known, or if function is not a table function.  Yes 