home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC84016 Status: Geschlossen

INCORRECT ERROR HANDLING CAUSES INCONSISTENT DPF STMM CONFIGURATIONS

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* 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
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
First fixed in DB2 Version 9.7 Fix Pack 7
Workaround
see Local Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC84097 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
07.06.2012
06.11.2012
06.11.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP7
Problem behoben lt. FixList in der Version
9.7.0.7 FixList