• 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
    Maxava

    Migrate IBM i with Confidence

    Tired of costly and risky migrations? Maxava Migrate Live minimizes disruption with seamless transitions.

    Upgrading to Power10, Power11, or cloud hosted system, Maxava has you covered!

    Book A Consultation Today

    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

  • The Power11 Transistor Count Discrepancies Explained – Sort Of
  • Is Your IBM i HA/DR Actually Tested – Or Just Installed?
  • Big Blue Delivers IBM i Customer Requests In ACS Update
  • New DbToo SDK Hooks RPG And Db2 For i To External Services
  • IBM i PTF Guide, Volume 27, Number 33
  • Tool Aims To Streamline Git Integration For Old School IBM i Devs
  • IBM To Add Full System Replication And FlashCopy To PowerHA
  • Guru: Decoding Base64 ASCII
  • The Price Tweaking Continues For Power Systems
  • IBM i PTF Guide, Volume 27, Numbers 31 And 32

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