PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).

Join the forum, it's quick and easy

PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).
PMS Information Systems
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Journaling

3 posters

Go down

Journaling Empty Journaling

Post  sivakumar Wed Jul 14, 2010 7:45 pm

Does journalling process have an impact on the overall system performance?


sivakumar

Posts : 174
Join date : 2009-07-27
Age : 37
Location : Chennai

Back to top Go down

Journaling Empty Re: Journaling

Post  sivakumar Wed Jul 14, 2010 7:47 pm

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."

Thanks to Mr.TomLiotta
System Programmer, Seattle.

sivakumar

Posts : 174
Join date : 2009-07-27
Age : 37
Location : Chennai

Back to top Go down

Journaling Empty journaling

Post  sridhar reddy Sat Mar 26, 2011 10:59 pm

Hi,
Could u plz tell me the processing of journaling, hot to get back data by journaling and whn to use cmtctrl and rollback . plz explain me.

sridhar reddy

Posts : 1
Join date : 2011-03-26

Back to top Go down

Journaling Empty Re: Journaling

Post  maran Fri Jan 06, 2012 7:44 pm

yes. it does
maran
maran
Admin

Posts : 442
Join date : 2009-07-24

https://pmsinformationsystem.forumotion.net

Back to top Go down

Journaling Empty Re: Journaling

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum