Система Linux, DB2 v8.1.2.128", "s061108", "MI00176", FixPak "14
В db2diag.log появилась ошибка:
2009-09-28-11.46.47.580736+240 I1G1358 LEVEL: Event
PID : 12435 TID : 3086857920 PROC : db2agent (STRAH) 0
INSTANCE: db2inst NODE : 000 DB : STRAH
APPHDL : 0-894 APPID: NF000001.C880.090928073550
FUNCTION: DB2 UDB, RAS/PD component, _pdlogInt, probe:120
START : New db2diag.log file
DATA #1 : Build Level, 124 bytes
Instance "db2inst" uses "32" bits and DB2 code release "SQL08027"
with level identifier "03080106".
Informational tokens are "DB2 v8.1.2.128", "s061108", "MI00176", FixPak "14".
DATA #2 : System Info, 436 bytes
System: Linux lin.045.pfr.ru 6 2 i686
CPU: total:2 online:2 Cores per socket:1 Threading degree per core:2
Physical Memory(MB): total:4052 free:110
Virtual Memory(MB): total:8147 free:4205
Swap Memory(MB): total:4095 free:4095
Kernel Params: msgMaxMessageSize:8192 msgMsgMap:16384 msgMaxQueueIDs:1024
msgNumberOfHeaders:16384 msgMaxQueueSize:16384
msgMaxSegmentSize:16 shmMax:268435456 shmMin:1 shmIDs:4096
shmSegments:4096 semMap:32000 semIDs:1024 semNum:32000
semUndo:32000 semNumPerID:250 semOps:32 semUndoSize:20
semMaxVal:32767 semAdjustOnExit:32767
Information in this record is only valid at the time when this file was
created (see this record's time stamp)

2009-09-28-11.46.47.580449+240 E1360G553 LEVEL: Severe (OS)
PID : 12435 TID : 3086857920 PROC : db2agent (STRAH) 0
INSTANCE: db2inst NODE : 000 DB : STRAH
APPHDL : 0-894 APPID: NF000001.C880.090928073550
FUNCTION: DB2 UDB, oper system services, getPrivateChunksFromOs, probe:100
CALLED : OS, -, malloc OSERR: ENOMEM (12)
MESSAGE : Private memory and/or virtual address space exhausted
DATA #1 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 4 bytes
209735680

2009-09-28-11.46.47.605407+240 E1914G553 LEVEL: Severe (OS)
PID : 12435 TID : 3086857920 PROC : db2agent (STRAH) 0
INSTANCE: db2inst NODE : 000 DB : STRAH
APPHDL : 0-894 APPID: NF000001.C880.090928073550
FUNCTION: DB2 UDB, oper system services, getPrivateChunksFromOs, probe:100
CALLED : OS, -, malloc OSERR: ENOMEM (12)
MESSAGE : Private memory and/or virtual address space exhausted
DATA #1 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 4 bytes
209735680

Появляется после запуска одной операции на клиенте в Вебсфере

в логе Вебсферы появляется ошибка:
[28.09.09 11:46:47:809 MSD] 0000005d ExceptionUtil E CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "setMessageContent" on bean "BeanId(strah#strahEJB.jar#Scheduler, null)". Exception data: {code=ERR_INTERNAL_ERROR, message=DB2 SQL error: SQLCODE: -930, SQLSTATE: 57011, SQLERRMC: null, comment=null}
at com.estylesoft.strah.ejb.scheduler.SchedulerBean.setMessageContent(SchedulerBean.java:46)

что можно с этим поделать?

mitek
посмотрите в db2mtrk -i -d -v -p сколько отъела база.
команда дает такой результат
Memory for instance

Database Monitor Heap is of size 180224 bytes
Other Memory is of size 1261568 bytes
Total: 1441792 bytes

Memory for database: STRRR

Backup/Restore/Util Heap is of size 16384 bytes
Package Cache is of size 393216 bytes
Catalog Cache Heap is of size 196608 bytes
Buffer Pool Heap is of size 211435520 bytes
Buffer Pool Heap is of size 1055440896 bytes
Buffer Pool Heap is of size 606208 bytes
Buffer Pool Heap is of size 344064 bytes
Buffer Pool Heap is of size 212992 bytes
Buffer Pool Heap is of size 147456 bytes
Lock Manager Heap is of size 423624704 bytes
Database Heap is of size 10633216 bytes
Other Memory is of size 0 bytes
Total: 1703051264 bytes

Memory for agent 17828

Application Control Heap is of size 16384 bytes
Application Heap is of size 212992 bytes
Total: 229376 bytes

mitek
если мне маразм не изменяет, то под Linux32 как раз DB2 может съесть не больше ~1,7Gb.
попробуйте уменьшить буферпул(ы)
к сожалению не силен в этом..
не подскажете как изменить размер этих буферпулов?

Спасибо, поробую поэкспериментировать.