DSXchange

I updated the APT_PM_CONDUCTOR_TIMEOUT to 900 and it woks fine...

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

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

Syntax... Prior to the patch /opt/IBM/InformationServer/Server/DSEngine/bin/dsjob -domain server -user dsadm -password dsadm -server server:31539 -lprojects After the patch dsjob -server :31539 -lprojects RESOLUTION: Fixed dsjob argument validation to allow "-server :portno" to be used wit...

Yep..IBM confirmed that unless there is only one version installed and using the default port, fully qualifying the server and port is mandatory for a dsjob command....

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

I tested the file method and it worked fine .. BUT

Is there a way to skip the domain also or none at all?

I mean using dsjob command as is ? My concern is we have a ton of scripts using dsjob in 7.5 that have to be upgraded to 8.1.

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

Finally it works....

Resolution Steps:

1) Update dsenv - Update the NZ and Oracle paths to point to 64bit version libraries.
2) Update odbc.ini - Use the 64bit driver
3) Restart Datastage Server.


Thanx
SvK

Hello ... DS8.1 is 64bit and the drivers are expected to be 64bit. It was a dsenv issue. I had to make sure the PATH and LIBPATH are set correctly and the Oracle and NZ directories are pointed correctly (xxbit) and also placed correctly in the PATH variable. Here is the env USER=isadmin8 LOGNAME=isa...

Hello... I am trying to configure ODBC to read a table on Netezza Database. Actually I am not even able to connect to the Database.... Executing the "example" script in branded_odbc results in this error. I am able to connect to Netezza database from AIX. [turks: isadmin8 :/opt/IBM/Informa...

Hello....

I tried other Orchadmin commands like check, copy and they all work fine...

I was able to copy a dataset I was able to use osh head etc and they are fine...


I dont know why orchadmin lf or rm or any connected to viewing the data files are not working....

Per IBM Support.... Edit the file " /opt/IBM/InformationServer/Server/DSEngine/sample/ds.rc " There is a section in the script with the following line: ------------------------------------------------------ # get the env of the admin, and filter out weird stuff (su $admnID -c "sh -c \...

Hello Ray....

I set up trusted ssh connection (creating id_rsa.pub) and I am able to ssh from one server to other without password.
and
I updated the remsh file to access thru ssh

Scenario: New installation. Datastage 8.1 installed on Server1 and Mounted the /opt/IBM/ folder on Server2 Configuration / Partitions: node1 and node2 are on Server1 and node3 and node4 are on Server2 Issue: A dataset is created with all 4 nodes (2nodes on Server1 + 2nodes on Server2). Job ran succe...