|
Notes:
The IFCID 7 record now must be matched with the 6 record, and shows how many pages were actually read into the bufferpool by the read request. Synchronous I/O is obvious at one page. However, Sequential, LP, and Dynamic may physically read anywhere from one through 32 pages into the pool....only those pages in the requested range that were not in the pool.
The 6 & 7 records also contain the ACE (Application Control Element) that can be match to a user address space to determine the planname and/or authid. For prefetch, there are two ACEs involved, the actual requestor, and the ACE of the Database Manager Address Space.
|