15.00 - Chapter 9 Database Initialization Program (dip) - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

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.