DB2 - Problembeschreibung
Problem IC67356 | Status: Geschlossen |
IN DB2 V9.7 ON WINDOWS PLATFORM AFTER INSTANCE RECYCLE DB2START MESSAGE IN THE DB2DIAG.LOG DOES NOT PROVIDE MEMORY INFORMATION | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
In DB2 v9.7 on windows platform after instance recycle db2start message in the db2diag.log does not provide any memory information We get the following message after instance recycle 2010-01-12-20.22.29.062000+330 I1283H1555 LEVEL: Event PID : 4500 TID : 3580 PROC : db2start.exe INSTANCE: DB2_01 NODE : 000 EDUID : 3580 FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130 DATA #1 : String, 41 bytes C:\PROGRA~1\IBM\SQLLIB~1\bin\DB2STAR2.EXE DATA #2 : Hexdump, 256 bytes 0x00127634 : 433A 5C50 524F 4752 417E 315C 4942 4D5C C:\PROGRA~1\IBM\ 0x00127644 : 5351 4C4C 4942 7E31 5C62 696E 5C44 4232 SQLLIB~1\bin\DB2 0x00127654 : 5354 4152 322E 4558 4500 4E4F 4D53 4700 STAR2.EXE.NOMSG. On Unix platform we get the following message 2010-01-12-09.12.42.406922-360 E144589A1213 LEVEL: Event PID : 884762 TID : 1 PROC : db2star2 INSTANCE: ihubv97 NODE : 000 EDUID : 1 FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911 MESSAGE : ADM7513W Database manager has started. START : DB2 DBM DATA #1 : Build Level, 152 bytes Instance "ihubv97" uses "64" bits and DB2 code release "SQL09071" with level identifier "08020107". Informational tokens are "DB2 v9.7.0.1", "s090607", "AIX6497", Fix Pack "1". DATA #2 : System Info, 224 bytes System: AIX AIXHUB6 3 5 0007E4DED700 CPU: total:4 online:4 Threading degree per core:2 Physical Memory(MB): total:3920 free:837 Virtual Memory(MB): total:8016 free:4105 Swap Memory(MB): total:4096 free:3268 Kernel Params: msgMaxMessageSize:4194304 msgMaxQueueSize:4194304 shmMax:68719476736 shmMin:1 shmIDs:131072 shmSegments:68719476736 semIDs:131072 semNumPerID:65535 2010-01-12-09.12.41.395269-360 I144184A404 LEVEL: Info - As seen there is no memory related information on windows platform. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * DB2 V9.7 Windows OS * **************************************************************** * PROBLEM DESCRIPTION: * * In DB2 v9.7 on windows platform after instance recycle * * db2start * * message in the db2diag.log does not provide any memory * * * * information * * * * * * * * We get the following message after instance recycle * * * * * * * * 2010-01-12-20.22.29.062000+330 I1283H1555 LEVEL: * * Event * * * * * * PID : 4500 TID : 3580 PROC : * * * * db2start.exe * * * * INSTANCE: DB2_01 NODE : 000 * * * * * * * * EDUID : 3580 * * * * * * * * FUNCTION: DB2 UDB, base sys utilities, * * sqleStartStopSingleNode, * * * * * * probe:1130 * * * * * * * * DATA #1 : String, 41 bytes * * * * * * * * C:\PROGRA~1\IBM\SQLLIB~1\bin\DB2STAR2.EXE * * * * * * * * DATA #2 : Hexdump, 256 bytes * * * * * * * * 0x00127634 : 433A 5C50 524F 4752 417E 315C 4942 4D5C * * * * C:\PROGRA~1\IBM\ * * * * 0x00127644 : 5351 4C4C 4942 7E31 5C62 696E 5C44 4232 * * * * SQLLIB~1\bin\DB2 * * * * 0x00127654 : 5354 4152 322E 4558 4500 4E4F 4D53 4700 * * * * STAR2.EXE.NOMSG. * * * * * * * * On Unix platform we get the following message * * * * * * * * 2010-01-12-09.12.42.406922-360 E144589A1213 LEVEL: * * Event * * * * * * PID : 884762 TID : 1 PROC : * * db2star2 * * * * INSTANCE: ihubv97 NODE : 000 * * * * * * * * EDUID : 1 * * * * * * * * FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, * * probe:911 * * * * * * MESSAGE : ADM7513W Database manager has started. * * * * * * * * START : DB2 DBM * * * * * * * * DATA #1 : Build Level, 152 bytes * * * * * * * * Instance "ihubv97" uses "64" bits and DB2 code release * * * * "SQL09071" * * * * with level identifier "08020107". * * * * * * * * Informational tokens are "DB2 v9.7.0.1", "s090607", * * "AIX6497", * * Fix Pack * * * * "1". * * * * * * * * DATA #2 : System Info, 224 bytes * * * * * * * * System: AIX AIXHUB6 3 5 0007E4DED700 * * * * * * * * CPU: total:4 online:4 Threading degree per core:2 * * * * * * * * Physical Memory(MB): total:3920 free:837 * * * * * * * * Virtual Memory(MB): total:8016 free:4105 * * * * * * * * Swap Memory(MB): total:4096 free:3268 * * * * * * * * Kernel Params: msgMaxMessageSize:4194304 * * * * msgMaxQueueSize:4194304 * * * * shmMax:68719476736 shmMin:1 shmIDs:131072 * * * * * * * * shmSegments:68719476736 semIDs:131072 * * * * semNumPerID:65535 * * * * 2010-01-12-09.12.41.395269-360 I144184A404 LEVEL: * * Info * * * * * * * * * * - As seen there is no memory related information on windows * * * * platform. * **************************************************************** * RECOMMENDATION: * * Upgrade to V9.7 FP5 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in V9.7 FP5 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 22.03.2010 10.12.2011 10.12.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP5 | |
Problem behoben lt. FixList in der Version | |
9.7.0.5 |