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.
- 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.