DB2 Migration

[Ravi.K]

Hi,

Recently we started migration of database DB2 8.2 to 9.5 version. During testing we found one issue when we read Date field(BIZDATE) as Date at DB2 API Stage then the BIZDATE is 1 day down to the actual date.

Suppose actual date: 2011-02-20 then output is coming as 2011-02-19.

Code: Select all

Job design:

DB2 API Stage --> Transfomer --> Sequential File.

Suppose when we read it as VARCHAR then it is good.

Any one come across this kind of issues.

[ray.wurlod]

Does this still occur if the Transformer stage is excluded?

[mantums]

View the data from DB2 stage, check what date it will show. Then you u will come to know that where is the error, check also any warning in the job after running.

[Ravi.K]

Sorry for the late reply. I was busy with other issues and BAU activities.

When i view data from DB2 API Stage it is showing as follows...

15757 (2011-02-20) Instead of 2011-02-20.

There are no warnings in the log.

[Ravi.K]

There are lot of Transformations applied at transformer stage. Eventhough i removed the transformer to find the issue. But no luck it is behaving same manner.

[Ravi.K]

We have raised a PMR with IBM. IBM provided a patch(APAR JR34196) for this and issue got resolved.

Thanks...