Всем привет,
есть instance на DB2 сервере:

$ db2level
DB21085I Instance "db2admin" uses "32" bits and DB2 code release "SQL08020"
with level identifier "03010106".
Informational tokens are "DB2 v8.1.0.73", "OD_14080", "MI00126_14080", and
FixPak "7".
Product is installed at "/opt/IBM/db2/V8.1".

на RedHat AS 2.1, пытаюсь на нем создать tools catalog командой:
db2 create tools catalog TOOLSCAT create new database TOOLSDB force

Эта команда благополучно подвешивает сервер. Как такое можно побороть?

nkulikovdb2 update dbm cfg using tracelevel 4
db2diag.log в студию

на tracelevel db2 ругнулся поэтому сделал так:
db2 update dbm cfg using diaglevel 4
db2 create tools catalog TOOLSCAT create new database toolsdb force

db2diag.log:
2005-08-18-17.02.06.002333+240 I2153793G287 LEVEL: Event
PID : 9127 TID : 8192 PROC : db2flacc
INSTANCE: db2admin NODE : 000
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE : CFG DBM: "Diaglevel" From: "3" To: "4"

2005-08-18-17.03.01.083965+240 I2154081G307 LEVEL: Info
PID : 9218 TID : 8194
FUNCTION: DB2 Common, Security, Users and Groups, secLoadClientAuthPlugin, probe
:10
DATA #1 : String, 91 bytes
Loaded plugin library /home/db2admin/sqllib/security32/plugin/IBM/client/IBMOSau
thclient.so

2005-08-18-17.03.01.085813+240 I2154389G243 LEVEL: Info
PID : 9218 TID : 8194
FUNCTION: DB2 Common, Security, Users and Groups, secLogMessage, probe:20
DATA #1 : String, 37 bytes
db2secClientAuthPluginInit successful

2005-08-18-17.03.01.086181+240 I2154633G297 LEVEL: Info
PID : 9218 TID : 8194
FUNCTION: DB2 Common, Security, Users and Groups, secLoadGroupPlugin, probe:10
DATA #1 : String, 86 bytes
Loaded plugin library /home/db2admin/sqllib/security32/plugin/IBM/group/IBMOSgro
ups.so

2005-08-18-17.03.01.086229+240 I2154931G238 LEVEL: Info
PID : 9218 TID : 8194
FUNCTION: DB2 Common, Security, Users and Groups, secLogMessage, probe:20
DATA #1 : String, 32 bytes
db2secGroupPluginInit successful

2005-08-18-17.03.01.091408+240 I2155170G910 LEVEL: Error
PID : 9211 TID : 8194 PROC : db2dasstm
INSTANCE: db2admin NODE : 000
FUNCTION: DB2 UDB, oper system services, sqlofica, probe:10
DATA #1 : Hexdump, 136 bytes
0x41FF2858 : 5351 4C43 4120 2020 8800 0000 13FC FFFF SQLCA ........
0x41FF2868 : 0700 544F 4F4C 5344 4200 0000 0000 0000 ..TOOLSDB.......
0x41FF2878 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x41FF2888 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x41FF2898 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x41FF28A8 : 0000 0000 0000 0000 5351 4C45 4352 4541 ........SQLECREA
0x41FF28B8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x41FF28C8 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x41FF28D8 : 2020 2020 2020 2020

2005-08-18-17.03.13.846604+240 I2156081G307 LEVEL: Info
PID : 9232 TID : 8192
FUNCTION: DB2 Common, Security, Users and Groups, secLoadClientAuthPlugin, probe
:10
DATA #1 : String, 91 bytes
Loaded plugin library /home/db2admin/sqllib/security32/plugin/IBM/client/IBMOSau
thclient.so

2005-08-18-17.03.13.846816+240 I2156389G243 LEVEL: Info
PID : 9232 TID : 8192
FUNCTION: DB2 Common, Security, Users and Groups, secLogMessage, probe:20
DATA #1 : String, 37 bytes
db2secClientAuthPluginInit successful

2005-08-18-17.03.13.847145+240 I2156633G297 LEVEL: Info
PID : 9232 TID : 8192
FUNCTION: DB2 Common, Security, Users and Groups, secLoadGroupPlugin, probe:10
DATA #1 : String, 86 bytes
Loaded plugin library /home/db2admin/sqllib/security32/plugin/IBM/group/IBMOSgro
ups.so

2005-08-18-17.03.13.847193+240 I2156931G238 LEVEL: Info
PID : 9232 TID : 8192
FUNCTION: DB2 Common, Security, Users and Groups, secLogMessage, probe:20
DATA #1 : String, 32 bytes
db2secGroupPluginInit successful

2005-08-18-17.03.36.910492+240 I2157170G194 LEVEL: Info
PID : 9211 TID : 8192
FUNCTION: DB2 Common, OSSe, OSSHIPCQueue::get, probe:80
MESSAGE : ECF=0x90000013 Time out

2005-08-18-17.03.56.931701+240 I2157365G194 LEVEL: Info
PID : 9211 TID : 8192
FUNCTION: DB2 Common, OSSe, OSSHIPCQueue::get, probe:80
MESSAGE : ECF=0x90000013 Time out

2005-08-18-17.04.10.608968+240 I2157560G345 LEVEL: Info
PID : 9211 TID : 16386 PROC : db2dasstm
INSTANCE: db2admin NODE : 000
APPID : *LOCAL.db2admin.050818130340
FUNCTION: DB2 UDB, oper system services, sqloSSemP, probe:3
MESSAGE : SQL10007N Message "0" could not be retrieved. Reason code: "4".

2005-08-18-17.04.10.618066+240 I2157906G327 LEVEL: Info
PID : 9211 TID : 16386 PROC : db2dasstm
INSTANCE: db2admin NODE : 000
APPID : *LOCAL.db2admin.050818130340
MESSAGE : SQO semop=> errno:
DATA #1 : Hexdump, 4 bytes
0x41FE7DE8 : 2B00 0000 +...

2005-08-18-17.04.10.618174+240 I2158234G329 LEVEL: Info
PID : 9211 TID : 16386 PROC : db2dasstm
INSTANCE: db2admin NODE : 000
APPID : *LOCAL.db2admin.050818130340
MESSAGE : SQO semop=> pSSemID:
DATA #1 : Hexdump, 4 bytes
0x41F88CA4 : 0100 0000 ....

2005-08-18-17.04.10.618262+240 I2158564G332 LEVEL: Info
PID : 9211 TID : 16386 PROC : db2dasstm
INSTANCE: db2admin NODE : 000
APPID : *LOCAL.db2admin.050818130340
MESSAGE : SQO semop=> pSSemSetID:
DATA #1 : Hexdump, 4 bytes
0x41F88C8C : 6100 2619 a.&.

2005-08-18-17.04.10.618388+240 I2158897G390 LEVEL: Info
PID : 9211 TID : 16386 PROC : db2dasstm
INSTANCE: db2admin NODE : 000
APPID : *LOCAL.db2admin.050818130340
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
MESSAGE : CCI Error:
DATA #1 : Hexdump, 4 bytes
0x41FE7E88 : 4700 0000 G...

2005-08-18-17.04.10.624109+240 I2159288G377 LEVEL: Info
PID : 9211 TID : 16386 PROC : db2dasstm
INSTANCE: db2admin NODE : 000
APPID : *LOCAL.db2admin.050818130340
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
RETCODE : ZRC=0x8136001C=-2127167460=SQLZ_RC_NO_CONNECTION, SQLT_SQLJC
"No connection"

2005-08-18-17.04.10.631765+240 I2159666G574 LEVEL: Info
PID : 9211 TID : 16386 PROC : db2dasstm
INSTANCE: db2admin NODE : 000
APPID : *LOCAL.db2admin.050818130340
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
DATA #1 : String, 266 bytes
CALL STACK:
[0] 0x40D428E8 _Z12sqljcReceiveP10sqljCmnMgr + 0x1FA
[1] 0x40DAE1D2 _Z21sqljrDrdaArDisconnectP7UCintfc + 0xCF8
[2] 0x408BC288 sqleUCdisconnect + 0x7A
[3] 0x408BBE03 sqleUCappConnectReset + 0xFD
[4] 0x408A0471 _Z8sqleistp17db2UCcommitOptionP5sqlca + 0x79

2005-08-18-17.04.10.882694+240 I2160241G405 LEVEL: Event
PID : 14414 TID : 8192 PROC : db2agent (TOOLSDB)
INSTANCE: db2admin NODE : 000 DB : TOOLSDB
APPHDL : 0-252 APPID: *LOCAL.db2admin.050818130410
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20
CHANGE : CFG DB TOOLSDB: "App_ctl_heap_sz" From: "128" To: "1024"

2005-08-18-17.04.10.908385+240 I2160647G400 LEVEL: Event
PID : 14414 TID : 8192 PROC : db2agent (TOOLSDB)
INSTANCE: db2admin NODE : 000 DB : TOOLSDB
APPHDL : 0-252 APPID: *LOCAL.db2admin.050818130410
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20
CHANGE : CFG DB TOOLSDB: "Applheapsz" From: "256" To: "1024"

2005-08-18-17.04.10.961457+240 I2161048G390 LEVEL: Info
PID : 9211 TID : 16386 PROC : db2dasstm
INSTANCE: db2admin NODE : 000
APPID : *LOCAL.db2admin.050818130410
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
MESSAGE : CCI Error:
DATA #1 : Hexdump, 4 bytes
0x41FF1D78 : 4700 0000 G...

2005-08-18-17.04.10.961687+240 I2161439G377 LEVEL: Info
PID : 9211 TID : 16386 PROC : db2dasstm
INSTANCE: db2admin NODE : 000
APPID : *LOCAL.db2admin.050818130410
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
RETCODE : ZRC=0x8136001C=-2127167460=SQLZ_RC_NO_CONNECTION, SQLT_SQLJC
"No connection"

2005-08-18-17.04.10.962118+240 I2161817G606 LEVEL: Info
PID : 9211 TID : 16386 PROC : db2dasstm
INSTANCE: db2admin NODE : 000
APPID : *LOCAL.db2admin.050818130410
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
DATA #1 : String, 298 bytes
CALL STACK:
[0] 0x40D428E8 _Z12sqljcReceiveP10sqljCmnMgr + 0x1FA
[1] 0x40DAE1D2 _Z21sqljrDrdaArDisconnectP7UCintfc + 0xCF8
[2] 0x408BC288 sqleUCdisconnect + 0x7A
[3] 0x408BBE03 sqleUCappConnectReset + 0xFD
[4] 0x40B1134B _Z17CLI_sqlDisconnectP15CLI_CONNECTINFOP5sqlcaP19CLI_ERRORHEADERI
NFO + 0x139

2005-08-18-17.04.11.221873+240 I2162424G390 LEVEL: Info
PID : 9211 TID : 16386 PROC : db2dasstm
INSTANCE: db2admin NODE : 000
APPID : *LOCAL.db2admin.050818130411
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
MESSAGE : CCI Error:
DATA #1 : Hexdump, 4 bytes
0x41FF1DB4 : 4700 0000 G...

2005-08-18-17.04.11.222145+240 I2162815G377 LEVEL: Info
PID : 9211 TID : 16386 PROC : db2dasstm
INSTANCE: db2admin NODE : 000
APPID : *LOCAL.db2admin.050818130411
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
RETCODE : ZRC=0x8136001C=-2127167460=SQLZ_RC_NO_CONNECTION, SQLT_SQLJC
"No connection"

2005-08-18-17.04.11.222583+240 I2163193G606 LEVEL: Info
PID : 9211 TID : 16386 PROC : db2dasstm
INSTANCE: db2admin NODE : 000
APPID : *LOCAL.db2admin.050818130411
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
DATA #1 : String, 298 bytes
CALL STACK:
[0] 0x40D428E8 _Z12sqljcReceiveP10sqljCmnMgr + 0x1FA
[1] 0x40DAE1D2 _Z21sqljrDrdaArDisconnectP7UCintfc + 0xCF8
[2] 0x408BC288 sqleUCdisconnect + 0x7A
[3] 0x408BBE03 sqleUCappConnectReset + 0xFD
[4] 0x40B1134B _Z17CLI_sqlDisconnectP15CLI_CONNECTINFOP5sqlcaP19CLI_ERRORHEADERI
NFO + 0x139

2005-08-18-17.04.11.631940+240 I2163800G390 LEVEL: Info
PID : 9211 TID : 16386 PROC : db2dasstm
INSTANCE: db2admin NODE : 000
APPID : *LOCAL.db2admin.050818130412
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
MESSAGE : CCI Error:
DATA #1 : Hexdump, 4 bytes
0x41FF1DB4 : 4700 0000 G...

2005-08-18-17.04.11.632175+240 I2164191G377 LEVEL: Info
PID : 9211 TID : 16386 PROC : db2dasstm
INSTANCE: db2admin NODE : 000
APPID : *LOCAL.db2admin.050818130412
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
RETCODE : ZRC=0x8136001C=-2127167460=SQLZ_RC_NO_CONNECTION, SQLT_SQLJC
"No connection"

2005-08-18-17.04.11.632613+240 I2164569G606 LEVEL: Info
PID : 9211 TID : 16386 PROC : db2dasstm
INSTANCE: db2admin NODE : 000
APPID : *LOCAL.db2admin.050818130412
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
DATA #1 : String, 298 bytes
CALL STACK:
[0] 0x40D428E8 _Z12sqljcReceiveP10sqljCmnMgr + 0x1FA
[1] 0x40DAE1D2 _Z21sqljrDrdaArDisconnectP7UCintfc + 0xCF8
[2] 0x408BC288 sqleUCdisconnect + 0x7A
[3] 0x408BBE03 sqleUCappConnectReset + 0xFD
[4] 0x40B1134B _Z17CLI_sqlDisconnectP15CLI_CONNECTINFOP5sqlcaP19CLI_ERRORHEADERI
NFO + 0x139

2005-08-18-17.04.16.958922+240 I2165176G194 LEVEL: Info
PID : 9211 TID : 8192
FUNCTION: DB2 Common, OSSe, OSSHIPCQueue::get, probe:80
MESSAGE : ECF=0x90000013 Time out

2005-08-18-17.04.36.984156+240 I2165371G194 LEVEL: Info
PID : 9211 TID : 8192
FUNCTION: DB2 Common, OSSe, OSSHIPCQueue::get, probe:80
MESSAGE : ECF=0x90000013 Time out

2005-08-18-17.04.57.005388+240 I2165566G194 LEVEL: Info
PID : 9211 TID : 8192
FUNCTION: DB2 Common, OSSe, OSSHIPCQueue::get, probe:80
MESSAGE : ECF=0x90000013 Time out

2005-08-18-17.05.17.026603+240 I2165761G194 LEVEL: Info
PID : 9211 TID : 8192
FUNCTION: DB2 Common, OSSe, OSSHIPCQueue::get, probe:80
MESSAGE : ECF=0x90000013 Time out

2005-08-18-17.05.37.047840+240 I2165956G194 LEVEL: Info
PID : 9211 TID : 8192
FUNCTION: DB2 Common, OSSe, OSSHIPCQueue::get, probe:80
MESSAGE : ECF=0x90000013 Time out

2005-08-18-17.05.57.079065+240 I2166151G194 LEVEL: Info
PID : 9211 TID : 8192
FUNCTION: DB2 Common, OSSe, OSSHIPCQueue::get, probe:80
MESSAGE : ECF=0x90000013 Time out

2005-08-18-17.06.17.100290+240 I2166346G194 LEVEL: Info
PID : 9211 TID : 8192
FUNCTION: DB2 Common, OSSe, OSSHIPCQueue::get, probe:80
MESSAGE : ECF=0x90000013 Time out

2005-08-18-17.06.37.121519+240 I2166541G194 LEVEL: Info
PID : 9211 TID : 8192
FUNCTION: DB2 Common, OSSe, OSSHIPCQueue::get, probe:80
MESSAGE : ECF=0x90000013 Time out

2005-08-18-17.06.57.142746+240 I2166736G194 LEVEL: Info
PID : 9211 TID : 8192
FUNCTION: DB2 Common, OSSe, OSSHIPCQueue::get, probe:80
MESSAGE : ECF=0x90000013 Time out

2005-08-18-17.07.01.863219+240 I2166931G321 LEVEL: Info
PID : 9233 TID : 8192 PROC : db2
INSTANCE: db2admin NODE : 000
FUNCTION: DB2 UDB, command line process, clp_read_outputq, probe:88
MESSAGE : O33 Read Queue Timeout Loop Max Exceeded
DATA #1 : signed integer, 4 bytes
31

2005-08-18-17.07.17.163973+240 I2167253G194 LEVEL: Info
PID : 9211 TID : 8192
FUNCTION: DB2 Common, OSSe, OSSHIPCQueue::get, probe:80
MESSAGE : ECF=0x90000013 Time out

2005-08-18-17.07.32.874968+240 I2167448G321 LEVEL: Info
PID : 9233 TID : 8192 PROC : db2
INSTANCE: db2admin NODE : 000
FUNCTION: DB2 UDB, command line process, clp_read_outputq, probe:88
MESSAGE : O33 Read Queue Timeout Loop Max Exceeded
DATA #1 : signed integer, 4 bytes
31

2005-08-18-17.07.37.185217+240 I2167770G194 LEVEL: Info
PID : 9211 TID : 8192
FUNCTION: DB2 Common, OSSe, OSSHIPCQueue::get, probe:80
MESSAGE : ECF=0x90000013 Time out

2005-08-18-17.07.57.206428+240 I2167965G194 LEVEL: Info
PID : 9211 TID : 8192
FUNCTION: DB2 Common, OSSe, OSSHIPCQueue::get, probe:80
MESSAGE : ECF=0x90000013 Time out

2005-08-18-17.08.03.876894+240 I2168160G321 LEVEL: Info
PID : 9233 TID : 8192 PROC : db2
INSTANCE: db2admin NODE : 000
FUNCTION: DB2 UDB, command line process, clp_read_outputq, probe:88
MESSAGE : O33 Read Queue Timeout Loop Max Exceeded
DATA #1 : signed integer, 4 bytes
31


При это наблюдается следующее:
- db2dasstm отжирает 99.9% процессорного времени
- strace -p <PID обжоры> дает:
--- SIGSEGV (Segmentation fault) @ 0 (0) ---
--- SIGSEGV (Segmentation fault) @ 0 (0) ---
--- SIGSEGV (Segmentation fault) @ 0 (0) ---
--- SIGSEGV (Segmentation fault) @ 0 (0) ---
--- SIGSEGV (Segmentation fault) @ 0 (0) ---
--- SIGSEGV (Segmentation fault) @ 0 (0) ---