Re: Informix Rollbacks: Prevention Suggestions

> My question is how to reduce the number of rollbacks. Would adding > the statement 'set lock mode to wait' help when added within our > source code? If it does, would the wait period be set to 15 or more > seconds? Peter, My first question is what are the users doing to have so many rollbacks. There are a number of possible alternative reasons than concurrency problems. For instance they may be trying to insert records that do not meet the referential integrity and check constraints of the database, if this is for sales order processing they may have many transactions where customers abort at the last minute. If concurrency problems are the major problem then you need to know what tables they are clashing on and what form of lock error they are getting. A redesign of that portion of the database may have more lasting impact than set lock mode to wait. If is possible that putting set lock mode to wait might ruin your transaction throughput and upset the user community. For instance look for all users needing access to a single record to get a unique transaction number this would respond to redesign well. Cheers - Jim My opinions are my own. They may vary with time but they remain MINE! ---------------------------------------------------------------------- Name: Jim Gordon Internet: jgordon@ssf-sys.DHL.COM Company: DHL Systems Inc Phone: (415) 375-5222 (Work) Address: 700 Airport Blvd. #300 (415) 775-7762 (Home) Burlingame, CA 94010-1937 Fax: (415) 375-5019 ----------------------------------------------------------------------