This presentation from the IDUG EMEA 2016 will provide an overview of DB2 LUW statistics and the options to collect them, to help you achieve optimal query performance, with minimal administration effort.
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.
When Oracle bought Peoplesoft, Siebel, and JD Edwards, an opportunity arose for IBM and SAP to work together to provide a superior ERP offering. SAP sales representatives received compensation for selling DB2, and many large companies migrated from Oracle to DB2.
SAP and IBM have held joint develop
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.