84 | 19 Aug 2010 @ 02:55 PDT | Tools | Reply | Inmod Compilation on Windows or Unix for FastLoad | First, 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... |
83 | 13 Aug 2010 @ 12:44 PDT | Tools | Reply | Multiload --sequential or parallel for multitable | Each .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... |
82 | 13 Aug 2010 @ 12:37 PDT | Tools | Reply | tlogview Example for MVS | Here 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... |
81 | 13 Aug 2010 @ 12:35 PDT | Tools | Reply | tlogview Example for MVS | The 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 ... |
80 | 13 Aug 2010 @ 12:22 PDT | Tools | Reply | MLoad and multiple input files | The 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... |
79 | 06 Aug 2010 @ 01:09 PDT | Tools | Reply | tlogview Example for MVS | Here is some tlogview info for MVS. Hope it helps.
//*
// SET TESTID='SAN@02'
// SET SCRIPT=&TESTID ... |
78 | 06 Aug 2010 @ 12:33 PDT | Tools | Reply | TPT_INFRA: TPT01162: Error: Unable to create the file INSTALLDIR/logs/TWBJobSeqNo | Script-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 ... |
77 | 06 Aug 2010 @ 12:25 PDT | Tools | Reply | TPT : tlogview Parameters and options | In 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 ... |
76 | 26 Jul 2010 @ 12:30 PDT | Tools | Reply | Terradata 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,... |
75 | 23 Jul 2010 @ 01:08 PDT | Tools | Reply | Teradata PT 12.0 error output schema does not match | The 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... |
74 | 14 Jul 2010 @ 01:24 PDT | Tools | Reply | TPT-Data Synch using Teradata Parallel Transporter | Please contact Jeff Schemanske for information on evaluating Teradata Data Mover. |
73 | 13 Jul 2010 @ 03:11 PDT | Tools | Reply | fastload 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... |
72 | 13 Jul 2010 @ 03:08 PDT | Tools | Reply | TPT-Data Synch using Teradata Parallel Transporter | Teradata Data Mover is a separate product offering and is not part of TTU. It has special requirements (it requires Teradata Managed Servers running Linux). |
71 | 12 Jul 2010 @ 03:29 PDT | Tools | Reply | TPT-Data Synch using Teradata Parallel Transporter | TPT 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... |
70 | 12 Jul 2010 @ 03:26 PDT | Tools | Reply | fastload windows 64-bit? | On Windows, FastLoad and FastExport run as 32-bit apps. There is no 64-bit version. |
69 | 12 Jul 2010 @ 03:25 PDT | Tools | Reply | tpt export import | We use the system's virtual memory. We do not use a file system. |
68 | 02 Jul 2010 @ 09:39 PDT | Tools | Reply | Release Lock - LOAD Operator - TPT | The 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... |
67 | 02 Jul 2010 @ 09:30 PDT | Tools | Reply | tpt export import | Thank 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... |
66 | 23 Jun 2010 @ 11:12 PDT | Tools | Reply | Warehouse Builder | If 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... |
65 | 17 May 2010 @ 06:22 PDT | Tools | Reply | PT job with Oracle and Informix ODBC operator error | TPT and the ODBC operator are only certified with ODBC drivers from DataDirect.
Also, please indicate which version of TPT you are using. |
64 | 17 May 2010 @ 06:10 PDT | Tools | Reply | Teradata PT 12.0 error output schema does not match | If 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... |
63 | 24 Feb 2010 @ 05:41 PST | Tools | Reply | FLOAD CANNOT OPEN FILE,RETURN CODE 12 | It 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... |
62 | 18 Feb 2010 @ 07:30 PST | Tools | Reply | Mload failure | BTW, 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... |
61 | 18 Feb 2010 @ 07:27 PST | Tools | Reply | Mload failure | The 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... |
60 | 28 Jan 2010 @ 11:29 PST | Tools | Reply | TPT load from ORACLE to Teradata | DECIMAL(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... |