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