473,324 Members | 2,541 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

AWE Bufferpool: instance crashing with DB2 8.x ESE FP8

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 ?

Nov 12 '05 #1
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 ?

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
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...
5
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
1
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...
5
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...
20
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...
3
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...
9
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...
3
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...
0
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
0
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...
0
isladogs
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...
1
isladogs
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...
0
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...
1
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)...
1
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...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
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....
0
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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.