fhg
Volume 8, Number 15 -- April 16, 2008

Performance Advice from a Mysterious Friend, Part 5

Published: April 16, 2008

by 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


Sponsored By
WORKSRIGHT SOFTWARE

Do you need area code information?
Do you need ZIP Code information?
Do you need ZIP+4 information?
Do you need city name information?
Do you need county information?
Do you need a nearest dealer locator system?

We can HELP! We have affordable AS/400 software and data to do all of the above. Whether you need a simple city name retrieval system or a sophisticated CASS postal coding system, we have it for you!

The ZIP/CITY system is based on 5-digit ZIP Codes. You can retrieve city names, state names, county names, area codes, time zones, latitude, longitude, and more just by knowing the ZIP Code. We supply information on all the latest area code changes. A nearest dealer locator function is also included. ZIP/CITY includes software, data, monthly updates, and unlimited support. The cost is $495 per year.

PER/ZIP4 is a sophisticated CASS certified postal coding system for assigning ZIP Codes, ZIP+4, carrier route, and delivery point codes. PER/ZIP4 also provides county names and FIPS codes. PER/ZIP4 can be used interactively, in batch, and with callable programs. PER/ZIP4 includes software, data, monthly updates, and unlimited support. The cost is $3,900 for the first year, and $1,950 for renewal.

Just call us and we'll arrange for 30 days FREE use of either
ZIP/CITY or PER/ZIP4.

WorksRight Software, Inc.
Phone: 601-856-8337
Fax: 601-856-9432
E-mail: software@worksright.com
Web site: www.worksright.com


Senior Technical Editor: Ted Holt
Technical Editor: Joe Hertvik
Contributing Technical Editors: Edwin Earley, Brian Kelly, Michael Sansoterra
Publisher and Advertising Director: Jenny Thomas
Advertising Sales Representative: Kim Reed
Contact the Editors: To contact anyone on the IT Jungle Team
Go to our contacts page and send us a message.

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


 
The Four Hundred
The 64-Core Power6-Based Power 595 Starts to Roll in May

And Then There Was One: The New and Improved Power 570

Sundry Power Systems Announcements

As I See It: Goldilocks and the Zen of IT

Albert Simon Barsa, Jr., 1953-2008

The Linux Beacon
Oracle Touts Unbreakable Linux, Adds Clusterware Support

Ubuntu 6.10 Comes to the End of the Line

IBM Merges System p and System i Server Lines

IBM Launches Dual-Core Power6 JS12 Blade Server

Most CIOs Say 2008 IT Budgets Are Stable, So Far

Four Hundred Stuff
i-Based SCS500 Internet Phone System Now Available

Raz-Lee Flushes Out Fraud with Application Security Tool

ARCAD Looks to Aid Application Modernization Projects with Updated Software

BOSaNOVA Goes Semi-Rugged with New Thin Client

Quadrant Updates IntelliChief with Web Forms

Big Iron
HP Goes Visual with Application Modernization Tools

Top Mainframe Stories From Around the Web

Chats, Webinars, Seminars, Shows, and Other Happenings

System i PTF Guide
April 12, 2008: Volume 10, Number 15

April 5, 2008: Volume 10, Number 14

March 29, 2008: Volume 10, Number 13

March 22, 2008: Volume 10, Number 12

March 15, 2008: Volume 10, Number 11

March 8, 2008: Volume 10, Number 10

The Windows Observer
New Batch of Windows Flaws Give Hackers a Roadmap to Riches

Yahoo Rebuffs Microsoft's Threat of a Hostile Takeover

AMD to Slash 10 Percent of Workforce Amid Sales Shortfall

Options to Microsoft's Hosted E-Mail Abound

Oracle to Support 10g on Windows Server 2008 by July

The Unix Guardian
The 64-Core Power6-Based Power 595 Starts to Roll in May

HP Rejiggers HP-UX 11i Packaging as Update 2 Ships

Sun Gangs Up Sparc T2+ Chips with Maramba Servers

The Power 575: Grandfather of the Multi-Teraflops Power7 Monster

Most CIOs Say 2008 IT Budgets Are Stable, So Far

Four Hundred Monitor
Four Hundred Monitor's
Full iSeries Events Calendar

THIS ISSUE SPONSORED BY:

Help/Systems
WorksRight Software
Twin Data


Printer Friendly Version


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

Four Hundred Guru

BACK ISSUES

From the IT Jungle Forums
Al Barsa passed away

Copying recs from a subfile to a file and keeping highlights

Imbedded SQL

CPYFRMSTMF problem

CPYTOIMPF problem

Table Transferfrom OS400 to Windows





 
Subscription Information:
You can unsubscribe, change your email address, or sign up for any of IT Jungle's free e-newsletters through our Web site at http://www.itjungle.com/sub/subscribe.html.

Copyright © 1996-2008 Guild Companies, Inc. All Rights Reserved.
Guild Companies, Inc., 50 Park Terrace East, Suite 8F, New York, NY 10034

Privacy Statement