Netezza Enterprise Load Issue

[vkumar]

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 ....

[asorrell]

It sounds like a Netezza file isn't accessible from the Server 2 nodes.

Is that file accessible from the second system?

Both machines need to have access to all the setup / config files for both DataStage AND Netezza.

[vkumar]

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