Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2007
    Posts
    2

    Unanswered: help help ....stored procedure db crash

    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

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Mar 2007
    Posts
    2

    thx marcus

    thanks marcus..i will upgrade to FP14

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •