Archives of the TeradataForum

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

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

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>>