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 IC65827 Status: Geschlossen

SQLOKAANALYZE MESSAGE LOGGED AS "SEVERE" IN THE DB2DIAG.LOG
DURING DB2START

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
When starting up DB2 through db2start, a severe message might be 
logged in the db2diag.log file if DB2 is unable to obtain 
information about your system, such as the architecture of the 
system, the OS ID, etc, as well as support for various features, 
like NUMA, extended I/O, etc. This does not impact DB2's ability 
to correctly operate, and therefore, the message need not be 
treated as severe. The message in question looks similar to the 
following: 
 
2009-11-26-09.59.32.253126-300 E48379E269         LEVEL: Severe 
PID     : 3244                 TID  : 46912637991088PROC : 
db2star2 
INSTANCE: db2hia               NODE : 000 
FUNCTION: DB2 UDB, oper system services, sqloKAAnalyze, probe:10 
DATA #1 : Codepath, 8 bytes 
5 
 
After applying the fix for this APAR, the message will still be 
logged, but at a warning level.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* When starting up DB2 through db2start, a sqloKAAnalyze       * 
* message might be logged in the db2diag.log file, with a      * 
* severe level, if DB2 is unable to gather information         * 
* pertaining to the system. In actuality, this issue is        * 
* non-severe as it doesn't impact DB2's ability to function    * 
* correctly. The appearance of this message might erroneously  * 
* lead people to believe that DB2 has encountered a severe     * 
* problem when, in fact, no such problem exists.The            * 
* db2diag.log message in questions looks similar to the        * 
* following:                                                   * 
*                                                              * 
* 2009-11-26-09.59.32.253126-300 E48379E269                    * 
* LEVEL:Severe                                                 * 
* PID     : 3244                 TID  : 46912637991088PROC :   * 
* db2star2                                                     * 
* INSTANCE: db2hia               NODE : 000                    * 
* FUNCTION: DB2 UDB, oper system services,                     * 
* sqloKAAnalyze,probe:10                                       * 
* DATA #1 : Codepath, 8 bytes                                  * 
* 5                                                            * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* To resolve the problem, upgrade to DB2 Version 9.7 Fixpack   * 
* 2.                                                           * 
****************************************************************
Local-Fix:
Treat this message as you would a non-severe message.
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
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 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Problem was first fixed in Version 9.7 Fixpack 2. 
 
With the fix for this APAR, the sqloKAAnalyze message is logged 
 
 
as a warning: 
 
2009-11-26-09.59.32.253126-300 E48379E269   LEVEL: Warning 
 
PID : 3244    TID : 46912637991088PROC : 
db2star2 
INSTANCE: db2hia NODE : 000 
FUNCTION: DB2 UDB, oper system services, sqloKAAnalyze, 
 
 
probe:10 
DATA #1 : Codepath, 8 bytes 
 
 
5
Workaround
see LOCAL FIX
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
25.01.2010
25.05.2010
25.05.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.,
9.7.FP2
Problem behoben lt. FixList in der Version
9.7.0.2 FixList