How to delete lock entry ?

[Former Member]

Hi.

We have many lock entry that created at yesterday.

I want to delete it but It's too many.

Is there any delete a lot of lock entry ?

Regards, Arnold.

[former_member613174]

T-code - SM12

select entry which you want delete or select all.

click on delete button.

[JPReyes]

I can see 7 similar answers in a row.

Posting without adding additional information is consider point-hunting.

@Julie, This is a very basic question, please research before posting.

Read the "Rules of Engagement"

Regards

Juan

[naveen_kumar1]

Hi Arnold,

Before deleing the lock entries you should take care of the following.

Black locks are normal transaction locks. Blue locks are inherited by the update system and deleted with the corresponding update request. Blue locks are also saved in the file system and restored when the system is restarted.

SM12 -> Select All -> Delete

Regards,

Naveen.

[Former Member]

Hi,

Always put the deletion of locked entry on second step. First of all always check whether you can achieve the same result by killing the user session. i always do the same sucessfully (no need to delete the entry from SM12).

- gaurav

[Former Member]

Hi

We can check the lock entries from SM12

Note the lock key of the relevant lock entry. Select this entry and choose Details to display the transaction code

so after the proper approval from the management you can delete the particular lock entry if required .

Regards

Shilpa

[Former Member]

Hi

Lock entries should only be deleted if you are sure that they are invalid and their deletion will not impair any active process (i.e user session)

To delete Lock Entries

1)Log on to respective Environment

2)Go to transaction SM12

3)Select Lock Entry

4)then select Delete All

Thanks.

[Former Member]

Hai Julie,

Before Deleting Lock Entries in SM12 ,u will take the Black and White Approval from the Project Manager OR U r Reporting Manager.

Thanks,

G.Rangarao

[Former Member]

Hello Julie.

Check with the users / process owners before deleting it. Carefull. Deleting without checking results in instability of DB

[former_member208104]

Hi,

You can delete lock entry using txn SM12-->Select all.

-Sanjay