JR34196: THE PROBLEM IS ABOUT READING ROWS FROM DB2 USING DB2 API STAGE

APAR status

• Closed as program error.

Error description

• the problem is about reading rows from DB2 using DB2 API stage,
  having
  DATE columns. The behavior is that the value extracted from DB2
  is
  modified by DataStage subtracting one day. For example, if in
  the table
  is
  written "09/03/2009", DataStage produces as result "09/02/2009"
  (exactly
  one day before).
  
  The same job implemented as server job, works as expected.
  the problem occurs on DataStage V7.5.1A running on Red Hat
  Enterprise
  Linux AS release 3 update 9. DB2 Server is V9.5.3.
  
  The problem is the same as PMR 91635,000,738 (751a: Date one day
  early
  for 11/12/09).
  Such PMR hs been solved installing patch e119071.
  

Local fix

• The problem is the same as PMR 91635,000,738 (751a: Date one day
  early
  for 11/12/09).
  Such PMR hs been solved installing patch e119071.
  the problem occurs on DataStage V7.5.1A running on Red Hat
  Enterprise
  Linux AS release 3 update 9. DB2 Server is V9.5.3.
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users on 7.5.1A using DB2 API stage
  ****************************************************************
  PROBLEM DESCRIPTION:
  The problem is about reading rows from DB2 using DB2 API stage,
  having DATE columns. The behavior is that the value extracted
  from DB2 is modified by DataStage subtracting one day. For
  example, if in the table is written "09/03/2009", DataStage
  produces as result "09/02/2009" (exactly one day before).
  
  
  ****************************************************************
  RECOMMENDATION:
  Apply patch dscapi_redhat_751_090904.tar on 7.5.1a branch
  ****************************************************************
  

Problem conclusion

• Provided Fix from 7.5.1a branch, as the code changes are
  already in that branch.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• SERVER
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R752 PSN

     UP