Hi All
It happened every day now that when a certain program on our db runs that it falls over after a while (+- 5 minutes) with a -900 sqlcode. The db has crashed then and needs to be restarted. The message in the diaglog looks like this: (Diaglevel 4). What does an internal error "0xFFFFB5AA" mean?.
2005-02-24-01.50.28.553000 Instance:PROD Node:000
PID:1852(db2syscs.exe) TID:1696 Appid:*LOCAL.PROD.050223233749
buffer_pool_services sqlbReadPageFromContainer Probe:20 Database:OPRSADB
DIA9999E An internal error occurred. Report the following error code :
"0xFFFFB5AA".
2005-02-24-01.50.28.553001 Instance:PROD Node:000
PID:1852(db2syscs.exe) TID:1696 Appid:*LOCAL.PROD.050223233749
buffer_pool_services sqlbReadPageFromContainer Probe:20 Database:OPRSADB
Obj={pool:40;obj:4;type:0} State=x27 Parent={40;4}, EM=96, PP0=128 Cont=0 Offset=1833452 BlkSize=12
Data Title:SQLB_OBJECT_DESC PID:1852 TID:1696 Node:000
2800 0400 2800 0400 0000 0000 043d 4f31 (...(........=O1
9c96 0000 0000 0000 6000 0000 0000 0000 œ–......`.......
8000 0000 0200 0000 2700 0000 0000 0000 €.......'.......
0010 0000 2000 0000 0100 0000 2800 0400 .... .......(...
58e8 560f 3000 5601 XèV.0.V.
2005-02-24-01.50.28.585000 Instance:PROD Node:000
PID:1852(db2syscs.exe) TID:1696 Appid:*LOCAL.PROD.050223233749
buffer_pool_services sqlbrdpg Probe:1110 Database:OPRSADB
DIA9999E An internal error occurred. Report the following error code :
"0xFFFFB5AA".
2005-02-24-01.50.28.585001 Instance:PROD Node:000
PID:1852(db2syscs.exe) TID:1696 Appid:*LOCAL.PROD.050223233749
buffer_pool_services sqlbrdpg Probe:1110 Database:OPRSADB
Obj={pool:40;obj:4;type:0} State=x27 Parent={40;4}, EM=96, PP0=128 Page=1833451 Cont=0 Offset=1833452 BlkSize=12
Unexpected EOF
Data Title:SQLB_OBJECT_DESC PID:1852 TID:1696 Node:000
2800 0400 2800 0400 0000 0000 043d 4f31 (...(........=O1
9c96 0000 0000 0000 6000 0000 0000 0000 œ–......`.......
8000 0000 0200 0000 2700 0000 0000 0000 €.......'.......
0010 0000 2000 0000 0100 0000 2800 0400 .... .......(...
58e8 560f 3000 5601 XèV.0.V.
2005-02-24-01.50.28.631000 Instance:PROD Node:000
PID:1852(db2syscs.exe) TID:1696 Appid:*LOCAL.PROD.050223233749
buffer_pool_services sqlbReadPage Probe:71 Database:OPRSADB
** Failure on first attempt to read the page ** aab5 ffff ªµÿÿ
Can anybody shed some light on this please. I’ll appreciate any help.
Thanks so much
Kotie
Kotie Hurter
DB2 Database Administrator
Experian S.A
--------------------------------------------
Tel: +27 (0)11 799 3485
Fax: +27 (0)11 7993451
Cell: +27 (0)82 468 8609
--------------------------------------------
[Email address protected] <BLOCKED::mailto:[Email address protected]
www.experian.co.za <BLOCKED::http://www.experian.co.za/>
www.experian-scorex.co.za
Access your credit report online and receive SMS/email credit report alerts visit www.siyazwana.co.za <BLOCKED::http://www.siyazwana.co.za/>
Information contained in this email and any attachment thereto is confidential and may not be copied or used by anyone other than the addressee, nor disclosed to any third party without prior written consent. There is no intention to create any legally binding contract or other commitment through the use of this email. Experian Limited (Company Registration number 1993/004542/10) and its group of companies. Registered office : Experian House, The Ambridge, Vrede Avenue, Douglasdale, South Africa
DB2 & UDB email list listserv db2-l LazyDBA home page