Investigating performance problems doesn’t have to be hard. There are some basic steps you can take to find common bottlenecks in your system – ‘performance first aid’ if you will. We’re going to look at some of these basic problems and how to find them, using monreport.dbsummary & friends.
Fast INSERT performance speeds the way to getting new data into DB2, for ETL, bulk ingest jobs, and even just day-to-day transactions. In this new blog entry, we look at several helpful tips for making INSERT run as quickly as possible.
This article is about DBI Software’s pureFeat™ Performance Management Suite for IBM DB2 LUW. For the past four consecutive years, Database Trends and Applications Magazine (DBTA) has honored DBI pureFeat as one of its Top 100 Trend Setting Products.
Statistics event monitors are an extremely useful way to get periodic monitoring of basic metrics on your system. They're just well-disguised behind a somewhat misleading name.
OVERHEAD and TRANSFERRATE are tablespace parameters that the optimizer uses to help choose an access plan. Are the defaults good enough? (hint: probably not) In this blog post, I describe a simple way to measure values for your system.