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

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