Results 1 to 3 of 3
  1. #1
    Join Date
    May 2010
    Posts
    1

    Unanswered: db2diag errors...any idea??

    Hello,

    Im newbe in db2...


    I have a lot of errors like this in db2diag....any ideas???


    2010-07-12-23.10.11.654814-300 I6538612E1073 LEVEL: Error
    PID : 19456 TID : 182968473088PROC : db2agent (PRD) 0
    INSTANCE: db2prd NODE : 000 DB : PRD
    APPHDL : 0-51 APPID: *LOCAL.db2prd.100713035751
    FUNCTION: DB2 UDB, oper system services, sqlofica, probe:10
    DATA #1 : Hexdump, 136 bytes
    0x0000002A95589368 : 5351 4C43 4120 2020 8800 0000 DDFC FFFF SQLCA ........
    0x0000002A95589378 : 1100 31FF 5341 5050 5244 2E54 5350 4556 ..1.SAPPRD.TSPEV
    0x0000002A95589388 : 4A4F 4220 2020 2020 2020 2020 2020 2020 JOB
    0x0000002A95589398 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x0000002A955893A8 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x0000002A955893B8 : 2020 2020 2020 2020 5351 4C44 4D49 5352 SQLDMISR
    0x0000002A955893C8 : 0500 0980 0500 0000 0000 0000 0000 0000 ................
    0x0000002A955893D8 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
    0x0000002A955893E8 : 2020 2032 3335 3035 23505

    2010-07-12-23.10.11.655216-300 I6539686E1073 LEVEL: Error
    PID : 19456 TID : 182968473088PROC : db2agent (PRD) 0
    INSTANCE: db2prd NODE : 000 DB : PRD
    APPHDL : 0-51 APPID: *LOCAL.db2prd.100713035751
    FUNCTION: DB2 UDB, oper system services, sqlofica, probe:10
    DATA #1 : Hexdump, 136 bytes
    0x0000002A95589368 : 5351 4C43 4120 2020 8800 0000 DDFC FFFF SQLCA ........
    0x0000002A95589378 : 1100 31FF 5341 5050 5244 2E54 5350 4556 ..1.SAPPRD.TSPEV
    0x0000002A95589388 : 4A4F 4220 2020 2020 2020 2020 2020 2020 JOB
    0x0000002A95589398 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x0000002A955893A8 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x0000002A955893B8 : 2020 2020 2020 2020 5351 4C44 4D49 5352 SQLDMISR
    0x0000002A955893C8 : 0500 0980 0500 0000 0000 0000 0000 0000 ................
    0x0000002A955893D8 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
    0x0000002A955893E8 : 2020 2032 3335 3035 23505

    2010-07-12-23.10.11.993131-300 I6540760E1073 LEVEL: Error
    PID : 19456 TID : 182968473088PROC : db2agent (PRD) 0
    INSTANCE: db2prd NODE : 000 DB : PRD
    APPHDL : 0-51 APPID: *LOCAL.db2prd.100713035751
    FUNCTION: DB2 UDB, oper system services, sqlofica, probe:10
    DATA #1 : Hexdump, 136 bytes
    0x0000002A95589368 : 5351 4C43 4120 2020 8800 0000 DDFC FFFF SQLCA ........
    0x0000002A95589378 : 1100 31FF 5341 5050 5244 2E54 5350 4556 ..1.SAPPRD.TSPEV
    0x0000002A95589388 : 4A4F 4220 2020 2020 2020 2020 2020 2020 JOB
    0x0000002A95589398 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x0000002A955893A8 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x0000002A955893B8 : 2020 2020 2020 2020 5351 4C44 4D49 5352 SQLDMISR
    0x0000002A955893C8 : 0500 0980 0500 0000 0000 0000 0000 0000 ................
    0x0000002A955893D8 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
    0x0000002A955893E8 : 2020 2032 3335 3035 23505



    Thanks in advance..

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368
    DDFC FFFF -> FFFFFCDD


    $ db2diag -rc FFFFFCDD

    Input ECF string 'FFFFFCDD' parsed as 0xFFFFFCDD (-803).
    NOTE: ../sqz/sqlzwhatisrc.C:
    V7 input ZRC 0xFFFFFCDD (-803) may translate to V8 ZRC value of 0x83000CDD (-2097148707)

    ZRC value to map: 0x83000CDD (-2097148707)
    V7 Equivalent ZRC value: 0xFFFFBCDD (-17187)

    ZRC class :
    Unexpected Operating System error (Class Index: 3)
    Component:
    Unknown component (Component Index: 0)
    Undefined as of DB2 v9.5.0.5; s091123
    Operating system reason code (errno):
    0x00000CDD (3293) = Error 3293 occurred.
    NOTE: Errno value 3293 is excessively large.
    It is possible that this error code is not a ZRC value.



    Attempting to lookup value 0xFFFFFCDD (-803) as a sqlcode
    Sqlcode -803
    SQL0803N One or more values in the INSERT statement, UPDATE statement, or
    foreign key update caused by a DELETE statement are not valid because the
    primary key, unique constraint or unique index identified by "" constrains
    table "" from having duplicate values for the index key.



    If you diaglevel is set to 4, reduce it to 3

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    if you are new- there is a good book in db2 lib - troubleshooting...
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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