Displaying function statistics
This procedure explains how to display function statistics.
Procedure
-
On the DB2 Administration Menu
(ADB2) panel, specify
Z, and press Enter.
The System Administration (ADB2Z) panel is displayed.
-
Specify option FM, and press Enter.
The Manage Functions (ADB2ZF) panel is displayed, as shown in the following figure.
Figure 1. Manage Functions (ADB2ZF) panel DB2 Admin -------------------- DD1A Manage Functions -------------------- 09:53 Option ===> DB2 System: DD1A 1 - Display/alter functions DB2 SQL ID: ADM001 2 - Create functions 3 - Display function statistics 4 - Start all functions 5 - Stop all functions 6 - Create view on SYSIBM.SYSROUTINES 7 - Display views on SYSIBM.SYSROUTINES Catalog table/view for option 1: Owner ===> SYSIBM (default is SYSIBM) Name ===> SYSROUTINES (default is SYSROUTINES) User defined functions can also be managed from option 1.F F1=HELP F2=SPLIT F3=END F4=RETURN F5=RFIND F6=RCHANGE F7=UP F8=DOWN F9=SWAP F10=LEFT F11=RIGHT F12=RETRIEVE
-
Specify option 3, and press Enter.
The Display Function Statistics (ADB2DB2O) panel, as shown in the following figure, is displayed. This panel displays statistics about external user-defined functions accessed by Db2 applications.
Figure 2. Display Function Statistics (ADB2DB2O) panel DB2 Admin ------- DD1A Browse DB2 Command Output --- Line 00000000 Col 001 080 Command ===> Scroll ===> PAGE -DIS FUNCTION SPEC(*.*) ********************************* Top of Data ********************************** DSNX975I DB2X DSNX9DIS DISPLAY FUNCTION SPECIFIC REPORT FOLLOWS - FUNCTION STATUS ACTIVE QUEUED MAXQUE TIMEOUT WLM_ENV APPL1 STARTED 1 0 0 0 PAYROLL APPL2 STARTED 1 0 0 0 PAYROLL APPL3 STARTED 0 1 2 0 PAYROLL APPL5 STOPREJ 0 0 0 0 SANDBOX APPL6 STOPABN 0 0 0 0 PAYROLL FUNC1 STOPQUE 0 0 0 0 SANDBOX DSNX9DIS DISPLAY FUNCTION SPECIFIC REPORT COMPLETE DSNX975I - DSNX9DIS DISPLAY FUNCTION SPECIFIC REPORT FOLLOWS - ******************************** Bottom of Data ********************************
When you press Enter, Db2 Admin Tool issues the -DIS FUNCTION SPEC(*.*) command.