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.
You may or may not have heard this rumor, “DB2 12 for z/OS is the last version”. Let me first of all reassure you DB2 is not going away. Quite the opposite.
Question: How do CPU shares work between super and sub classes?
Question: I am trying in to find the workload name being used by a connection in DB2 10.5? What's the easiest way to do this?
Tuning of SQL queries requires understanding why DB2 chose a particular access path and determining whether or not that access path should perform as expected. The key to this is understanding what filter factors are, how they are used by the Optimizer and how to get DB2 to better estimate them,