AS/400 journaling

1,150 pts.
Tags:
AS/400 journaling
AS/400 performance
V5R4
Does journalling process have an impact on the overall system performance?

Software/Hardware used:
as/400,V5 R4
ASKED: January 12, 2010  1:11 PM
UPDATED: January 13, 2010  8:15 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

IBM suggest that your batch processing time will increase by 3-5% with the right hardware and tuning. A great deal matters whether you are journaling the entire system for HA or doing before and after journaling on a DB2 database esp. using commitment control. I would recommend jumping one processor size, say from a 550 to a 570/MMA if your business can’t afford longer run times.

========================================================

Every process that uses a CPU cycle or a byte of storage will impact system performance. Why would you think journaling wouldn’t?

Does compiling a program affect performance? Yes. Does starting a display session and leaving it sit quietly affect performance? Yes. Does leaving spooled files sitting on output queues affect performance? Yes, but people do it for months without a second thought.

It’s not a question of “if” performance is affected. The questions are “how much?” and “will the impact be positive or negative?” and “does the impact matter to me?” Most likely, journaling will use CPU and storage resources that could be available for something else. But we have no way to know if it will make any difference for you.

Is your system running continually at 95+% CPU utilization? If it is, then journaling will probably have a noticeable negative impact if you journal enough transactions against enough files. Is your disk status continually showing 40% or more busy across your drives? If so, then journaling will probably have a noticeable negative impact.

If you aren’t using more than 90% of your CPU capacity, why are you wasting so much processor capacity? Why don’t you put it to use? You paid for it. Why be concerned about using more of it?

Note that there are journaling practices that are good and bad. But there are also good and bad backup practices. Without knowing about your system and business environment, there’s no way to say much beyond “Probably.”

Tom

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Steve Pitcher
    I posted some information on how to use triggers to capture database changes. Insignificant overhead. I'm not sure what you need to journal though. Check it out at: http://itknowledgeexchange.techtarget.com/endjobabn/search400-tip-tracking-data-changes-on-ibm-i-with-triggers/
    1,070 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following