When our IBM Technology Expert Labs team was engaged by the client to determine the root cause of these system performance spikes, they found that the high CPU usage peaks were a result of multiple queries on the system using parallel processing.
The improper usage of Db2 SMP occurs when it’s enabled systemwide instead of selectively applying parallel processing to long-running queries and database operations in specific jobs. Read More
Get empowered with IBM Power
