Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2010
    Posts
    7

    Talking Unanswered: 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

  2. #2
    Join Date
    Jan 2010
    Posts
    335
    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 ...
    -----------------------------------------------------------

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    I think this message means: force application command returned sql1230w. Not sure why the level is Severe.

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    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

Posting Permissions

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