Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 12 May 1999 @ 00:09:29 GMT

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

Subj:   Re: Default database space
From:   John K. Wight

There is also another school of thought that I have worked in a customer environment and that is each user has it's own database space and can create as much in that space as is available. It helps the DBA to monitor user usage, requirements, etc. And when a user needs more space (usually as they mature and get created more sophisticated -identified through monitoring usage over time). In this scenario, there is no problem of duplicate table names other than the user trying to create a table with the same name that they created before and forgot to drop - but that is a different issue. I prefer this approach and allocate all users xMB's of space initially and let them contact help desk, DBC, etc. when they need more. This allows you to monitor usage, assist in supporting usage/techniques, etc. And allocate more space when needed, etc. I can then do usage analysis by user to see what each one is using, % of total, etc.

Just another way o look at the world.

John K. Wight
Senior Solutions Consultant - Retail Solutions Group
NCR Corp.

  <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