Set Up the BTEQ Scripts and Run Program Executables | Teradata Viewpoint - 17.10 - Setting Up the BTEQ Scripts and Run Program Executables - Teradata Viewpoint

Teradata® Viewpoint Installation, Configuration, and Upgrade Guide for Customers

Product
Teradata Viewpoint
Release Number
17.10
Release Date
October 2021
Content Type
Administration
Configuration
Installation
Publication ID
B035-2207-101K
Language
English (United States)
The Teradata Notification Service for Linux runs the BTEQ and Run Program alert actions. The BTEQ scripts and program executables must be located in specified directories.

The directories where you placed the BTEQ scripts and programs are scanned periodically by the Teradata Notification Service while the service is running. If changes are detected to the directories, the updated directory contents are relayed to the alert service, which updates the Teradata Alerts repository on the Viewpoint server. The alert service must be running on the Viewpoint server in order for updates to be visible on the Viewpoint server.

The following directories are created during the installation and preserved during upgrades. The system administrator must make sure these directories have the appropriate permissions set for the service user (default is “camuser”) effective user ID for the tdnotification service.
/opt/teradata/client/cam/sql
/opt/teradata/client/cam/usrcmd
During the installation, the following symbolic links are created:
  • For 16.50:
    • /opt/teradata/client/16.50/cam/tdnotification/sql -> /opt/teradata/client/cam/sql
    • /opt/teradata/client/16.50/cam/tdnotification/usrcmd -> /opt/teradata/client/cam/usrcmd
  • For 16.20:
    • /opt/teradata/client/16.20/cam/tdnotification/sql -> /opt/teradata/client/cam/sql
    • /opt/teradata/client/16.20/cam/tdnotification/usrcmd -> /opt/teradata/client/cam/usrcmd
  1. Log on to the server as the root user.
  2. Place the BTEQ scripts in:
    /opt/teradata/client/cam/tdnotification/sql
  3. Make sure the BTEQ scripts have at least 744 file permissions and are owned by the service user account.
  4. Place the programs you want to run in:
    /opt/teradata/client/cam/tdnotification/usrcmd
  5. Make sure the programs have at least 755 file permissions and are owned by the service user account.