IBM Support

JR31810: NETEZZA STAGE, NZLOAD, GETS "FILE NOT FOUND" WITH 2 NODES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Customer is running job with Netezza stage using nzload method
    on a 2-node cluster.  DS 8.1, Red Hat Linux.  Getting "file not
    found" errors from nzload.
    
    1 - File names passed to the nzload utility incorporate only the
    fastname of the conductor node, rather than the fastname of the
    node the operator is run on (see item #71 in the log)
    
    2 - The location of these files is always /tmp... regardless of
    what he has specified in his apt.config file
    

Local fix

  • This fix is included in 8.0.1 fix pack 3
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    Users of Netezza Operator Stage
    ****************************************************************
    PROBLEM DESCRIPTION:
    Running a job with Netezza stage using nzload method on a
    2-nodecluster. DS 8.1, Red Hat Linux.  Getting "file not
           found" errors from nzload.
    ****************************************************************
    RECOMMENDATION:
    Apply this APAR.
    The fix has been included in the IS 8.1 FP1. Apply the FP1 for
    IS 8.1
    ****************************************************************
    

Problem conclusion

  • Problem has been corrected by generating the pipe name so that
    separate pipes on the native nodes will be created and there
    won't be any "further file not found" errors.
    
    Also making use of the TMPDIR environment variable so that the
    log files and temporary location can be set at runtime.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR31810

  • 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-01-27

  • Closed date

    2009-02-25

  • Last modified date

    2010-12-10

  • 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 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.0.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
10 December 2010