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.
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.