DSXchange

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.

That is Teradata specialist knowledge, though you may be lucky here (there are a few Teradata specialists amongst us - I am not among them).

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