Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 28 Jan 2005 @ 14:26:38 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Maximum Limits of Users in Warehouse
From:   Coffing Christopher L


I like to keep things interesting...

I need to know what the real-world maximum limits are for adding users into the warehouse.

We have a 36-Node 24TB system. We currently have 6178 users.

I have been asked to create 480,000 users (this will change to 750,000) in the system. The basis of this request is to enable any POTENTIAL user access to the warehouse.

The expectation is there will NOT be a huge amount of concurrent usage at this time. The only space allocated to these users will be SPOOL.

What are the ramifications for creating this many users?

I believe this will affect our backup strategies and I need to know if there are other issues to be concerned with regarding resources etc...

Your experience is greatly appreciated. I am also interested in who out there has the most users to date???

Chris Coffing
Air Force Knowledge Services (AFKS)
Lead DBA Operations & Support
Teradata Certified Master

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023