DB2 - Problembeschreibung
Problem IT08292 | Status: Geschlossen |
CONCURRENT LOAD FROM REMOTE CURSOR MAY FAIL WITH SQL3508N ON WINDOWS PLATFORM. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
For LOAD Remote Fetch (i.e. load from remote cursor), LOAD spawns/creates a process (db2lueff.exe) to fetch data from the cursor. However, the child process may inherit file handles including "load.msg" from its parent process (db2sysc.exe) on Windows, so that one LOAD may fail to delete its own "load.msg" while "db2lueff.exe" spawned by another concurrent LOAD in the same instance inherits the file handle. Here is a sample error output in db2diag.log: 2015-03-12-21.40.17.311000+540 I9259371F583 LEVEL: Error PID : 1980 TID : 7464 PROC : db2syscs.exe INSTANCE: DB2_01 NODE : 000 DB : P06024 APPHDL : 0-672 APPID: *LOCAL.DB2_01.150312123956 AUTHID : ADMINISTRATOR HOSTNAME: WINDOWS1 EDUID : 7464 EDUNAME: db2agent (SAMPLE) 0 FUNCTION: DB2 UDB, database utilities, sqluReportErrToDiag, probe:0 MESSAGE : Error deleting message file , -2029060074, 0000000000000000, Detected in file:sqluqagt.C, Line:1777 2015-03-12-21.40.17.311000+540 I9259956F1152 LEVEL: Error PID : 1980 TID : 7464 PROC : db2syscs.exe INSTANCE: DB2_01 NODE : 000 DB : P06024 APPHDL : 0-672 APPID: *LOCAL.DB2_01.150312123956 AUTHID : ADMINISTRATOR HOSTNAME: WINDOWS1 EDUID : 7464 EDUNAME: db2agent (SAMPLE) 0 FUNCTION: DB2 UDB, database utilities, sqluqagt, probe:1779 MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT "SQLCA has already been built" DATA #1 : String, 0 bytes Object not dumped: Address: 0x0000000000000000 Size: 0 Reason: Address is NULL DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -3508 sqlerrml: 70 sqlerrmc: TEMP_FILE 6 C:\DB2_01\NODE0000\SQL00001\load\DB200003.PID\DB200004.OID sqlerrp : SQLUQAGT sqlerrd : (1) 0x8015006D (2) 0x00000000 (3) 0x00000000 (4) 0x00000000 (5) 0x00000000 (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Windows user. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.5 Fix Pack 7. * **************************************************************** | |
Local-Fix: | |
Issue LOAD serially. | |
Lösung | |
First fixed in DB2 Version 10.5 Fix Pack 7. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 14.04.2015 28.01.2016 28.01.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.7 |