Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2012
    Posts
    10

    Unanswered: mincommit depricated in 10.1

    In DB2 10.1 the database configuration parameter "mincommit" has been depricated.

    Has IBM simply done away with the ability to group commits prior to writing to disk to reduce disk IO. ( Yes I know full well the impact of doing that, things you think are on disk that truly aren't and hence in a crash scenario potentially missing transactions ).

    Did IBM state anywhere formally or informally why they did this ? Is there an alternate way of doing the same thing as mincommit with db2 ?

    Thanks.

  2. #2
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    Read here:

    IBM DB2 10.1 Information Center for Linux, UNIX, and Windows

    This from the above link:
    Tuning of this parameter is not required due to improvements to the logging infrastructure.

  3. #3
    Join Date
    Mar 2012
    Posts
    10
    Quote Originally Posted by papadi View Post
    Tuning of this parameter is not required due to improvements to the logging infrastructure.:
    LOL.... I love IBM.... Of course it was

    Except that is not what I am observing.....

    Thanks for the pointer to the official statement.

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369

  5. #5
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486

    mincommit

    Except that is not what I am observing.....

    Thanks for the pointer to the official statement.
    You're welcome.

    And it Must be True - after all it was found on the internet. . .

    They do also mention that it "may be discontinued in a future release (surprise, surprise).

Posting Permissions

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