home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC65838 Status: Geschlossen

EXTENT MOVEMENT FAILS WITH SQLE_RC_DUP_TASK_ID "THIS TASK ID
ALREADY EXISTS"

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
A single DB2 UDB instance contains multiple databases. On each 
such database there has been an operation requiring an extent 
movement, for example a new container has been added to a 
tablespace. If the respective extent movement operations start 
at around same time, and if the tablespaces where the extent 
movement is about to begin share the same tablespace ID, the 
extent movement may fail with an SQLE_RC_DUP_TASK_ID error 
reported by "sqlbSpawnExtentMovementIcoord, probe:5015", 
indicating that a duplicate extent movement task has been 
submitted. A sample db2diag.log message: 
 
2009-12-03-14.57.12.915728-300 I251906E516         LEVEL: Severe 
PID     : 18874                TID  : 479610986765 PROC : 
db2sysc 
INSTANCE: db2inst1              NODE: 000          DB   : SAMPLE 
APPHDL  : 0-266                APPID: 
*LOCAL.db2inst1.091203195635 
AUTHID  : DB2INST1 
EDUID   : 168                  EDUNAME: db2agent (SAMPLE) 
FUNCTION: DB2 UDB, buffer pool services, 
sqlbSpawnExtentMovementIcoord, probe:5015 
MESSAGE : ZRC=0x80050153=-2147155629=SQLE_RC_DUP_TASK_ID 
          "This task ID already exists" 
 
This is a timing dependent error. The fundamental problem is 
that extent movement tasks are currently using an identifier 
that is not sufficiently unique. The purpose is to improve the 
design of the task identifier.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* see APAR description                                         * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Problem first fixed in DB2 UDB 9.7 FixPak 2.                 * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
see APAR description
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
25.01.2010
13.05.2010
13.05.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.
Problem behoben lt. FixList in der Version
9.7.0.2 FixList