All Forums Tools
ericsun2 44 posts Joined 06/10
17 Feb 2014
TPT 14.10 output to named pipe and then gzip to final files

I tried to write TPT output to named pipe, and then use gzip to compress the stream into final files.
gzip < /var/tmp/fact_abc_segment.fifo-1 > ~/data/fact_abc_segment.1.fastload.gz
gzip < /var/tmp/fact_abc_segment.fifo-8 > ~/data/fact_abc_segment.8.fastload.gz
 

EXPORT_OPERATOR: connecting sessions
EXPORT_OPERATOR: The RDBMS retryable error code list was not found
EXPORT_OPERATOR: The job will use its internal retryable error codes
FILE_WRITER: TPT19424 pmGetPos failed. Request unsupported by Access Module (24)
FILE_WRITER: TPT19424 pmGetPos failed. Request unsupported by Access Module (24)
FILE_WRITER: TPT19307 Fatal error checkpointing data.
FILE_WRITER: TPT19424 pmGetPos failed. Request unsupported by Access Module (24)
FILE_WRITER: TPT19307 Fatal error checkpointing data.
FILE_WRITER: TPT19307 Fatal error checkpointing data.
FILE_WRITER: TPT19424 pmGetPos failed. Request unsupported by Access Module (24)
FILE_WRITER: TPT19003 TPT Exit code set to 12.
FILE_WRITER: TPT19003 ECI operator ID: FILE_WRITER-6640
     !WARNING! FIFO pipe detected
**** 16:50:28 Starting to send rows to file '/var/tmp/fact_abc_segment.fifo-1'
FILE_WRITER: TPT19222 Operator instance 1 processing file '/var/tmp/fact_abc_segment.fifo-1'.
     !WARNING! FIFO pipe detected
**** 16:50:28 Starting to send rows to file '/var/tmp/fact_abc_segment.fifo-2'
     !WARNING! FIFO pipe detected
FILE_WRITER: TPT19222 Operator instance 2 processing file '/var/tmp/fact_abc_segment.fifo-2'.
     !WARNING! FIFO pipe detected
     !WARNING! FIFO pipe detected

CheckPoint No. 1 started.
MAIN_STEP            INSERT_1[0001]       Success              FILE_WRITER             8    1 CHECKPOINT-Started   16:50:30     0.0000     0.0000      65000          0                0                0    6
0     0 N Y
MAIN_STEP            INSERT_1[0002]       Success              FILE_WRITER             8    2 CHECKPOINT-Started   16:50:30     0.0000     0.0000      65000          0                0                0    6
0     0 N Y
     !ERROR! Can't position pipe
MAIN_STEP            INSERT_1[0003]       Success              FILE_WRITER             8    3 CHECKPOINT-Started   16:50:30     0.0000     0.0000      65000          0                0                0    6
0     0 N Y
     !ERROR! Can't position pipe
     NOT returning position for file=/var/tmp/fact_abc_segment.fifo-1
     !ERROR! Can't position pipe
MAIN_STEP            INSERT_1[0004]       Success              FILE_WRITER             8    4 CHECKPOINT-Started   16:50:30     0.0000     0.0000      65000          0                0                0    6
0     0 N Y
     NOT returning position for file=/var/tmp/fact_abc_segment.fifo-2

Keep getting "pmGetPos" error.

ericsun2 44 posts Joined 06/10
17 Feb 2014
TPT_INFRA: TPT03720: Error: Checkpoint command failed with 48
     !ERROR! Can't position pipe
     NOT returning position for file=/var/tmp/fact_abc_segment.fifo-5
FILE_WRITER: TPT19424 pmGetPos failed. Request unsupported by Access Module (24)
FILE_WRITER: TPT19307 Fatal error checkpointing data.
     NOT returning position for file=/var/tmp/fact_abc_segment.fifo-7
FILE_WRITER: TPT19424 pmGetPos failed. Request unsupported by Access Module (24)
     !ERROR!  'Request unsupported by Access Module'
     NOT returning position for file=/var/tmp/fact_abc_segment.fifo-8
     !ERROR!  pmGetPos rc=24

Here is the wrapper shell script:

if [[ -z "$TWB_ROOT" ]]
then
  TWB_ROOT=`find /opt/teradata/client -type d -name tbuild | sort -n | head -1`
  LD_LIBRARY_PATH=$TWB_ROOT/lib
fi

data_path=/mnt/n001/temp/FACT_ABC_SEGMENT
data_date=`date +'%Y%m%d%H'`
fifo_path=/var/tmp
i=1

for i in $(seq 1 8); do
  fifo_pipe=$fifo_path/fact_abc_segment.fifo-${i}
  mkfifo $fifo_pipe
  gzip -3 < $fifo_pipe > ${data_path}/fact_abc_segment.${i}.fastload.gz &
done

echo "Ready to call TPT"
tbuild -z 60 -h 128M -C \
 -f ~/tpt/export.fact_abc_segment.sql \
 -v ~/tpt/export.fact_abc_segment.jobvars \
 -u "DataFileCount=${i}" \
 fmcs-$data_date

 

feinholz 1234 posts Joined 05/08
17 Feb 2014

What are you trying to accomplish here?
TPT can both read and write gzip files.
Might be easier to do that than to use pipes.
 

--SteveF

ericsun2 44 posts Joined 06/10
17 Feb 2014

Oh, I have an old wrapper shell script to compress TPT output. Just upgrade to 14.10 TTU lately, it did not work anymore.
How to WRITE to *.gz directly? I tried to specify FileName = xxx.gz but the output file can't be read by gzip.

$ cat tpt/export.fact_abc_segment.jobvars 
UserName='tpt_reader'
UserPassword='tpt_password'
TdpId='tddev'
TechnicalSubjectArea='segment'
DataFilePath='/mnt/data/fastload_local/FACT_ABC_SEGMENT'
DataFileName='fact_abc_segment.gz'

SourceTableName='FACT.FACT_ABC_SEGMENT'

Output files look like:

$ ls -1
fact_abc_segment.gz-1
fact_abc_segment.gz-2
fact_abc_segment.gz-3
fact_abc_segment.gz-4
fact_abc_segment.gz-5
fact_abc_segment.gz-6
fact_abc_segment.gz-7
fact_abc_segment.gz-8

$ gzip -d -c fact_abc_segment.gz-2

gzip: fact_abc_segment.gz-2: not in gzip format

The file content looks like uncompressed fastload formatted indicator file:

$ hexdump -C -n 128 fact_abc_segment.gz-1
00000000  12 00 00 dd 42 11 00 e5  4b f0 03 00 00 00 00 7a  |....B...K......z|
00000010  00 00 00 04 0a 12 00 00  dd 42 11 00 32 8e 2d 12  |.........B..2.-.|
00000020  00 00 00 00 7a 00 00 00  04 0a 12 00 00 dd 42 11  |....z.........B.|
00000030  00 99 cd 8b 12 00 00 00  00 7a 00 00 00 04 0a 12  |.........z......|
00000040  00 00 dd 42 11 00 c6 d6  38 01 00 00 00 00 7a 00  |...B....8.....z.|
00000050  00 00 04 0a 12 00 00 dd  42 11 00 3e 6f de 03 00  |........B..>o...|
00000060  00 00 00 7a 00 00 00 04  0a 12 00 00 dd 42 11 00  |...z.........B..|
00000070  7e e5 f7 03 00 00 00 00  7a 00 00 00 04 0a 12 00  |~.......z.......|

 

ericsun2 44 posts Joined 06/10
17 Feb 2014

Hi Steven,
The original goal is to generate *.gz files directly to save disk space and transportation network overhead later. Generally, *.gz files are 3~5x smaller than the plain FASTLOAD output.
Here is the TPT template:

USING CHARACTER SET UTF8 
DEFINE JOB EXPORT_TO_FASTLOAD_FORMAT
DESCRIPTION 'Export from ' || @SourceTableName || ' to the INDICDATA file: ' || @DataFileName
(
DEFINE SCHEMA DATA_FILE_SCHEMA
(
"DATE_ID"                       IntDate,
"MEMBER_ID"                     BigInt,
"CUSTOM_SEGMENT_ID"             Int,
"PRIORITY"                      ByteInt
);

  DEFINE OPERATOR EXPORT_OPERATOR
  TYPE EXPORT
  SCHEMA DATA_FILE_SCHEMA
  ATTRIBUTES
  (
  VARCHAR PrivateLogName = @SourceTableName || '_log',
  VARCHAR TdpId          = @TdpId,
  VARCHAR UserName       = @UserName,
  VARCHAR UserPassword   = @UserPassword,
  VARCHAR QueryBandSessInfo = 'Action=TPT_EXPORT; Format=Fastload;',
  VARCHAR SpoolMode      = 'noSpool',
  INTEGER MaxDecimalDigits = 18,
  VARCHAR DateForm       = 'INTEGERDATE',
  VARCHAR SelectStmt     = 'select * from ' || @SourceTableName  
  );

  DEFINE OPERATOR FILE_WRITER
  TYPE DATACONNECTOR CONSUMER
  SCHEMA *
  ATTRIBUTES
  (
  VARCHAR PrivateLogName = 'indicdata_writor_log',
  VARCHAR DirectoryPath  = @DataFilePath,
  VARCHAR FileName       = @DataFileName,
  VARCHAR Format         = 'Formatted',
  VARCHAR OpenMode       = 'Write',
  VARCHAR IndicatorMode  = 'Y'
  );
  
  APPLY TO OPERATOR (FILE_WRITER[@DataFileCount])
  SELECT * FROM OPERATOR (EXPORT_OPERATOR[@NumOfReader]);
);

Thank you so much for the help!

ericsun2 44 posts Joined 06/10
17 Feb 2014

It seems that gzip file can be generated if I write to a single outpuf file with ".gz" file extension.
But I need to generate multiple *.gz files, in order to:

  • utilize multiple CPU cores to compress the data stream
  • gzip is quite CPU instensive, a single gzip process can easily use up 100% of a core
  • while load via TPT's multi-readers, multiple *.gz files are more efficient than single *.gz file
  • all readers don't have to read from the beginning of the same big *.gz file

TPT used to allow writing to named pipes on Linux, so we can launch multiple gzip process in the background to compress the data stream.

ericsun2 44 posts Joined 06/10
17 Feb 2014
┌nmon─12c──────[H for help]───Hostname=xxxx-xxxxx───Refresh= 2secs ───21:03.35─────────────────────────────────────────┐
│ CPU Utilisation ─────────────────────────────────────────────────────────────────────────────────────────────────────│
│                           +-------------------------------------------------+                                        │
│CPU  User%  Sys% Wait% Idle|0          |25         |50          |75	   100|                                        │
│ 1   1.0   6.1   0.5   92.4|sss                                              >                                        │
│ 2   2.0   2.0   3.0   93.1|W                                                >                                        │
│ 3   0.5   0.5   0.5   98.5|                                                 >                                        │
│ 4   1.0   2.0   0.0   97.0|                                                 >                                        │
│ 5   0.0   0.6  57.4   42.0|WWWWWWWWWWWWWWWWWWWWWWWWWWWW                     >                                        │
│ 6   3.0   1.0   4.5   91.5|UWW                                              >                                        │
│ 7   0.0   0.0   0.0  100.0|                                                 >                                        │
│ 8   1.0   0.5   0.0   98.5|                                                 >                                        │
│ 9 100.0   0.0   0.0    0.0|UUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUU>                                        │
│10   2.5   0.5   0.0   97.0|U                                                >                                        │
│11   0.0   0.0   0.0  100.0|                                                 >                                        │
│12   0.5   0.0   0.0   99.5|                                                 >                                        │
│13   0.5   0.5   0.0   99.0|                                                 >                                        │
│14   3.0   0.5  96.5    0.0|UWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW>                                        │
│15   1.2   2.5   1.2   95.1|s                                                >                                        │
│16   5.2   5.2   2.1   87.6|UUssW                                            >                                        │
│17   0.0   1.1   0.0   98.9|                   >                             |                                        │
│18   3.0   4.0   1.5   91.6|Us                                               >                                        │
│19   0.0   0.5   0.0   99.5|       >                                         |                                        │
│20   3.0   1.5   0.0   95.5|U                                                >                                        │
│21   0.0   0.0   0.0  100.0|                                                 >                                        │
│22   0.0   1.6   0.0   98.4|                                        >        |                                        │
│23   0.0   0.0   0.0  100.0|                                    >            |                                        │
│24   0.0   0.0   0.0  100.0| >                                               |                                        │
│                           +-------------------------------------------------+                                        │
│Avg  4.8   1.1   7.7   86.5|UUWWW                    >                       |                                        │
│                           +-------------------------------------------------+                                        │
│ Network I/O ─────────────────────────────────────────────────────────────────────────────────────────────────────────│
│I/F Name Recv=KB/s Trans=KB/s packin packout insize outsize Peak->Recv Trans                                          │
│    lo     0.0     0.0       0.0      0.0     0.0    0.0       14.7    14.7                                           │
│  eth0 26250.0 83880.6    46598.8   59032.9   576.8 1455.0    749912.6 290677.8                                       │
│  eth1     0.1     0.1       1.5      0.5    60.0  179.0        1.8     0.1                                           │
│ bond0 26250.1 83880.7    46600.3   59033.4   576.8 1455.0    749914.4 290677.8                                       │
│──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────│

nmon output to illustrate when TPT is writing to a single *.gz file without using named pipe. One of the cores is maxed out, but Teradata server has a lot of potential to pump more data to the client machine.

feinholz 1234 posts Joined 05/08
17 Feb 2014

You can specify multiple instances of the DataConnector operator (as the file writer) and use the -C option on the command line. TPT will round-robin the data to each instance and each instance will write to its own file.
 
This will help you generate multiple .gz files (all should be roughly the same size).
 

--SteveF

ericsun2 44 posts Joined 06/10
17 Feb 2014

Hi Steven,
When I "APPLY TO OPERATOR (FILE_WRITER[@DataFileCount])" and use -C to generate multiple output files, all the files will have ***.gz-n as extension, but the actual file contents are the uncompressed Formatted Fastload instead of compressed Formatted Fastload.
However, when I output to a single file, the content is indeeded compressed with gzip codec.
Is this a bug or intended behavior?

feinholz 1234 posts Joined 05/08
18 Feb 2014

Yup. Found a bug.
 
The DC operator is looking at the .gz-x extension and not the .gz extension (prior to appending the instance number).
 
Plus, putting the instance number on the file extension means the user would have to rename their files prior to loading. Not ideal. We will have to fix that too.
 
Thanks for your patience.
 

--SteveF

ericsun2 44 posts Joined 06/10
18 Feb 2014

Hi Steven,
It will be great for TPT to generate files like below (instead of abc.gz-3, abc.gz-12, ...)

  • abc.1.gz
  • abc.3.gz
  • abc.8.gz

I will look forward to a fix in 14.10.00.07+
So for now, would you be able to comment on named pipe usage?

feinholz 1234 posts Joined 05/08
18 Feb 2014

Not sure on the exact naming convention yet.
We have to be careful with backwards compatibility issues.
What specifically do you want to know about named pipes?
Are you using the named pipe access module?
 

--SteveF

feinholz 1234 posts Joined 05/08
18 Feb 2014

Pipe issues resulting in "getpos" errors was fixed in 14.10.00.003 and 14.00.00.011.

--SteveF

ericsun2 44 posts Joined 06/10
18 Feb 2014

named pipe access module can be used for READER only. it does not work with WRITER.
my 14.10.00.02 clearly has problem of "getpos" against named pipe. I will ask DBA to get the latest TTU soon.
Thanks a lot, Steven. You are always always prompt and helpful!

ericsun2 44 posts Joined 06/10
18 Feb 2014
Teradata Parallel Transporter Version 14.10.00.03

Job log: /opt/teradata/client/14.10/tbuild/logs/fmcs-2014021817-7.out
Job id is fmcs-2014021817-7, running on xxxxxx
Teradata Parallel Transporter FILE_WRITER: TPT19006 Version 14.10.00.03
FILE_WRITER Instance 1 directing private log report to 'indicdata_writor_log-1'.
FILE_WRITER Instance 2 directing private log report to 'indicdata_writor_log-2'.
FILE_WRITER Instance 7 directing private log report to 'indicdata_writor_log-7'.
FILE_WRITER Instance 3 directing private log report to 'indicdata_writor_log-3'.
FILE_WRITER Instance 6 directing private log report to 'indicdata_writor_log-6'.
FILE_WRITER Instance 8 directing private log report to 'indicdata_writor_log-8'.
FILE_WRITER Instance 4 directing private log report to 'indicdata_writor_log-4'.
FILE_WRITER Instance 5 directing private log report to 'indicdata_writor_log-5'.
Teradata Parallel Transporter Export Operator Version 14.10.00.03
EXPORT_OPERATOR: private log specified: DWH_STG.FACT_abc_SEGMENT_log
FILE_WRITER: TPT19007 DataConnector Consumer operator Instances: 8
FILE_WRITER: TPT19003 ECI operator ID: 'FILE_WRITER-29763'
FILE_WRITER: TPT19222 Operator instance 1 processing file '/var/tmp/fact_abc_segment.fifo-1'.
FILE_WRITER: TPT19222 Operator instance 7 processing file '/var/tmp/fact_abc_segment.fifo-7'.
FILE_WRITER: TPT19222 Operator instance 6 processing file '/var/tmp/fact_abc_segment.fifo-6'.
FILE_WRITER: TPT19222 Operator instance 2 processing file '/var/tmp/fact_abc_segment.fifo-2'.
FILE_WRITER: TPT19222 Operator instance 3 processing file '/var/tmp/fact_abc_segment.fifo-3'.
FILE_WRITER: TPT19222 Operator instance 4 processing file '/var/tmp/fact_abc_segment.fifo-4'.
FILE_WRITER: TPT19222 Operator instance 5 processing file '/var/tmp/fact_abc_segment.fifo-5'.
FILE_WRITER: TPT19222 Operator instance 8 processing file '/var/tmp/fact_abc_segment.fifo-8'.
EXPORT_OPERATOR: connecting sessions
EXPORT_OPERATOR: The RDBMS retryable error code list was not found
EXPORT_OPERATOR: The job will use its internal retryable error codes
FILE_WRITER: TPT19456 (from pmGetPos) PIPE files can not be checkpointed or restarted (56).
FILE_WRITER: TPT19307 Fatal error checkpointing data.
FILE_WRITER: TPT19003 TPT Exit code set to 12.
FILE_WRITER: TPT19456 (from pmGetPos) PIPE files can not be checkpointed or restarted (56).
FILE_WRITER: TPT19456 (from pmGetPos) PIPE files can not be checkpointed or restarted (56).
FILE_WRITER: TPT19307 Fatal error checkpointing data.
FILE_WRITER: TPT19307 Fatal error checkpointing data.
FILE_WRITER: TPT19456 (from pmGetPos) PIPE files can not be checkpointed or restarted (56).
FILE_WRITER: TPT19003 TPT Exit code set to 12.
FILE_WRITER: TPT19456 (from pmGetPos) PIPE files can not be checkpointed or restarted (56).
FILE_WRITER: TPT19003 TPT Exit code set to 12.
FILE_WRITER: TPT19307 Fatal error checkpointing data.

Hi Steven,
I upgraded from 14.10.00.02 to 14.10.00.03 today, but the "pmGetPos" is still bugging me.

ericsun2 44 posts Joined 06/10
18 Feb 2014
/opt/teradata/client/14.10/tbuild/lib $ ls -l
total 8404
drwxr-xr-x 2 root root    4096 Feb 18 17:01 gcc_3.x
-r--r--r-- 1 root root 1511843 Dec 10 13:49 libdataconop.so
-r--r--r-- 1 root root   51145 Dec 10 13:49 libddlop.so
-r--r--r-- 1 root root  144107 Dec 10 13:49 libexportop.so
-r--r--r-- 1 root root 1167191 Dec 10 13:49 libfeomop.so
-r--r--r-- 1 root root 1158858 Dec 10 13:49 libflimop.so
-r--r--r-- 1 root root  120692 Dec 10 13:49 libinsertop.so
-r--r--r-- 1 root root  114687 Dec 10 13:49 libloadop.so
-r--r--r-- 1 root root   34653 Dec 10 13:49 liblogview.so
-r--r--r-- 1 root root 1168077 Dec 10 13:49 libmlimop.so
-r--r--r-- 1 root root  279776 Dec 10 13:49 libodbcop.so
-r--r--r-- 1 root root  602532 Dec 10 13:49 libopcommon.so
-r--r--r-- 1 root root   10992 Dec 10 13:49 liboscmdop.so
-r--r--r-- 1 root root   87686 Dec 10 13:49 libptmin.so
-r--r--r-- 1 root root   22291 Dec 10 13:49 libptmos.so
-r--r--r-- 1 root root  121268 Dec 10 13:49 libptmpi.so
-r--r--r-- 1 root root   41666 Dec 10 13:49 libptmpo.so
-r--r--r-- 1 root root  669703 Dec 10 13:49 libpxcommon.so
-r--r--r-- 1 root root  118413 Dec 10 13:49 libpxextrct.so
-r--r--r-- 1 root root    9203 Dec 10 13:49 libpxicu.so
-r--r--r-- 1 root root   43988 Dec 10 13:49 libschemapop.so
-r--r--r-- 1 root root  136933 Dec 10 13:49 libselectop.so
-r--r--r-- 1 root root  331364 Dec 10 19:25 libstreamop.so
-r--r--r-- 1 root root   83530 Dec 10 13:49 libtableqry.so
-r--r--r-- 1 root root  382681 Dec 10 13:49 libtelapi.so
-r--r--r-- 1 root root  136344 Dec 10 13:49 libupdateop.so

-r-xr-xr-x 1 root root  297275 Dec 10 13:49 coordinator
-r-xr-xr-x 1 root root  843745 Dec 10 13:49 executor
-r-xr-xr-x 1 root root  103189 Dec 10 13:49 planexecutor
-r-xr-xr-x 1 root root   10850 Dec 10 13:49 ptmcmd
-r-xr-xr-x 1 root root   50522 Dec 10 13:49 ptmexec
-r-xr-xr-x 1 root root   40322 Dec 10 13:49 ptmgts
-r-xr-xr-x 1 root root   28655 Dec 10 13:49 ptmjlgr
-r-xr-xr-x 1 root root   47976 Dec 10 13:49 ptmlvs
-r-xr-xr-x 1 root root   13144 Dec 10 13:49 ptmtims
-r-xr-xr-x 1 root root 1854238 Dec 10 13:49 tbuildexe
-r-xr-xr-x 1 root root   57344 Dec 10 13:49 tdloadexe
-r-xr-xr-x 1 root root     621 Dec 10 13:49 tdlog
-r-xr-xr-x 1 root root   20324 Dec 10 13:49 tlogviewexe
-r-xr-xr-x 1 root root   10145 Dec 10 13:49 tptlaunch

 

feinholz 1234 posts Joined 05/08
18 Feb 2014

What is the command line you are using to run the TPT job?

--SteveF

ericsun2 44 posts Joined 06/10
18 Feb 2014

Post the shell commands again:

if [[ -z "$TWB_ROOT" ]]
then
  TWB_ROOT=`find /opt/teradata/client -type d -name tbuild | sort -n | head -1`
  LD_LIBRARY_PATH=$TWB_ROOT/lib
fi
 
data_path=/mnt/n001/temp/FACT_ABC_SEGMENT
data_date=`date +'%Y%m%d%H'`
fifo_path=/var/tmp
i=1
 
for i in $(seq 1 8); do
  fifo_pipe=$fifo_path/fact_abc_segment.fifo-${i}
  mkfifo $fifo_pipe
  gzip -3 < $fifo_pipe > ${data_path}/fact_abc_segment.${i}.fastload.gz &
done
 
echo "Ready to call TPT"
tbuild -z 60 -h 128M -C \
 -f ~/tpt/export.fact_abc_segment.sql \
 -v ~/tpt/export.fact_abc_segment.jobvars \
 -u "DataFileCount=${i}" \
 fmcs-$data_date

TPT EXPORT will write to

  • /var/tmp/fact_abc_segment.fifo-1
  • /var/tmp/fact_abc_segment.fifo-2
  • ...
  • /var/tmp/fact_abc_segment.fifo-8
feinholz 1234 posts Joined 05/08
19 Feb 2014

Ok. You cannot "checkpoint" when using pipes.
Remove the "-z 60" part of the command and your job should be able to run.

--SteveF

ericsun2 44 posts Joined 06/10
19 Feb 2014

Validated.

  • 14.10.00.02 has the "GetPos" issue even after removing "-z 60" option
  • 14.10.00.03 works fine without "-z 60" option

The multiple gzip named pipes work again now.
Thanks, Steven.

feinholz 1234 posts Joined 05/08
19 Feb 2014

Thanks for the validation (and your patience).

--SteveF

asilby 2 posts Joined 03/14
03 Mar 2014

Hi, I am getting this same issue in the Express version. We are currently evaluating Teradata. Is there someway I can update TPT as I'm using the VM Ware download?
Regards, 
Andy

dnoeth 4628 posts Joined 11/04
03 Mar 2014

Hi Andy,
there was a new version of TD Express a few days ago, 14.10.01.01, you might try if this includes TPT 14.10.00.03.
Dieter

Dieter

asilby 2 posts Joined 03/14
03 Mar 2014

Hi Dieter, Thank you. The version listed on the download page for VM Ware seems to be a version we downloaded a few weeks ago. Do you know when a new VM Ware version might be released?
Andy
 

dnoeth 4628 posts Joined 11/04
03 Mar 2014

Can't be "a few weeks ago", don't use the one on top, scroll down :-)

Version: 14.10.01.01

Released: 28 Feb 2014

Dieter

anil.doobagunta 11 posts Joined 10/11
03 Dec 2015

HI Steve , I got same requirement for writing data to multiple files and zip exported files.  I am using 15.00.00.00 version. But I am facing same issue as mentioned above(.gz-x) files are not getting compressed. Is there any workaround for it.
 
TPT generated files with below names, but these are not getting compressed.

  • abc.1.gz
  • abc.3.gz
  • abc.8.gz
feinholz 1234 posts Joined 05/08
03 Dec 2015

TPT only supports uncompressing files on input.
We do not support compressing on output.
 

--SteveF

You must sign in to leave a comment.