help! "Private memory and/or virtual address space exhausted" issue.

vanessaspring

does anyone met this error before?

env: AIX, 64-bit, 20G physical memoery.

here is from db2diag.log

2007-06-08-15.03.16.708411-420 E62989A572         LEVEL: Severe (OS)
PID     : 1048626              TID  : 1           PROC : db2agent (MCYDB) 0
INSTANCE: db2p1ngp             NODE : 000         DB   : MCYDB
APPHDL  : 0-669                APPID: GA06F76B.G00C.025C48220317
FUNCTION: DB2 UDB, oper system services, getPrivateChunksFromOs, probe:100
CALLED  : OS, -, malloc
OSERR   : ENOMEM (12) "There is not enough memory available now."
MESSAGE : Private memory and/or virtual address space exhausted
DATA #1 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes
1019904

2007-06-08-15.03.16.709534-420 E63562A572         LEVEL: Severe (OS)
PID     : 1048626              TID  : 1           PROC : db2agent (MCYDB) 0
INSTANCE: db2p1ngp             NODE : 000         DB   : MCYDB
APPHDL  : 0-669                APPID: GA06F76B.G00C.025C48220317
FUNCTION: DB2 UDB, oper system services, getPrivateChunksFromOs, probe:100
CALLED  : OS, -, malloc
OSERR   : ENOMEM (12) "There is not enough memory available now."
MESSAGE : Private memory and/or virtual address space exhausted
DATA #1 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes
1019904

2007-06-08-15.03.16.709880-420 I64135A384         LEVEL: Error
PID     : 1048626              TID  : 1           PROC : db2agent (MCYDB) 0
INSTANCE: db2p1ngp             NODE : 000         DB   : MCYDB
APPHDL  : 0-669                APPID: GA06F76B.G00C.025C48220317
FUNCTION: DB2 UDB, runtime interpreter, sqlri_hsjnGetTupleBlock, probe:10
MESSAGE : Private virtual memory exhausted


here is memory monitoring from system around that moment:
06/08/07 15:05 size      inuse       free                    pin    virtual
memory      5095424    4051392    1044032     415455    2797145
pg space    1310720      31578
pin          415193        262          0
in use      2797029     258936     995427

does it look like memory fragmentation issue?

thanks!

wangzhonnewnew

u sure instance is 64 bits? show db2level... and capture db2support.zip:
db2support . -d <dbname> -c -g -s

also please read the following article:
http://www-1.ibm.com/support/doc ... s=utf-8&lang=en

vanessaspring

原帖由 wangzhonnewnew 于 2007-6-11 10:24 发表
u sure instance is 64 bits? show db2level... and capture db2support.zip:
db2support . -d <dbname> -c -g -s

also please read the following article:
[url]http://www-1.ibm.com/support/docvi ...

thanks for your information.

yes, the instance is 64 bit. I am pretty sure.

here is the running result of db2level:

$ db2level
DB21085I  Instance "db2p1ngp" uses "64" bits and DB2 code release "SQL08026"
with level identifier "03070106".
Informational tokens are "DB2 v8.1.1.120", "s060801", "U808888", and FixPak
"13".
Product is installed at "/usr/opt/db2_08_01".

I am checking the website you provided now...

vanessaspring

It seems like "soft user data limit" had been reached.

My current setting is: 240M (245759K), let me check my snapshot at that moment...

[ 本帖最后由 vanessaspring 于 2007-6-11 15:16 编辑 ]