There is a possibility if the rollback request was interrupted,
it
may result in PDB System Controller on remote node to send -952
to coord node.
e.g.
At node 0, RDS received a failure on rollback request (i.e.
sqlcode -952) from node 1. This unexpected failure causing
database to be marked bad.
The db2diag.log may have the following messages:
2011-08-29-11.15.12.813187+540 I31107A462 LEVEL: Error
PID : 40435774 TID : 74084 PROC :
db2sysc 0
INSTANCE: pmninst NODE : 000 DB : TPCC
APPHDL : 0-1499 APPID: *N0.pmninst.110829021924
AUTHID : PMNINST
EDUID : 74084 EDUNAME: db2agent (TPCC) 0
FUNCTION: DB2 UDB, relation data serv, sqlrkrbk, probe:100
MESSAGE : Node 1 fails on tranReqType 102 and tranRplyType is
305
102 SQLR_PE_TRAN_ROLLBACK, 305 SQLR_PE_TRAN_ERROR_ACK
2011-08-29-11.15.12.813740+540 I31570A435 LEVEL: Error
PID : 40435774 TID : 74084 PROC :
db2sysc 0
INSTANCE: pmninst NODE : 000 DB : TPCC
APPHDL : 0-1499 APPID: *N0.pmninst.110829021924
AUTHID : PMNINST
EDUID : 74084 EDUNAME: db2agent (TPCC) 0
FUNCTION: DB2 UDB, relation data serv, sqlrkrbk, probe:150
MESSAGE : numNodeReply is 3 and i is 2
2011-08-29-11.15.12.814045+540 I32006A1096 LEVEL:
Severe
PID : 40435774 TID : 74084 PROC :
db2sysc 0
INSTANCE: pmninst NODE : 000 DB : TPCC
APPHDL : 0-1499 APPID: *N0.pmninst.110829021924
AUTHID : PMNINST
EDUID : 74084 EDUNAME: db2agent (TPCC) 0
FUNCTION: DB2 UDB, relation data serv, sqlrkrbk, probe:200
MESSAGE : cur_tnl_node :
DATA #1 : Hexdump, 125 bytes
0x0A000200014F4F3E : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x0A000200014F4F4E : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x0A000200014F4F5E : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x0A000200014F4F6E : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x0A000200014F4F7E : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x0A000200014F4F8E : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x0A000200014F4F9E : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x0A000200014F4FAE : 0000 0000 0000 0000 0000 0000 00
.............
2011-08-29-11.15.12.827549+540 I41735A817 LEVEL:
Severe
PID : 40435774 TID : 74084 PROC :
db2sysc 0
INSTANCE: pmninst NODE : 000 DB : TPCC
APPHDL : 0-1499 APPID: *N0.pmninst.110829021924
AUTHID : PMNINST
EDUID : 74084 EDUNAME: db2agent (TPCC) 0
FUNCTION: DB2 UDB, relation data serv, sqlrrSqlCode, probe:15
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -952 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLEKPDB
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0x00000000 (6)
0x00000001
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2011-08-29-11.15.12.899111+540 E42553A764 LEVEL: Error
PID : 40435774 TID : 74084 PROC :
db2sysc 0
INSTANCE: pmninst NODE : 000 DB : TPCC
APPHDL : 0-1499 APPID: *N0.pmninst.110829021924
AUTHID : PMNINST
EDUID : 74084 EDUNAME: db2agent (TPCC) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:30
MESSAGE : ADM14005E The following error occurred: "AppErr".
First Occurrence
Data Capture (FODC) has been invoked in the following
mode:
"Automatic". Diagnostic information has been recorded
in the
directory named
"/home/pmninst/sqllib/db2dump/FODC_AppErr_2011-08-29-11.15.12.87
0768_
40435774_74084_000/".
2011-08-29-11.15.13.172606+540 I45110A851 LEVEL:
Severe
PID : 40435774 TID : 74084 PROC :
db2sysc 0
INSTANCE: pmninst NODE : 000 DB : TPCC
APPHDL : 0-1499 APPID: *N0.pmninst.110829021924
AUTHID : PMNINST
EDUID : 74084 EDUNAME: db2agent (TPCC) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
probe:300
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 29
sqlerrmc: numNodeReply is 3 and i is 2
sqlerrp : SQLRR069
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0xFFFFFED4 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2011-08-29-11.15.14.600092+540 I175370A2425 LEVEL:
Severe
PID : 40435774 TID : 74084 PROC :
db2sysc 0
INSTANCE: pmninst NODE : 000 DB : TPCC
APPHDL : 0-1499 APPID: *N0.pmninst.110829021924
AUTHID : PMNINST
EDUID : 74084 EDUNAME: db2agent (TPCC) 0
FUNCTION: DB2 UDB, global services, sqlzeMapZrc, probe:15
MESSAGE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT
"SQLCA has already been built"
DATA #1 : String, 30 bytes
SQL_RC_E984 overwrites SQLCODE
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 29
sqlerrmc: numNodeReply is 3 and i is 2
sqlerrp : SQLRR069
sqlerrd : (1) 0x801A006D (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0xFFFFFED4 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
CALLSTCK:
[0] 0x0900000004EDB6EC pdLog@glue678 + 0xD4
[1] 0x090000000474CED4
sqlzeMapZrc__FP8sqeAgentUiUlT2P5sqlcaiPC12sqlzeContextb + 0x3D4
[2] 0x09000000052417C0 sqlrrMapZrc__FP8sqlrr_cbUiUli@glue61B +
0x80
[3] 0x09000000041A6F44
sqlrrbck_dps__FP8sqlrr_cbiN22P15SQLXA_CALL_INFOP9SQLP_GXIDb +
0xE0
[4] 0x09000000051FBFF4
sqlrrbck__FP8sqlrr_cbiN32P15SQLXA_CALL_INFO + 0x9D8
[5] 0x09000000051FB45C sqlrr_rollback__FP14db2UCinterface +
0xB8
[6] 0x090000000536EEF4
sqljs_ddm_rdbrllbck__FP14db2UCinterfaceP13sqljDDMObject + 0x330
[7] 0x090000000536EAF0
sqljs_ddm_rdbrllbck__FP14db2UCinterfaceP13sqljDDMObject@glue1D68
+ 0x74
[8] 0x090000000536EA0C
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface
+ 0x50
[9] 0x0900000005123380
.sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb.fdpr.
clone.220
+ 0x390
[10] 0x0900000005121A84
@69@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x23C
[11] 0x09000000052291A8
@69@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xA8
[12] 0x0900000005228E24
@69@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x38C
[13] 0x09000000052289D4
sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0xE8
[14] 0x0900000004ECF224 RunEDU__8sqeAgentFv + 0x148
[15] 0x0900000004EC9CC4 EDUDriver__9sqzEDUObjFv + 0x2E4
[16] 0x0900000004ED5924 sqloEDUEntry + 0x2E8
[17] 0x0900000000C24E10 _pthread_body + 0xF0
[18] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF
2011-08-29-11.15.14.876525+540 I202840A858 LEVEL:
Severe
PID : 40435774 TID : 74084 PROC :
db2sysc 0
INSTANCE: pmninst NODE : 000 DB : TPCC
APPHDL : 0-1499 APPID: *N0.pmninst.110829021924
AUTHID : PMNINST
EDUID : 74084 EDUNAME: db2agent (TPCC) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_rds_common_post,
probe:2100
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -984 sqlerrml: 29
sqlerrmc: numNodeReply is 3 and i is 2
sqlerrp : SQLRR069
sqlerrd : (1) 0x801A006D (2) 0xFFFFFC7B (3)
0x00000000
(4) 0x00000000 (5) 0xFFFFFED4 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: |
