Check Repository Space | Teradata Viewpoint - 16.20 - 16.50 - Checking Repository Space - Teradata Viewpoint

Teradata® Viewpoint Installation, Configuration, and Upgrade Guide for Customers

Product
Teradata Viewpoint
Release Number
16.20
16.50
Release Date
July 2021
Content Type
Administration
Configuration
Installation
Publication ID
B035-2207-071K
Language
English (United States)

When upgrading to Viewpoint 16.20.00.03 or later, the repository database must be upgraded to Postgres 9.4.

When upgrading to Viewpoint 16.50.00.00 or later, the repository database must be upgraded to Postgres 10.

This upgrade requires a new copy of the database to be created in the repository drive, so free space for a second copy of the database directory must be available before starting the upgrade.

For large databases, the conversion task can take substantial time, proportional to the size of the database files. Tests show the conversion takes approximately 20 minutes for every 100Gb of data in /data/viewpointdb.

If do not have enough space, contact your system administrator to provide more free space. If you cannot free up enough space, contact your Customer Service Representative.
  1. Check the size of the database:
    du -ks /data/viewpointdb
    Example result:
    144392400 /data/viewpointdb
  2. Check the available space on the repository drive:
    df -k /data
    Example result:
    Filesystem 1K-blocks Used Available Use% Mounted on 
    /dev/sdb 3512848256 462050224 3050798032 14% /data