Re: journalling overhead

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

As Al stated, no not on a read. Reads are not journaled and not able to be
journaled prior to V5.

Are you sure you're not reading for update and updating? Are you sure you're
not reading for update and there are lock issues? Has an index changed? Have
you put the job in debug and checked for index issues?

Next, an interactive program that reads 200,000 records is, IMO _not_ an
interactive job, it's a batch job running in the interactive environment.

===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - AS/400 Administrator
 -- IBM Certified Specialist - RPG IV Developer

"America is the land that fought for freedom and then
  began passing laws to get rid of it."

     - Alfred E. Neuman

-----Original Message-----
From: Phil <sublime78ska@yahoo.com>
To: MIDRANGE-L@midrange.com <MIDRANGE-L@midrange.com>
Date: Wednesday, June 06, 2001 9:13 AM
Subject: RE: journalling overhead


>Al,
>
>This machine is at V4R5.  But there is only one ASP.
>
>Phil
>
>-----Original Message-----
>From: owner-midrange-l@midrange.com
[mailto:owner-midrange-l@midrange.com]On
>Behalf Of barsa@barsaconsulting.com
>Sent: Wednesday, June 06, 2001 6:16 AM
>To: MIDRANGE-L@midrange.com
>Subject: Re: journalling overhead
>
>
>Not likely, unless you are using the read journaling implemented in V5R1.
>The removal of the performance problems with journaling is heavily based on
>the premise that the journal receiver is in a dedicated User ASP.
>
>Al - traveling - off to COMMON Europe tomorrow
>
>Al Barsa, Jr.
>Barsa Consulting Group, LLC
>
>400>390
>
>914-251-1234
>914-251-9406 fax
>
>http://www.barsaconsulting.com
>http://www.taatool.com
>
>
>
>
>
>
>                    "Phil"
>                    <sublime78ska@yahoo        To:
><MIDRANGE-L@midrange.com>
>                    .com>                      cc:
>                    Sent by:                   Subject:     journalling
>overhead
>                    owner-midrange-l@mi
>                    drange.com
>
>
>                    06/06/01 12:35 AM
>                    Please respond to
>                    MIDRANGE-L
>
>
>
>
>
>
>I have been hearing for a few years now that journaling no longer causes a
>performance problem.  And I've been journaling files as I use embedded sql.
>
>I have been getting performance complaints lately on one particular
>program.
>The program is an interactive program that returns a rate.  It was written
>about 15 years ago.  It must read through a file which has about 200,000
>records in it and is recently journaled.
>
>My question is - can it be the journaling?
>
>Phil
>
>
>_________________________________________________________
>Do You Yahoo!?
>Get your free @yahoo.com address at http://mail.yahoo.com
>
>+---
>| This is the Midrange System Mailing List!
>| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
>| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
>| To unsubscribe from this list send email to
>MIDRANGE-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator:
>david@midrange.com
>+---
>
>
>
>
>+---
>| This is the Midrange System Mailing List!
>| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
>| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
>| To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator:
>david@midrange.com
>+---
>
>
>_________________________________________________________
>Do You Yahoo!?
>Get your free @yahoo.com address at http://mail.yahoo.com
>
>+---
>| This is the Midrange System Mailing List!
>| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
>| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
>| To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator:
david@midrange.com
>+---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---