APAR status
Closed as program error.
Error description
Site has DataStage "server" job consisting of data source, DB2 API lookup stage, and an output file containing combination of columns from both the data source and matching row from DB2 lookup stage which worked correctly. . After migrating from 7.5 to 8.1, the same server job now generates incorrect output. Numeric columns from the DB2 lookupt stage still output correctly, but character columns (both CHAR and VARCHAR) containing non-null values now output the string "0" instead of correct value, or in come cases output a null. . This problem is limited to the DB2 API stage. If the lookup is performed instead using ODBC stage, the output is correct. . Note: Reference CRM# 64886,370,000.
Local fix
Use ODBC stage in place of DB2 API stage to bypass problem. This fix is included in 8.0.1 fixpack 3
Problem summary
**************************************************************** USERS AFFECTED: The problem is seen when using DB2 API stage in IS 8.1 to lookup data **************************************************************** PROBLEM DESCRIPTION: All character columns (CHAR and VARCHAR) have output value of "0" when DB2 API stage is used as a lookup **************************************************************** RECOMMENDATION: Install patch_JR33424 ****************************************************************
Problem conclusion
The issue is fixed in patch_JR33424
Temporary fix
Comments
APAR Information
APAR number
JR33424
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
810
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-06-18
Closed date
2009-06-26
Last modified date
2010-12-09
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
DB2API
Fix information
Fixed component name
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R810 PSN
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
09 December 2010