Re: Online Engine vs Standard

Jack Parker (jparker@hpbs3645.boi.hp.com) wrote: > Addendum (should this go an our non-existant FAQ?): I nominate you as Editor-in-Chief Jack! > 4. Lower the default Transaction high water marks from: [ . . . ] > to: > LTXHWM 70 # Long TX high-water mark (percent) > LTXEHWM 80 # Long TX exclusive high-water mark (percent) We deadlocked anyway with these settings. We now run with: LTXHWM 40 # Long TX high-water mark (percent) LTXEHWM 65 # Long TX exclusive high-water mark (percent) and Informix will never convince me that it's safe to run with them any higher. 10. Start out with LARGE but relatively few logfiles if you expect your system will grow over time (or even if you don't expect it to, it will grow anyway). Later you can add logfiles (up to the max of 61). If you instead start with a lot of relatively small logs you will be stuck at the max log limit of 61 and won't be able to change their size (LOGSIZE) without reinitializing your disc space. Ken Miles Vancouver Division Hewlett-Packard (Finally sleeping better now that I have 1.3GByte of log space).