DSXchange

Point JAVA_HOME to /opt/IBM/WebSphere/AppServer/java_1.7_64/bin/java

Yes. The BCI functions emulate the ODBC API. Search here for examples and details.

The Knowledge Center still shows 12c as supported, so I guess they haven't gotten around to fixing it there.

It didn't like your line 3, which needs to name the services tier machine.

Line 4 needs to name the engine tier machine.

DSXchange is an all-volunteer site whose members post as and when they can. There is no obligation to do so. Further, we don't do "urgent". If you want "urgent" sign up with your official support provider for premium service, and learn just how expensive "urgent" can b...

The log will tell you.

Do a "Where Used" report (in Designer or in Metadata Workbench) for the Teradata Connector stage.

A Transform SP usually expects to have input(s) and output.

First do some diagnosis - create a job that pulls the DB2 table into a Copy stage (which acts as a sink). That will allow you to determine whether the slowness is in the DB2 stage or the Data Set write operation.

Let us know, then we can address the correct problem instead of wasting time.

Use the 32-bit ODBC Administrator (odbcad32.exe) to create a 32-bit DSN. You will probably find this in the SysWOW64 folder.

The aa_project&!DS.ADMIN!& is a shared lock only, to signal administrator tools that they don't have exclusive access to the project. This kind of lock will not exhibit the symptoms you have described. I'm not sure what the problem is here. It might be that you only have a single licence for...

Did you create a System DSN or File DSN? DataStage will not work with a User DSN.

Do you have a rejects link to capture any rows the were sent but failed to be inserted?

dsjob -ljobs projectname

Remember that the project name is case sensitive.