relation between parameters pack ,latency and statement rate

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
rakesh.nc
Participant
Posts: 39
Joined: Wed Aug 01, 2007 5:10 am
Location: Chennai

relation between parameters pack ,latency and statement rate

Post by rakesh.nc »

hi,
i want to know the realtionship betweent the TPUMP parameter values, such as pack,sess min, sess max, latency and statement rate.
What kind of relation we have between all the above said parameters. for an example, if i am increasing the pack value for some thing. how this varied pack will be related to latency,statement rate. whether i need to increase the statement rate or latency along with the pack for better performance.
regards,
Rakesh
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

That is Teradata specialist knowledge, though you may be lucky here (there are a few Teradata specialists amongst us - I am not among them).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
John Smith
Charter Member
Charter Member
Posts: 193
Joined: Tue Sep 05, 2006 8:01 pm
Location: Australia

Post by John Smith »

The information you require is found in the Teradata TPUMP User's Guide.
Unfortunately I don't have a copy but try contacting your DBA or get it from the Teradata website : http://www.info.teradata.com
Post Reply