Hello, there is a posting in this mailing list from Markus Bader posted on Tue, 9 Oct 2001 with the title "Database lock does not disappear" but I found no answer to the question. I have the same problem, there is a lock on a table but I can't remove it (the lock was not set explicitely).
"SELECT * FROM SHOW_TABLELOCKS" has the result: ------------------------------------------- PDBSDOM.MF_HOSTPLATFORMMAP LOCK ROW excl 00343660.2862243 PDBSDOM 007743 0036 ------------------ "SELECT * FROM MF_HOSTPLATFORMMAP WITH LOCK ISOLATION LEVEL 0" has the result: ---------------------- PLATFORM HOST ---------------------- alphaosf ds0005 -------------------- ... so there is only one row (column PLATFORM is primary key) in the table. Executing the statement "UNLOCK ROW MF_HOSTPLATFORMMAP KEY PLATFORM = 'alphaosf' IN EXCLUSIVE MODE" causes no error but afterwards the lock is still there, perhaps because this is a different transaction, the original one doesn't exist any more. Still the same question: Is there a way to get rid of the entry ? (DB-Version: Kernel 7.3.0, Build 024-000-085-555) Regards, Kilian _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
