Re: Problem with long transactions

Brad, yes, increasing the number of logs will help the problem. also, tuning the transaction high/low water marks and the exclusive transaction high/low water marks will help as well. the reason for the logs filling when aborting a long transaction it that informix logs the rollback as well. we initially set up our system with 500 pages/log and we have had to increase the number of logs to 61. what types of transactions are you doing? dbload vs 'load from file...' will definitely affect your logs - 'load from file...' from a large file will fill the logs fast. regards, ------------------------------------------------------------------------------ | . . Bob Baskett | ... ... Software Engineer, DBA | ..... ..... Business Systems Integration Group | .. ... .. Semiconductor Products Sector | . . . Mesa, AZ | | Motorola, Inc ------------------------------------------------------------------------------