DB2 - Problembeschreibung
Problem IC73053 | Status: Geschlossen |
DROP AND CALL PROCEDURE STATEMENTS RUNNING CONCURRENTLY MAY DEADLOCK | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
While having two or more connections to the database if an attempt is made to drop a procedure, while another connection is calling or creating a procedure with the same name, though in a different schema, a deadlock may occur. This is to complete previous fix. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All DB2 for Linux, Unix and Windows Version 9.5 GA through * * Fix Pack 7 servers where concurrent create/drop stored * * procedures are running. * **************************************************************** * PROBLEM DESCRIPTION: * * Creating and dropping SQL procedures with the same name may * * hit deadlocks. The internal catalog access/locking strategy * * causes these issues. * **************************************************************** * RECOMMENDATION: * * Update your instance to DB2 Version 9.5 Fix Pack 8 or avoid * * creating and dropping SQL procedures concurrently. * **************************************************************** | |
Local-Fix: | |
Avoid "drop and create procedure with same name" at same time. | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows | |
Lösung | |
Problem is first fixed in DB2 Version 9.5 Fix Pack 8 and all subsequent Fix Packs. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC73327 IC73328 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 06.12.2010 04.08.2011 04.08.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP8 | |
Problem behoben lt. FixList in der Version | |
9.5.0.8 |