Running A DIP Script in Teradata

Note:

The following was run on a Teradata Express 15.10 VM.

Problem:

Teradata Support’s response to correcting a problem we were having with calendar functions was “running DIPCAL should successfully fix this error”.  I needed to know how to run a DIP Script

RESOLUTION:

Note: This is not the only way to way to run a DIP Script.

  • Log on to one of the database nodes as root or a super user.
  • From the command line, run: cnsterm 6
  • In the CNSTERM session window, enter the command: start dip
  • Make a note, which window has started in, and exit the session by pressing the keys: CTRL + c

start_dip

  • Open the window running the DIP session from the number listed above: cnsterm 1
  • Enter the DBC password for the database node. Note that the DBC password will be visible on the screen.

Enter_DBC_Password

  • A list will appear of all the scripts that can be run, choose the number of the script needed.

DIP_Menu

  • After the script has completed, to exit the DIP session, press: n
  • Exit the session by pressing the keys: CTRL + c
  • Verify there was no errors in the output log.

Exit_DIP

Comments are closed.