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 IC93384 Status: Geschlossen

CONCURRENT CREATE/ALTER TABLE STATEMENTS CONTAINING "GENERATED ALWAYS
AS IDENTITY" COLUMN MIGHT END UP WITH AN INFINITE LOOP

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
Concurrent CREATE TABLE statements, containing GENERATED ALWAYS 
AS IDENTITY column: 
 
CREATE TABLE T1 ( 
    C1 INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 
1,INCREMENT BY 1,CACHE 500), 
    C2 INTEGER, 
    ... 
) 
 
might end up with an infinite loop, causing an EDU to perform 
endlessly during processing of the insert statement into 
SYSIBM.SYSSEQUENCES table. 
 
Similar symptoms might be seen during execution of concurrent 
ALTER TABLE statements. 
Further, concurrent execution of CREATE SEQUENCE statements, 
might end up with the same problem. 
 
Once the issue occurs, you will notice in the traces: 
 
258            0.000356343   sqlrlCatalogScan::insert entry 
[eduid 55437 eduname db2agent] 
271            0.000382562   | sqlrinsr entry [eduid 55437 
eduname db2agent] 
272            0.000383853   | | sqldRowInsert entry [eduid 
55437 eduname db2agent] 
280            0.000391375   | | | sqldFullFormatFixedVar entry 
[eduid 55437 eduname db2agent] 
281            0.000394125   | | | | sqldFormatLobLongCol entry 
[eduid 55437 eduname db2agent] 
283            0.000395888   | | | | | sqldmadx entry [eduid 
55437 eduname db2agent] 
284            0.000397056   | | | | | | sqldxLobCreate entry 
[eduid 55437 eduname db2agent] 
288            0.000399843   | | | | | | | sqldxCreateLob entry 
[eduid 55437 eduname db2agent] 
291            0.000403281   | | | | | | | | sqldx_ld_extend 
entry [eduid 55437 eduname db2agent] 
292            0.000404570   | | | | | | | | | 
sqldx_ld_alloc_bsegs entry [eduid 55437 eduname db2agent] 
294            0.000407693   | | | | | | | | | | sqldxGetBseg 
entry [eduid 55437 eduname db2agent] 
303            0.000416812   | | | | | | | | | | | 
sqldxOuterRbsHunt entry [eduid 55437 eduname db2agent] 
312            0.000426392   | | | | | | | | | | | | 
sqldxRbsHunt entry [eduid 55437 eduname db2agent] 
313            0.000427312   | | | | | | | | | | | | | 
sqldxRBSFreePendDel entry [eduid 55437 eduname db2agent] 
314            0.000428062   | | | | | | | | | | | | | | 
sqlpInitBFI entry [eduid 55437 eduname db2agent] 
315            0.000428507   | | | | | | | | | | | | | | 
sqlpInitBFI exit 
316            0.000429312   | | | | | | | | | | | | | | 
sqldxFreePendDel entry [eduid 55437 eduname db2agent] 
317            0.000429853   | | | | | | | | | | | | | | 
sqldxFreePendDel exit [rc = 0x8748006D = -2025324435 = 
SQLDXE_NFOUND] 
318            0.000431101   | | | | | | | | | | | | | 
sqldxRBSFreePendDel exit 
319            0.000431423   | | | | | | | | | | | | 
sqldxRbsHunt exit [rc = 0x8748006D = -2025324435 = 
SQLDXE_NFOUND] 
320            0.000432343   | | | | | | | | | | | | 
sqldxRbsHunt entry [eduid 55437 eduname db2agent] 
321            0.000432625   | | | | | | | | | | | | 
sqldxRbsHunt exit [rc = 0x8748006D = -2025324435 = 
SQLDXE_NFOUND] 
322            0.000433304   | | | | | | | | | | | | 
sqldxRbsHunt entry [eduid 55437 eduname db2agent] 
... 
504            0.000529125   | | | | | | | | | | | | 
sqldxRbsHunt entry [eduid 55437 eduname db2agent] 
505            0.000529347   | | | | | | | | | | | | 
sqldxRbsHunt exit [rc = 0x8748006D = -2025324435 = 
SQLDXE_NFOUND] 
 
 
From this point, you will notice following sqldxRbsHunt blocks: 
 
506            0.000529955   | | | | | | | | | | | | 
sqldxRbsHunt entry [eduid 55437 eduname db2agent] 
507            0.000530222   | | | | | | | | | | | | | 
sqldxRBSFreePendDel entry [eduid 55437 eduname db2agent] 
508            0.000530775   | | | | | | | | | | | | | | 
sqlpInitBFI entry [eduid 55437 eduname db2agent] 
509            0.000530968   | | | | | | | | | | | | | | 
sqlpInitBFI exit 
510            0.000531531   | | | | | | | | | | | | | | 
sqldxFreePendDel entry [eduid 55437 eduname db2agent] 
511            0.000531748   | | | | | | | | | | | | | | 
sqldxFreePendDel exit [rc = 0x8748006D = -2025324435 = 
SQLDXE_NFOUND] 
512            0.000532308   | | | | | | | | | | | | | 
sqldxRBSFreePendDel exit 
513            0.000532533   | | | | | | | | | | | | 
sqldxRbsHunt exit [rc = 0x8748006D = -2025324435 = 
SQLDXE_NFOUND]
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.5 fixpack 1                        * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 10.5 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows

Lösung
Problem was first fixed in DB2 version 10.5 fixpack 1
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
25.06.2013
26.08.2013
26.08.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.1 FixList