Archives of the TeradataForum
Message Posted: Thu, 29 Nov 2012 @ 20:33:40 GMT
We have a 1+1 (HSN) with 48 AMPS. Now , my ETL team is running a TPUMP job which loads 7 files to the same table , with each file having close to 2 Million records. Could you please tell me what can be the ideal number for the 'SESSIONS' variable in the TPUMP script? The team ran a single job with SESSION = 48 (Since there are 48 AMPS) . However if they run all 7 jobs in parallel with 48 * 7 SESSIONS , will the system reach saturation?
ERRLIMIT 0 CHECKPOINT 0 TENACITY 4 SESSIONS 48 SLEEP 6 SERIALIZE OFF PACK 500 ROBUST OF
Thanks for all the help!!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|