| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IC84016 | Status: Closed |
INCORRECT ERROR HANDLING CAUSES INCONSISTENT DPF STMM CONFIGURATIONS | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problem description: | |
When an STMM configuration update fails in DPF - other than a
bufferpool change - it may leave the configuration in an
inconsistent state across the partitions being tuned. For
example, an update to SHEAPTHRES_SHR, PCKCACHESZ, or LOCKLIST
may be successful on some partitions and be rolled back on
others. This can cause problems with subsequent STMM tuning
since the planning of tuning changes assumes all tuned
partitions are similar to the tuning partition. For example,
subsequent STMM tuning changes may consistently fail, preventing
STMM from adjusting to workload demands.
There are many db2diag.log entries when an STMM tuning failure
occurs in DPF, but the specific entry to look for is the
following, with an incorrect listing of "nodes that failed"
(these are the nodes where the tuning change actually succeeds):
2011-07-07-01.07.40.143255+120 I5749387A914 LEVEL: Error
PID : 5763200 TID : 3343 PROC : db2sysc
2
INSTANCE: udb500 NODE : 002 DB : SAMPLE
APPHDL : 2-51 APPID: *N2.DB2.110706225945
AUTHID : db2inst1
EDUID : 3343 EDUNAME: db2stmm (SAMPLE) 2
FUNCTION: DB2 UDB, config/install, sqlfPdbUpdDbCfgReq,
probe:1260
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : sqlcabc: 0 sqlcode: -5124 sqlerrml: 1
sqlerrmc: 1
sqlerrp :
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0x00000000 (6)
0x00000001
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
DATA #2 : String, 73 bytes
Number of failed nodes: 10
Nodes that failed: 3, 4, 5, 6, 7, and others.
The configuration on the tuned partitions can also be checked to
see whether the PCKCACHESZ, LOCKLIST, and SHEAPTHRES_SHR
settings are consistent. | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * DPF systems configured to use STMM tuning * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.7 Fix Pack 7 * **************************************************************** | |
| Local Fix: | |
manually adjust the configuration to correct any inconsistency | |
| available fix packs: | |
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows | |
| Solution | |
First fixed in DB2 Version 9.7 Fix Pack 7 | |
| Workaround | |
see Local Fix | |
| BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC84097 follow-up : | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 07.06.2012 06.11.2012 06.11.2012 |
| Problem solved at the following versions (IBM BugInfos) | |
9.7.FP7 | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 9.7.0.7 |
|