Viewpoint Alerts for Space Usage | Teradata Vantage - Setting Up Teradata Viewpoint Alerts for Space Usage - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantage™

You can use Teradata Viewpoint to regularly monitor space usage, and catch most space problems. However, it may be useful to setup a few alerts in areas where space problems can seriously affect database function.

The following table contains some examples of common space usage alerts.

Alert Setup Parameters Response to Alert Occurrence
Crashdumps Space

The crashdumps database needs enough space to contain possible large data dumps that occur during crashes, and which are used in system recovery.

Alert rules:
  • Only include databases = crashdumps
  • Current Perm Max% > 70
    The threshold is set low because a crashdump can be very large.

Alert Action:

  • Email
  • Do not run twice in 5 minutes

Severity: Medium

  • Add perm space to the crashdumps database.
  • Purge the crashdumps database of unneeded data and back up needed data to external media.
DBC Space

User DBC contains all system tables and logs. Critical system functions depend on DBC having enough space.

You can set the same alert parameters for system databases DBCMNGR and SystemFE, which perform other critical system functions.
Alert rules:
  • Only include databases = DBC
  • Current Perm Max% > 80
    Use 90% for SystemFE.

Alert Action:

  • Email
  • Do not run twice in 5 minutes

Severity: Medium

Add perm space to the database.
Set up three alerts to identify when a database exceeds important space thresholds.
  • All DB 90%
  • All DB 95%
  • All DB 97%
Alert rules:
  • All databases
  • Current Perm Max%
> percent

Alert Action:

  • Email (Pager for critical alerts)
  • Do not run twice in 5 minutes

Severity: (apply one of the following to the related alert)

  • Medium (90%)
  • High (95%)
  • Critical (97%)
You should allocate additional perm space to a database as soon as possible after perm space usage exceeds 90%.

Databases that trigger the High or Critical alert levels before you can respond to a Medium alert are growing very fast and should receive more space immediately.

You can investigate which tables are using database perm space.