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..

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

if you are new- there is a good book in db2 lib - troubleshooting...