DB2 - Problembeschreibung
Problem IC65846 | Status: Geschlossen |
LOCK TABLE CREATES AN IS LOCK ON SYSIBM.SYSUSERAUTH IN ADDITION TO THE TABLE LOCK REQUESTED | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - 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 AFFETCED: All PROBLEM DESCRIPTION: See ERROR DESCRIPTION PROBLEM SUMMARY: See ERROR DESCRIPTION | |
Local-Fix: | |
Executing the LOCK TABLE statement as DBADM will not create the additional lock on SYSUSERAUTH. | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in Version 9.5 Fix Pack 6. | |
Workaround | |
See LOCAL FIX. | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC66073 IC66074 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 26.01.2010 10.09.2010 10.09.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP6 | |
Problem behoben lt. FixList in der Version |