Netezza Enterprise Load Issue
Posted: Fri Mar 19, 2010 12:40 pm
Hello ...
I have a job that loads data from a flat file to a Netezza Database. Our Datastage-8.1 is setup on a server and mounted on another server.
My APT_CONFIG has 4 nodes (2nodes on Server1 and 2nodes on Server2). Server2 doesn't have any installation but the Server1 installation directory is cross mounted on the Server2.
Issue: When I execute the Netezza load job using only Server1 nodes data is loaded successfully BUT when I execute the same job using all 4 nodes job aborts with this error but some records are loaded. Data from Server1 nodes are loaded.
Load method used is "nzload"
Error:
Netezza_Enterprise_15,2: Error: Error occured while opening data file
Error: unable to open '/nz/sys/strings/ldrStrings.C.txt
Pls advise ....
I have a job that loads data from a flat file to a Netezza Database. Our Datastage-8.1 is setup on a server and mounted on another server.
My APT_CONFIG has 4 nodes (2nodes on Server1 and 2nodes on Server2). Server2 doesn't have any installation but the Server1 installation directory is cross mounted on the Server2.
Issue: When I execute the Netezza load job using only Server1 nodes data is loaded successfully BUT when I execute the same job using all 4 nodes job aborts with this error but some records are loaded. Data from Server1 nodes are loaded.
Load method used is "nzload"
Error:
Netezza_Enterprise_15,2: Error: Error occured while opening data file
Error: unable to open '/nz/sys/strings/ldrStrings.C.txt
Pls advise ....