Re: v5r4 upgrade first touch object conversions and logical files

Jerry,

Yeah, I'm trying to find out if the DSPOBJD "first touch" was finished.

We have done a full system save since the upgrade, does anybody know
if that counts as a "first touch" for the purposes of v5r4 *FILE
conversion?

Charles

On Mon, Nov 24, 2008 at 10:17 AM, Jerry Adams <Jerry@xxxxxxxxxxxxxxx> wrote:

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
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.