The I/O operations (reads, updates, creates, and deletes) on LOBs, sorted by user and by LOB, are viewable in PROMON. To see this information:

  1. Select Advanced options by entering R&D on the PROMON Main Menu.
  2. Select Other Displays by entering 3 on the R&D Main (Top) Menu.
  3. Select I/O Operations by User by Lob by entering 8 on the Other Displays Menu.

The following shows a sample of the output. 


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

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