Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Location
    zxczxczxc
    Posts
    52

    Unanswered: How are Long Transactions Calculated?

    HI,
    I want to know whether the server uses rowsize*noofrows or the actual size of the row(actual data stored in the row,some columns contain data less than their declared values, like char columns) multiplied by no of rows for calculating Long transactions.

    Example
    I have a table

    Table1 (x char(10),y char(20),z integer).

    I insert the rows
    Table1("123","345",123)
    The rowsize of the table is 30+integersize bytes

    But the actual rowsize is 3+3+integer bytes.

    Does the server use the former or the later calculation for Long transactions.


    bye
    zxczxczc

  2. #2
    Join Date
    Mar 2004
    Location
    Netherlands
    Posts
    183
    Answer: Neither

    It is not really calculated. It just looks at the space in the logical logs between the begin work statement and the current log position. If this space is larger then the specified percentage (LTXHWM), than IDS will trigger a long transaction event.

    So it is based on the space used, not calculated.

    Hope this helps,

    Rob Prop

  3. #3
    Join Date
    Apr 2004
    Location
    Brussels
    Posts
    57
    And the space used in the log files starting from "begin work" is also consumed by concurrent users.
    The more concurrent users with tranansactions, the less space you can use before the system detects a LONG TRANSACTION.
    Yves & Willy

Posting Permissions

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