The temporary buffer cache activity message displays information about the Temporary IQ Store buffer cache.
This line in the IQ message log (.iqmsg file) displays information about the Temporary IQ Store buffer cache:
Temporary I: L25240/P8 O: D4749/P0 C:D0
Item |
Description |
|---|---|
Temporary: I: L# |
Number of logical file reads. |
P# |
Number of physical file reads. |
O: D# |
Number of times a buffer was destroyed. |
P# |
Number of physical writes. |
C: D# |
Buffer manager data compression ratio. This is the total number of bytes eligible for compression minus number of bytes used after compression divided by total number of bytes eligible for compression times 100. In other words, it tells how much data was compressed (what percentage it is of its uncompressed size). The larger the number, the better. Only certain data blocks are eligible for compression. Eligible blocks include indexes, (90-95% of a database) and Sort sets. This reflects only data compression techniques used by the buffer manager. Other data compression may take place before data reaches the buffer manager, so the total data compression may be higher. |
In general, assuming the buffer cache is full, you should have between 10 and 1000 logical reads per physical read. A lower value indicates excessive thrashing in the buffer manager. More than 1000 times larger can indicate that you may be overallocating memory to your buffer cache.