Can someone help out on this problem we have or someone encouter this simiar issue? We are replicated data from MVS DB2 to Oracle 10G.
Lately we often getting sql1476 with sqlcode "-430". I open a PMR with IBM but no answer yet.
Here is the apply program trace logs:
*** SQL ERROR ***: SQL1476N The current transaction was rolled back because of error "-430". SQLSTATE=40506
DOINS: insert_string is INSERT INTO "DJRADM"."TGT002_TRNSM_BATCH" ("IBMSNAP_OPERATION", "IBMSNAP_INTENTSEQ", "IBMSNAP_COMMITSEQ",
"IBMSNAP_LOGMARKER", "NBR", "FK_CREATION_DT", "SENDER_BIC_ADR", "PRCSD_IND") VALUES(?, ?, ?, ?, ?, ?, ?, ?)
------------ Sqlda for INSERT (DOINS:2) -----------
sqldaid:
+00000000 00000000 002b0000 | + |
sqldabc: 1952
sqln: 44
sqld: 8
Here is db2diag.log indicated:
2008-01-24-13.33.21.338000-300 I436227H469 LEVEL: Warning
PID : 4840 TID : 3848 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : PDDRP
APPHDL : 0-855 APPID: *LOCAL.DB2.080410175051
FUNCTION: DB2 UDB, relation data serv, sqlrr_rollback_with_sqlcode, probe:60
MESSAGE : NLI or DMS force ROLLBACK
DATA #1 : Hexdump, 4 bytes
0x0475F934 : 0100 0200 ....
2008-01-24-13.33.21.338000-300 I436698H469 LEVEL: Warning
PID : 4840 TID : 5684 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : PDDRP
APPHDL : 0-812 APPID: *LOCAL.DB2.080410175055
FUNCTION: DB2 UDB, relation data serv, sqlrr_rollback_with_sqlcode, probe:60
MESSAGE : NLI or DMS force ROLLBACK
DATA #1 : Hexdump, 4 bytes
0x04C32FC4 : 0100 0200 ....
2008-01-24-13.33.21.338000-300 I437169H424 LEVEL: Error
PID : 4840 TID : 1404 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : PDDRP
APPHDL : 0-859 APPID: *LOCAL.DB2.080410175124
FUNCTION: DB2 UDB, Query Gateway, sqlqg_Call_FMP_Thread, probe:911
RETCODE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT
"SQLCA has already been built"
2008-01-24-13.33.21.338000-300 I437595H397 LEVEL: Warning
PID : 4840 TID : 3588 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : PDDRP
APPHDL : 0-828 APPID: *LOCAL.DB2.080410175035
MESSAGE : Removing FMP from pool
DATA #1 : Hexdump, 12 bytes
0x04289030 : 808C 8804 141A 0000 0000 0000 ............
2008-01-24-13.33.21.338000-300 I437994H711 LEVEL: Warning
PID : 4840 TID : 3848 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : PDDRP
APPHDL : 0-855 APPID: *LOCAL.DB2.080410175051
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -430 sqlerrml: 19
sqlerrmc: FedFmp abnormal end
sqlerrp : SQLRI223
sqlerrd : (1) 0x801A006D (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFFF6 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2008-01-24-13.33.21.338000-300 I438707H711 LEVEL: Warning
PID : 4840 TID : 5684 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : PDDRP
APPHDL : 0-812 APPID: *LOCAL.DB2.080410175055
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -430 sqlerrml: 19
sqlerrmc: FedFmp abnormal end
sqlerrp : SQLRI223
sqlerrd : (1) 0x801A006D (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFFF6 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Thanks
Ken