onstat -g prc command: Print sessions using UDR or SPL routines

Use the onstat -g prc command to display the number of sessions that are currently using the UDR or SPL routine.

Figure 1. Syntax:

Example output

Figure 2. onstat -g prc command output

UDR Cache: 
    Number of lists          : 31
    PC_POOLSIZE              : 127
     
UDR Cache Entries: 

list id   ref  drop hits      heap_ptr  udr name 
--------------------------------------------------------
0    80   0    0    702       4c589020  syscdr@amsterdam:.ifx_allow_newline
0    494  1    0    3         4c1e6820  syscdr@amsterdam:.compare
0    219  0    0    2         4bfd1020  syscdr@amsterdam:.streamread
0    297  0    0    8         4bb99020  syscdr@amsterdam:.ifx_checksum
0    134  0    0    10214     4bb5f020  syscdr@amsterdam:.destroy
0    232  0    0    34        4bd62820  syscdr@amsterdam:.cdrcmd
0    364  0    0    1         4c345020  syscdr@amsterdam:.rci_insert
0    180  0    0    1         4bcba020  syscdr@amsterdam:.gist_drop
0    91   0    0    9         4bd2e020  sysha@amsterdam:.rlt_open
0    500  0    0    76        4bb9f020  sysadmin@amsterdam:.admin
0    27   0    0    1478      4c0ec020  sysadmin@amsterdam:.destroy
...

    Total number of udr entries : 254
    Number of entries in use    : 9

UDR Cache: 
    Number of lists          : 31
    PC_POOLSIZE              : 127
     
UDR Cache Entries: 

list id   ref  drop hits       last_access          heap_ptr         udr_name
--------------------------------------------------------------------------------

0    79   0    0    1          2020-05-12 10:36:34  464a1c38         stores_demo@myserver:.proc1
0    46   0    0    10         2020-05-12 10:36:34  4dcba038         stores_demo@myserver:.proc2
0    376  0    0    1          2020-05-12 10:36:32  46303038         stores_demo@myserver:.proc3
0    363  0    0    1          2020-05-12 10:36:32  462f2c38         stores_demo@myserver:.proc4

    Total number of udr entries : 254
    Number of entries in use    : 9

UDR Cache: 
    Number of lists          : 31
    PC_POOLSIZE              : 127
    Number of entries        : 0
    Number of inuse entries  : 0

UDR Cache Entries: 
list#  id  ref_cnt   dropped?   heap_ptr     udr_name
--------------------------------------------------------------
UDR Cache is empty.

Output description

Number of lists: Number of lists in the UDR cache
PC_POOLSIZE: Number of entries that can be cached at one time
Number of entries: Number of entries in the UDR cache
Number of inuse entries: Number of entries that are being used
list
list#: UDR cache hash chain ID (bucket number)
id: Unique ID of the routine
ref
ref_cnt: Number of sessions that are currently accessing the UDR or SPL routine from the cache
drop
dropped?: Whether the routine is marked to be dropped
hits: The number of times the cache entry is accessed.
last_access: The time at which the cache entry was last accessed.
heap_ptr: Heap address that is used to store this entry
udr_name: The name of the UDR or SPL routine in the cache
Total number of udr entries: Number of entries in the cache
Number of entries in use: Number of entries that are being used