×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.