|
Problem IC67356
|
Status: Closed |
IN DB2 V9.7 ON WINDOWS PLATFORM AFTER INSTANCE RECYCLE DB2START MESSAGE IN THE DB2DIAG.LOG DOES NOT PROVIDE MEMORY INFORMATION |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| 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. |
| Problem Summary: |
****************************************************************
* 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: |
|
| available fix packs: |
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
|
| Solution |
First fixed in V9.7 FP5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.03.2010
10.12.2011
10.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
