In this post, you’ll learn about the error message -187 a reference to a current date/time special register is invalid because the mvs tod clock is bad or the mvs parmtz is out of range in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-187 a reference to a current date/time special register is invalid because the mvs tod clock is bad or the mvs parmtz is out of range
Reason for the Error
DB2 has encountered an invalid time-of-day (TOD) clock.� The user referenced one of the special registers: CURRENT DATE, CURRENT TIME, CURRENT TIMESTAMP, or CURRENT TIMEZONE.� If the user referenced CURRENT TIMEZONE, the MVS parameter PARMTZ was out of range.
Solution
For CURRENT TIMEZONE, check that the MVS parameter PARMTZ is between -24 and +24 hours.� For the other CURRENT special registers, check that the MVS TOD clock has been set correctly.
