APAR status
Closed as program error.
Error description
The problem is that originally the stream input had to be laid down first and was thus first in the list of links. However it is now possible to lay down the reference link first. Just convert the first input link to a reference link and lay down a new stream link. The problem also manifests itself as incorrect information in the director monitor, which interestingly does not differentiate between primary and reference lookup irrespective of the order the job is assembled.
Local fix
This fix is included in 8.0.1 fix pack 3
Problem summary
**************************************************************** USERS AFFECTED: Jobs using PxLookup stage **************************************************************** PROBLEM DESCRIPTION: Depending on the order in which PxLookup stage inputs llinks arecreated the reported row counts for reference links may be incorrectly reported. The first link was incorrectly assumed to be the stream input and the stream input's row count is used forall reference links. **************************************************************** RECOMMENDATION: apply patch and re-compile jobs that exhibit the problem. This change is included in 8.1 FP1 ****************************************************************
Problem conclusion
Changed Job compiler to ensure that stream input is first input.
Temporary fix
Comments
APAR Information
APAR number
JR31954
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
752
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-02-09
Closed date
2009-04-20
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:
Fix information
Fixed component name
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R752 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":"7.5.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
09 December 2010