In DPF environment, XA connection may get userTemp entry not
found!" message when transaction rolls back with Global
temporary table defined .
db2diag.log shows following message:
2010-06-18-00.05.06.477185-300 I1188135A465 LEVEL: Error
PID : 1 TID : 1 PROC :
db2agntp (DB2ADMIN) 7
INSTANCE: db2admn NODE : 007 DB :
DB2ADMIN
APPHDL : 901-996 APPID: 10.0.0.1.57832.10061816000
AUTHID : DB2ADMIN
FUNCTION: DB2 UDB, relation data serv, sqlrr_logUndo, probe:40
DATA #1 : String, 82 bytes
userTemp entry not found!
logrec->data.log1.tid = :6
logrec->data.log1.fid = :2
2010-06-22-14.26.50.403277-300 I504832A403LEVEL: Severe
PID : 1 TID : 1 PROC : db2agntp
(DB2ADMIN) 7
INSTANCE: db2admn NODE : 007 DB :
DB2ADMIN
APPHDL : 901-996 APPID:
10.0.0.1.57832.10061816000
AUTHID : DB2ADMIN
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:20
RETCODE : ZRC=0x00000000=0=PSM_OK "Unknown"
2010-06-22-14.26.50.407837-300 I505236A799 LEVEL: Severe
PID : 4837410 TID : 1 PROC :
db2agntp (DB2ADMIN) 6
INSTANCE: db2admn NODE : 007 DB :
DB2ADMIN
APPHDL : 901-996 APPID:
10.0.0.1.57832.10061816000
AUTHID : DB2ADMIN
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data, probe:0
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 25
sqlerrmc: userTemp entry not found!
sqlerrp : SQLRR0E0
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFFD8 (6) 0x00000006
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
stack on data node will show
0 sqloDumpEDU
1 sqldDumpContext
2 sqlrr_dump_ffdc
3 sqlzeDumpFFDC
4 sqlzeSqlCode
5 sqlrrSqlCode
6 sqlrr_logUndo
7 sqldmund
8 sqlptudo
9 sqlptud1
10 sqlpxrbk
11 sqlrr_tran_router
12 sqlrr_subagent_router
13 sqleSubRequestRouter
This APAR only applies for v9.1 in DPF environment. It is
already fixed in v9.5 |
