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.

09/21/06        Activity: I/O Operations by User by Table
13:41:38        09/21/06 09:36 to 09/21/06 09:37 (39 sec)

 Usr:Ten   Table       Reads            Updates          Creates     Deletes
   0: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 
   5:0         1           0                  0                 0         0 
   5:0         2           0                  0                 0         0 
   5:0         3           0                  0                 0         0 
   5:0         4           0                  0                 0         0 
   5:0         5           0                  0                 0         0 
   5:0         6           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
  • Table — The table number
  • Reads — The number of reads the user has performed on the table
  • Updates — The number of updates the user has performed on the table
  • Creates — The number of creates the user has performed on the table
  • Deletes — The number of deletes the user has performed on the table

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