Joe Geller discusses some favorite tuning tips for Db2 in this video recorded at IDUG EMEA in Lisbon last month.
This article starts a serial devoted to Db2 for z/OS System Profiles. Profiles are still not widely used and known while they represent a strong capability allowing to automatically tune the system. This introductory article discusses how you can define and activate a system profile.
There are a number of fairly important tuning tips that do not get much attention. In this article I will describe one of my favorites – Hash Joins.
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.