![]() |
Copyright © TIBCO Software Inc. All rights reserved. |
The pm_objects_lock table stores information about every procedure object that is currently locked.TABLE pm_objects_lock (
object_guid VARCHAR(36) NOT NULL,
lck_state INTEGER NULL,
lck_owner VARCHAR(24) NULL,
lck_time DATETIME NULL)
Flag that defines (1) that this procedure object is locked.
If this happens the object cannot be accessed again until the locks in the proc_index and pm_objects tables are released. To do this:
1. Log in to SQL Server as the background user.
2. In SQL Query Analyzer, use the following query to delete all locks associated with the locked procedure (where procedure_name is the name of the locked procedure):
delete procedure_lock where proc_id = (select proc_id from proc_index where proc_name = ’procedure_name’)delete pm_objects_lock where object_guid = (select object_guid from pm_objects where object_name like ’proc_name%’)
The like statement requires a % sign prefixed or suffixed to the procedure_name. However, this will select similarly-named procedures - for example, ’TEST%’ would select procedures named TEST1, TEST2, TEST3, even if only TEST4 needed to be cleared.You are recommended to ensure that the procedure name is complete - in the case in the previous paragraph, specify ’TEST4%’ - so that the % character only covers the option procedure description.
![]() |
Copyright © TIBCO Software Inc. All rights reserved. |