DB2 8.1 Fixpack 6.
Windows 2003
16 Gb Memory

Дважды подряд при дисконнекте всех приложений падает инстанс.
Первый раз я отнеслась к этому излишне легкомысленно - перед дисконнектом были изменены ряд параметров типа увеличение SORTHEAP и NUM_IOSERVERS, я списала на это.

Второй раз - абсолютно чистый, все приложения количеством 3 штуки мирно отконнектились.

База остается целой, после рестарта инстанса креш-рековери не выполняется.

PMR с IBM еще не открыт, но может быть, народная мудрость чего скажет?

Спасибо!

07.00 - опускаются все приложения.

Примерно 07.02 - обнаруживаю проблему (вновь поднятые приложения не коннектятся)

Примерно 07.03.30 выполняется команда db2Start, после чего выполняю connect to OLAP4, все нормально подымается.

=========================================================
2004-07-14-07.00.47.609000 Instance:DB2 Node:000
PID:1524(db2syscs.exe) TID:268 Appid:none
data protection sqlpghck Probe:1390

ExtNum 26166, state 401, baselsn 00000009AC4E2000 nextlsn 00000009ACA4496D

2004-07-14-07.00.53.484000 Instance:DB2 Node:000
PID:1524(db2syscs.exe) TID:1640 Appid:*LOCAL.DB2.00D5C2120720
SQO Memory Management sqlofmblkEx Probe:24 Database:OLAP4

The pool that owns memory block 0x01EAE760 has already been freed!

2004-07-14-07.00.53.515000 Instance:DB2 Node:000
PID:1524(db2syscs.exe) TID:1640 Appid:*LOCAL.DB2.00D5C2120720
base sys utilities sqleagnt_sigsegvh Probe:1 Database:OLAP4

Error in agent servicing application with coor_node:
0x0174A422 : 0x0000 ..

2004-07-14-07.00.53.515001 Instance:DB2 Node:000
PID:1524(db2syscs.exe) TID:1640 Appid:*LOCAL.DB2.00D5C2120720
base sys utilities sqleagnt_sigsegvh Probe:2 Database:OLAP4

Error in agent servicing application with coor_agent_index:
0x0174A420 : 0x000A ..

2004-07-14-07.00.53.515002 Instance:DB2 Node:000
PID:1524(db2syscs.exe) TID:1640 Appid:*LOCAL.DB2.00D5C2120720
base sys utilities sqleagnt_sigsegvh Probe:3 Database:OLAP4

Error in agent servicing application with CLIENT PID:
0x0174A400 : 0x34323731 1724

2004-07-14-07.00.53.531000 Instance:DB2 Node:000
PID:1524(db2syscs.exe) TID:1640 Appid:*LOCAL.DB2.00D5C2120720
base sys utilities sqleagnt_sigsegvh Probe:4 Database:OLAP4

Error in agent servicing application with INBOUND APPLICATION ID:
0x016C7F03 : 2A4C 4F43 414C 2E44 4232 2E30 3044 3543 *LOCAL.DB2.00D5C
0x016C7F13 : 3231 3230 3732 30 2120720

2004-07-14-07.00.53.531001 Instance:DB2 Node:000
PID:1524(db2syscs.exe) TID:1640 Appid:*LOCAL.DB2.00D5C2120720
base sys utilities sqleagnt_sigsegvh Probe:5 Database:OLAP4

Error in agent servicing application with INBOUND SEQUENCE NUMBER:
0x016C7F24 : 0x0A71 q.

2004-07-14-07.00.53.531002 Instance:DB2 Node:000
PID:1524(db2syscs.exe) TID:1640 Appid:*LOCAL.DB2.00D5C2120720
base sys utilities sqleagnt_sigsegvh Probe:8 Database:OLAP4

Error in agent servicing application with AUTHORIZATION ID:
0x166DC129 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x166DC139 : 0000 0000 0000 0000 0000 0000 0000 00 ...............

2004-07-14-07.00.53.531003 Instance:DB2 Node:000
PID:1524(db2syscs.exe) TID:1640 Appid:*LOCAL.DB2.00D5C2120720
base sys utilities sqleagnt_sigsegvh Probe:9 Database:OLAP4

Error in agent servicing application with PRODUCT SIGNATURE:
0x166DC2F8 : 0x36313038304C5153 SQL08016

2004-07-14-07.00.53.531004 Instance:DB2 Node:000
PID:1524(db2syscs.exe) TID:1640 Appid:*LOCAL.DB2.00D5C2120720
base sys utilities sqleagnt_sigsegvh Probe:10 Database:OLAP4

Error in agent servicing application with APPLICATION NAME:
0x166DC2CE : 7079 7264 626D 2E65 7865 pyrdbm.exe

PID:1524 TID:1640 Node:000 Title: SQLE_AGENTCB
Dump File:D:\db2\DiagLog\15241640.000

PID:1524 TID:1640 Node:000 Title: SQLE_AGENT_PRIVATECB
Dump File:D:\db2\DiagLog\15241640.000

PID:1524 TID:1640 Node:000 Title: SQLE_DBCB
Dump File:D:\db2\DiagLog\15241640.000

PID:1524 TID:1640 Node:000 Title: SQLE_MASTER_APP_CB
Dump File:D:\db2\DiagLog\15241640.000

PID:1524 TID:1640 Node:000 Title: SQLE_APP_CB
Dump File:D:\db2\DiagLog\15241640.000

PID:1524 TID:1640 Node:000 Title: SQLE_COORDINATOR_CB
Dump File:D:\db2\DiagLog\15241640.000

PID:1524 TID:1640 Node:000 Title: SQLE_APP_SA_CB
Dump File:D:\db2\DiagLog\15241640.000

PID:1524 TID:1640 Node:000 Title: SQLE_APP_GROUP_CB
Dump File:D:\db2\DiagLog\15241640.000

2004-07-14-07.00.53.593000 Instance:DB2 Node:000
PID:1524(db2syscs.exe) TID:1640 Appid:*LOCAL.DB2.00D5C2120720
base sys utilities sqleCleanupResources Probe:5 Database:OLAP4

DiagData
0x0174FDA4 : 0x00000000 ....

2004-07-14-07.02.06.331000 Instance:DB2 Node:000
PID:3584(pyrdbm.exe) TID:2012 Appid:none
oper system services sqloSSemClose Probe:20

Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.

PID:3584 TID:2012 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.


2004-07-14-07.02.06.331002 Instance:DB2 Node:000
PID:3584(pyrdbm.exe) TID:2012 Appid:none
oper system services sqloSSemClose Probe:20

Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.

PID:3584 TID:2012 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.


2004-07-14-07.02.06.331000 Instance:DB2 Node:000
PID:892(pyrdbm.exe) TID:3588 Appid:none
oper system services sqloSSemClose Probe:20

Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.

PID:892 TID:3588 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.


2004-07-14-07.02.06.846001 Instance:DB2 Node:000
PID:892(pyrdbm.exe) TID:3588 Appid:none
oper system services sqloSSemClose Probe:20

Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.

PID:892 TID:3588 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.


2004-07-14-07.02.06.331000 Instance:DB2 Node:000
PID:3704(pyrdbm.exe) TID:3636 Appid:none
oper system services sqloSSemClose Probe:20

Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.

PID:3704 TID:3636 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.


2004-07-14-07.02.07.346001 Instance:DB2 Node:000
PID:3704(pyrdbm.exe) TID:3636 Appid:none
oper system services sqloSSemClose Probe:20

Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.

PID:3704 TID:3636 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.


2004-07-14-07.02.06.331000 Instance:DB2 Node:000
PID:4060(pyrdbm.exe) TID:2560 Appid:none
oper system services sqloSSemClose Probe:20

Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.

PID:4060 TID:2560 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.


2004-07-14-07.02.07.846001 Instance:DB2 Node:000
PID:4060(pyrdbm.exe) TID:2560 Appid:none
oper system services sqloSSemClose Probe:20

Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.

PID:4060 TID:2560 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.


2004-07-14-07.02.06.331000 Instance:DB2 Node:000
PID:3544(pyrdbm.exe) TID:1256 Appid:none
oper system services sqloSSemClose Probe:20

Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.

PID:3544 TID:1256 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.


2004-07-14-07.02.08.346001 Instance:DB2 Node:000
PID:3544(pyrdbm.exe) TID:1256 Appid:none
oper system services sqloSSemClose Probe:20

Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.

PID:3544 TID:1256 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.


2004-07-14-07.03.11.253000 Instance:DB2 Node:000
PID:3296(db2bp.exe) TID:2716 Appid:none
oper system services sqloSSemClose Probe:20

Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.

PID:3296 TID:2716 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.


2004-07-14-07.03.11.253002 Instance:DB2 Node:000
PID:3296(db2bp.exe) TID:2716 Appid:none
oper system services sqloSSemClose Probe:20

Unexpected system error 0x6 has occurred.
This has been mapped to ZRC 0x83000006.

PID:3296 TID:2716 Node:000 Title: SYSTEM ERROR DESCRIPTION
The handle is invalid.


2004-07-14-07.03.50.393000 Instance:DB2 Node:000
PID:3452(db2syscs.exe) TID:2420 Appid:none
base sys utilities DB2StartMain Probe:911

ADM7513W Database manager has started.

2004-07-14-07.03.54.096000 Instance:DB2 Node:000
PID:3452(db2syscs.exe) TID:2836 Appid:*LOCAL.DB2.0177C4120353
buffer pool services sqlbAllocateAWEMem Probe:80 Database:OLAP4

ADM6068I The buffer pool "PYRHISTIDXBP" (ID "2") is using AWE. Physical size
is "32000". Window size is "6400".

2004-07-14-07.03.54.534000 Instance:DB2 Node:000
PID:3452(db2syscs.exe) TID:2836 Appid:*LOCAL.DB2.0177C4120353
buffer pool services sqlbAllocateAWEMem Probe:80 Database:OLAP4

Да это сделала, проверила - живет.

Но это ж именно мусор под ковер! Плюс не забыть после следующего рестарта базы ее активировать, я же надеюсь не рестартовать ее сколько-то месяцев.

База-то вроде не должна быть задета этим ошибка, скорее всего, ошибка проявляется именно в процессе освобождения буферов, когда все флаши сброшены.

Да, две новых.

Одна на машине, где 4Gb, AWE не используется:

[e] DB2PATH=C:\SQLLIB
DB2_STRIPED_CONTAINERS=ON
DB2NTWORKSET=1024,3072
DB2NTNOCACHE=1
DB2INSTPROF=C:\SQLLIB
DB2COMM=TCPIP
[g] DB2SYSTEM=RE-23
[g] DB2PATH=C:\SQLLIB
[g] DB2INSTDEF=DB2
[g] DB2ADMINSERVER=DB2DAS00

1 ID NPAGES PAGESIZE ESTORE NUMBLOCKP BLOCKSIZE

------------- ----------- ----------- ----------- ------ ----------- -----------

IBMDEFAULTBP 1 250 4096 N 0 0

MAIL4KDAT 2 120000 4096 N 0 0

MAIL4KIDX 3 125000 4096 N 0 0



Вторая на машине с 16 Gb (AWE включено):

[e] DB2PATH=C:\SQLLIB
DB2_AWE=2,32000,6400;3,128000,25600;4,48000,9600;5,64000,12800;6,64000,12800;7,128000,51200;8,256000,51200;9,64000,12800
DB2_STRIPED_CONTAINERS=ON
DB2NTWORKSET=1024,2048
DB2NTNOCACHE=off
DB2INSTPROF=C:\SQLLIB
DB2COMM=TCPIP
[g] DB2SYSTEM=RE-24
[g] DB2PATH=C:\SQLLIB
[g] DB2INSTDEF=DB2
[g] DB2ADMINSERVER=DB2DAS00

BUFFERPOOLID NPAGES PAGESIZE ESTORE NUMBLOCKPAGES BLOCKSIZE
-------------------- ------------ ----------- ----------- ------ ------------- -----------
IBMDEFAULTBP 1 512 4096 N 0 0
PYRHISTIDXBP 2 128000 16384 N 0 0
PYRHISTDATABP 3 128000 16384 N 0 0
PYRUSERDATABP 4 48000 4096 N 0 0
PYRUSERIDXBP 5 64000 4096 N 0 0
PYRLARGEDATABP 6 64000 4096 N 0 0
PYRLARGEIDXBP 7 256000 4096 N 0 0
PYRDATABP 8 256000 4096 N 0 0
PYRIDXBP 9 64000 4096 N 0 0

Да, одна. А почему должно быть больше? Или почему так много вопросов? :)

Она одна тянет на 300 Гигов, и транзакций в пике штук так несколько тысяч в минуту.

Support ответил

We have done some research on this pmr. Base on the stack trace. We
identified this to be a known problem JR19415. Below is the link.

http://www-306.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/aparlib.d2w/display_apar_details?aparno=JR19415.

This APAR is not included in FP6 and will be included in FP7.

В общем, не ходите, дети, на 8 версию:( 7 работает как часы.