Re: 5.3 to 5.4 upgrade issues

Peter,

Here is the link.

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/rzahc/sqlconv.htm


Chris Seager
IS Assistant Director
City of Saginaw
Office (989)759-1586
Cell (989)737-5558




"Peter Dow (ML)"
<maillist@dowsoft
ware.com> To
Sent by: Midrange Systems Technical
midrange-l-bounce Discussion
s@xxxxxxxxxxxx <midrange-l@xxxxxxxxxxxx>
cc

01/09/2008 10:06 Subject
PM Re: 5.3 to 5.4 upgrade issues


Please respond to
Midrange Systems
Technical
Discussion
<midrange-l@midra
nge.com>






Thanks Chuck and Evan.

I wasn't told about the upgrade until after it was done, and then only
because another programmer ran into the CPF4204 problem. Unfortunately I
don't think I'll convince them to take the time to report the problem.
However, I will take a look at the Memo To Users, google some more and
take a look at STROBJCVN.

*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
pdow@xxxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxxx> /

CRPence wrote:

CPF4204 is the DB2 for i5/OS Query Engine equivalent to the i5/OS
message CPF9999. The only way to know what transpired, is to have
investigated the error(s) that led to the generic failure message being
issued. Having performed actions like recompile\recreate of objects may
enable bypassing the error condition, but does not [assist to] identify
the defect origin. That doing so [appears to] resolves the situation
does not necessarily imply that the issue is related to conversions,
even if that is probable. However it is surely not due to /background/
conversions, because SQL program [associated space] and database [file,
member, alignment, et al] object conversions would [almost exclusively]
transpire on /first touch/ of the objects.

Reporting the problem as a defect might assist to both identify the
origin and resolve the error by effecting a correction being provided in
the form of a PTF [even if only for future instances of similar upgrades
and objects], so others need not perform similar actions in an attempt
to bypass\circumvent the defect. Or, the problem might be found to
already have a preventive PTF available; for conversion issues, such
that future first-touch conversions will not exhibit the same failure.

Regards, Chuck

--
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.