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

    April 23, 2008 Ted Holt

    This is the last of the performance tips that I received from one of your fellow readers. I hope you’ve enjoyed the previous tips and found some of them useful as well.

    Today’s advice: “Increase the journal recovery ratio from the default of 50,000 to 250,000.”

    IBM’ers Larry Youngren and Chris Kindinger provide a thorough discussion of this topic at http://www.redbooks.ibm.com/abstracts/tips0625.html”. Although the discussion centers around V5R4, they also provide information for V5R3 and V5R2.

    The journal recovery ratio has to do with the IPL process. The journal recovery ratio’s purpose is to limit the number of journal entries that must be reapplied to the database in the event of a system crash when the contents of main memory could not be written to disk. Youngren and Kindinger point out that the default value of 50,000 was set when machinery was much slower than current systems and when the system recovery algorithms were not as good as the ones available today. Hardware and software advances are a good indication that the default value is probably not the most effective setting these days.

    To increase the journal recovery ratio, use the Change Journal (CHGJRN) command.

    CHGJRN . . . JRNRCYCNT(250000)
    

    Users of V5R3 and V5R2 can find other instructions in the Larry Youngren and Chris Kindinger’s article linked above.

    RELATED STORIES

    Performance Advice from a Mysterious Friend, Part 5

    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
    ARCAD Software

    [Webinar] Synchronous IBM i and non-IBM i Deployments
    April 13 at 12 p.m. ET

    Do you need to automate and synchronize deployments across ALL your environments and applications?

    Many backend IBM i applications have off-platform components, such as an API layer, or Web front-end. To ensure your application stays reliable, artifacts must be deployed securely and in-sync.

    In our Webinar, learn how to orchestrate all your deployments, multi-platform and multi-cloud, using DROPS by ARCAD Software:

    – One single console to deploy across multiple endpoints – IBM i, Windows, Linux, IBM z, on prem or cloud

    – Real-time visibility of application status, from anywhere

    – Deployment plans and one-click-deploy

    – Rollback on error

    Simplify and secure your application delivery.

    Register Now

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    COMMON:  Join us at the annual 2009 conference, April 26 - April 30, in Reno, Nevada
    LANSA:  It's Time for 4 days of education at the LANSA User Conference, May 4 – 7, in Orlando
    Camp Help/Systems:  Explore operations automation and BI, June 17 - 20, 2008, Minneapolis, MN

    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

    Dextron Supports Java with Data Modeling Tools IBM’s Power Systems Sales Plan and Various Gotchas

    Leave a Reply Cancel reply

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

WorksRight Software
ProData Computer Services
Guild Companies

Table of Contents

  • A Recycle Bin for the IFS (Sort Of)
  • Performance Advice from a Mysterious Friend, Part 6
  • What is INZSYS, and Why Should I Care?

Content archive

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

Recent Posts

  • LANSA Developing Business Intelligence Tool
  • Blazing The Trail For VTL In The Cloud
  • Data De-Dupe Gives VTL Customers More Options
  • Four Hundred Monitor, March 29
  • The Big Spending On IT Security Is Only Going To Get Bigger
  • IBM Tweaks Some Power Systems Prices Down, Others Up
  • Disaster Recovery: From OS/400 V5R3 To IBM i 7.4 In 36 Hours
  • The Disconnect In Modernization Planning And Execution
  • Superior Support: One Of The Reasons You Pay The Power Systems Premium
  • IBM i PTF Guide, Volume 25, Number 13

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 © 2023 IT Jungle