Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2008

    Unanswered: LogsHeld Monitor

    Hello Friends,

    We are having LogsHeld problem in our production environment. This happens once a fortnight roughly. The casinos fall off because of slowness. Forcing holding application recovers.

    I need to write a monitor to tarck a situatiion when a transaction log is held for long time that causes everything to slow down.
    At the moment I will start with SEC_LOGS_ALLOCATED monitored. If so I will check further(APPL_ID_OLDEST_XACT . . . .). If not I will think that everything is normal.

    Any body who might have done this, please advise or correct me .

    (DB2V9.5 fp 4 on Win2k3)


  2. #2
    Join Date
    Aug 2008
    Toronto, Canada
    You may want to look at max_log / num_log_span db cfg parameters - they can be used in order to stop an appl from consuming a lot of active log space.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts