Displays information regarding I/O operations by user and by index.

PROMON I/O Operations by User by Index display

The following shows a sample I/O Operations by User by Index display.

Usr:Ten   Index     Reads      Creates     Deletes     Splits     Block Dels
  0:0        1          0            0           0          0              0 
  0:0        2          0            0           0          0              0 
  0:0        3          0            0           0          0              0 
  0:0        4          0            0           0          0              0 
  0:0        5          0            0           0          0              0 
  0:0        6          0            0           0          0              0 
  0:0        7          0            0           0          0              0 
  0:0        8          0            0           0          0              0 
  0:0        9          0            0           0          0              0 
  5:0        1          0            0           0          0              0 
  5:0        2          0            0           0          0              0 
  5:0        3          0            0           0          0              0 
  5:0        4          0            0           0          0              0 
  5:0        5          0            0           0          0              0 
  5:0        6          0            0           0          0              0 
  5:0        7          0            0           0          0              0 
  5:0        8          0            0           0          0              0 
  5:0        9          0            0           0          0              0
  6:ST       1          0            0           0          0              0 
  6:ST       2          0            0           0          0              0 
  6:ST       3          0            0           0          0              0 
  6:ST       4          0            0           0          0              0 
  6:ST       5          0            0           0          0              0 
  6:ST       6          0            0           0          0              0 
  6:ST       7          0            0           0          0              0 
  6:ST       8          0            0           0          0              0 
  6:ST       9          0            0           0          0              0 

Enter <return> for more, A, L, R, S, U, Z, P, T, or X (? for help):

This display shows the following information:

  • User:Ten — The user number and tenant
  • Index — The index number
  • Reads — The number of times read access has occurred to the index by the user
  • Creates — The number of times create access has occurred to the index by the user
  • Deletes — The number of times delete access has occurred to the index by the user
  • Splits — The number of split operations that have occurred to the index by the user
  • Block dels — The umber of block deletes that have occurred to the index by the user

By default, the display will show the user activity for up to 100 indexes. The monitored indexes are selected by the startup parameters -baseindex and -indexrange. See Database Startup Parameters for more information on these parameters.