Preventing the Collection of Timestamps
The collection of timestamp data is an expensive monitoring operation. This is especially the case when the collection of a timestamp occurs for a common database operation (e.g., the start or completion of a unit of work).
To control the collection of timestamp monitor data, you can use the TIMESTAMP monitor switch. Setting the TIMESTAMP switch to OFF (it is ON by default) instructs the database manager to skip any timestamp operating system calls when computing time or timestamp-related monitor elements. Turning this switch OFF becomes important when CPU utilization approaches 100%. When this occurs, the performance degradation caused by issuing timestamps increases dramatically.
Unlike all the other ...
Get DB2® Version 8: The Official Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
