Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2011
    Posts
    1

    Unanswered: facing error messages related to db2fmp.exe

    2011-12-15-04.33.52.915000+330 I30764837H925 LEVEL: Error
    PID : 1076 TID : 9672 PROC : db2fmp.exe
    INSTANCE: DB2 NODE : 000
    FUNCTION: DB2 UDB, oper system services, sqlofica, probe:10
    DATA #1 : Hexdump, 136 bytes
    0x001174D4 : 5351 4C43 4120 2020 8800 0000 0BFE FFFF SQLCA ........
    0x001174E4 : 0000 2020 2020 2020 2020 2020 2020 2020 ..
    0x001174F4 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x00117504 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x00117514 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x00117524 : 2020 2020 2020 2020 5351 4C41 4341 4C4C SQLACALL
    0x00117534 : 8C00 0080 8C00 0000 0000 0000 0000 0000 ................
    0x00117544 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
    0x00117554 : 2020 2032 3435 3031 24501


    I have already updated the diaglevel at 4 but not getting clue

    its db2 v8.2 system

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    DB2 V8.2 is out of service for years already. You may want to consider upgrading to a more recent, supported version.

    Anyway, what you see there is the output of a SQLCA (SQL communication area). The SQLCode is 0BFE FFFF, which is SQLCODE -501: SQL0501N The short version is that you try to use a cursor, which is not opened. Maybe a ROLLBACK occurred on the connection or the cursor is not WITH HOLD and you did a COMMIT, or you never opened the cursor before fetching from it.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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