System clock vs. DB2 - DB2 Database

eugene

Is there any issue re-setting system time while DB2 database is online
and the system clock is ahead. The database is actually a 24x7
operational and a unscheduled shutdown would be a problem.
Thanks,
-Eugene

Nov 12 '05 #1

Subscribe Post Reply

5906

Jan M. Nelken

eu****@profitlogic.com wrote:

Is there any issue re-setting system time while DB2 database is online
and the system clock is ahead. The database is actually a 24x7
operational and a unscheduled shutdown would be a problem.
Thanks,
-Eugene

Yes. Even when db2 is stopped setting clock back may be hazardous to your health
(think recovery - point in time). How much clock is ahead?

Jan M. Nelken

Nov 12 '05 #2

eugene

The system clock is about 40 min ahead wich is not good to the
applications using this database instance (I'll have to fix the
timestamps in the app tables anyways at the scheduled database
meintenance time).

Nov 12 '05 #3

Jan M. Nelken

eu****@profitlogic.com wrote:

The system clock is about 40 min ahead wich is not good to the
applications using this database instance (I'll have to fix the
timestamps in the app tables anyways at the scheduled database
meintenance time).

At time T bring *completely db2 down.
Change Autostart to No (*** Test this part - no DB2 processes should be started).
Reboot.
Reset system clock to T-40.
Reboot the system.
Wait 45 minuts.
Start DB2.
Change Autostart to yes.

Jan M. Nelken

Nov 12 '05 #4

eugene

I also figured out an alternative solution which would be:
- Stop the database
- Start the database in quiesced mode and switch from the archival
logging to the circular one (that should reset database logs)
- Restart the database to activate noarchivelog mode
- Stop the database
- Reset system clock (I am not sure if a Linux server should be
rebooted after it's clock gets reset)
- Start the database in quiesced mode and switch back to archival
logging
- Restart the database to activate archival logging (backup will be
forced of course).

Pros: no need to ensure there is no DB2 processes running and wait for
more than 40 min.
Cons: database backup required switching from circular to archival mode

The latter is not an issue as will take no longer than 15-20 min or so
to disk in our case.

Does it seem to make sense?

-Eugene

Nov 12 '05 #5

Serge Rielau

Jan M. Nelken wrote:

eu****@profitlogic.com wrote:
The system clock is about 40 min ahead wich is not good to the
applications using this database instance (I'll have to fix the
timestamps in the app tables anyways at the scheduled database
meintenance time).

At time T bring *completely db2 down.
Change Autostart to No (*** Test this part - no DB2 processes should be
started).
Reboot.
Reset system clock to T-40.
Reboot the system.
Wait 45 minuts.
Start DB2.
Change Autostart to yes.

Jan M. Nelken

And make sure no DDL has been done in the 40min you'll get double.
E.g. SQL statements cannos see functions screated in the future.
Cheers
Serge

Nov 12 '05 #6

Stanley Sinclair

So, bottom line guys . . .

How to keep all clients on a server at the same time? And how to keep
all servers on a system at the same time?
I'm using Windows 2003 Server with all XP clients.

Nov 12 '05 #7

Gert van der Kooij

In article <11**********************@f14g2000cwb.googlegroups .com>,
Stanley Sinclair (st*************@bellsouth.net) says...

So, bottom line guys . . .

How to keep all clients on a server at the same time? And how to keep
all servers on a system at the same time?
I'm using Windows 2003 Server with all XP clients.

You can define the 2003 server to act as the internet time server
which you can define on the XP clients. Check the XP help for
additional info.

Nov 12 '05 #8

Mark Yudkin

Put a radio-controlled clock or other such hardware on the W2K3 server and
make it a time service provider. You can also use an internet time service
provider if you prefer, but the dedicated hardware is better.

Configure the XP clients to use the W2K3 server as their time service
provider.

The w32tm command is used for both functions.

If you're using DHCP for the XP client, you just define the W2K3 server as
the time server (option 004) in the DHCP. You can also define your time
offset there too (option 002). That way, you don't have to manage all the XP
clients separately.

"Stanley Sinclair" <st*************@bellsouth.net> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

So, bottom line guys . . .

How to keep all clients on a server at the same time? And how to keep
all servers on a system at the same time?
I'm using Windows 2003 Server with all XP clients.

Nov 12 '05 #9

Similar topics

System Time Update using IRIG

by: Valiz | last post by:

Hi, I am updating system time with IRIG time source which sends irregular pulses as shown below 11000011111100111111111111111111....(1-IRIG present and 0-IRIG not present) I need to update...

Visual Basic 4 / 5 / 6

System Clock

by: James Harriman | last post by:

Hi, I need to be able to measure a time interval in milliseconds on a windows machine. I have tried using time.clock() but it appears to measure time in seconds...Is there a way to measure time...

Python

How to determine if the system clock has been set back in time

by: David Lindgren | last post by:

Hello. I am trying to figure out a way to determine if the user has resetted the system clock between two times of running my application. One idea I have is that I could check the modified date...

.NET Framework

System time in C++

by: Partho Choudhury | last post by:

Hi all: I need to add a snippet which access the system time (upto atleast milliseconds) using ANSI std. C++. I cannot use MFC and Win32 APIs in my program for now for various reasons. Is there...

C / C++

Is it possible to examine a system from within a VBA procedure to read and document system settings?

by: MLH | last post by:

I wish to give someone an A97 database they can install on their PC as a runtime application. I want them to click a button on a form (frmDocumentMyPC). I want to document as much useful...

Microsoft Access / VBA

calculating system clock resolution

by: jUrner | last post by:

Hello all I have the problem of how to calculate the resolution of the system clock. Its now two days of head sratching and still there is nothing more than these few lines on my huge white...

Python

Read System Clock in Windows

by: Moikel | last post by:

Hello, I'm writing a program that requires that I generate random numbers. I'm using the C rand()function. I want to use the system clock as a seed for the function. How do I read the system...

C / C++

pausing system clock

by: Carlos Lozano | last post by:

I have requirement to pause the system clock until a certain event (Win XP). Then the clock will be resumed to the real time. I think it can be done using core functions and/or redirecting the...

C# / C Sharp

Replace System tray clock

by: David H | last post by:

I am looking for a way to either run a program in the system tray, or (ideally) replace the system clock with my own custom clock app. I know I can use NotifyIcon to put an icon in the tray, but...

C# / C Sharp

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing