Hi

i am running stored procedure and my db crashed on windows 2003 server..here are the details:

DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL08020" with
level identifier "03010106".
Informational tokens are "DB2 v8.1.7.664", "s040914", "WR21342", and FixPak
"7".
Product is installed at "D:\PROGRA~1\IBM\SQLLIB".

diaglog details:


2007-03-23-18.55.33.640000-360 I356665H346 LEVEL: Severe
PID : 3296 TID : 3308 PROC : db2fmp.exe
INSTANCE: DB2 NODE : 000
MESSAGE : Fenced mode process encountered an abnormal situation...terminating
DATA #1 : Hexdump, 4 bytes
0x03E22524 : 0000 0000 ....

2007-03-23-18.57.34.544000-300 I357013H1081 LEVEL: Severe
PID : 1796 TID : 1424 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : WEBPROD
APPHDL : 0-136 APPID: *LOCAL.DB2.070323235134
FUNCTION: DB2 UDB, common communication, sqlccIPCSignalDariEnd, probe:10
MESSAGE : FMP didn't respond in 10 seconds, initStruct =
DATA #1 : Hexdump, 132 bytes
0x1262CED0 : B0DF 4600 0000 0600 0001 0000 0100 0000 ..F.............
0x1262CEE0 : B0DF 4622 0000 0022 00C0 BE02 FFFF FF6F ..F"...".......o
0x1262CEF0 : 0200 0000 50E0 0100 0000 0000 B0F3 9001 ....P...........
0x1262CF00 : 0407 0000 D7EB 3CB1 B4F3 9001 0407 0000 ......<.........
0x1262CF10 : E7EB 3CB1 B8F3 9001 0407 0000 F6EB 3CB1 ..<...........<.
0x1262CF20 : 0000 0000 0100 0000 0000 0000 0100 0000 ................
0x1262CF30 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x1262CF40 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x1262CF50 : 0000 0000 ....

2007-03-23-18.57.34.544000-300 I358096H1611 LEVEL: Severe
PID : 1796 TID : 1424 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : WEBPROD
APPHDL : 0-136 APPID: *LOCAL.DB2.070323235134
FUNCTION: DB2 UDB, routine_infrastructure, sqlerCleanThreadResource, probe:1
MESSAGE : FMP process didn't respond for 10 seconds, fmpThread =
DATA #1 : Hexdump, 244 bytes
0x136D76C0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x136D76D0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x136D76E0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x136D76F0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x136D7700 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x136D7710 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x136D7720 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x136D7730 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x136D7740 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x136D7750 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x136D7760 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x136D7770 : 0000 0000 0000 0000 00F0 0000 0000 0000 ................
0x136D7780 : 0000 0000 04D2 0000 D204 0000 EC0C 0000 ................
0x136D7790 : C0EB 3112 D404 1D12 0000 0000 C004 1D12 ..1.............
0x136D77A0 : D0CE 6212 0000 0000 0100 0000 0000 0000 ..b.............
0x136D77B0 : 0000 0000 ....

2007-03-23-18.57.34.544000-300 I359709H1830 LEVEL: Severe
PID : 1796 TID : 1424 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : WEBPROD
APPHDL : 0-136 APPID: *LOCAL.DB2.070323235134
FUNCTION: DB2 UDB, routine_infrastructure, sqlerCleanThreadResource, probe:1
MESSAGE : FMP process didn't respond for 10 seconds, fmpRow =
DATA #1 : Hexdump, 292 bytes
0x121D04C0 : E00C 0000 0000 BD01 0000 0000 8000 BE01 ................
0x121D04D0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x121D04E0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x121D04F0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x121D0500 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x121D0510 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x121D0520 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x121D0530 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x121D0540 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x121D0550 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x121D0560 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x121D0570 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x121D0580 : 0000 0000 0000 0000 0000 0000 00F0 0000 ................
0x121D0590 : 9A00 0000 0000 0000 009D 0000 9A00 0000 ................
0x121D05A0 : 0000 0000 C0EB 3112 0000 0000 0000 0000 ......1.........
0x121D05B0 : C004 1D12 E00E 1D12 0000 0000 0000 0000 ................
0x121D05C0 : 0000 0000 0000 0000 307B 6D13 0052 D30F ........0{m..R..
0x121D05D0 : 40DF 3112 1300 0000 0000 0000 0200 1000 @.1.............
0x121D05E0 : E404 0100 ....

any help regarding this would be appreciated

Fixpack 7 is the first release of version 8.2. Being a first release, it has quite a few bugs. Please upgrade to the latest fixpack (FP14). There is no charge for fixpacks.
http://www-1.ibm.com/support/docview...id=swg21256235

thanks marcus..i will upgrade to FP14