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.
There’s good news from the IBM lab: IBM dashDB for Transactions now offers high availability plans, and offers “pay per use” plans that are billed by-the-day.
Understanding DB2 for LUW Buffer Pool I/O
You will get virtually no argument from anybody that buffer pool management is important to good DB2 and application performance. Large buffer pools are a well known wisdom. There are many ideas on buffer pool management, including the number of buffer pools