APAR status
Closed as program error.
Error description
Customer has upgraded from 7.5.1A to 8.01, default behaviour of Teradata Multiload stage on parallel canvas when loading char(n) values which contain less than n chars has changed due to Ecase 101629. At 7.5.1A such values were padded with spaces at 8.0.1 they are now correctly padded with $APT_STRING_PADCHAR which has a default of od 0x00. This change has had a significant impact after upgrade, was missed by their regression testing as such affected their go live date. They require a change such that the old behaviour can be obtained by the use of an envirnment variable.
Local fix
Set $APT_STRING_PADCHAR to 0x20
Problem summary
**************************************************************** USERS AFFECTED: ALL **************************************************************** PROBLEM DESCRIPTION: Actual length of CHAR column is given through DSCAPIOP as per specific customer request based on the environment variable PRESERVE_CHARDATA_LENGTH **************************************************************** RECOMMENDATION: Patch is provided for this customer. ****************************************************************
Problem conclusion
The difference of behavior in DSCAsStr() from 7.5.1 to 8.0.1 is due to the fix done for ecase 101629 to match with the behavior on server canvas. As the customer wants back the buggy behavior we have suggested an environment variable (but not sure what happens to the scenario mentioned in ecase 101629). Presently this particular customer needs to turn on the environment variable PRESERVE_CHARDATA_LENGTH to TRUE and the default behavior will take effect.
Temporary fix
Comments
APAR Information
APAR number
JR31223
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
801
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-11-26
Closed date
2011-05-20
Last modified date
2011-05-20
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
R801 PSY
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.0.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
20 May 2011