Displaying function statistics

This procedure explains how to display function statistics.

1. On the DB2 Administration Menu (ADB2) panel, specify Z, and press Enter.
   The System Administration (ADB2Z) panel is displayed.
2. Specify option FM, and press Enter.
   The Manage Functions (ADB2ZF) panel is displayed, as shown in the following figure.

    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  

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

    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.