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.


Syntax:

>>-onstat-- -g--prc--------------------------------------------><

Example output

Figure 1. 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

Output description

Number of lists: Number of lists in the UDR cache
PC_POOLSIZE: Number of entries that can be cached at one time
list: UDR cache hash chain ID (bucket number)
id: Unique ID of the routine
ref: Number of sessions that are currently accessing the UDR or SPL routine from the cache
drop: Whether the routine is marked to be dropped
hits: The number of times the cache entry is 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