• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Performance Advice from a Mysterious Friend, Part 5

    April 16, 2008 Ted Holt

    Here’s yet another performance tip from a fellow subscriber and System i consultant. Thanks for the feedback on previous tips.

    Today’s tip: “Use soft commit when committing transactions containing a small number of update, insert, and/or delete operations.”

    According to the IBM V5R4 Information Center, “Soft commit is a form of commitment control that limits the number of times that the system writes journal entries associated with a transaction to disk.” In this regard, it is much like journal caching, but unlike journal caching, there is no additional fee for soft commit.

    Be warned that soft commit does not protect against system failure as well as traditional commitment control does. I suspect it is for this reason that our friend recommends the use of soft commit only when the number of transactions is small.

    RELATED STORIES

    Performance Advice from a Mysterious Friend, Part 4

    Performance Advice from a Mysterious Friend, Part 3

    Performance Advice from a Mysterious Friend, Part 2

    Performance Advice from a Mysterious Friend



                         Post this story to del.icio.us
                   Post this story to Digg
        Post this story to Slashdot

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    OCEAN User Group

    OCEAN TechCon25 Online

    It’s an Exciting Time for IBM i !

    July 16 & 17, 2025 – ONLINE

    Two virtual days of learning, presented by an outstanding group of IBM’ers and IBM Champions, featuring leading-edge topics.

    FREE for OCEAN members!

    Register NOW!

    Annual (12-month) Individual OCEAN Memberships are $80 and a Corporate Membership is $250. A Corporate Membership would allow your entire company to have full access to the OCEAN website & video library and to attend OCEAN events at member rates. Act now because rates are increasing on August 1, 2025.

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    LANSA:  It's Time for 4 days of education at the LANSA User Conference, May 4 – 7, in Orlando
    MoshiMoshi:  An Interactive Experience for the System i Community. See Episode 1 now!
    Vision Solutions:  A Rewind Button for i5 Data? Read the Whitepaper

    IT Jungle Store Top Book Picks

    Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
    Getting Started with PHP for i5/OS: List Price, $59.95
    The System i RPG & RPG IV Tutorial and Lab Exercises: List Price, $59.95
    The System i Pocket RPG & RPG IV Guide: List Price, $69.95
    The iSeries Pocket Database Guide: List Price, $59.00
    The iSeries Pocket Developers' Guide: List Price, $59.00
    The iSeries Pocket SQL Guide: List Price, $59.00
    The iSeries Pocket Query Guide: List Price, $49.00
    The iSeries Pocket WebFacing Primer: List Price, $39.00
    Migrating to WebSphere Express for iSeries: List Price, $49.00
    iSeries Express Web Implementer's Guide: List Price, $59.00
    Getting Started with WebSphere Development Studio for iSeries: List Price, $79.95
    Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
    Getting Started with WebSphere Express for iSeries: List Price, $49.00
    WebFacing Application Design and Development Guide: List Price, $55.00
    Can the AS/400 Survive IBM?: List Price, $49.00
    The All-Everything Machine: List Price, $29.95
    Chip Wars: List Price, $29.95

    Healthcare Company Adopts Biometric Time and Attendance Terminals IBM Expands VIP to All Systems for Precision Sales

    Leave a Reply Cancel reply

Volume 8, Number 15 -- April 16, 2008
THIS ISSUE SPONSORED BY:

Help/Systems
WorksRight Software
Twin Data

Table of Contents

  • More about SQL and Logical Files
  • Performance Advice from a Mysterious Friend, Part 5
  • Admin Alert: V6R1 Changes for the i5/OS Administrator, Part 2

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • With Power11, Power Systems “Go To Eleven”
  • With Subscription Price, IBM i P20 And P30 Tiers Get Bigger Bundles
  • Izzi Buys CNX, Eyes Valence Port To System Z
  • IBM i Shops “Attacking” Security Concerns, Study Shows
  • IBM i PTF Guide, Volume 27, Number 26
  • Liam Allan Shares What’s Coming Next With Code For IBM i
  • From Stable To Scalable: Visual LANSA 16 Powers IBM i Growth – Launching July 8
  • VS Code Will Be The Heart Of The Modern IBM i Platform
  • The AS/400: A 37-Year-Old Dog That Loves To Learn New Tricks
  • IBM i PTF Guide, Volume 27, Number 25

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2025 IT Jungle