After an upgrade to V5R4, I always do a DSPOBJD *ALLUSR/*ALL *FILE, DSPOBJD
*ALLUSR/*ALL *USRQ, DSPOBJD *ALLUSR/*ALL *DTAQ, and then a STROBJCVN
*SQLPGMS on all User libraries. The only drawback to this is that all these
objects get a last changed date update, but that is better than doing it at
first touch on Monday morning when the users get on the system (typically a
weekend upgrade). I had one customer who didn't want the last changed
(could have been used date, don't remember which) date to be updated, and
they said they didn't want me to run these. Monday morning, the system was
as slow as molasses as all their regular production objects were touched for
the first time and converted. By noon the system was back to normal, but to
me that isn't the right way to do it.
Pete
Pete Massiello
iTech Solutions
http://www.itechsol.com
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Evan Harris
Sent: Tuesday, November 25, 2008 1:02 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: v5r4 upgrade first touch object conversions and logical files
Hi Pete
Why the preference for DSPOBJD rather than STROBJCVN ? Also, in your
experience does DSPOBJD cause SQLPKG objects to get converted ?
Regards
Evan Harris
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Pete Massiello
Sent: Tuesday, 25 November 2008 6:10 p.m.
To: 'Midrange Systems Technical Discussion'
Subject: RE: v5r4 upgrade first touch object conversions and logical files
Great reason to do a FULL Backup after an upgrade as you touch everything.
But after all upgrades to V5R4, we do a DSPOBJD *ALLUSR/*ALL *FILE, which
touches all files and prevents the Monday morning issues of first touch.
Pete
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jerry Adams
Sent: Monday, November 24, 2008 10:18 AM
To: Midrange Systems Technical Discussion
Subject: RE: v5r4 upgrade first touch object conversions and logical files
Sorry, Charles, but can't answer from any in depth knowledge of the
conversion internals.
However, from experience (5.3 -> 5.4) I just did a DSPOBJD over all of our
data libraries. We have a bushel basket full of LF's, and access to most of
our PF's is via the LF's. Not to say the LF's didn't have to wait to be
"touched" directly, but we never noticed a hiccup. Bear in mind that our
largest PF is probably (at the time) in the neighborhood of 1,000,000
records.
Also, since the LF is a *File, the DSPOBJD should have (I'm guessing, did)
touch them, too.
Jerry C. Adams
IBM System i Programmer/Analyst
B&W Wholesale
office: 615-995-7024
email: jerry@xxxxxxxxxxxxxxx
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles Wilt
Sent: Monday, November 24, 2008 8:49 AM
To: Midrange Systems Technical Discussion
Subject: v5r4 upgrade first touch object conversions and logical files
All,
I'm wondering when the "first touch" object conversion occurs for a logical
file after an upgrade to v5r4 from v5r2.
Consider for instance, an SQL query that references the physical, obviously
the physical will be converted, but what about the logicals?
Are they converted when the physical is?
If not, would the query optimizer count as a "first touch"?
Or would they only be converted if directly referenced by an RPG program,
DSPOBJD or similar?
Thanks!
Charles Wilt
midrange.com
