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,
In this article we are going to examine some tuning options that a DBA has available to help improve dynamic SQL performance on DB2 LUW.