IBM Support

JR31223: ECASE 101629 FIX HAS CHANGED DEFAULT BEHAVIOUR (CORRECTLY), HOWEVER CUSTOMER WAS RELYING ON THIS, REGRESSION ON UPGRADE

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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