Archives of the TeradataForum

Message Posted: Sun, 25 Mar 2007 @ 11:09:24 GMT

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

There are a couple different ways:

1. If you have the administrator, you can click on the UserID , click on tools on the menu bar, and select "modify user".

If you have profiles defined, you will get the profile name from there, then go back to the tool on the menu and select "Administer profiles".

Select that user's profile from the drop down. The spool space on the profile is the user's spool space.

If you do not have profiles defined, then the spool space is what you see on the "modify user" screen.

2. You can also do a query against dbc.users view for spoolspace (in queryman or bteq):

     SELECT USERNAME, SPOOLSPACE FROM DBC.USERS
        WHERE USERNAME = 'your user ID';

Nazy

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