-187   A REFERENCE TO A CURRENT DATETIME SPECIAL REGISTER IS INVALID BECAUSE THE MVS TOD CLOCK IS BAD OR THE MVS PARMTZ IS OUT OF RANGE

Explanation

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.

System action

The statement cannot be processed.

Programmer response

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.

SQLSTATE

22506