Archives of the TeradataForum

Message Posted: Wed, 12 Oct 2011 @ 08:58:32 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Machha,

Thanks for your reply. Where can I find the Mload.exe in the client folder? Also the absolute path I was referring to is the library path.

( From Teradata pdf... )

Making 32-bit Load and Unload Utilities Work with 64-bit PowerCenter

Applies to: FastLoad, MultiLoad, TPump, FastExport

If you use 64-bit PowerCenter, you need to reset the library path to make PowerCenter work with the32-bit Teradata load and unload utilities. You must reset the library path before you can run a session that invokes a load or unload utility.

To reset the library path, you need to replace the loader or FastExport executable with a shell script. The following procedure explains how to reset the library path for TPump on AIX. You can use the same method to reset the library path for the other utilities on Linux or other UNIX operating systems.

To reset the library path:

1. Create a shell script like the following called _infa, for example,

     tpump_infa :

     #!/bin/sh
     LIBPATH=/usr/lib;export LIBPATH
     COPLIB=/usr/lib;export COPLIB
     COPERR=/usr/lib;export COPERR
     PATH=$PATH:$INFA_HOME/server/infa_shared/TgtFiles
     exec tpump "$@"
     exit $?

In the loader connection in the Workflow Manager, set the External Loader Executable attribute (for a load utility) or the Executable Name attribute (for FastExport) to the name of the shell script. So for Tpump, change the External Loader Executable from tpump to tpump_infa.

Please tell me which library path have been mentioned here.

Regards,

Gunja Khemka
Consultant

	<Prev	Next>		<<First	<Prev	Next>	Last>>