Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Fri, 28 Jan 2005 @ 15:17:20 GMT


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


Subj:   Re: Maximum Limits of Users in Warehouse
 
From:   David Wellman

Hi Chris,

Biggest system in terms of number of users that I've heard of is @12000 (a 'small' telecoms company in the US !).

A couple of things comes to mind when thinking about the ramifications of this:

- MAKE SURE that your backups use the NONEMPTY DATABASES option. Even on (much) smaller numbers of users I've seen this make a noticeable difference.

- MAKE SURE that your backups use the NONEMPTY DATABASES option. Even on (much) smaller numbers of users I've seen this make a noticeable difference.

- MAKE SURE that your backups use the NONEMPTY DATABASES option. Even on (much) smaller numbers of users I've seen this make a noticeable difference.

(have I made the point yet ?)

- BEFORE you start creating that many users make sure that you have PUBLIC access rights reduced to a minimum, I guess if you are on V2R5 then settin gup Roles before hand would be even better. With this many users the potential for the AccessRights table to get seriously out of hand is enormous.

- the backup of database DBC will almost certainly get significantly longer, that just adds to your backup issues

- (you've probably thought of this, but...) when creating those users, do them in batches, run the batches outside prime time (or were you thinking of using Teradata Administrator to create them ? - grin !)


Cheers,

Dave



     
  <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