 |
|
|
|
Next: Index Access 2003
|
| Author |
Message |
External
Since: Feb 10, 2005
Posts: 1
|
(Msg. 1) Posted: Thu Feb 10, 2005 8:41 am
Post subject: AWE Bufferpool: instance crashing with DB2 8.x ESE FP8
Archived from groups: comp>databases>ibm-db2 (more info?)
|
|
|
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 ? |
|
| Back to top |
|
 | |
External
Since: Oct 17, 2004
Posts: 6
|
(Msg. 2) Posted: Fri Feb 11, 2005 5:40 am
Post subject: Re: AWE Bufferpool: instance crashing with DB2 8.x ESE FP8 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Open a PMR.
<zahni31 RemoveThis @gmx.de> wrote in message
news:1108050082.302029.277330@z14g2000cwz.googlegroups.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 ?
><!-- ~MESSAGE_AFTER~ --> |
|
| Back to top |
|
| |
| Related Topics: | heavy inserts and bufferpool - I am new to DB2. version info DB2 9.5 , Linux some more info:- create bufferpool bp1 size 140000 pagesize 8K ; update db cfg for test using CHNGPGS_THRESH 5 ; update db cfg for test using NUM_IOCLEANERS 3 ; update db cfg for test using NUM_IOSERVERS 3 ...
What is the optimal average bufferpool read time in a multi - Hi, What would be the optimal/good/average/bad average bufferpool read times in a EEE data ware house environment? Also, is the operation of sending data over tablequeue will have affect because of high overall CPU I/O wait time? I was thinking it..
Calculate the maximum total memory ever used by the instance - Hi All, Is there a way to calculate the maximum total memory ever used by the instance? Is db2mtrk the answer ... especially the high watermark option..... If I add up all the values......Will it be the total memory used ? Thanks - beena
Instance choice in JDBC url connection - Hello all, I'm using DB2 UDB 7.2 on a Linux server and I've installed the DB2 client on my Windows 2000 machine. I've defined on my client two instances, one for test databases and one for production databases and I've cataloged the same database (of..
db2fm -D ; Error: failed to find the default instance. Env.. - When executing the command : db2fm -D I received the error: Failed to find the default instance. Environment variable $DB2INSTANCE not set properly. What is the best approach from here - Using option -i for instance ? |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Profile
Private Messages
Log in
