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.
As guest blogger, Russ Stocker shares useful tips on DB2 Large Object (LOB) performance. Part 1: Inlining
In February 2016 the DB2 12 Editorial Committee was formed, comprised of volunteers from IDUG’s worldwide community of DB2 users and consultants. This White Paper contains their findings, including practical experiences and independent evaluations of the new features.
The purpose of this article is to decode the DB2 backup and restore performance statistics that are now logged in the db2diag.log. It will also discuss some factors that influence backup performance and how the performance stats can be used to identify where performance bottlenecks exist.
Performance problems can be tough to solve, especially if you've not had to deal with them much before. In this session from IDUG NA 2016, Steve Rees goes through a step-by-step, decision tree-based approach for tackling performance problems.