16.10 - Overview - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

The Database Initialization Program, dip (abbreviated throughout the documentation as DIP), is a series of executable SQL script files packaged with Teradata Database. Each DIP script creates one or more database objects for or used by the following:

  • Teradata Database:
    • To implement a feature, such as security access logging, client character sets, and calendar arithmetic.
    • To store system information, such as PDE crashdumps, resource usage, query text, and error message text.
  • Users:
    • To view the contents of the Data Dictionary (system catalog) tables.
    • To generate system reports, such as resource usage statistics

DIP allows you to execute one, several, or all script files, which create a variety of database objects. The most commonly needed DIP scripts are executed during Teradata Database installation, but you can run the DIP utility at any time to add optional features.