Professional Web Applications Themes

Make DB2 UDB Date and Time Stamp Consistent With Win2000 - IBM DB2

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...

  1. #1

    Default Make DB2 UDB Date and Time Stamp Consistent With Win2000

    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
    SAP BASIS Consultant Guest

  2. #2

    Default Re: Make DB2 UDB Date and Time Stamp Consistent With Win2000

    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.


    Philip Nelson Guest

Similar Threads

  1. Date and Time stamp on photo: how to remove
    By fred vincent in forum Adobe Photoshop 7, CS, CS2 & CS3
    Replies: 4
    Last Post: February 15th, 10:51 PM
  2. Time/Date Stamp on Note
    By Sarah_Mangum@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 0
    Last Post: April 1st, 04:48 PM
  3. Automatically adding date/time stamp to an edited record
    By Allen Browne in forum Microsoft Access
    Replies: 1
    Last Post: August 1st, 04:19 PM
  4. time stamp
    By Peter R. Fletcher in forum Microsoft Access
    Replies: 2
    Last Post: July 24th, 07:54 AM
  5. Date and Time stamp
    By Ken Snell in forum Microsoft Access
    Replies: 0
    Last Post: July 16th, 06:26 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139