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 IC88167 Status: Closed

Load Remote Fetch might trap and crash DB2 instance during the INDEX COPY
phase

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
When loading from cursor with database option (Load Remote 
Fetch), if there is no DELETE phase, Load might trap and crash 
DB2 instance during the INDEX COPY phase. 
 
You can see the following errors from db2diag.log: 
 
2012-10-29-13.39.00.277586-300 I3210667A579       LEVEL: Error 
PID     : 18022488             TID  : 1           PROC : 
db2lueff 
INSTANCE: sample             NODE : 000 
APPID   : 157.146.32.89.45390.121029183900 
EDUID   : 1 
FUNCTION: DB2 UDB, database utilities, sqluffOpenOutputStream, 
probe:283 
MESSAGE : ZRC=0x820F0002=-2112946174=SQLO_INV_MEM "Invalid 
memory addr" 
          DIA8561C A invalid memory block was encountered. 
DATA #1 : String, 0 bytes 
Object not dumped: Address: 0x0000000000000000 Size: 0 Reason: 
Address is NULL 
DATA #2 : File name, 13 bytes 
sqluueffApp.C 
 
2012-10-29-13.39.00.289921-300 I3211247A623       LEVEL: Error 
PID     : 18022488             TID  : 1           PROC : 
db2lueff 
INSTANCE: sample             NODE : 000 
APPID   : 157.146.32.89.45390.121029183900 
EDUID   : 1 
FUNCTION: DB2 UDB, database utilities, sqluffMain, probe:2321 
MESSAGE : ZRC=0x820F0002=-2112946174=SQLO_INV_MEM "Invalid 
memory addr" 
          DIA8561C A invalid memory block was encountered. 
DATA #1 : String, 0 bytes 
Object not dumped: Address: 0x0000000000000000 Size: 0 Reason: 
Address is NULL 
DATA #2 : File name, 13 bytes 
sqluueffApp.C 
DATA #3 : String, 27 bytes 
Error opening output stream 
 
... ... 
 
2012-10-29-13.39.00.291626-300 I3213616A504       LEVEL: Warning 
PID     : 44957714             TID  : 14253       PROC : db2sysc 
0 
INSTANCE: sample             NODE : 000         DB   : SAMPLE 
APPHDL  : 0-30372              APPID: 
*LOCAL.db2ppp1p.121029173618 
AUTHID  : SAMPLE 
EDUID   : 14253                EDUNAME: db2lurex 0 
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0 
DATA #1 : String, 83 bytes 
LOADID: 9112.2012-10-29-12.36.22.735144.0 (8;961) 
UserExitSA is done -2145779603, 0 
 
... ... 
 
2012-10-29-13.39.00.298634-300 I3215719A775       LEVEL: Error 
PID     : 44957714             TID  : 14253       PROC : db2sysc 
0 
INSTANCE: sample             NODE : 000 
EDUID   : 14253                EDUNAME: db2lurex 0 
FUNCTION: DB2 UDB, database utilities, 
sqlusCUserExitSubAgent::iRun, probe:1394 
MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT 
          "SQLCA has already been built" 
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes 
LOADID: 9112.2012-10-29-12.36.22.735144.0 (8;961) 
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes 
 sqlcaid :           sqlcabc: 0   sqlcode: -83   sqlerrml: 0 
 sqlerrmc: 
 sqlerrp : SQLUFFAP 
 sqlerrd : (1) 0x8015006D      (2) 0x00000000      (3) 
0x00000000 
           (4) 0x00000000      (5) 0x00000000      (6) 
0x00000000 
 sqlwarn : (1) 
 
... ... 
 
2012-10-29-13.39.20.618199-300 I3218219A514       LEVEL: Warning 
PID     : 44957714             TID  : 9112        PROC : db2sysc 
0 
INSTANCE: sample             NODE : 000         DB   : SAMPLE 
APPHDL  : 0-30372              APPID: 
*LOCAL.db2ppp1p.121029173618 
AUTHID  : SAMPLE 
EDUID   : 9112                 EDUNAME: db2agent (DB2PPP1P) 0 
FUNCTION: DB2 UDB, RAS/PD component, 
pdEDUIsInDB2KernelOperation, probe:600 
DATA #1 : String, 33 bytes 
 bCleanUp__20sqluCMediaListServer 
DATA #2 : String, 4 bytes 
sqlu 
 
The stack trace looks like the following: 
 
  sqluCMediaListServer::bCleanUp 
  sqluCleanupUserExitPipes 
  sqluCleanupUserExitCB 
  sqluAppCbCleanup 
  sqluCommitCallBack 
  sqlrrcom_dps 
  sqlrrcom 
  sqlrr_commit 
  sqluv_commit 
  sqlu_register_table_load 
  sqluvtld_route_in
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users using Load Remote Fetch with the INDEX COPY phase      * 
* might be affected.                                           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to fix pack 8 of DB2 v9.7 or later.                  * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
First fixed in fix pack 8 of DB2 v9.7.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC88474 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
12.11.2012
23.09.2013
23.09.2013
Problem solved at the following versions (IBM BugInfos)
9.7.
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.8 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.