How to do it...

The steps for managing DBC space are as follows:

  1. Log in to the Teradata database using SQLA or Studio.
  2. Identify the tables in the database that have grown significantly:
**Table Space**LOCK dbc.tablesize ACCESSSELECT tablename, SUM(cur rentperm)FROM dbc.tablesizeWHERE databasename ='<databasename>' -- if require to filter specific databasesGROUP BY 1 ORDER BY 2 DESC;
  1. If the tables from step 2 do not show any abnormal growth, we will check on another possibility. The DBC maxperm limit is exceeded on just one AMP, but there is still enough free space on other AMPs:
**Space per AMP/VPROC to check skewness**LOCK ROW FOR ACCESSSELECTvproc,SUM(currentperm),SUM(maxperm)FROM dbc.diskspaceWHERE databasename = '<databasename>'

Get Teradata Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial