Monitoring user-defined functions
You can monitor external user-defined functions by using the DISPLAY FUNCTION SPECIFIC command. This command displays statistics about the functions and lists the range of functions that are stopped because of a STOP FUNCTION SPECIFIC command.
About this task
This Db2 command displays statistics about external user-defined functions that are accessed by Db2 applications. This command displays one output line for each function that has been accessed by a Db2 application. Information returned by this command reflects a dynamic status. By the time Db2 displays the information, the status might have changed. Built-in functions or user-defined functions that are sourced on another function are not applicable to this command.
Procedure
To
monitor user-defined functions:
Example
For example, to display information about functions in the PAYROLL schema and the HRPROD schema, issue this command:
-DISPLAY FUNCTION SPECIFIC(PAYROLL.*,HRPROD.*)The following output is produced:
DSNX975I DSNX9DIS - DISPLAY FUNCTION SPECIFIC REPORT FOLLOWS-
------ SCHEMA=PAYROLL
FUNCTION STATUS ACTIVE QUED MAXQ TIMEOUT FAIL WLM_ENV
PAYRFNC1
STARTED 0 0 1 0 0 PAYROLL
PAYRFNC2
STOPQUE 0 5 5 3 0 PAYROLL
PAYRFNC3
STARTED 2 0 6 0 0 PAYROLL
USERFNC4
STOPREJ 0 0 1 0 1 SANDBOX
------ SCHEMA=HRPROD
FUNCTION STATUS ACTIVE QUED MAXQ TIMEOUT FAIL WLM_ENV
HRFNC1
STARTED 0 0 1 0 0 HRFUNCS
HRFNC2
STOPREJ 0 0 1 0 0 HRFUNCS
DSNX9DIS DISPLAY FUNCTION SPECIFIC REPORT COMPLETE
DSN9022I - DSNX9COM '-DISPLAY FUNC' NORMAL COMPLETION