If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > The reason cause this error message?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-19-11, 23:11
dba.zhif dba.zhif is offline
Registered User
 
Join Date: Aug 2010
Posts: 7
Talking The reason cause this error message?

Hi all,

If any body knows the reason cause the following error message from my db2diag.log file?

2011-01-14-02.03.20.426729-300 I1141235G422 LEVEL: Severe
PID : 12797 TID : 3086329536 PROC : db2agent (instance)
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-1173 APPID: *LOCAL.db2inst1.110114070317
FUNCTION: DB2 UDB, base sys utilities, sqleForceAgents, probe:15
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0xBFB68F20 : CE04 0000 ....


PS. My db2level information is as below,

DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08029"
with level identifier "030A0106".
Informational tokens are "DB2 v8.1.2.156", "s080813", "MI00283", and FixPak
"17".
Product is installed at "/opt/IBM/db2/V8.1".

Thanks,
zhif
Reply With Quote
  #2 (permalink)  
Old 01-20-11, 03:14
nvk@vhv nvk@vhv is offline
Registered User
 
Join Date: Jan 2010
Posts: 294
Hi!

> db2diag -rc 0xBFB68F20

Input ECF string '0xBFB68F20' parsed as 0xBFB68F20 (-1078554848).

ZRC value to map: 0xBFB68F20 (-1078554848)

ZRC class :
Unknown class (Class Index: 63)
Component:
; (Component Index: 182)
Reason Code:
36640 (0x8F20)

Identifer:
ERROR: no mapping found
Identifer (without component):
ERROR: no mapping found

Description:
No known description

Associated information:
Sqlcode -901
SQL0901N The SQL statement failed because of a non-severe system error.
Subsequent SQL statements can be processed. (Reason "".)

Number of sqlca tokens : 1
Diaglog message number: 1



Attempting to lookup value 0xBFB68F20 (-1078554848) as a sqlcode
No sqlcode message found for value -1078554848

-----------------------------------------------------------
The error code provided, 0xBFB68F20 (-1078554848), is not recognized as :
1. a valid ECF error code
2. a valid ZRC value
3. a valid sqlcode.
Attempting to byte reverse the given error code ...
-----------------------------------------------------------
Reply With Quote
  #3 (permalink)  
Old 01-25-11, 21:08
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
I think this message means: force application command returned sql1230w. Not sure why the level is Severe.
Reply With Quote
  #4 (permalink)  
Old 01-27-11, 14:55
stolze stolze is offline
Registered User
 
Join Date: Jan 2007
Location: Jena, Germany
Posts: 2,662
I'm not quite sure why you try to pass the address 0xBFB68F20 to "db2diag -rc". The 0x04CE = 1230 is the interesting part and that is just a warning.
__________________
Knut Stolze
IBM DB2 Analytics Accelerator
IBM Germany Research & Development
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On