Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.