Hugo Killian 11.Jan.08 10:40 AM a Web browser DB2 Learning Management System - 1.0.x pSeries (AIX)
After analyzing the results of a DB2 monitoring on the LMM database during a period of time of 2 hours on a LMS Production Platform in a large company, I can concluded that are tree tables that have excessive “rows read” compared to the operations made on that same tables.
The tables “ATTEMPT”, “USER_OBJECTIVE” and “PROGRESS” have excessive “rows read” in a short period of time ( 2 hours ).
I want to know if these results are a normal or there is some problem with the LMS 1.0.5sp5 related to db2 usage.
Note: The reorganization of the tables, using the “reorgchk” and “reorg” tools, are made weekly and the statistics are made daily. Most of all performance tunings, recommended by IBM, are implemented on this LMS platform.