|
Problem IC91219
|
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 / 970 - 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 9.7 fixpack 9 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
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
|
| Lösung |
Problem was first fixed in DB2 version 9.7 fixpack 9 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC91824 IC93384
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 02.04.2013
02.10.2013
02.10.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP9
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.9
|
 |
| 9.7.0.9
|
|
