I have a situation on a DB server where the "current timestamp" command
shows the actual system time offset by one hour, which has never been
noticed before?!?
The DB2 is V9.1 (FP03), running on AIX 5.3.
System timezone is offset by one hour to GMT, but this shouldn't cause such
behavior.
# echo $TZ
NFT-1DFT,M3.5.0,M10.5.0
# db2 "select current timestamp from sysibm.sysdummy1"
1
--------------------------
2008-03-28-11.21.07.753817
1 record(s) selected.
# date
Fri 28 Mar 2008 10:21:08
Any ideas on this one?
Regards,
Damir
7  9158 
Damir wrote:
I have a situation on a DB server where the "current timestamp" command
shows the actual system time offset by one hour, which has never been
noticed before?!?
The DB2 is V9.1 (FP03), running on AIX 5.3.
System timezone is offset by one hour to GMT, but this shouldn't cause such
behavior.
# echo $TZ
NFT-1DFT,M3.5.0,M10.5.0
# db2 "select current timestamp from sysibm.sysdummy1"
1
--------------------------
2008-03-28-11.21.07.753817
1 record(s) selected.
# date
Fri 28 Mar 2008 10:21:08
Any ideas on this one?
DST Daylight Savings Time
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
"Serge Rielau" <sr*****@ca.ibm.comwrote in message
news:65*************@mid.individual.net...
Damir wrote:
>I have a situation on a DB server where the "current timestamp" command
shows the actual system time offset by one hour, which has never been
noticed before?!?
The DB2 is V9.1 (FP03), running on AIX 5.3.
System timezone is offset by one hour to GMT, but this shouldn't cause
such behavior.
# echo $TZ
NFT-1DFT,M3.5.0,M10.5.0
# db2 "select current timestamp from sysibm.sysdummy1"
1
--------------------------
2008-03-28-11.21.07.753817
1 record(s) selected.
# date
Fri 28 Mar 2008 10:21:08
Any ideas on this one?
DST Daylight Savings Time
We had the same problem on our AIX 5.3 servers. db2 v9.1 fp2 and 4. Since
Fri March 28th 02:00 the summertime is active on the instance of db2.
(current timezone changes then from 1 to 2). That's 2 days to early. So all
current timestamps are wrong. We could change the timestamp to yesterday and
then back to today. Then the time is correct. But what's happening on Sunday
then when the real summetime in Europe starts ?
We opened a Sev 1 PMR for this unexpected problem.
Paul
Paul Peters wrote:
"Serge Rielau" <sr*****@ca.ibm.comwrote in message
news:65*************@mid.individual.net...
>Damir wrote:
>>I have a situation on a DB server where the "current timestamp" command
shows the actual system time offset by one hour, which has never been
noticed before?!?
The DB2 is V9.1 (FP03), running on AIX 5.3.
System timezone is offset by one hour to GMT, but this shouldn't cause
such behavior.
# echo $TZ
NFT-1DFT,M3.5.0,M10.5.0
# db2 "select current timestamp from sysibm.sysdummy1"
1
--------------------------
2008-03-28-11.21.07.753817
1 record(s) selected.
# date
Fri 28 Mar 2008 10:21:08
Any ideas on this one?
DST Daylight Savings Time
We had the same problem on our AIX 5.3 servers. db2 v9.1 fp2 and 4. Since
Fri March 28th 02:00 the summertime is active on the instance of db2.
(current timezone changes then from 1 to 2). That's 2 days to early. So all
current timestamps are wrong. We could change the timestamp to yesterday and
then back to today. Then the time is correct. But what's happening on Sunday
then when the real summetime in Europe starts ?
We opened a Sev 1 PMR for this unexpected problem.
Presumably with AIX?
PS: Which country are you? Germany switched on Easter Sunday (I thought)
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
>We opened a Sev 1 PMR for this unexpected problem.
Presumably with AIX?
PS: Which country are you? Germany switched on Easter Sunday (I thought)
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
With AIX. : I'm coming from the Netherlands. Europe is switching on next
Sunday (March 30th)
"Serge Rielau" <sr*****@ca.ibm.comwrote in message
news:65*************@mid.individual.net...
Paul Peters wrote:
>"Serge Rielau" <sr*****@ca.ibm.comwrote in message
news:65*************@mid.individual.net...
....
>We had the same problem on our AIX 5.3 servers. db2 v9.1 fp2 and 4. Since
Fri March 28th 02:00 the summertime is active on the instance of db2.
(current timezone changes then from 1 to 2). That's 2 days to early. So
all current timestamps are wrong. We could change the timestamp to
yesterday and then back to today. Then the time is correct. But what's
happening on Sunday then when the real summetime in Europe starts ?
We opened a Sev 1 PMR for this unexpected problem.
Presumably with AIX?
PS: Which country are you? Germany switched on Easter Sunday (I thought)
Here is my situation in more detail (on more different servers):
1. AIX 5.3_TL07, DB2 V9_FP03, current timezone = 2
2. AIX 5.3_TL07, DB2 V9_FP00, current timezone = 2
3. AIX 5.2_TL09, DB2 V9_FP02, current timezone = 1
It seems as though DB2 has a problem with AIX 5.3, since it works as
expected with AIX 5.2 ?!
Regards,
Damir
Does anyone know if this is a real problem ? Is there indeed a
timezone-related bug in DB2 v9 on AIX 5.3 ?
I think, that the timestamp generated from OS. Does your timestamp
shows different time than your OS ?
On Apr 8, 10:12 am, idenent...@hotmail.com wrote:
Does anyone know if this is a real problem ? Is there indeed a
timezone-related bug in DB2 v9 on AIX 5.3 ?
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Thomas Guettler |
last post by:
Hi,
I think it would be good, if the current time
would be in the traceback.
This would make it easier to read logfiles with
tracebacks of python scripts.
I know that I can write a custom...
|
by: Andreas |
last post by:
Hello list,
I suspect, this is a common issue for newbies.
Is there a simple way to have an auto-updating timestamp like mysql has ?
create table something (
id int4,
sometext...
|
by: Chris |
last post by:
Sorry,
This should be simple, but brain is hurting...
How do I convert a Current Time to a Decimal 6,0 (HMS)? There must be a
cleaner way then this:
Insert into Table Values
Dec(...
|
by: Russell Smith |
last post by:
Timestamps support infinity. However if appears dates do not.
When timestamps are cast to dates, there is no output. Is this an acceptable option or not?
Below are a number of examples...
|
by: Brian Tkatch |
last post by:
I have a PROCEDURE that test other PROCEDUREs.
Timings_Call
------------------
Id
Group
Name
Text
Timings_Log
|
by: anwar |
last post by:
Hi all,
Im trying to extract db2 server current system timestamp from unix
shell script. So from shell script call the export command " db2
export to curdate.txt of del modified by chardel' '...
|
by: mghale |
last post by:
I have a question that I'm hoping has an easy answer.
I'm working in DB2 V8.2 on AIX 5.3
I have a timestamp column (i.e. 4/26/2006 1:02:42.000000 PM) that I
want to return in a report from...
|
by: smowbray |
last post by:
I am trying to populate a timestamp on a form when a certain event happens. I am just starting to learn scripting and hope someone can help.
On my form there is a button that calls another process....
|
by: Ashit Vora |
last post by:
Hi,
I want to find the current time stamp in micro sec precision.
The requirement is,
my function is executed in an infinite loop.
I measure a value and check if the value computed is what i...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
| |
