Make DB2 UDB Date and Time Stamp Consistent With Win2000

[SAP BASIS Consultant]

Hello,

As somebody fairly new to DB2..

I am looking to migrate a V6 (No laughter please, it was a sandbox
system hardly used at all) UDB/Win2000 system used by SAP. I noticed
that the Win2000 server in which it resides is off by
about 20 minutes so I changed the time from the Win2000 Control Panel.
Now, SAP is complaining that DB2's date/time is inconsistent with
that on the OS.

How can I make my DB date/time consistent with that of Win2000?





Thanks,
DF

[Philip Nelson]

On Thu, 07 Aug 2003 07:36:25 -0700, SAP BASIS Consultant wrote:

> Hello,
>
> As somebody fairly new to DB2..
>
> I am looking to migrate a V6 (No laughter please, it was a sandbox
> system hardly used at all) UDB/Win2000 system used by SAP. I noticed
> that the Win2000 server in which it resides is off by
> about 20 minutes so I changed the time from the Win2000 Control Panel.
> Now, SAP is complaining that DB2's date/time is inconsistent with
> that on the OS.
>
> How can I make my DB date/time consistent with that of Win2000?
>
>
>
>
>
> Thanks,
> DF

At a guess I say you'd need to stop and start the DB2 instances on the
box. I'm thinking that the problem will be with logging (for example)
where everything is dependant on timestamps.

You can do this through the Control Panel (Services) but the easiest way
to achieve this may be just to reboot the box.