|
Was the based-on SQL TABLE PF of the SQL INDEX LF created new in
this scenario, or was it created on a prior release? If the SQL
TABLE was created in the past [before the PTF was applied] but has
never been re-created from source or modified by ALTER TABLE to
effect the new\corrected FmtLvlId for the RcdFmt, then the DATE,
TIME, or TIMESTAMP field definition still reflects a RcdFmtLvlID
with the separator being incorrectly included in the hash. If so,
then the scenario would seem to be an example of a side-effect for
the fix having been implemented as "least impact" as described in my
archived post and one of the APARs which intended to provide a fix:
http://archive.midrange.com/midrange-l/200706/msg01191.html
SE22099 - OSP-DB FMTLVLID GENERATED INCORRECTLY FOR TIMESTAMP FIELD003c87e4
http://www->01.ibm.com/support/docview.wss?uid=nas2ede7e016599ca1268625707e
The corrective actions need to be performed for any columns with0041fe11
those data types, which were created prior to the corrective PTF
having been applied, as described in the informational APAR:
II14134 - RECORD FORMAT LEVEL IDENTIFIER CHANGING FOR SQL TABLES
http://www->01.ibm.com/support/docview.wss?uid=nas221529fcce2f4b07086257101
Regards, Chuck
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.