In my project, we are upgrading DB2V10 from V8. We found some difference like 'TIMESTAMP EXTERNAL' occupies X(26) in V8 and in X(19)v10. Also from google i got the following link
Where the Char data type has some incompatible changes,
But i can't find the difference of 'TIMESTAMP EXTERNAL' in that link. The 'TIMESTAMP EXTERNAL' detail is obtained from our DBA. Please let me know what are all the difference that need to be verified before upgrading V10.
With DB2 10 for z/OS new-function mode, timestamp data type can provide precision up to a
picosecond (10-12 of a second). You can control the number of digits for the fractional second
using the optional timestamp precision attribute. The precision attribute range is 0 to 12, and
the default value is 6 because only six digits for the fractional second were supported in prior
releases. Example6-25 illustrates various timestamp precisions that could be declared.
Example 6-25 Examples of timestamp precision
The external representation of a timestamp is a string representation of the form
yyyy-mm-dd-hh.mm.ss (19 bytes, when precision is 0) or yyyy-mm-dd-hh.mm.ss.nnnnnnnnnnnn
(where the number of digits n for the fractional second can vary from 1 to 12, resulting in
external length of 21 to 32 accordingly).