Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Mon, 14 Mar 2005 @ 21:07:41 GMT


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


Subj:   Re: TPump Update
 
From:   Hassinger, Bill

The column in the UPDATE WHERE clause is the UPI. No record is being updated more than once. There are 12 NUSI's but they are not being updated, so why would those tables be effected? There is no RI.

There is heavy activity on Teradata but not the database or table I'm updating. Dropping all the NUSI's had little effect on update time. Below is part of the job output, note high avg DBS wait at checkpoints, what if anything does this indicate?

Bottom line, I'm pretty underwhelmed by TPUMP; I thought it would much faster doing row level updates using a UPI input dataset.

     **** 13:35:28 UTY6630 Options in effect for following TPump Import(s):
          .       Tenacity:    4 hour limit to successfully connect load sessions.
          .   Max Sessions:    10 session(s).
          .   Min Sessions:    8 session(s).
          .     Checkpoint:    15 minute(s).
          .       Errlimit:    No limit in effect.
          .   Restart Mode:    ROBUST.
          .  Serialization:    ON.
          .        Packing:    50 Statements per Request.
          .   StartUp Rate:    UNLIMITED Statements per Minute.
     **** 13:35:30 UTY6608 Import 1 begins.
     **** 13:50:33 UTY6641 Since last chkpt., 15690 recs. in, 14500 stmts., 290 reqs
     **** 13:50:33 UTY6647 Since last chkpt., avg. DBS wait time: 3.11
     **** 13:50:33 UTY6606 Beginning checkpoint...
     **** 13:54:58 UTY6641 Since last chkpt., 15690 recs. in, 15690 stmts., 320 reqs
     **** 13:54:58 UTY6647 Since last chkpt., avg. DBS wait time: 3.65
     **** 13:54:58 UTY6607 Checkpoint Completes with 15690 rows sent.
     **** 14:11:57 UTY6641 Since last chkpt., 6562 recs. in, 5673 stmts., 114 reqs
     **** 14:11:57 UTY6647 Since last chkpt., avg. DBS wait time: 8.91
     **** 14:11:57 UTY6606 Beginning checkpoint...
     **** 14:16:00 UTY6641 Since last chkpt., 6562 recs. in, 6712 stmts., 140 reqs
     **** 14:16:00 UTY6647 Since last chkpt., avg. DBS wait time: 9.01
     **** 14:16:00 UTY6607 Checkpoint Completes with 22252 rows sent.
     **** 14:16:00 UTY6641 Since last chkpt., 0 recs. in, 0 stmts., 0 reqs
     **** 14:16:00 UTY6647 Since last chkpt., avg. DBS wait time: 0.00
     **** 14:16:00 UTY6612 Beginning final checkpoint...
     **** 14:16:00 UTY6641 Since last chkpt., 0 recs. in, 0 stmts., 0 reqs
     **** 14:16:00 UTY6647 Since last chkpt., avg. DBS wait time: 0.00
     **** 14:16:00 UTY6607 Checkpoint Completes with 22252 rows sent.
     **** 14:16:00 UTY6642 Import 1 statements: 22402, requests: 460
     **** 14:16:00 UTY6643 Import 1 average statements per request: 48.70
     **** 14:16:00 UTY6644 Import 1 average statements per record: 1.01
     **** 14:16:00 UTY6645 Import 1 statements/session: avg. 2240.20, min. 2197.00, max. 2289.00
     **** 14:16:00 UTY6646 Import 1 requests/session: average 46.00, minimum 45.00, maximum 47.00
     **** 14:16:00 UTY6648 Import 1 DBS wait time/session: avg. 243.00, min. 11.00, max. 680.00
     **** 14:16:00 UTY6649 Import 1 DBS wait time/request: avg. 5.25, min. 0.24, max. 14.78
     **** 14:16:00 UTY1803 Import processing statistics
          .                                       IMPORT  1     Total thus far
          .                                       =========     ==============

          Candidate records considered:........       22252....... 22252
          Apply conditions satisfied:..........       22252....... 22252
          Records logable to error table:......           0....... 0
          Candidate records rejected:..........           0....... 0

Bill H



     
  <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