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 ....
Netezza Enterprise Load Issue
Moderators: chulett, rschirm, roy
Netezza Enterprise Load Issue
Thanx........
CTCT
CTCT
A separate NZ Client is installed on Server1 and Server2.
We tried to create a soft link for the directory in the root on Server2...Error changed to...
Netezza_Enterprise_12,2: Error: Error occured while opening data file
Error: Load Failed, records not inserted.
But the same set of records are loaded successfully If I use only the main Server1 nodes. Data is not a problem. I am missing something....Pls advise
We tried to create a soft link for the directory in the root on Server2...Error changed to...
Netezza_Enterprise_12,2: Error: Error occured while opening data file
Error: Load Failed, records not inserted.
But the same set of records are loaded successfully If I use only the main Server1 nodes. Data is not a problem. I am missing something....Pls advise
Thanx........
CTCT
CTCT