Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 02 Dec 2002 @ 22:41:43 GMT

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

Subj:   Re: Sessions vs AMPs vs Data
From:   Madhu Reddy

Comments are embedded

  Based on our experience with FastLoads, and attempting to maximise the performance bu minimise the number of sessions, I calculated a formula to work out the number of sessions a FastLoad script should use.  

Is following formula is only for FastLoad? IS this applies for MultiLoad and Tpump also?

  1. Calculate the number of records contained within a message (64K Block). This is output as part of the FastLoad logs. Call this value RM.  

I got following message from my Fastload Job output for table1

**** 16:32:29 Number of recs/msg: 690
**** 16:32:29 Starting to send to RDBMS with rec
**** 16:32:29 Sending row 77
**** 16:32:29 Finished sending rows to the RDBMS

Here RM is 690
AM i correct?

  2. Calculate the average number of records for a single load. Call this value AR.  

How to calculate this?

  3. Calculate the average number of message blocks required to be transferred. Call this value AM, which is calculated as ROUNDUP(AR / RM, 0) within Excel.  

How to calculate this without using Excel?

  <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: 28 Jun 2020