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.

Read syntax diagramSkip visual syntax diagram
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

Copyright© 2019 HCL Technologies Limited