I/O Operations by User by Table

Displays I/O operations by user and by table.

PROMON I/O Operations by User by Table display

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

03/01/23        Activity: I/O Operations by User by Table
15:34:27        03/01/23 15:25 to 03/01/23 15:33 (7 min 42 sec)
 
  Usr:Ten    Table     Reads     Updates     Creates     Deletes    O/S Reads
 
    0            1         0           0           0           0            0 
    0            2         0           0           0           0            0 
    0            3         0           0           0           0            0 
    0            4         0           0           0           0            0 
    0            5         0           0           0           0            0 
    0            6         0           0           0           0            0 
    0            7         0           0           0           0            0 
    0            8         0           0           0           0            0 
    0            9         0           0           0           0            0 
    0           10         0           0           0           0            2 
    1            1         0           0           0           0            0 
    1            2        84           0           0           0            4 
    1            3         0           0           0           0            0 
    1            4         0           0           0           0            0 
    1            5         0           0           0           0            0 
    1            6         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 table
  • Creates — The number of create operations the user performed on the table
  • Deletes — The number of delete operations the user performed on the table
  • Splits — The number of split operations the user performed on the table
  • Block dels — The number of block deletes the user performed on the table
  • O/S Reads — The number of reads from disk that each user performed on the table

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