kfogarty.com – Database Consultants

Website of Kenny Fogarty. An independent database consultant, based in London, England.

Statistics Trace

Filed under: DB2, Traces — Kenny at 6:05 am on Monday, September 18, 2006

Information pertaining to the entire DB2 subsystem is recorded in statistics trace records. This information is particularly useful for measuring the activity and response of DB2 as a whole. Information on the utilization and status of the bufferpools, DB2 locking, DB2 logging, and DB2 storage is accumulated.

Estimated overhead: An average of 2 percent CPU overhead per transaction.

Sphere: Related Content

No Comments

No comments yet.

RSS feed for comments on this post.

Sorry, the comment form is closed at this time.