this is my first time posting so bear with me...

when I update a DB2 column defined as “timestamp” with any time between 2-3 a.m. on 3/13/2011 (US time change date) an hour is automatically added. However a customer of mine can modify date values in their tables to have times between 2 and 3 on this date without DB2 adding an hour. The hour between 2-3 does not really exist since we jumped forward.

I am trying to determine where this functionality is set. is it ZPARM setting?

example:

update table set TRN_DT = '2011-03-13 02:11:10'

The statement runs without error but the results are:

TRN_DT
2011-03-13 03:11:10

I would guess you have a timezone set that tells DB2 about the DST shift applicable to that timezone? The customer may have a different timezone set in which the DST shift occurs on another date (or no DST shift at all).

Thanks Knut, that sounds plausible but what I am wondering is where this is set.

George

I would start looking in the system settings.