#DateForumTypeThreadPost
8419 Aug 2010 @ 02:55 PDTToolsReplyInmod Compilation on Windows or Unix for FastLoadFirst, I will say that it may not be guaranteed that source code compiled with GCC or TCC will work on Windows. However, assuming that the code was written, compiled and linked correctly and the...
8313 Aug 2010 @ 12:44 PDTToolsReplyMultiload --sequential or parallel for multitableEach .IMPORT statement can only accept a single file name. Each .IMPORT statement pertains to a single load task, and each one is executed sequentially. Within each .IMPORT statement you can spe...
8213 Aug 2010 @ 12:37 PDTToolsReplytlogview Example for MVSHere is another example. Note the special syntax -f "*" -g which tells tlogview to output "all" of the operator logs, and -g is to sort by operator. //HIS JOB statement //TLOGVIEW EX...
8113 Aug 2010 @ 12:35 PDTToolsReplytlogview Example for MVSThe JCL I provided was an example in case you DID provide names for private log names for the operators. It is better to supply them so that the output from each operator can be "categorized" into ...
8013 Aug 2010 @ 12:22 PDTToolsReplyMLoad and multiple input filesThe example given above, with the multiple .IMPORT statements will actually execute those load tasks sequentially, not in parallel. If you would like to load data from multiple files in parallel...
7906 Aug 2010 @ 01:09 PDTToolsReplytlogview Example for MVSHere is some tlogview info for MVS. Hope it helps. //* // SET TESTID='SAN@02' // SET SCRIPT=&TESTID ...
7806 Aug 2010 @ 12:33 PDTToolsReplyTPT_INFRA: TPT01162: Error: Unable to create the file INSTALLDIR/logs/TWBJobSeqNoScript-based TPT only has a 32-bit version. The API portion of TPT has both 32-bit and 64-bit libraries. In order to run 32-bit script-based TPT, you need all of the environment variables to point ...
7706 Aug 2010 @ 12:25 PDTToolsReplyTPT : tlogview Parameters and optionsIn general, the only ones you need are as follows: tlogview -j -f where: is the unique identifier of the job (usually, the job name with a hyphen and unique number) is the name of ...
7626 Jul 2010 @ 12:30 PDTToolsReplyTerradata Connection: ICULOADERROR(527)According to the CLI expert: No, the user apps must NOT link with ICU. This error means CLI could not dlopen the ICU library. Most likely it is not installed or not in the path, or, less likely,...
7523 Jul 2010 @ 01:08 PDTToolsReplyTeradata PT 12.0 error output schema does not matchThe error message manual for TPT is a work in progress. We have started it (in 13.10) but not all errors are in there. We will be adding them in each release. I agree with you that some errors s...
7414 Jul 2010 @ 01:24 PDTToolsReplyTPT-Data Synch using Teradata Parallel TransporterPlease contact Jeff Schemanske for information on evaluating Teradata Data Mover.
7313 Jul 2010 @ 03:11 PDTToolsReplyfastload insertion I am not quite sure that the DBS FastLoad protocol will allow CASE logic in an INSERT statement. The use of the INSERT statement with FastLoad is very restrictive (DBS restriction, not client restr...
7213 Jul 2010 @ 03:08 PDTToolsReplyTPT-Data Synch using Teradata Parallel TransporterTeradata Data Mover is a separate product offering and is not part of TTU. It has special requirements (it requires Teradata Managed Servers running Linux).
7112 Jul 2010 @ 03:29 PDTToolsReplyTPT-Data Synch using Teradata Parallel TransporterTPT cannot perform data synchronization (Data Mover is a better choice for that). TPT is just the mechanism by which you would actually copy the data (and Data Mover uses ARC and TPT's operators...
7012 Jul 2010 @ 03:26 PDTToolsReplyfastload windows 64-bit?On Windows, FastLoad and FastExport run as 32-bit apps. There is no 64-bit version.
6912 Jul 2010 @ 03:25 PDTToolsReplytpt export importWe use the system's virtual memory. We do not use a file system.
6802 Jul 2010 @ 09:39 PDTToolsReplyRelease Lock - LOAD Operator - TPTThe Load operator in TPT works the exact same way as FastLoad, and TPT can recover from the same errors as FastLoad, in the same fashion. When there is an error and you do not want to, or cannot...
6702 Jul 2010 @ 09:30 PDTToolsReplytpt export importThank you for trying TPT. I think you will find it easier to do export-to-load with TPT than trying to use FastExport and FastLoad (or MultiLoad) with named pipes and all of the coordination needed...
6623 Jun 2010 @ 11:12 PDTToolsReplyWarehouse BuilderIf you have checked your data file and have validated that it is ok, then my suggestion would be to upgrade to one of the supported versions of Teradata Parallel Transporter (TPT). You are runni...
6517 May 2010 @ 06:22 PDTToolsReplyPT job with Oracle and Informix ODBC operator errorTPT and the ODBC operator are only certified with ODBC drivers from DataDirect. Also, please indicate which version of TPT you are using.
6417 May 2010 @ 06:10 PDTToolsReplyTeradata PT 12.0 error output schema does not matchIf you want to use the Export operator to extract the data from Teradata, then yes you need to CAST the columns in the SELECT statement being sent to Teradata. The Export operator utilizes the Fast...
6324 Feb 2010 @ 05:41 PSTToolsReplyFLOAD CANNOT OPEN FILE,RETURN CODE 12It looks like the output has been edited to remove timestamps and such.It would be best to provide as much of the output as possible without any editing.My guess would be that:1. file does not exis...
6218 Feb 2010 @ 07:30 PSTToolsReplyMload failureBTW, if you release the locks, and you delete the work tables, all previous rows sent to Teradataare gone. This means you will have to start the job from the very beginning, meaning you need toalso...
6118 Feb 2010 @ 07:27 PSTToolsReplyMload failureThe post subject line says "Mload failure" but this is really TPT, not MultiLoad.If this job will always fail when re-running it, then a few things can be done:1. go into $TWB_ROOT/logs and look fo...
6028 Jan 2010 @ 11:29 PSTToolsReplyTPT load from ORACLE to TeradataDECIMAL(10,0) in the TPT schema should work. If that does not work, please send me the output from the job, the job script and even the log file (the .out file, which is binary). I will take a l...

Pages