The database server uses the LTXHWM and LTXEHWM configuration parameters to set high-watermarks for long transactions. If DYNAMIC_LOGS is set to 1 or 2, the default LTXHWM value is 80 percent and LTXEHWM is 90 percent. If DYNAMIC_LOGS is set to 0, the default LTXHWM value is 50 percent and the default LTXHEWM value is 60 percent.
If you decrease your high-watermark values, you increase the likelihood of long transactions. To compensate, allocate additional log space. For information on LTXHWM and LTXEHWM, see the chapter on configuration parameters in the IBM Informix Administrator's Reference.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]