Netezza Enterprise Configuration Issue

[vkumar]

Hello ...

I am trying to connect to NZ database(NPS-4.5) using ODBC and NZ Enterprise Stage.

I created a simple job

Job1: Flat file --> Copy Stage --> ODBC Stage
Job2: Flat file --> Copy Stage --> NZ Enterprise Stage

Job1 with ODBC worked fine but Job2 with NZ stage is not working

Here is the error I get when I use NZLOAD method.

Error: Netezza_Enterprise_12,0: Error: ERROR: External Table : count of bad input rows reached maxerrors limit, see nzlog file
Erro [nzetsubop.C:300]

Is there a Environment variable where we can set the max errors?

Here is the error I get when I use ET method

Error: Netezza_Enterprise_12,2: Error: Error occured while opening data file
Error: unable to open '/nz/sys/strings/ldrStrings.C.txt [nzetsubop.C:300]

Do I need any additional permissions on the database to use this method?

I tried the DS_CONNECT and Example script in the branded_odbc folder and it ends up in Core Dump.

Is it necessary that this scirpts shld work? ODBC job works OK with this script failing.

Pls advise.
Thanx

[vkumar]

Resolution:

Add a new parameter in the Administrator or the Job
$APT_NZ_ERRORS_ALLOWED = 100

Update LIBPATH
NZ_HOME path should precede Oracle_HOME path.

For Example..here is our LIBPATH

/opt/IBM/InformationServer/Server/branded_odbc/lib:/opt/IBM/InformationServer/Server/DSComponents/lib:/opt/IBM/InformationServer/Server/DSComponents/bin:/opt/IBM/InformationServer/Server/DSEngine/lib:/opt/IBM/InformationServer/Server/DSEngine/uvdlls:/opt/IBM/InformationServer/Server/PXEngine/lib:/opt/IBM/InformationServer/ASBNode/apps/jre/bin:/opt/IBM/InformationServer/ASBNode/apps/jre/bin/classic:/opt/IBM/InformationServer/ASBNode/lib/cpp:/opt/IBM/InformationServer/ASBNode/apps/proxy/cpp/aix-all-ppc_64:/usr/nps/kit/lib64:/usr/oracle/product/10.2.0/db/lib


It worked fine....