Database Reference
In-Depth Information
operating system level and are reloaded into the lock table in the event of a system restart.
Black locks in transaction SM12 are normal transaction locks and are associated with the
dialog work processes.
Obsolete Locks
When user connectivity to the SAP system ends abruptly because of network issues, or if a
transaction is canceled by the end user in a ungraceful manner, then the locks held for that
particular transaction would still be present in the lock table and would prevent the same
user or other users from accessing and making changes in the system. In these situations the
obsolete locks can be deleted, but only after confirming this with the owner of the locks. It
is never recommended to delete a lock table entry without performing due diligence with re-
gard to the owner of the lock.
Lock Table Overflow
Lock table overflow is a condition when the SAP system demands more lock table entries
than what it is currently configured for usage. Lock table overflow can be detected by using
transaction SM12 or SM21. In transaction SM12, if you scroll down to the bottom of the
screen you will see a message indicating that there was a lock table overflow. This is also
recorded in the system log. The lock table overflow issue can be fixed by increasing the pro-
file parameter enque/table_size value to a higher number.
Deadlocks
Deadlocks result when two or more users lock each other's data and are waiting for it to be
released. Deadlocks can be resolved by releasing either the lock holder or lock waiter.
Transaction code DB01 can be used to check if there is an active deadlock in the system.
Summary
• SAP profiles are installed at the operating system level by the SAP installation pro-
gram SAPInst.
• SAP profiles include the start, default, and instance profiles.
• The start profile has all the start commands for the SAP system.
• The default profile includes all the parameters that are applicable to all application
servers of an instance.
• The instance profile includes all the parameters that are applicable for a particular in-
stance.
• Transaction RZ10 must be used to maintain SAP profile parameters.
Search WWH ::




Custom Search