[H-GEN] TimeZones and Redhat 8.0

[Timothy Hitchens]

[ Humbug *General* list - semi-serious discussions about Humbug and     ]
[ Unix-related topics. Posts from non-subscribed addresses will vanish. ]

DB2 has it's own time offset settings and you need to check these as
well.

I haven't used DB2 for about 18 months and can't remember off the top of
my
head what it is back look it up.



Timothy Hitchens (HiTCHO)
Open Source Consulting
e-mail: tim at hitcho.com.au

> -----Original Message-----
> From: Majordomo [mailto:majordom at caliburn.humbug.org.au] On 
> Behalf Of Mark Leung
> Sent: Tuesday, 21 January 2003 9:05 AM
> To: general at lists.humbug.org.au
> Subject: Re: [H-GEN] TimeZones and Redhat 8.0
> 
> 
> [ Humbug *General* list - semi-serious discussions about 
> Humbug and     ]
> [ Unix-related topics. Posts from non-subscribed addresses 
> will vanish. ]
> 
> 
> James, apologies for ignorance - what is NTP daemon ?
> I have Mandrake 8.0 and DB2 v7.2.  When I type "date" on the 
> command line, and when I use "current timestamp" in insert 
> SQL statements, I don't get the 1 hour difference.  I am in 
> the Queensland timezone. Ming
> 
> 
>                                                               
>                                                       
>                       "James Collins"                         
>                                                       
>                       <nospam at ltuae.com>            To:       
> <general at lists.humbug.org.au>                         
>                       Sent by: Majordomo            cc:       
>                                                       
>                       <majordom at caliburn.hum        Subject:  
> [H-GEN] TimeZones and Redhat 8.0                      
>                       bug.org.au>                             
>                                                       
>                                                               
>                                                       
>                                                               
>                                                       
>                       19/01/03 15:09                          
>                                                       
>                       Please respond to                       
>                                                       
>                       general                                 
>                                                       
>                                                               
>                                                       
>                                                               
>                                                       
> 
> 
> 
> [ Humbug *General* list - semi-serious discussions about 
> Humbug and     ]
> [ Unix-related topics. Posts from non-subscribed addresses 
> will vanish. ]
> 
> 
>     I seem to be having a strange thing with DB2 and Redhat 
> 8.0 - While the time revealed by typing "date" on the command 
> line is correct, and the NTP daemon is running correctly and 
> everything "appears" correct, when I do an insert or update 
> on a DB2 database, using the "current timestamp" command, the 
> time is 1 hour slow.... Has anyone else in the Queensland 
> timezone had this strangeness occur?? Anyone got any idea 
> where I might look for where the problem is? NB: This problem 
> doesn't occur on the test server, which is currently still 
> running 7.3 - Only on the 8.0 production server...
> 
> James :) Collins
> 
> 
> 
> --
> * This is list (humbug) general handled by 
> majordomo at lists.humbug.org.au .
> * Postings to this list are only accepted from subscribed addresses of
> * lists 'general' or 'general-post'.  See http://www.humbug.org.au/
> 
> 
> 
> 
> 
> --
> * This is list (humbug) general handled by 
> majordomo at lists.humbug.org.au .
> * Postings to this list are only accepted from subscribed addresses of
> * lists 'general' or 'general-post'.  See http://www.humbug.org.au/
> 


--
* This is list (humbug) general handled by majordomo at lists.humbug.org.au .
* Postings to this list are only accepted from subscribed addresses of
* lists 'general' or 'general-post'.  See http://www.humbug.org.au/