IY95213: TIMESTAMP ROUNDING ERROR FOR MILLI-SECONDS

APAR status

• Closed as program error.

Error description

• For low values of fractional seconds simple rounding might
  suffice, but
  for high values such as 999500 rounding to 1000 when the format
  mask is
  SSS is not only one digit more than expected but is also
  logically
  incorrect.
  
  It might be argued that in such a case the fraction should
  become 000
  and the number of seconds should be incremented.  But that could
  result
  in a rounding increment of every timestamp element up to and
  including
  the year.  As well as giving a potentially unexpected change of
  every
  element at a year end boundary, this could also cause unexpected
  effects
  at Daylight Saving Time boundaries.
  

Local fix

• NA
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of Websphere Message Broker        *
  *                 version 6.0 using ESQL datetime datatypes.   *
  ****************************************************************
  * PROBLEM DESCRIPTION: ESQL Datetime objects do not have       *
  *                      their fractional seconds digits         *
  *                      rounded corrrectly when converting to   *
  *                      a format mask with less than six        *
  *                      digits of fractional seconds.           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When manipulating datetime objects with less than 6 digits
  of fractional seconds in the format mask, a rounding error
  in the ESQL datetime datatype can cause unexpected results.
  
  The user will see timestamps with fractional seconds of
  .9999 incorrectly rounded to .100 without the seconds digit
  being incremented. This can also result in ESQL datetime
  fields in a chronological sequence of messages (for example
  using the CURRENT_TIMESTAMP function) having non-increasing
  values.
  

Problem conclusion

• Websphere Message Broker has been modified to truncate extra
  digits when converting to a format mask with less than six
  digits of fractional seconds rather than rounding.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  MSSG BROKER AIX

• Fixed component ID

  5724J0501

Applicable component levels

• R100 PSY

     UP