|
Problem IC66073
|
Status: Geschlossen |
LOCK TABLE CREATES AN IS LOCK ON SYSIBM.SYSUSERAUTH IN ADDITION TO THE TABLE LOCK REQUESTED |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problembeschreibung: |
A LOCK TABLE statement does not only lock the table in
question. In addition an IS lock is created on
SYSIBM.SYSUSERAUTH, which will be kept till the end of
transaction.
This APAR will avoid the additional IS lock on SYSUSERAUTH. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Problem Description above. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V9.1 Fix Pack 10. *
**************************************************************** |
| Local-Fix: |
Executing the LOCK TABLE statement as DBADM will not create the
additional lock on SYSUSERAUTH. |
| verfügbare FixPacks: |
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Lösung |
First fixed in DB2 V9.1 Fix Pack 10. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 04.02.2010
16.06.2011
16.06.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.1.FP10
|
| Problem behoben lt. FixList in der Version |
| 9.1.0.10
|
 |
