Home

Latest versions	fixlist
11.1.0.7
10.5.0.9
10.1.0.6
9.8.0.5
9.7.0.11
9.5.0.10
9.1.0.12

Have problems? - contact us.
Register for free
Contact form

DB2 - Problem description

Problem IC69849	Status: Closed
IN DPF ENVIRONMENT, DB2 V9.1 USERS WITH XA CONNECTIONS MAY GET SQL901 CONTAINING "USERTEMP ENTRY NOT FOUND!" MESSAGE
product:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problem description:
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
Problem Summary:
**************************************************************** * USERS AFFECTED: * * All the users in DPF environment on only V9.1 * **************************************************************** * PROBLEM DESCRIPTION: * * See APAR description * **************************************************************** * RECOMMENDATION: * * Upgrade to IBM DB2 V9.1 Fixpack 10 * ****************************************************************
Local Fix:

available fix packs:
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
Solution
Fixed in V9.1 Fixpack 10
Workaround
not known / see Local fix
Timestamps
Date - problem reported : Date - problem closed : Date - last modified :	12.07.2010 20.06.2011 20.06.2011
Problem solved at the following versions (IBM BugInfos)
9.1.FP10
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.10