Resolving problems with database stages on 64-bit systems

If you are running jobs in a 64–bit environment, you must ensure that any database clients that are required by connectivity stages match the installed version of InfoSphere® DataStage®.

Symptoms

Failure of the stage with symptoms such as a memory fault and corresponding core dump.

Causes

If you are running a 64–bit version of InfoSphere DataStage, you must ensure any database clients that you use are also 64–bit. If you are running a 32–bit version of InfoSphere DataStage, you must ensure any database clients that you use are also 32–bit.

For example, Oracle database is available with both 32- and 64-bit clients. You must use the 32-bit client with 32-bit InfoSphere DataStage, and the 64-bit client with 64-bit InfoSphere DataStage.

Important: On Windows, IBM® InfoSphere Information Server always runs as a 32-bit application, even when Windows is 64-bit. In this case, ensure that 32-bit drivers are installed for any database clients.

Environment

Applies to 64–bit UNIX, Linux, or Windows environments.