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

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.