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. 


 07/14/17        Activity: I/O Operations by User by Lob
 15:42:10        07/14/17 15:42 to 07/14/17 15:42 (7 sec)
							
 Usr:Ten     Table   Lob     Reads   Updates    Creates    Deletes      
  24         11      8       0       0          1          0