Re: v5r4 upgrade first touch object conversions and logical files

["Charles Wilt" <charles.wilt@xxxxxxxxx>]

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.