DB2 - Problem description
Problem IC65597 | Status: Closed |
POSSIBLE PERFORMANCE ISSUE RELATED TO TABLE QUEUE PERFORMANCE AND TABLE | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
In a DPF environment, and/or if INTRA_PARALLEL dbm cfg parameter is turned on, queries may involve multiple db2 agents to execute them. Sometimes, rows need to be sent and received on table queues, the mechanism for flowing rows between agents via FCM functionality. The logic for sending and receiving involves a flow control mechanism for regulating the flow of rows between senders and receivers. Part of this logic uses in internal timing delay which gets calculated dynamically. This fix will ensure the timing delay calculations are more accurate, which may improve performance with respect to table queues and table queue spilling. If snapshots are showing a lot of table queue spilling, this APAR might help reduce table queue spilling, depending on the situation. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * DPF and/or SMP * **************************************************************** * PROBLEM DESCRIPTION: * * POSSIBLE PERFORMANCE ISSUE RELATED TO TABLE QUEUE * * PERFORMANCE AND TABLE QUEUE SPILLING. * **************************************************************** * RECOMMENDATION: * * Upgrade to db2 v9.1 FP8 * **************************************************************** | |
Local Fix: | |
non | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Solution | |
First fixed in v9.1 FP8. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 15.01.2010 12.07.2010 12.07.2010 |
Problem solved at the following versions (IBM BugInfos) | |
9.1.FP8 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.2 |