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.

03/01/23        Activity: I/O Operations by User by Index
15:35:52        03/01/23 15:25 to 03/01/23 15:33 (7 min 42 sec)
 
  Usr:Ten  Index  Reads  Creates  Deletes  Splits  Block Dels  O/S Reads
 
    0         34      0        0        0       0           0          1 
    0         35      0        0        0       0           0          1 
    0         36      0        0        0       0           0          1 
    1          1    192        0        0       0           0          1 
    1          2      0        0        0       0           0          0 
    1          3      5        0        0       0           0          2 
    1          4     17        0        0       0           0          2 
    1          5     38        0        0       0           0          2 
    1          6     76        0        0       0           0          3 
    1          7      0        0        0       0           0          0 
    1          8      0        0        0       0           0          0 
    1          9      0        0        0       0           0          0 
    1         10      0        0        0       0           0          0 
    1         11      0        0        0       0           0          0 
    1         12     84        0        0       0           0          1 
    1         13      0        0        0       0           0          0 
    1         14      0        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 read operations the user performed on the index
  • Creates — The number of create operations the user performed on the index
  • Deletes — The number of delete operations the user performed on the index
  • Splits — The number of split operations the user performed on the index
  • Block dels — The number of block deletes the user performed on the index
  • O/S Reads — The number of reads from disk that each user performed on the index

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