Problem in Date From DB2/UDB

Andet · Post by **Andet** » Mon Nov 13, 2006 5:18 am

okay, lets go further then.

Is this a dataset or a flat file?
Is the datastaqe server and database in the same time zone?
Is the output server in the same time zone as datastage?
Is the Datastage client in the same time zone?
What timezone is all of the above?

(I've seen date differences from US to India for example).

Ande

ragunathan13 · Post by **ragunathan13** » Mon Nov 13, 2006 7:01 am

Andet wrote:okay, lets go further then.

Is this a dataset or a flat file?
Is the datastaqe server and database in the same time zone?
Is the output server in the same time zone as datastage?
Is the Datastage client in the same time zone?
What timezone is all of the above?

(I've seen date differences from US to India for example).

Ande

hi Ande

it is dataset.(same thing happend for some other like file set ,seq file )
The time zone is same for all.

Time zone for above all are (GMT+05:30)

Ragunathan J

Andet · Post by **Andet** » Mon Nov 13, 2006 7:21 pm

Must be that side of the world....

No, really, is the DB catalog and datastage server on the same server?
Does your network have automatic time synchronization?
I did some research into the processes and if you're not changing the date, either you found a remarkable bug, or your servers are not in synch.
I suggest you open a ticket with IBM.

Ande