Chapter 9 Database Initialization Program (dip) - Teradata Database

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.

Scenarios Runs From

Database Window or comparable interface to the Teradata Database console subsystem, such as cnsterm

Linux command line

For general information on starting the utilities from different interfaces, see Appendix B: “Starting the Utilities”

Scenarios Running DIP

There are two ways to run DIP:

Interactively

Type start dip from the Supervisor window of CNS or just dip from the Linux command line.

The DIP utility presents a numbered list of available DIP scripts. Type the number or name of the script to be executed, and press Enter.

Depending on what script you selected, a message similar to the following appears:

Executing DIPERR at Tue Feb 20 13:04:29 2001

Please wait...

DIPERR is complete at Tue Feb 20 13:04:46 2001

Please review the results in /tmp/dip1.txt on node 1- 4

Note: The results of the script are saved into a text file, which is named using DIP and the number of the script.

To run another script, type Y and press Enter, then continue as above. To exit DIP, type N and press Enter.

Non-interactively

If you know the menu number of the DIP script, you can run DIP with a single-line command from the Supervisor window of Database Window (or any interface to the console subsystem (CNS), such as the cnsterm command-line utility). Use the following syntax:

Syntax Element	Description
dbc_password	The password for user DBC. If the password contains the # character, enclose the dbc_password within quotes or apostrophes: “our#dbc#password”
-h	Displays DIP online help information.
-s list_of_scripts	Displays a list of script numbers or names separated by spaces to be executed in that order. For example: 1 2 5 6 DIPERR DIPDB DIPVIEWS DIPVIEWSV Note: See “Example” on page 151 for the list of DIP numbers and their corresponding names.
script_name	The DIP menu name of the script to be run, for example, DIPALL or DIPVIEWS
script_number	The DIP menu number of the script to be run.