Hi again
Thanks for answer.
When i was writing first message i didn't have enough knowledge about how do we use shared table and how we lock it.
We are trying to lock it with Lock statement exactly the way it is written in this paper
http://www.lexjansen.com/pharmasug/2005/posters/po33.pdf
But it doesn't work well. In spite of some trick with SCL open\close strategy which is given in paper.
The problem is, that when one process has locked the table, and another one is trying to acquire the lock with "lock TableName". Lock statement writes ERROR message in log. And it is not appropriate for our code. Because it is made in such a way, that if there is an ERROR message in log, it thinks that the process failed.
And we have a long batch tree of processes, and when one of them fails(even if it worked well, but had just dummy ERROR message in log) others don't start.
... View more