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 | |
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 |