Running DIP - Advanced SQL Engine - Teradata Database

There are two ways to run DIP:

• Interactively
  1. 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.

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

     The results of the script are saved into a text file, which is named using DIP and the number of the script.
  3. 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:

  dip {
    dbc_password { script_number | script_name | -s list_of_scripts } |
    -h
  }

  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

  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.

Usage Notes

The DIPALL script executes all DIP scripts that appear in the menu above it. It is normally run as part of Teradata Database installation, so running the scripts above it individually is not normally necessary.

Scripts that appear below DIPALL in the menu are for special purposes, and should generally only be run with guidance from the Teradata Support Center.