Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 18 Apr 2001 @ 17:06:11 GMT

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

Subj:   Re: NT Utilities
From:   John Hall

How much data are your users going to be loading? Are there recoverability issues? Is there an issue about how fast these jobs run (ie- the job must finish within a couple of hours).

With relatively small volumes of data, you might consider limiting your users to multisession BTEQ .IMPORTs. There is no limit to the number of jobs that can run concurrently. The limited bandwidth of BTEQ inherently limits the amount of data that is going to be loaded and minimizes the impact on the database (which is an issue if these jobs are going to run unmonitored).

Admittedly, there's nothing elegant about BTEQ - but it might be the safest thing to put in the hands of your users.

  <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: 15 Jun 2023