Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 11 Apr 2003 @ 17:49:12 GMT

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

Subj:   Re: Latency in TPUMP loads from MQ
From:   Robert Meunier


There use to be a decent white paper out on the Teradata web site that talked about all the TPump settings and different settings for different situations.

However, I just went out to the Teradata site and couldn't find any reference to this white paper. This has happened to me a lot. Does anyone know where Teradata is "hiding" their older white papers. There are only three listed on their site and I know there's been a lot more then three published.

I thought I might have a copy of it, but couldn't find it. Maybe someone else has a copy or knows where a copy is.

Regarding some of your specific questions:

From the manual - Pack:

Keyword for the number of statements to pack into a multiplestatement request. The maximum value is 300. Packing improves network/channel efficiency by reducing the number of sends and receives between the application and the Teradata RDBMS.


Flushing threshold based on number of seconds oldest record has resided in buffer. LATENCY cannot be less than ten seconds.

How the two work together...

Let's say you are running 10 sessions with a Pack of 20 (the default) and you are doing a trickle load. It's possible that data could sit in the client buffer for one or more sessions waiting until it can "pack" 20 statements together. The data would sit there until a specific session received 20 statements. This in theory could be for hours or days (depending on the data rate). By specifying Latency you are going to force these buffers to be sent to Terdata every "n" seconds. You could also get around this by using 1 session and a Pack of 1, but then if you all of a sudden had a lot of data arriving at the same time you'd have a bottleneck. The introduction of Latency allows for you to get larger volumes of data into Teradata when needed, but also prevent "stale" data from accumulating.

Robert Meunier

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016