Database Engine 20 | Database Initialization Program (dip) | Teradata Vantage - Database Initialization Program (dip) - Teradata Vantage - Database Engine 20

Database Utilities

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Database Engine 20
Teradata Vantage
Release Number
20.00
Published
June 2025
ft:locale
en-US
ft:lastEdition
2026-03-26
dita:mapPath
ron1747160181474.ditamap
dita:ditavalPath
ft:empty
dita:id
vkz1472241255652
lifecycle
latest
Product Category
Teradata Vantageā„¢
The utility described is not available for as-a-service customers.
The Database Initialization Program, dip (abbreviated throughout the documentation as DIP), is a series of executable SQL script files packaged with Database Engine 20. Each DIP script creates one or more database objects for or used by the following:
  • Database Engine 20:
    • 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 Database Engine 20 installation, but you can run the DIP utility at any time to add optional features.