Archives of the TeradataForum
Message Posted: Wed, 16 Mar 2005 @ 20:28:21 GMT
Here are my general findings concerning TPUMP, results may vary. I am currently using V2R3.
PACK SIZE: The bigger the PACK size the better. With PACK = 1, I had fewer BLOCKED sessions, but the job completion time increased. When I tried PACK size 100 I got an "insufficient memory for plastic steps" error, and reduced it to 75 than 50 to overcome it. Newer versions of TD may allow larger PACK size.
SESSION SIZE: More sessions better. Caused increase in Blocked (conflicting) Sessions, but job run time decreased. I was inserting 22,000 rows and there was a run time decrease when going from 10-30 sessions, less noticeable from 30-60 sessions.
CHECKPOINT: It appears checkpoints default to 15 minutes. Since this is a <20 minute job I removed checkpointing. May want included in longer running jobs.
SYSTEM LOAD: System load seemed to have the biggest effect on run time. Even though there was no conflict on table being updated, time required to process BLOCKED sessions appeared longer during high CPU load.
BLOCKED SESSIONS: As suggested by other users, this seems to be caused by ROW Hash collisions; 80 AMPS and 22,000 UPI updates, 50 update statements per PACK. It appears that subsequent statement packages will not be requested until all statements are processed.
TARGET TABLE SIZE: Processing time did not appear to be a function of target table size. Only a function of number of Updates.
Thanks again for all the insight.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|