Are these programs pure RPG programs or embedded SQL RPG programs?
In embedded SQL programs the access plans for static SQL statements get
stored. Each time an SQL statement is executed the access plan (stored in
either SQE plan chache and/or program) is validated. If a new access plan
(for static embedded SQL statements) must be built caused for example by new
additional access plans or different data, this new access plan will be
added to the program object. The old access plans already stored in the
program object are not removed. In this way a program can get a change date
and grow even though nobody changed anything.
When recompiling the embedded SQL programs only a single access plan (per
static SQL statements) will be implemented.
Just recompile these embedded SQL programs and compare the sizes before and
after.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Robert Munday
Gesendet: Tuesday, 30. August 2011 23:27
An: Midrange List
Betreff: Growing Programs - Second Attempt
Greetings.
Second attempt. I renamed the program example to protect the innocent. It
is the same program... five days apart.
I am writing some object comparison programs to compare for changes over a
period of time. I use DSPOBJD to an outfile and compare against a
previously saved file. Two questions:
What is the purpose of `Changed Date`? Does that change when the program is
used (last used date) or when a physical change occurs to the structure?
Also I see that RPG programs are growing in size. There have been no
modifications that I can see in the source. The only thing changed is the
size field.
Size
Create Dt Change Dt
Old- INVTR909 *PGM RPGLE 7,589,888 Item to Item
Transfer Process 04/04/2009 04/04/2009
New- INVTR909 *PGM RPGLE 7,733,248 Item to Item
Transfer Process 04/04/2009 04/04/2009
How did that occur?
Thanks,
Robert Munday
Montgomery, AL
midrange.com
