Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 02 Jan 2007 @ 09:50:07 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Question on Spool/Profiles
From:   Dieter Noeth

Anomy.Anom wrote:

  If I create a user and give him spool of 10GB, then add him to a Profile that has a different Account ID and spool size. The manual states that the user will show up with that Profile's account string and use that amount of spool.  

It depends on the release (V2R6+), within dipviews.bteq there's a comment:

DR95517-sh180008-01 05Jul21 DBC.Users shows Profile info

  Is there a query that will display this for the user? If I do a select * from dbc.users, it will show me the 10GB and the original account string.  

Just add an Outer Join to dbc.profileinfo, e.g.:

        COALESCE(p.SpoolSpace, u.SpoolSpace),
        COALESCE(p.TempSpace, u.TempSpace),
     FROM dbc.users AS u LEFT JOIN dbc.profileinfo p
     ON u.ProfileName = p.ProfileName


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