Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
What's the relationship between DB2 time and system time?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Fri Aug 22, 2014 8:28 am    Post subject: What's the relationship between DB2 time and system time?
Reply with quote

What's the relationship between DB2 time and system time?
If system time changes, will DB2 time change?
or, DB2 time is retrieved by a special engine that owned by DB2 itself?

What if I changed the current time of DB2? should I stop DB2 first?
Back to top
View user's profile Send private message

gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Fri Aug 22, 2014 5:37 pm    Post subject:
Reply with quote

How will you change DB2 system time? I think DB2 picks time from system.
Back to top
View user's profile Send private message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Fri Aug 22, 2014 7:46 pm    Post subject:
Reply with quote

gylbharat wrote:
How will you change DB2 system time? I think DB2 picks time from system.

my data is processed by order of TIMESTAMP when it was inserted, if someone changes system time, there might be impact on my processing. So, I care about it.
I cannot find some useful information from DB2 redbook, so, I hope some one could help me on this.

thanks.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1806
Location: NY,USA

PostPosted: Fri Aug 22, 2014 7:48 pm    Post subject:
Reply with quote

The CURRENT DATE special register gives the current system date. This can be used in select statements or more directly using the VALUES statement.

Quote:
DB2 time is retrieved by a special engine that owned by DB2 itself?


I don't think there is any special engine, the values or sysibm.sysdummy1 gives the date from the current server.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1806
Location: NY,USA

PostPosted: Fri Aug 22, 2014 9:23 pm    Post subject:
Reply with quote

Quote:
my data is processed by order of TIMESTAMP when it was inserted, if someone changes system time, there might be impact on my processing. So, I care about it.

And can you give us a case?
Back to top
View user's profile Send private message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Fri Aug 22, 2014 10:00 pm    Post subject:
Reply with quote

for instance, I will process data exactly in the acending order of timestamp when data was inserted, but if someone changes the time to a earlier point, the following data inserted in a period of time will never be processed. This is a problem.
Back to top
View user's profile Send private message
Bill O'Boyle

CICS Moderator


Joined: 14 Jan 2008
Posts: 2504
Location: Atlanta, Georgia, USA

PostPosted: Fri Aug 22, 2014 11:41 pm    Post subject: Reply to: What's the relationship between DB2 time and syste
Reply with quote

It seems you're describing a Daylight Saving change. If this is true, when you fallback, most shops stop processing for one-hour.

When you move forward, you'll see a one-hour difference in timestamps between the timestamp prior to moving forward and the updated timestamp after moving forward. This movement is normally based upon the Greenwhich Mean Time offset.

The DSN where the GMT offset is set, is usually SYS1.PARMLIB. But, I can't recall the member name. Your z/OS System Programmer would know the member nanme.

If you find the member name, look at the last USERID who updated it.

If someone in your shop is altering the timestamp (this is at the Operating System level) without authorization or without any legitimate reason (possibly malicious), you better find out who this is, before he/she really screws up the works. icon_oak.gif

HTH....
Back to top
View user's profile Send private message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Sat Aug 23, 2014 5:58 pm    Post subject:
Reply with quote

Thanks, Bill.
So, you are telling that DB2 time is retrieved from system time.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. 00D3003B - time outs in DB2 when invo... chavinash2004 DB2 2 Mon Oct 09, 2017 4:39 pm
No new posts VSAM RLS Wait time blayek JCL & VSAM 2 Mon Oct 02, 2017 9:05 pm
No new posts Comparing 2 Files using Current time arunsoods SYNCSORT 9 Fri Sep 22, 2017 6:00 pm
No new posts Regarding time parameter shanthi gude JCL & VSAM 7 Mon Sep 04, 2017 2:31 pm
No new posts How system know which REXX to excute? jackzhang75 CLIST & REXX 14 Thu Jul 06, 2017 1:09 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us