Hello,
i currently setup a new machine with DB2 8.x ESE FP8 .
The machine is a HP Proliant ML570, 14 GB RAM, 4xXeon 3.0 GHZ....
Windows 2003 Enterprise (booted with /3GB and /PAE).
DB2 is using AWE:
DB2_AWE=1,330000,40000
Now i had this error for one time:
2005-02-10-16.20.24.687000+060 E239924H478 LEVEL: Warning
PID : 2532 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : BALFI
APPHDL : 0-46 APPID: 0E16B823.2104.050210150936
FUNCTION: DB2 UDB, buffer pool services, sqlbAllocateAWEMem, probe:80
MESSAGE : ADM6068I The buffer pool "IBMDEFAULTBP" (ID "1") is using
AWE.
Physical size is "330000". Window size is "40000".
2005-02-10-16.21.12.234000+060 E240404H478 LEVEL: Warning
PID : 2532 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : BALFI
APPHDL : 0-47 APPID: 0E16B823.3104.050210152111
FUNCTION: DB2 UDB, buffer pool services, sqlbAllocateAWEMem, probe:80
MESSAGE : ADM6068I The buffer pool "IBMDEFAULTBP" (ID "1") is using
AWE.
Physical size is "330000". Window size is "40000".
2005-02-10-16.21.14.281000+060 E240884H493 LEVEL: Error (OS)
PID : 2532 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : BALFI
APPHDL : 0-47 APPID: 0E16B823.3104.050210152111
FUNCTION: DB2 UDB, oper system services, sqloVLMDetachVLMSegment,
probe:60
CALLED : OS, -, unspecified_system_function OSERR: 487
RETCODE : ECF=0x9000000A=-1879048182=ECF_INVALID_ADDRESS
Invalid address
2005-02-10-16.21.14.312000+060 I241379H485 LEVEL: Severe
PID : 2532 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : BALFI
APPHDL : 0-47 APPID: 0E16B823.3104.050210152111
FUNCTION: DB2 UDB, oper system services, sqloVLMDetachVLMSegment,
probe:60
MESSAGE : sqloVLMDetachVLMSegment: Unexpected Error
DATA #1 : Hexdump, 4 bytes
0x0FD23C3C : E701 0083 ....
2005-02-10-16.21.14.312000+060 I241866H460 LEVEL: Severe
PID : 2532 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : BALFI
APPHDL : 0-47 APPID: 0E16B823.3104.050210152111
FUNCTION: DB2 UDB, buffer pool services, sqlbUnmapBPDsForAWE, probe:10
MESSAGE : Detach Failed, rc =
DATA #1 : Hexdump, 4 bytes
0x0FD23C58 : E701 0083 ....
2005-02-10-16.21.14.328000+060 I242328H456 LEVEL: Severe
PID : 2532 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : BALFI
APPHDL : 0-47 APPID: 0E16B823.3104.050210152111
FUNCTION: DB2 UDB, buffer pool services, sqlbUnmapBPDsForAWE, probe:20
MESSAGE : bufferpool ID =
DATA #1 : Hexdump, 4 bytes
0x11328D00 : 0100 0000 ....
2005-02-10-16.21.14.328000+060 I242786H907 LEVEL: Severe
PID : 2532 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : BALFI
APPHDL : 0-47 APPID: 0E16B823.3104.050210152111
FUNCTION: DB2 UDB, buffer pool services, sqlbUnmapBPDsForAWE, probe:30
MESSAGE : curBPD =
DATA #1 : Hexdump, 112 bytes
0x0F611CE0 : 0000 0000 FFFF 0000 0000 0000 0000 0000
.................
0x0F611CF0 : 0000 0000 FFFF FFFF 0000 0000 0000 0000
.................
0x0F611D00 : 0000 0000 0000 0000 0000 0700 0000 0000
.................
0x0F611D10 : 0000 0002 0000 0000 0000 0000 0000 0002
.................
0x0F611D20 : 0000 0000 0000 0000 0020 040C 0000 0000 .........
.......
0x0F611D30 : 0000 0000 0000 0000 E015 610F E023 610F
...........a..#a.
0x0F611D40 : 0000 0000 528D 0000 0000 00C0 0000 0000
.....R...........
2005-02-10-16.21.14.343000+060 I243695H455 LEVEL: Severe
PID : 2532 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : BALFI
APPHDL : 0-47 APPID: 0E16B823.3104.050210152111
FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10
MESSAGE : sqle_panic: Panic/sleep =
DATA #1 : Hexdump, 4 bytes
0x00B20148 : 0000 0000 ....
2005-02-10-16.21.14.343000+060 I244152H446 LEVEL: Severe
PID : 2532 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : BALFI
APPHDL : 0-47 APPID: 0E16B823.3104.050210152111
FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:5
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x0FD23694 : 0000 0000 ....
2005-02-10-16.21.14.343000+060 I244600H492 LEVEL: Warning
PID : 2532 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : BALFI
APPHDL : 0-47 APPID: 0E16B823.3104.050210152111
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x0FD23560 : 0000 0000 ....
2005-02-10-16.21.14.421000+060 I245094H469 LEVEL: Severe
PID : 2532 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : BALFI
APPHDL : 0-47 APPID: 0E16B823.3104.050210152111
FUNCTION: DB2 UDB, SQO Memory Management, sqlofpol, probe:1030
MESSAGE : sqloGetMemChunks not explicitly freed.
DATA #1 : Hexdump, 4 bytes
0x0FD234E4 : 0100 0000 ....
2005-02-10-16.21.14.421000+060 I245565H469 LEVEL: Severe
PID : 2532 TID : 2792 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : BALFI
APPHDL : 0-47 APPID: 0E16B823.3104.050210152111
FUNCTION: DB2 UDB, SQO Memory Management, sqlofpol, probe:1030
MESSAGE : sqloGetMemChunks not explicitly freed.
DATA #1 : Hexdump, 4 bytes
0x0FD234E4 : 0100 0000 ....
Any idea ? 1 3380
Open a PMR.
<za*****@gmx.de> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com... Hello,
i currently setup a new machine with DB2 8.x ESE FP8 . The machine is a HP Proliant ML570, 14 GB RAM, 4xXeon 3.0 GHZ.... Windows 2003 Enterprise (booted with /3GB and /PAE).
DB2 is using AWE:
DB2_AWE=1,330000,40000
Now i had this error for one time:
2005-02-10-16.20.24.687000+060 E239924H478 LEVEL: Warning PID : 2532 TID : 2792 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : BALFI APPHDL : 0-46 APPID: 0E16B823.2104.050210150936 FUNCTION: DB2 UDB, buffer pool services, sqlbAllocateAWEMem, probe:80 MESSAGE : ADM6068I The buffer pool "IBMDEFAULTBP" (ID "1") is using AWE. Physical size is "330000". Window size is "40000".
2005-02-10-16.21.12.234000+060 E240404H478 LEVEL: Warning PID : 2532 TID : 2792 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : BALFI APPHDL : 0-47 APPID: 0E16B823.3104.050210152111 FUNCTION: DB2 UDB, buffer pool services, sqlbAllocateAWEMem, probe:80 MESSAGE : ADM6068I The buffer pool "IBMDEFAULTBP" (ID "1") is using AWE. Physical size is "330000". Window size is "40000".
2005-02-10-16.21.14.281000+060 E240884H493 LEVEL: Error (OS) PID : 2532 TID : 2792 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : BALFI APPHDL : 0-47 APPID: 0E16B823.3104.050210152111 FUNCTION: DB2 UDB, oper system services, sqloVLMDetachVLMSegment, probe:60 CALLED : OS, -, unspecified_system_function OSERR: 487 RETCODE : ECF=0x9000000A=-1879048182=ECF_INVALID_ADDRESS Invalid address
2005-02-10-16.21.14.312000+060 I241379H485 LEVEL: Severe PID : 2532 TID : 2792 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : BALFI APPHDL : 0-47 APPID: 0E16B823.3104.050210152111 FUNCTION: DB2 UDB, oper system services, sqloVLMDetachVLMSegment, probe:60 MESSAGE : sqloVLMDetachVLMSegment: Unexpected Error DATA #1 : Hexdump, 4 bytes 0x0FD23C3C : E701 0083 ....
2005-02-10-16.21.14.312000+060 I241866H460 LEVEL: Severe PID : 2532 TID : 2792 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : BALFI APPHDL : 0-47 APPID: 0E16B823.3104.050210152111 FUNCTION: DB2 UDB, buffer pool services, sqlbUnmapBPDsForAWE, probe:10 MESSAGE : Detach Failed, rc = DATA #1 : Hexdump, 4 bytes 0x0FD23C58 : E701 0083 ....
2005-02-10-16.21.14.328000+060 I242328H456 LEVEL: Severe PID : 2532 TID : 2792 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : BALFI APPHDL : 0-47 APPID: 0E16B823.3104.050210152111 FUNCTION: DB2 UDB, buffer pool services, sqlbUnmapBPDsForAWE, probe:20 MESSAGE : bufferpool ID = DATA #1 : Hexdump, 4 bytes 0x11328D00 : 0100 0000 ....
2005-02-10-16.21.14.328000+060 I242786H907 LEVEL: Severe PID : 2532 TID : 2792 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : BALFI APPHDL : 0-47 APPID: 0E16B823.3104.050210152111 FUNCTION: DB2 UDB, buffer pool services, sqlbUnmapBPDsForAWE, probe:30 MESSAGE : curBPD = DATA #1 : Hexdump, 112 bytes 0x0F611CE0 : 0000 0000 FFFF 0000 0000 0000 0000 0000 ................ 0x0F611CF0 : 0000 0000 FFFF FFFF 0000 0000 0000 0000 ................ 0x0F611D00 : 0000 0000 0000 0000 0000 0700 0000 0000 ................ 0x0F611D10 : 0000 0002 0000 0000 0000 0000 0000 0002 ................ 0x0F611D20 : 0000 0000 0000 0000 0020 040C 0000 0000 ......... ...... 0x0F611D30 : 0000 0000 0000 0000 E015 610F E023 610F ..........a..#a. 0x0F611D40 : 0000 0000 528D 0000 0000 00C0 0000 0000 ....R...........
2005-02-10-16.21.14.343000+060 I243695H455 LEVEL: Severe PID : 2532 TID : 2792 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : BALFI APPHDL : 0-47 APPID: 0E16B823.3104.050210152111 FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10 MESSAGE : sqle_panic: Panic/sleep = DATA #1 : Hexdump, 4 bytes 0x00B20148 : 0000 0000 ....
2005-02-10-16.21.14.343000+060 I244152H446 LEVEL: Severe PID : 2532 TID : 2792 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : BALFI APPHDL : 0-47 APPID: 0E16B823.3104.050210152111 FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:5 MESSAGE : DiagData DATA #1 : Hexdump, 4 bytes 0x0FD23694 : 0000 0000 ....
2005-02-10-16.21.14.343000+060 I244600H492 LEVEL: Warning PID : 2532 TID : 2792 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : BALFI APPHDL : 0-47 APPID: 0E16B823.3104.050210152111 FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5 MESSAGE : Bringing down all db2fmp processes as part of db2stop DATA #1 : Hexdump, 4 bytes 0x0FD23560 : 0000 0000 ....
2005-02-10-16.21.14.421000+060 I245094H469 LEVEL: Severe PID : 2532 TID : 2792 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : BALFI APPHDL : 0-47 APPID: 0E16B823.3104.050210152111 FUNCTION: DB2 UDB, SQO Memory Management, sqlofpol, probe:1030 MESSAGE : sqloGetMemChunks not explicitly freed. DATA #1 : Hexdump, 4 bytes 0x0FD234E4 : 0100 0000 ....
2005-02-10-16.21.14.421000+060 I245565H469 LEVEL: Severe PID : 2532 TID : 2792 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : BALFI APPHDL : 0-47 APPID: 0E16B823.3104.050210152111 FUNCTION: DB2 UDB, SQO Memory Management, sqlofpol, probe:1030 MESSAGE : sqloGetMemChunks not explicitly freed. DATA #1 : Hexdump, 4 bytes 0x0FD234E4 : 0100 0000 ....
Any idea ? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: xixi |
last post by:
hi, we are using db2 udb v8.1 on windows, normally i would use control
center to change bufferpool size since i know the change will be
effect immediately for version 8.1, so i right click...
|
by: Paul |
last post by:
Hi,
is there any way to know the content of the bufferpool :
- space usage not present in snapshot
- tables actually cached in and number of pages, same for index ...
thx
|
by: Christian Berg |
last post by:
Hi,
I have got a problem with resizing the bufferpool of a DB2 v.8.2
instance.
The DB2 runs on an AIX 5.x platform.
Problem is that an "ALTER BUFFERPOOL ..." command is not persistent if...
|
by: Hemant Shah |
last post by:
Folks,
I am not sure what I am doing wrong, but We have an transaction that
does some serious calculation on small chink of data over and over
again.
It selects few rows from the table...
|
by: Hemant Shah |
last post by:
Folks,
I am using DB2 UDB 8.2 on AIX 5.1. How large of a bufferpool can you create?
I tried to create a 4GB bufferpool db2 complained that is cannot
allocate enogth memory. I have 16GB on this...
|
by: dotyet |
last post by:
Hi Everyone,
I am in a very strange situation, and am looking for suggestions to
tackle it.
I have a 10 gig database on 64-bit windows 2003 running platform. The
database has about 5 gigs of...
|
by: aczapran |
last post by:
Everything I read on DB2 indicates that the bufferpool is a pool of
database pages used to speed up database access. It is controlled by
us, when we specify how many pages we would like to have...
|
by: dunleav1 |
last post by:
In 9.1 and 9.5 (Linux 64 bit) when a buffer pool is set to self-
tuning, how are blocks configured in respect to blocked vs non-blocked
when self-tuning is set to on?
(ie) I have one bufferpool...
|
by: dot.yet |
last post by:
Hi Everyone,
environment:
DB2 9.5 WSE with FP 2a
Solaris 10 u5 - 64-bit
SMP - 2 Quad CPUS - total 8 cores
16 GB RAM
SAMPLE database
Solaris Containers
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
| |