![]() Please note that as this parameter is not dynamic one, restart of the application server is required for the changes to become effective. In RZ10 transaction, select the profile of the instance, for which workprocess number to be changed and edit the profile through extended maintenance and save the changes done and activate the profile. Rdisp/wp_no_vb2 (for update2 workprocess) Rdisp/wp_no_enq (for enqueue workprocess) Rdisp/wp_no_btc ( for background workprocess) To increase/decrease the number of workprocesses, value to be changed accordingly for the following parameters as per workprocess in RZ10 Transaction. Increase the number of enqueue workprocesses.The person responsible, his or her user name, the time, and the number of locks are listed.ĭelete History: The overflow history is deleted. History: The overflow history is displayed. On the List of Lock Entries screen choose the menu option Extras → Top Capacity Used →Ĭurrent: The current capacity used status is displayed. To determine the optimal value for this parameter, you can check the maximum locks set so far in the history and the current number of locks set. Increase the size of lock table i.e increase the parameter enque/table_size value using RZ10 transaction. This error typically occurs when trying to transfer inside a cluster (the timeout is much shorter for a file load between servers than an initial load.) The Fix. ![]() To resolve the lock table overflow issue:. The update process is hanging and this is passing a lot of locks onto the update task.An application sets a large number of locks.You can determine both the maximum number and the current number of entries in the transaction using Extras/Statistics. Parameter enque/table_size determines the size of the lock table in KB. The maximum number of locks in the lock table is subject to an upper limit, which can be defined in a profile parameter. What is the reason for lock table overflow and how to resolve it.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |