Archives of the TeradataForum

Message Posted: Fri, 13 Dec 2002 @ 21:54:43 GMT

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

Two comments:

1) Teradata space management is by AMP VProc, not total. You can check space using dbc.DiskSpace view, and comparing CurrentPerm with MaxPerm. For example:

SELECT SUM(CurrentPerm) as CurrentSpace,
SUM(MaxPerm) as TotalLimit,
MAX(CurrentPerm) as MaxAMP,
MAX(MaxPerm) as LimitByAMP
FROM dbc.DiskSpace WHERE DatabaseName='DEV';

2) By chance are your worktables and/or errortables (or maybe even the logtable) being placed in a database other than DEV? The error message may be confusing because it names the database that contains the target table, even if the space problem is with one of the other tables in some other database. (DR62635)

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