This procedure tells you how to find the cause of Informix database performance problems when sessions are waiting on locks held by other sessions, which is a common problem. As a solution, you might need to consider buffering number ranges.

If a program has a problem while holding a lock on a record that is to be updated by many users – for example, a record with an important material number – then all work processes might fill with users who are waiting for that record. This affects even those users who do not need the record, because there are no free work processes.