IBM Support

JR32751: DATASTAGE 8.0.1: PX JOB LOGS APPEAR CONFUSED WHEN RUNNING MULTIPLE NETEZZA LOADS IN PARALLEL.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When running multiple paralled (PX) jobs which load data into
    Netezza targets, the job logs get messed up.  For example:
    
    Job 1 is loading Table A
    Job 2 is loading Table B
    
    In the logs of Job 1 there are messages for Table B.
    

Local fix

  • This fix is included in 8.0.1 fix pack 3
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    IS 801 RH Linux Netezza EE Stage
    ****************************************************************
    PROBLEM DESCRIPTION:
    DATASTAGE 8.0.1: PX JOB LOGS APPEAR CONFUSED WHEN RUNNING
    MULTIPLE NETEZZA LOADS IN PARALLEL
    ****************************************************************
    RECOMMENDATION:
    NOTE: Pls apply the PX Engine patch before applying this netezza
    patch.
    
    PXEngine patch: JR32539.
    
    Instead of applying the patch JR32456 for this CRM it is
    preferred to apply the patch JR32825 for the CRM 17008.379,000
    
    which has the fix for both the CRMs and is the cumulative patch.
    ****************************************************************
    

Problem conclusion

  • The code is fixed.
    Now uniquely and different 'nzoutput' files are created for each
    run of netezza ee stage on each datastage node, so that the PX
    Job log will log out the right table name in the ds job log.
    Patch has been delivered to the customer.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR32751

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-04-20

  • Closed date

    2011-12-21

  • Last modified date

    2011-12-21

  • 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:
21 December 2011