Installing the Protector on Multi Node

The Teradata Data Warehouse Protector build provides an automated script to manage the installation process on a standalone system. The master script internally calls the scripts to install the components. The master script installs the components in the following order:

  1. Log Forwarder
  2. RPAgent
  3. Policy Enforcement Point (Database Protector)

The installation can also be performed manually by executing the individual scripts to install the different components.

The master script is available in the directory where the installation files are extracted. It provides the following arguments:

  • install - installs the components in an interactive mode.
  • upgrade - installs a newer version of the protector with minimal downtime.
  • silent - installs the components in a non-interactive mode.
  • install.ini - installs the components as per the parameters provided in the file.
  • help - lists the arguments available for the script.

In addition, the master script will rollback the installation process if any errors are encountered. The script will revert the changes.

Viewing the Arguments for the Script

  1. Log in to the server as the user with the required permissions.
  2. Navigate to the directory containing the extracted files and the installation scripts.
  3. To view the arguments, run the following command:
    ./Install_TeradataProtector_Linux_x64_<DBP_version>.sh --help
    
  4. Press ENTER. The script lists the available arguments.
     Options:
     --install    Use this option when installing the solution for the first time on a machine/host.
                 (i.e., there is no previous installation present)
    
     --upgrade    Use this option when upgrading an existing installation on the machine/host.
    
     --install-ini <file>    (Optional) Provide a path to an install.ini file for silent or pre-configured installations.
                             This option works with --install only.
                             It must not be used with --upgrade or --silent.
                             You can pass this either as:
                             --install-ini /path/to/install.ini
                             or
                             --install-ini=/path/to/install.ini
                             Refer to the product documentation for details about the configuration options available in install.ini.
                             The documentation describes all supported keys, required fields, and example configurations.
     --silent    (Optional) Runs the installation/upgrade in silent mode with minimum interactive prompts.
    
     --help, -h  Display this help message and exit.
    

Installing the Protector using the Interactive Mode

  1. Log in to the server as the user with the required permissions.
  2. Navigate to the directory containing the extracted files and the installation scripts.
  3. To execute the script, run the following command:
    ./Install_TeradataProtector_Linux_x64_<DBP_version>.sh --install
    
  4. Press ENTER.
    The script executes pre-checks and the prompt to select the silent mode of installation appears.
     2026-05-04 03:43:56 - [INFO] ========================================================================
     2026-05-04 03:43:56 - [INFO] Starting environment pre-checks before installation/upgrade
     2026-05-04 03:43:56 - [INFO] ========================================================================
    
     2026-05-04 03:43:56 - [INFO] Prerequisites check passed: pcl and bteq commands are available on current/running node
     2026-05-04 03:43:56 - [INFO] Checking Teradata PDE state on running node...
     2026-05-04 03:43:56 - [INFO] PDE state check passed on running node: PDE state is RUN/STARTED
     2026-05-04 03:43:56 - [INFO] Checking accessibility of all Teradata nodes...
     2026-05-04 03:43:56 - [INFO] IMPORTANT: ALL nodes must be accessible - if even 1 node is down, installation will be aborted
     2026-05-04 03:43:56 - [INFO] ==========================================
     2026-05-04 03:43:56 - [INFO] Node accessibility check PASSED
     2026-05-04 03:43:56 - [INFO] All 4 node(s) have connected
    
     <---------------------  <node_name>  -------------------------------->
     abyss2
    
    
     <---------------------  <node_name>  -------------------------------->
     abyss4
    
    
     <---------------------  <node_name>  -------------------------------->
     abyss3
    
    
     <---------------------  <node_name>  -------------------------------->
     abyss1
     2026-05-04 03:43:56 - [INFO] ==========================================
    
     2026-05-04 03:43:57 - [INFO] ========================================================================
     2026-05-04 03:43:57 - [INFO] All environment pre-checks PASSED - proceeding with installation
     2026-05-04 03:43:57 - [INFO] ========================================================================
    
     Do you want silent installation? (yes/no) [no]: 
    
  5. To proceed with interactive mode of installation, type no.
  6. Press ENTER.
    The prompt to specify the installation directory for the components appears.
    Do you want to install the new LogForwarder, RPAgent, and DatabaseProtector together in a single directory? (yes/no) [no]:
    
  7. To install the components under a same directory, type yes.
  8. Press ENTER.
    The prompt to enter the installation directory appears.
    Enter new installation directory [/opt/protegrity]:
    
  9. To use the default directory, press ENTER. The prompt to provide credentials to create the UDFs appears.
    Do you want to continue and create UDFs?
    To create the UDFs, provide the database credentials  (yes/no) [no]:
    
  10. To create the UDFs, type yes.

    Note: Skipping creation of the UDFs terminates the upgrade script.

  11. Press ENTER.
    The prompt to enter the database user name appears.
    Enter Teradata database username:
    
  12. Enter the username to login to the database.
  13. Press ENTER.
    The prompt to enter the database password appears.
    Enter Teradata database user's password:
    
  14. Enter the password.
  15. Press ENTER.
    The prompt to specify the database to install the UDF appears.
    Enter name of database where the UDFs will be installed [PROTEGRITY]:
    
  16. Enter the database name to install the UDFs.
  17. Press ENTER.
    The prompt to specify the maximum size of varchar to be allocated by the UDFs appears.
    Enter the maximum size of varchar to be allocated by the UDFs [500]:
    
  18. Enter the maximum size of varchar to be allocated by the UDFs.
  19. Press ENTER.
    The script validates the database and the prompt to verify the configuration appears.
    2026-05-04 03:43:56 - [INFO] Validating database ...
    2026-05-04 03:43:56 - [INFO] Database validated successfully
    
    2026-05-04 03:43:56 - [INFO] **************************************************************************
    2026-05-04 03:43:56 - [INFO] Installation will be done with following configuration:
    2026-05-04 03:43:56 - [INFO] Mode: install
    2026-05-04 03:43:56 - [INFO] Logforwarder Installation Directory: /opt/protegrity/<DBP_version>
    2026-05-04 03:43:56 - [INFO] RPAgent Installation Directory: /opt/protegrity/<DBP_version>
    2026-05-04 03:43:56 - [INFO] DatabaseProtector Installation Directory: /opt/protegrity/<DBP_version>
    2026-05-04 03:43:56 - [INFO] This is a fresh install.
    2026-05-04 03:43:56 - [INFO] **************************************************************************
    
    2026-05-04 03:43:56 - [INFO] Please verify the above configuration before proceeding.
    Do you want to continue? (yes/no) [no]:
    
  20. To continue, type yes.
  21. Press ENTER.
    The script proceeds with the installation and triggers the Log Forwarder installation script. The prompt to enter the Audit Store endpoint appears.
    2026-05-04 03:43:56 - [INFO] Continuing with installation...
    2026-05-04 03:43:56 - [INFO] Installing/Upgrading LOGFORWARDER...
    2026-05-04 03:43:56 - [INFO] Executing ./LogforwarderSetup_Linux_x64_<DBP_version>.sh...
    Enter the audit store endpoint (host), alternative (host:port) to use another port than the default port 9200:
    
  22. Enter the audit store endpoint.
  23. Press ENTER.
    The prompt to enter additional audit store endpoint appears.
    Audit store endpoints: <ESA_IP_Address>:9200
    Do you want to add another audit store endpoint? [y/n]:
    
  24. To specify additional endpoints, type yes.
  25. Press ENTER.
    The prompt to enter the Audit Store endpoint appears.
    Enter the audit store endpoint (host), alternative (host:port) to use another port than the default port 9200:
    
  26. Enter the audit store endpoint.
  27. Press ENTER.
    The script lists the endpoints that will be added. The prompt to accept and continue the installation appears.
    -------------------------------------------
    These audit store endpoints will be added:
    <ESA_IP_Address>:9200
    <ESA_IP_Address>:9200
    <ESA_IP_Address>:9200
    
    Type 'y' to accept or 'n' to abort installation:
    
  28. To accept the endpoints and proceed, type yes.
  29. Press ENTER.
    The script installs the log forwarder. The script then triggers the RPAgent installation script. The prompt to enter the upstream host name or IP address appears.
    Unpacking...
    Extracting files...
    
    Protegrity Log Forwarder installed in /opt/protegrity/<DBP_version>/logforwarder.
    
    2026-05-04 03:43:56 - [INFO] ./LogforwarderSetup_Linux_x64_<DBP_version>.sh completed successfully.
    2026-05-04 03:43:56 - [INFO] Installing/Upgrading RPAGENT...
    Please enter upstream host name or IP address, alternative (host:port) to use another port than the default port 25400:
    
  30. Enter the ESA host name.
  31. Press ENTER.
    The prompt to enter ESA token appears.
    Enter ESA token (leave blank to use username/password):
    
  32. To specify the username/password, press ENTER.
    The prompt to enter ESA username appears.
    Enter ESA username:
    
  33. Enter the username to connect to ESA.
  34. Press ENTER.
    The prompt to enter ESA password appears.
    Enter ESA user's password:
    
  35. Enter the password to connect to ESA.
  36. Press ENTER.
    The script:
    • validates and downloads the certificates from ESA
    • installs the RPAgent
    • copies the Log Forwarder and RPAgent to all the nodes in the Teradata cluster
    • creates installation directories
    • starts the new Log Forwarder on all the nodes
    • triggers the script to install the database objects
    • creates the UDFs The prompt to install the varcharunicode UDF appears.
    2026-05-04 03:43:56 - [INFO] Executing ./RPAgentSetup_Linux_x64_<DBP_version>.sh...
    Unpacking...
    Extracting files...
    Certificate validation successful.
    Obtaining token from <ESA_Hostname>:25400...
    Downloading certificates from <ESA_Hostname>:25400...
    % Total    % Received % Xferd  Average Speed  Time    Time    Time   Current
                                    Dload  Upload  Total   Spent   Left   Speed
    100  11264 100  11264   0      0  63570      0                              0
    
    Extracting certificates...
    Certificates successfully downloaded and stored in /opt/protegrity/<DBP_version>/rpagent/data
    
    Protegrity RPAgent installed in /opt/protegrity/<DBP_version>/rpagent.
    
    2026-05-04 03:43:56 - [INFO] ./RPAgentSetup_Linux_x64_<DBP_version>.sh completed successfully.
    2026-05-04 03:43:56 - [INFO] Copying Logforwarder and RPAgent to all nodes in the Teradata cluster
    2026-05-04 03:43:56 - [INFO] Copying Logforwarder and RPAgent components to all nodes
    2026-05-04 03:43:56 - [INFO] Creating installation directories on all nodes if not present
    All 4 node(s) have connected
    All 4 node(s) have connected
    All 4 node(s) have connected
    All 4 node(s) have connected
    2026-05-04 03:43:56 - [INFO] Copying Logforwarder directory /opt/protegrity/<DBP_version>/logforwarder to all nodes
    All 4 node(s) have connected
    <node_name>: send completed: 57933910 bytes received (9 files/5 directories)
    <node_name>: send completed: 57933910 bytes received (9 files/5 directories)
    <node_name>: send completed: 57933910 bytes received (9 files/5 directories)
    <node_name>: send completed: 57933910 bytes received (9 files/5 directories)
    localhost:1022: send completed: 57934195 bytes received (9 files/5 directories)
    All 4 node(s) have connected
    All 4 node(s) have connected
    2026-05-04 03:43:56 - [INFO] Logforwarder successfully copied to all nodes
    2026-05-04 03:43:56 - [INFO] Copying RPAgent directory /opt/protegrity/<DBP_version>/rpagent to all nodes
    All 4 node(s) have connected
    <node_name>: send completed: 14787336 bytes received (9 files/3 directories)
    <node_name>: send completed: 14787336 bytes received (9 files/3 directories)
    <node_name>: send completed: 14787336 bytes received (9 files/3 directories)
    <node_name>: send completed: 14787336 bytes received (9 files/3 directories)
    All 4 node(s) have connected
    All 4 node(s) have connected
    2026-05-04 03:43:56 - [INFO] RPAgent successfully copied to all nodes
    2026-05-04 03:43:56 - [INFO] Logforwarder and RPAgent successfully copied to all nodes
    2026-05-04 03:43:56 - [INFO] Starting new Logforwarder on all nodes
    2026-05-04 03:45:39 - [INFO] Preparing Database Protector installation...
    2026-05-04 03:45:39 - [INFO] Installing/Upgrading DBP...
    2026-05-04 03:45:39 - [INFO] Executing ./PepTeradataSetup_Linux_x64_<DBP_version>.sh...
    2026-05-04 03:45:40 - [INFO] ./PepTeradataSetup_Linux_x64_<DBP_version>.sh completed successfully.
    2026-05-04 03:45:40 - [INFO] Copying DatabaseProtector to all nodes
    All 4 node(s) have connected
    <node_name>: send completed: 8926081 bytes received (16 files/5 directories)
    <node_name>: send completed: 8926081 bytes received (16 files/5 directories)
    <node_name>: send completed: 8926081 bytes received (16 files/5 directories)
    <node_name>: send completed: 8926081 bytes received (16 files/5 directories)
    All 4 node(s) have connected
    All 4 node(s) have connected
    2026-05-04 03:45:41 - [INFO] Setting DatabaseProtector ownership (tdatuser:tdtrusted) on all nodes
    All 4 node(s) have connected
    2026-05-04 03:45:41 - [INFO] DatabaseProtector successfully copied to all nodes
    2026-05-04 03:45:41 - [INFO] Synchronizing /etc/protegrity to all nodes
    All 4 node(s) have connected
    All 4 node(s) have connected
    <node_name>: send completed: 1157 bytes received (1 files/1 directories)
    <node_name>: send completed: 1157 bytes received (1 files/1 directories)
    <node_name>: send completed: 1157 bytes received (1 files/1 directories)
    <node_name>: send completed: 1157 bytes received (1 files/1 directories)
    All 4 node(s) have connected
    All 4 node(s) have connected
    All 4 node(s) have connected
    2026-05-04 03:45:42 - [INFO] User configuration directory successfully synchronized to all nodes
    2026-05-04 03:45:42 - [INFO] Starting new RPAgent on all nodes
    2026-05-04 03:45:42 - [INFO] Successfully launched new RPAgent on all nodes
    2026-05-04 03:45:42 - [INFO] Creating new UDFs (database operation on current node only - shared across all nodes)
    BTEQ 17.20.00.08 (64-bit) Mon May  4 03:45:42 2026 PID: 130808
    
    +---------+---------+---------+---------+---------+---------+---------+----
    .SET EXITONDELAY ON MAXREQTIME 300 RC 12
    +---------+---------+---------+---------+---------+---------+---------+----
    .logon localhost/<database_user_name>,
    
    *** Logon successfully completed.
    *** Teradata Database Release is 17.20.03.18                   
    *** Teradata Database Version is 17.20.03.18                     
    *** Transaction Semantics are BTET.
    *** Session Character Set Name is 'ASCII'.
    
    *** Total elapsed time was 1 second.
    
    +---------+---------+---------+---------+---------+---------+---------+----
    database <database_name>;
    
    *** New default database accepted. 
    *** Total elapsed time was 1 second.
    
    
    +---------+---------+---------+---------+---------+---------+---------+----
    .IF ERRORCODE <> 0 THEN .QUIT 12;
    +---------+---------+---------+---------+---------+---------+---------+----
    .run file /opt/protegrity/<DBP_version>/databaseprotector/teradata/sqlscripts/c
    reateobjects.sql;
    +---------+---------+---------+---------+---------+---------+---------+----
    
    Do you want to create the varcharunicode UDFs? (yes/no) [no]:
    
  37. To create the varcharunicode UDFs, type yes.
  38. Press ENTER.
    The script creates the varcharunicode UDFs and completes the installation.
    2026-05-04 03:46:03 - [INFO] Creating varcharunicode UDFs
    BTEQ 17.20.00.08 (64-bit) Mon May  4 03:46:03 2026 PID: 131563
    
    +---------+---------+---------+---------+---------+---------+---------+----
    .SET EXITONDELAY ON MAXREQTIME 300 RC 12
    +---------+---------+---------+---------+---------+---------+---------+----
    .logon localhost/<database_user_name>,
    
    *** Logon successfully completed.
    *** Teradata Database Release is 17.20.03.18                   
    *** Teradata Database Version is 17.20.03.18                     
    *** Transaction Semantics are BTET.
    *** Session Character Set Name is 'ASCII'.
    
    *** Total elapsed time was 1 second.
    
    +---------+---------+---------+---------+---------+---------+---------+----
    database <database_name>;
    
    *** New default database accepted. 
    *** Total elapsed time was 1 second.
    
    
    +---------+---------+---------+---------+---------+---------+---------+----
    .IF ERRORCODE <> 0 THEN .QUIT 12;
    +---------+---------+---------+---------+---------+---------+---------+----
    .run file /opt/protegrity/<DBP_version>/databaseprotector/teradata/sqlscripts/c
    reatevarcharunicode.sql;
    +---------+---------+---------+---------+---------+---------+---------+----
    
    2026-05-04 03:46:05 - [INFO] Varcharunicode UDFs created successfully
    2026-05-04 03:46:05 - [INFO] Testing UDFs
    BTEQ 17.20.00.08 (64-bit) Mon May  4 03:46:05 2026 PID: 131653
    
    +---------+---------+---------+---------+---------+---------+---------+----
    .SET EXITONDELAY ON MAXREQTIME 300 RC 12
    +---------+---------+---------+---------+---------+---------+---------+----
    .logon localhost/<database_user_name>,
    
    *** Logon successfully completed.
    *** Teradata Database Release is 17.20.03.18                   
    *** Teradata Database Version is 17.20.03.18                     
    *** Transaction Semantics are BTET.
    *** Session Character Set Name is 'ASCII'.
    
    *** Total elapsed time was 1 second.
    
    +---------+---------+---------+---------+---------+---------+---------+----
    database <database_name>;
    
    *** New default database accepted. 
    *** Total elapsed time was 1 second.
    
    
    +---------+---------+---------+---------+---------+---------+---------+----
    .IF ERRORCODE <> 0 THEN .QUIT 12;
    +---------+---------+---------+---------+---------+---------+---------+----
    select pty_getversion();
    
    *** Query completed. One row found. One column returned. 
    *** Total elapsed time was 1 second.
    
    pty_getversion()
    ---------------------------------------------------------------------------
    <DBP_version>
    
    +---------+---------+---------+---------+---------+---------+---------+----
    .logoff
    *** You are now logged off from the <database_user_name>.
    +---------+---------+---------+---------+---------+---------+---------+----
    .quit
    *** Exiting BTEQ...
    *** RC (return code) = 0 
    2026-05-04 03:46:05 - [INFO] Installation successful.
    2026-05-04 03:46:05 - [INFO] All components installed successfully.
    
    2026-05-04 03:46:05 - [INFO] IMPORTANT: Protegrity UDT installation must be handled manually. Refer to product documentation.
    2026-05-04 03:46:05 - [INFO] IMPORTANT: Protegrity Decimal UDF objects installation must be handled manually. Refer to product documentation.
    

Installing the Protector using the Silent Mode

  1. Log in to the server as the user with the required permissions.
  2. Navigate to the directory containing the extracted files and the installation scripts.
  3. To execute the script, run the following command:
    ./Install_TeradataProtector_Linux_x64_<DBP_version>.sh --install
    
  4. Press ENTER.
    The script executes pre-checks and the prompt to select the silent mode of installation appears.
     2026-05-04 03:54:36 - [INFO] ========================================================================
     2026-05-04 03:54:36 - [INFO] Starting environment pre-checks before installation/upgrade
     2026-05-04 03:54:36 - [INFO] ========================================================================
    
     2026-05-04 03:54:36 - [INFO] Prerequisites check passed: pcl and bteq commands are available on current/running node
     2026-05-04 03:54:36 - [INFO] Checking Teradata PDE state on running node...
     2026-05-04 03:54:36 - [INFO] PDE state check passed on running node: PDE state is RUN/STARTED
     2026-05-04 03:54:36 - [INFO] Checking accessibility of all Teradata nodes...
     2026-05-04 03:54:36 - [INFO] IMPORTANT: ALL nodes must be accessible - if even 1 node is down, installation will be aborted
     2026-05-04 03:54:36 - [INFO] ==========================================
     2026-05-04 03:54:36 - [INFO] Node accessibility check PASSED
     2026-05-04 03:54:36 - [INFO] All 4 node(s) have connected
    
     <---------------------  <node_name>  -------------------------------->
     abyss4
    
    
     <---------------------  <node_name>  -------------------------------->
     abyss2
    
    
     <---------------------  <node_name>  -------------------------------->
     abyss3
    
    
     <---------------------  <node_name>  -------------------------------->
     abyss1
     2026-05-04 03:54:36 - [INFO] ==========================================
    
     2026-05-04 03:54:36 - [INFO] ========================================================================
     2026-05-04 03:54:36 - [INFO] All environment pre-checks PASSED - proceeding with installation
     2026-05-04 03:54:36 - [INFO] ========================================================================
    
     Do you want silent installation? (yes/no) [no]:
    
  5. To proceed with silent mode of installation, type yes.
  6. Press ENTER.
    The script uses the default installation directory, /opt/protegrity/, for silent installation. The prompt to create UDFs and provide database credentials appears.
     2026-05-04 03:54:39 - [INFO] You have chosen silent mode. Therefore, /opt/protegrity is considered as base directory for new installation.
     Do you want to continue and create UDFs?
     To create the UDFs, provide the database credentials  (yes/no) [no]: 
    
  7. To create the UDFs, type yes.

    Note: Skipping creation of the UDFs terminates the upgrade script.

  8. Press ENTER.
    The prompt to enter the database username appears.
    Enter Teradata database username:
    
  9. Enter the username.
  10. Press ENTER.
    The prompt to enter the password appears.
    Enter Teradata database user's password:
    
  11. Enter the password.
  12. Press ENTER.
    The prompt to enter the database name appears.
    Enter name of database where the UDFs will be installed [PROTEGRITY]:
    
  13. Enter the database name to install the UDFs.
  14. Press ENTER.
    The prompt to specify the maximum size of varchar to be allocated by the UDFs appears.
    Enter the maximum size of varchar to be allocated by the UDFs [500]:
    
  15. Enter the maximum size of varchar to be allocated by the UDFs.
  16. Press ENTER.
    The script validates the database. The script lists the configuration and the prompt to continue appears.
    2026-05-04 03:54:55 - [INFO] Validating database ...
    2026-05-04 03:54:55 - [INFO] Database validated successfully
    
    2026-05-04 03:54:55 - [INFO] **************************************************************************
    2026-05-04 03:54:55 - [INFO] Installation will be done with following configuration:
    2026-05-04 03:54:55 - [INFO] Mode: install
    2026-05-04 03:54:55 - [INFO] Logforwarder Installation Directory: /opt/protegrity/<DBP_version>
    2026-05-04 03:54:55 - [INFO] RPAgent Installation Directory: /opt/protegrity/<DBP_version>
    2026-05-04 03:54:55 - [INFO] DatabaseProtector Installation Directory: /opt/protegrity/<DBP_version>
    2026-05-04 03:54:55 - [INFO] This is a fresh install.
    2026-05-04 03:54:55 - [INFO] **************************************************************************
    
    2026-05-04 03:54:55 - [INFO] Please verify the above configuration before proceeding.
    Do you want to continue? (yes/no) [no]:
    
  17. To proceed with the configuration, type yes.
  18. Press ENTER.
    The script proceeds with the installation and completes the Log Forwarder installation. The prompt to enter the upstream host name or IP address appears.
    2026-05-04 03:55:03 - [INFO] Continuing with installation...
    2026-05-04 03:55:03 - [INFO] Installing/Upgrading LOGFORWARDER...
    2026-05-04 03:55:03 - [INFO] Executing ./LogforwarderSetup_Linux_x64_<DBP_version>.sh...
    2026-05-04 03:55:23 - [INFO] ./LogforwarderSetup_Linux_x64_<DBP_version>.sh completed successfully.
    2026-05-04 03:55:23 - [INFO] Installing/Upgrading RPAGENT...
    Please enter upstream host name or IP address, alternative (host:port) to use another port than the default port 25400:
    
  19. Enter the ESA hostname.
  20. Press ENTER.
    The prompt to enter ESA token appears.
    Enter ESA token (leave blank to use username/password):
    
  21. To specify the username/password, press ENTER.
    The prompt to enter ESA username appears.
    Enter ESA username:
    
  22. Enter the username to connect to ESA.
  23. Press ENTER.
    The prompt to enter ESA password appears.
    Enter ESA user's password:
    
  24. Enter the password to connect to ESA.
  25. Press ENTER.
    The script:
    • validates and downloads the certificates from ESA
    • installs the RPAgent
    • copies the Log Forwarder and RPAgent to all the nodes in the Teradata cluster
    • creates installation directories
    • starts the new Log Forwarder on all the nodes
    • triggers the script to install the database objects
    • installs the database objects
    • copies the objects to all the nodes in the cluster
    • starts the new RPAgent on all the nodes
    • creates the new UDFs The prompt to create the varcharunicode UDFs appears.
    2026-05-04 03:55:43 - [INFO] Executing ./RPAgentSetup_Linux_x64_<DBP_version>.sh...
    Unpacking...
    Extracting files...
    Certificate validation successful.
    Obtaining token from <ESA_Hostname>:25400...
    Downloading certificates from <ESA_Hostname>:25400...
    % Total    % Received % Xferd  Average Speed  Time    Time    Time   Current
                                    Dload  Upload  Total   Spent   Left   Speed
    100  11264 100  11264   0      0  63570      0                              0
    
    Extracting certificates...
    Certificates successfully downloaded and stored in /opt/protegrity/<DBP_version>/rpagent/data
    
    Protegrity RPAgent installed in /opt/protegrity/<DBP_version>/rpagent.
    
    2026-05-04 03:55:51 - [INFO] ./RPAgentSetup_Linux_x64_<DBP_version>.sh completed successfully.
    2026-05-04 03:55:51 - [INFO] Copying Logforwarder and RPAgent to all nodes in the Teradata cluster
    2026-05-04 03:55:51 - [INFO] Copying Logforwarder and RPAgent components to all nodes
    2026-05-04 03:55:51 - [INFO] Creating installation directories on all nodes if not present
    All 4 node(s) have connected
    All 4 node(s) have connected
    All 4 node(s) have connected
    All 4 node(s) have connected
    2026-05-04 03:55:52 - [INFO] Copying Logforwarder directory /opt/protegrity/<DBP_version>/logforwarder to all nodes
    All 4 node(s) have connected
    <node_name>: send completed: 57933910 bytes received (9 files/5 directories)
    <node_name>: send completed: 57933910 bytes received (9 files/5 directories)
    <node_name>: send completed: 57933910 bytes received (9 files/5 directories)
    <node_name>: send completed: 57933910 bytes received (9 files/5 directories)
    All 4 node(s) have connected
    All 4 node(s) have connected
    2026-05-04 03:55:53 - [INFO] Logforwarder successfully copied to all nodes
    2026-05-04 03:55:53 - [INFO] Copying RPAgent directory /opt/protegrity/<DBP_version>/rpagent to all nodes
    All 4 node(s) have connected
    <node_name>: send completed: 14787336 bytes received (9 files/3 directories)
    <node_name>: send completed: 14787336 bytes received (9 files/3 directories)
    <node_name>: send completed: 14787336 bytes received (9 files/3 directories)
    <node_name>: send completed: 14787336 bytes received (9 files/3 directories)
    All 4 node(s) have connected
    All 4 node(s) have connected
    2026-05-04 03:55:54 - [INFO] RPAgent successfully copied to all nodes
    2026-05-04 03:55:54 - [INFO] Logforwarder and RPAgent successfully copied to all nodes
    2026-05-04 03:55:54 - [INFO] Starting new Logforwarder on all nodes
    2026-05-04 03:55:56 - [INFO] Preparing Database Protector installation...
    2026-05-04 03:55:56 - [INFO] Installing/Upgrading DBP...
    2026-05-04 03:55:56 - [INFO] Executing ./PepTeradataSetup_Linux_x64_<DBP_version>.sh...
    2026-05-04 03:55:57 - [INFO] ./PepTeradataSetup_Linux_x64_<DBP_version>.sh completed successfully.
    2026-05-04 03:55:57 - [INFO] Copying DatabaseProtector to all nodes
    All 4 node(s) have connected
    <node_name>: send completed: 8926081 bytes received (16 files/5 directories)
    <node_name>: send completed: 8926081 bytes received (16 files/5 directories)
    <node_name>: send completed: 8926081 bytes received (16 files/5 directories)
    <node_name>: send completed: 8926081 bytes received (16 files/5 directories)
    All 4 node(s) have connected
    All 4 node(s) have connected
    2026-05-04 03:55:57 - [INFO] Setting DatabaseProtector ownership (tdatuser:tdtrusted) on all nodes
    All 4 node(s) have connected
    2026-05-04 03:55:57 - [INFO] DatabaseProtector successfully copied to all nodes
    2026-05-04 03:55:57 - [INFO] Synchronizing /etc/protegrity to all nodes
    All 4 node(s) have connected
    All 4 node(s) have connected
    <node_name>: send completed: 1157 bytes received (1 files/1 directories)
    <node_name>: send completed: 1157 bytes received (1 files/1 directories)
    <node_name>: send completed: 1157 bytes received (1 files/1 directories)
    <node_name>: send completed: 1157 bytes received (1 files/1 directories)
    All 4 node(s) have connected
    All 4 node(s) have connected
    All 4 node(s) have connected
    2026-05-04 03:55:58 - [INFO] User configuration directory successfully synchronized to all nodes
    2026-05-04 03:55:58 - [INFO] Starting new RPAgent on all nodes
    2026-05-04 03:55:58 - [INFO] Successfully launched new RPAgent on all nodes
    2026-05-04 03:55:58 - [INFO] Creating new UDFs (database operation on current node only - shared across all nodes)
    BTEQ 17.20.00.08 (64-bit) Mon May  4 03:55:58 2026 PID: 138943
    
    +---------+---------+---------+---------+---------+---------+---------+----
    .SET EXITONDELAY ON MAXREQTIME 300 RC 12
    +---------+---------+---------+---------+---------+---------+---------+----
    .logon localhost/<database_user_name>,
    
    *** Logon successfully completed.
    *** Teradata Database Release is 17.20.03.18                   
    *** Teradata Database Version is 17.20.03.18                     
    *** Transaction Semantics are BTET.
    *** Session Character Set Name is 'ASCII'.
    
    *** Total elapsed time was 1 second.
    
    +---------+---------+---------+---------+---------+---------+---------+----
    database <database_name>;
    
    *** New default database accepted. 
    *** Total elapsed time was 1 second.
    
    
    +---------+---------+---------+---------+---------+---------+---------+----
    .IF ERRORCODE <> 0 THEN .QUIT 12;
    +---------+---------+---------+---------+---------+---------+---------+----
    .run file /opt/protegrity/<DBP_version>/databaseprotector/teradata/sqlscripts/c
    reateobjects.sql;
    +---------+---------+---------+---------+---------+---------+---------+----
    
    Do you want to create the varcharunicode UDFs? (yes/no) [no]:
    
  26. To create the varcharunicode UDFs, type yes.
  27. Press ENTER.
    The script installs the varcharunicode UDFs and completes the installation.
    2026-05-04 03:58:43 - [INFO] Creating varcharunicode UDFs
    BTEQ 17.20.00.08 (64-bit) Mon May  4 03:58:43 2026 PID: 140061
    
    +---------+---------+---------+---------+---------+---------+---------+----
    .SET EXITONDELAY ON MAXREQTIME 300 RC 12
    +---------+---------+---------+---------+---------+---------+---------+----
    .logon localhost/<database_user_name>,
    
    *** Logon successfully completed.
    *** Teradata Database Release is 17.20.03.18                   
    *** Teradata Database Version is 17.20.03.18                     
    *** Transaction Semantics are BTET.
    *** Session Character Set Name is 'ASCII'.
    
    *** Total elapsed time was 1 second.
    
    +---------+---------+---------+---------+---------+---------+---------+----
    database <database_name>;
    
    *** New default database accepted. 
    *** Total elapsed time was 1 second.
    
    
    +---------+---------+---------+---------+---------+---------+---------+----
    .IF ERRORCODE <> 0 THEN .QUIT 12;
    +---------+---------+---------+---------+---------+---------+---------+----
    .run file /opt/protegrity/<DBP_version>/databaseprotector/teradata/sqlscripts/c
    reatevarcharunicode.sql;
    +---------+---------+---------+---------+---------+---------+---------+----
    
    2026-05-04 03:58:45 - [INFO] Varcharunicode UDFs created successfully
    2026-05-04 03:58:45 - [INFO] Testing UDFs
    BTEQ 17.20.00.08 (64-bit) Mon May  4 03:58:45 2026 PID: 140151
    
    +---------+---------+---------+---------+---------+---------+---------+----
    .SET EXITONDELAY ON MAXREQTIME 300 RC 12
    +---------+---------+---------+---------+---------+---------+---------+----
    .logon localhost/<database_user_name>,
    
    *** Logon successfully completed.
    *** Teradata Database Release is 17.20.03.18                   
    *** Teradata Database Version is 17.20.03.18                     
    *** Transaction Semantics are BTET.
    *** Session Character Set Name is 'ASCII'.
    
    *** Total elapsed time was 1 second.
    
    +---------+---------+---------+---------+---------+---------+---------+----
    database <database_name>;
    
    *** New default database accepted. 
    *** Total elapsed time was 1 second.
    
    
    +---------+---------+---------+---------+---------+---------+---------+----
    .IF ERRORCODE <> 0 THEN .QUIT 12;
    +---------+---------+---------+---------+---------+---------+---------+----
    select pty_getversion();
    
    *** Query completed. One row found. One column returned. 
    *** Total elapsed time was 1 second.
    
    pty_getversion()
    ---------------------------------------------------------------------------
    <DBP_version>
    
    +---------+---------+---------+---------+---------+---------+---------+----
    .logoff
    *** You are now logged off from the <database_user_name>.
    +---------+---------+---------+---------+---------+---------+---------+----
    .quit
    *** Exiting BTEQ...
    *** RC (return code) = 0 
    2026-05-04 03:58:45 - [INFO] Installation successful.
    2026-05-04 03:58:45 - [INFO] All components installed successfully.
    
    2026-05-04 03:58:45 - [INFO] IMPORTANT: Protegrity UDT installation must be handled manually. Refer to product documentation.
    2026-05-04 03:58:45 - [INFO] IMPORTANT: Protegrity Decimal UDF objects installation must be handled manually. Refer to product documentation.
    

Installing the Protector using the install.ini file

This argument requires the install.ini file to be present and updated with the required parameters. The install.ini files contains the installation directories for the components and the endpoints for the Log Forwarder and RPAgent.

A sample output of the install.ini file is listed below.

; =============================================================================
; install.ini - Sample configuration file for Database Protector installation
; =============================================================================
;
; Usage:
;   ./install_pep_teradata_v2.sh --install --install-ini /path/to/install.ini
;
; Notes:
;   - This file is only supported with --install mode (not --upgrade or --silent).
;   - Lines starting with ; or # are treated as comments.
;   - All fields listed below are REQUIRED unless noted otherwise.
;   - Section names and keys are case-insensitive during parsing.
;   - The installer will automatically append the component subdirectory
;     (e.g., /logforwarder, /rpagent, /databaseprotector) under each
;     INSTALLATION_DIR path.
;
; =============================================================================

[Logforwarder]
; Base directory where LogForwarder will be installed.
; The installer will create a "logforwarder" subdirectory under this path.
INSTALLATION_DIR = /opt/protegrity

; Space-separated list of audit store endpoint(s) in host:port format.
; Multiple endpoints can be specified for redundancy.
AUDIT_STORE_ENDPOINTS = <Audit_Store_Endpoint>:9200 <Audit_Store_Endpoint>:9200

[RPAgent]
; Base directory where RPAgent will be installed.
; The installer will create an "rpagent" subdirectory under this path.
INSTALLATION_DIR = /opt/protegrity

; Upstream ESA (Enterprise Security Administrator) host and port.
; Format: <ip_or_hostname>:<port>
; If the port is omitted, the default port 25400 is used.
UPSTREAM_HOST_IP_ADDR_PORT = <ESA_Hostname>:25400

[DatabaseProtector]
; Base directory where DatabaseProtector will be installed.
; The installer will create a "databaseprotector" subdirectory under this path.
INSTALLATION_DIR = /opt/protegrity

; Teradata database name used for creating UDF objects.
DATABASE_NAME = <Database_name_to_install_UDFs>

; Maximum size of VARCHAR to be allocated by the UDFs.
; Must be a positive integer.
MAX_VARCHAR_SIZE = 500

Note: To use any directory for the Database Protector, ensure the directory is available. Otherwise, the installation will fail. Note: The default port for the Audit Store endpoint is 9200. The default port for the RPAgent is 25400. To use any other port, replace the value.

To install the protector using the install.ini argument:

  1. Log in to the server as the user with the required permissions.
  2. Navigate to the directory containing the extracted files and the installation scripts.
  3. To execute the script with the argument, run the following command:
    ./Install_TeradataProtector_Linux_x64_<DBP_version>.sh --install --install-ini <path_to_install.ini_file>
    
  4. Press ENTER.
    The script performs a pre-check, detects the install.ini file and the prompt to create the UDF appears.
     2026-05-04 04:11:01 - [INFO] ========================================================================
     2026-05-04 04:11:01 - [INFO] Starting environment pre-checks before installation/upgrade
     2026-05-04 04:11:01 - [INFO] ========================================================================
    
     2026-05-04 04:11:01 - [INFO] Prerequisites check passed: pcl and bteq commands are available on current/running node
     2026-05-04 04:11:01 - [INFO] Checking Teradata PDE state on running node...
     2026-05-04 04:11:01 - [INFO] PDE state check passed on running node: PDE state is RUN/STARTED
     2026-05-04 04:11:01 - [INFO] Checking accessibility of all Teradata nodes...
     2026-05-04 04:11:01 - [INFO] IMPORTANT: ALL nodes must be accessible - if even 1 node is down, installation will be aborted
     2026-05-04 04:11:01 - [INFO] ==========================================
     2026-05-04 04:11:01 - [INFO] Node accessibility check PASSED
     2026-05-04 04:11:01 - [INFO] All 4 node(s) have connected
    
     <---------------------  <node_name>  -------------------------------->
     abyss4
    
    
     <---------------------  <node_name>  -------------------------------->
     abyss3
    
    
     <---------------------  <node_name>  -------------------------------->
     abyss2
    
    
     <---------------------  <node_name>  -------------------------------->
     abyss1
     2026-05-04 04:11:01 - [INFO] ==========================================
    
     2026-05-04 04:11:01 - [INFO] ========================================================================
     2026-05-04 04:11:01 - [INFO] All environment pre-checks PASSED - proceeding with installation
     2026-05-04 04:11:01 - [INFO] ========================================================================
    
     2026-05-04 04:11:01 - [INFO] install.ini detected: /<path_to_install.ini_file>/install.ini
     Do you want to continue and create UDFs?
     To create the UDFs, provide the database credentials  (yes/no) [no]: 
    
  5. To create the UDFs, type yes.
  6. Press ENTER.
    The prompt to enter the database username appears.
    Enter Teradata database username:
    
  7. Enter the username.
  8. Press ENTER.
    The prompt to enter the database password appears.
    Enter Teradata database user's password:
    
  9. Enter the password.
  10. Press ENTER.
    The script validates the database and lists the configuration. The prompt to verify the configuration appears.
    2026-05-04 04:11:12 - [INFO] Validating database ...
    2026-05-04 04:11:12 - [INFO] Database validated successfully
    
    2026-05-04 04:11:12 - [INFO] **************************************************************************
    2026-05-04 04:11:12 - [INFO] Installation will be done with following configuration:
    2026-05-04 04:11:12 - [INFO] Mode: install
    2026-05-04 04:11:12 - [INFO] Using configuration from install.ini: 
    2026-05-04 04:11:12 - [INFO] Logforwarder Installation Directory: /home/<DBP_version>
    2026-05-04 04:11:12 - [INFO] Audit Store Endpoints: 10.25.61.133:9443 10.25.61.135:9443 10.25.61.136:9443
    2026-05-04 04:11:12 - [INFO] RPAgent Installation Directory: /home/<DBP_version>
    2026-05-04 04:11:12 - [INFO] Upstream (ESA) IP Address for RPAgent: 10.25.61.135
    2026-05-04 04:11:12 - [INFO] Upstream (ESA) Port for RPAgent: 25400
    2026-05-04 04:11:12 - [INFO] DatabaseProtector Installation Directory: /home/<DBP_version>
    2026-05-04 04:11:12 - [INFO] This is a fresh install.
    2026-05-04 04:11:12 - [INFO] **************************************************************************
    
    2026-05-04 04:11:12 - [INFO] Please verify the above configuration before proceeding.
    Do you want to continue? (yes/no) [no]:
    
  11. To proceed with the configuration, type yes.
  12. Press ENTER.
    The script installs the log forwarder. The script then triggers the RPAgent installation script. The prompt to enter ESA token appears.
    2026-05-04 04:11:46 - [INFO] Continuing with installation...
    2026-05-04 04:11:46 - [INFO] Installing/Upgrading LOGFORWARDER...
    2026-05-04 04:11:46 - [INFO] Executing ./LogforwarderSetup_Linux_x64_<DBP_version>.sh...
    2026-05-04 04:11:47 - [INFO] ./LogforwarderSetup_Linux_x64_<DBP_version>.sh completed successfully.
    2026-05-04 04:11:47 - [INFO] Installing/Upgrading RPAGENT...
    Enter ESA token (leave blank to use username/password):
    
  13. To use the credentials for ESA, press ENTER.
    The prompt to enter the username appears.
    Enter ESA username:
    
  14. Enter the username.
  15. Press ENTER.
    The prompt to enter the password appears.
    Enter ESA user's password:
    
  16. Enter the password.
  17. Press ENTER.
    The script:
    • validates and downloads the certificates from ESA
    • installs the RPAgent
    • copies the Log Forwarder and RPAgent to all the nodes in the Teradata cluster
    • creates installation directories
    • starts the new Log Forwarder on all the nodes
    • triggers the script to install the database objects
    • creates the UDFs The prompt to install the varcharunicode UDF appears.
    2026-05-04 04:12:08 - [INFO] Executing ./RPAgentSetup_Linux_x64_<DBP_version>.sh...
    Unpacking...
    Extracting files...
    Certificate validation successful.
    Obtaining token from <ESA_Hostname>:25400...
    Downloading certificates from <ESA_Hostname>:25400...
    % Total    % Received % Xferd  Average Speed  Time    Time    Time   Current
                                    Dload  Upload  Total   Spent   Left   Speed
    100  11264 100  11264   0      0  54891      0                              0
    
    Extracting certificates...
    Certificates successfully downloaded and stored in /opt/protegrity/<DBP_version>/rpagent/data
    
    Protegrity RPAgent installed in /opt/protegrity/<DBP_version>/rpagent.
    
    2026-05-04 04:12:14 - [INFO] ./RPAgentSetup_Linux_x64_<DBP_version>.sh completed successfully.
    2026-05-04 04:12:14 - [INFO] Copying Logforwarder and RPAgent to all nodes in the Teradata cluster
    2026-05-04 04:12:14 - [INFO] Copying Logforwarder and RPAgent components to all nodes
    2026-05-04 04:12:14 - [INFO] Creating installation directories on all nodes if not present
    All 4 node(s) have connected
    All 4 node(s) have connected
    All 4 node(s) have connected
    All 4 node(s) have connected
    2026-05-04 04:12:14 - [INFO] Copying Logforwarder directory /home/<DBP_version>/logforwarder to all nodes
    All 4 node(s) have connected
    <node_name>: send completed: 57934078 bytes received (9 files/5 directories)
    <node_name>: send completed: 57934078 bytes received (9 files/5 directories)
    <node_name>: send completed: 57934078 bytes received (9 files/5 directories)
    <node_name>: send completed: 57934078 bytes received (9 files/5 directories)
    All 4 node(s) have connected
    All 4 node(s) have connected
    2026-05-04 04:12:15 - [INFO] Logforwarder successfully copied to all nodes
    2026-05-04 04:12:15 - [INFO] Copying RPAgent directory /opt/protegrity/<DBP_version>/rpagent to all nodes
    All 4 node(s) have connected
    <node_name>: send completed: 14787256 bytes received (9 files/3 directories)
    <node_name>: send completed: 14787256 bytes received (9 files/3 directories)
    <node_name>: send completed: 14787256 bytes received (9 files/3 directories)
    <node_name>: send completed: 14787256 bytes received (9 files/3 directories)
    All 4 node(s) have connected
    All 4 node(s) have connected
    2026-05-04 04:12:16 - [INFO] RPAgent successfully copied to all nodes
    2026-05-04 04:12:16 - [INFO] Logforwarder and RPAgent successfully copied to all nodes
    2026-05-04 04:12:16 - [INFO] Starting new Logforwarder on all nodes
    2026-05-04 04:12:19 - [INFO] Preparing Database Protector installation...
    2026-05-04 04:12:19 - [INFO] Installing/Upgrading DBP...
    2026-05-04 04:12:19 - [INFO] Executing ./PepTeradataSetup_Linux_x64_<DBP_version>.sh...
    2026-05-04 04:12:19 - [INFO] ./PepTeradataSetup_Linux_x64_<DBP_version>.sh completed successfully.
    2026-05-04 04:12:19 - [INFO] Copying DatabaseProtector to all nodes
    All 4 node(s) have connected
    <node_name>: send completed: 8924920 bytes received (16 files/5 directories)
    <node_name>: send completed: 8924920 bytes received (16 files/5 directories)
    <node_name>: send completed: 8924920 bytes received (16 files/5 directories)
    <node_name>: send completed: 8924920 bytes received (16 files/5 directories)
    All 4 node(s) have connected
    All 4 node(s) have connected
    2026-05-04 04:12:20 - [INFO] Setting DatabaseProtector ownership (tdatuser:tdtrusted) on all nodes
    All 4 node(s) have connected
    2026-05-04 04:12:20 - [INFO] DatabaseProtector successfully copied to all nodes
    2026-05-04 04:12:20 - [INFO] Synchronizing /etc/protegrity to all nodes
    All 4 node(s) have connected
    All 4 node(s) have connected
    <node_name>: send completed: 1157 bytes received (1 files/1 directories)
    <node_name>: send completed: 1157 bytes received (1 files/1 directories)
    <node_name>: send completed: 1157 bytes received (1 files/1 directories)
    <node_name>: send completed: 1157 bytes received (1 files/1 directories)
    All 4 node(s) have connected
    All 4 node(s) have connected
    All 4 node(s) have connected
    2026-05-04 04:12:21 - [INFO] User configuration directory successfully synchronized to all nodes
    2026-05-04 04:12:21 - [INFO] Starting new RPAgent on all nodes
    2026-05-04 04:12:21 - [INFO] Successfully launched new RPAgent on all nodes
    2026-05-04 04:12:21 - [INFO] Creating new UDFs (database operation on current node only - shared across all nodes)
    BTEQ 17.20.00.08 (64-bit) Mon May  4 04:12:21 2026 PID: 143569
    
    +---------+---------+---------+---------+---------+---------+---------+----
    .SET EXITONDELAY ON MAXREQTIME 300 RC 12
    +---------+---------+---------+---------+---------+---------+---------+----
    .logon localhost/<database_name>,
    
    *** Logon successfully completed.
    *** Teradata Database Release is 17.20.03.18                   
    *** Teradata Database Version is 17.20.03.18                     
    *** Transaction Semantics are BTET.
    *** Session Character Set Name is 'ASCII'.
    
    *** Total elapsed time was 1 second.
    
    +---------+---------+---------+---------+---------+---------+---------+----
    database testdb;
    
    *** New default database accepted. 
    *** Total elapsed time was 1 second.
    
    
    +---------+---------+---------+---------+---------+---------+---------+----
    .IF ERRORCODE <> 0 THEN .QUIT 12;
    +---------+---------+---------+---------+---------+---------+---------+----
    .run file /home/<DBP_version>/databaseprotector/teradata/sqlscripts/createobjec
    ts.sql;
    +---------+---------+---------+---------+---------+---------+---------+----
    
    Do you want to create the varcharunicode UDFs? (yes/no) [no]:
    
  18. To create the varcharunicode UDFs, type yes.
  19. Press ENTER.
    The script creates the varcharunicode UDFs and completes the installation.
    2026-05-04 04:12:44 - [INFO] Creating varcharunicode UDFs
    BTEQ 17.20.00.08 (64-bit) Mon May  4 04:12:44 2026 PID: 144325
    
    +---------+---------+---------+---------+---------+---------+---------+----
    .SET EXITONDELAY ON MAXREQTIME 300 RC 12
    +---------+---------+---------+---------+---------+---------+---------+----
    .logon localhost/<database_name>,
    
    *** Logon successfully completed.
    *** Teradata Database Release is 17.20.03.18                   
    *** Teradata Database Version is 17.20.03.18                     
    *** Transaction Semantics are BTET.
    *** Session Character Set Name is 'ASCII'.
    
    *** Total elapsed time was 1 second.
    
    +---------+---------+---------+---------+---------+---------+---------+----
    database testdb;
    
    *** New default database accepted. 
    *** Total elapsed time was 1 second.
    
    
    +---------+---------+---------+---------+---------+---------+---------+----
    .IF ERRORCODE <> 0 THEN .QUIT 12;
    +---------+---------+---------+---------+---------+---------+---------+----
    .run file /home/<DBP_version>/databaseprotector/teradata/sqlscripts/createvarch
    arunicode.sql;
    +---------+---------+---------+---------+---------+---------+---------+----
    
    2026-05-04 04:12:46 - [INFO] Varcharunicode UDFs created successfully
    2026-05-04 04:12:46 - [INFO] Testing UDFs
    BTEQ 17.20.00.08 (64-bit) Mon May  4 04:12:46 2026 PID: 144416
    
    +---------+---------+---------+---------+---------+---------+---------+----
    .SET EXITONDELAY ON MAXREQTIME 300 RC 12
    +---------+---------+---------+---------+---------+---------+---------+----
    .logon localhost/<database_name>,
    
    *** Logon successfully completed.
    *** Teradata Database Release is 17.20.03.18                   
    *** Teradata Database Version is 17.20.03.18                     
    *** Transaction Semantics are BTET.
    *** Session Character Set Name is 'ASCII'.
    
    *** Total elapsed time was 1 second.
    
    +---------+---------+---------+---------+---------+---------+---------+----
    database testdb;
    
    *** New default database accepted. 
    *** Total elapsed time was 1 second.
    
    
    +---------+---------+---------+---------+---------+---------+---------+----
    .IF ERRORCODE <> 0 THEN .QUIT 12;
    +---------+---------+---------+---------+---------+---------+---------+----
    select pty_getversion();
    
    *** Query completed. One row found. One column returned. 
    *** Total elapsed time was 1 second.
    
    pty_getversion()
    ---------------------------------------------------------------------------
    <DBP_version>
    
    +---------+---------+---------+---------+---------+---------+---------+----
    .logoff
    *** You are now logged off from the <database_name>.
    +---------+---------+---------+---------+---------+---------+---------+----
    .quit
    *** Exiting BTEQ...
    *** RC (return code) = 0 
    2026-05-04 04:12:46 - [INFO] Installation successful.
    2026-05-04 04:12:46 - [INFO] All components installed successfully.
    
    2026-05-04 04:12:46 - [INFO] IMPORTANT: Protegrity UDT installation must be handled manually. Refer to product documentation.
    2026-05-04 04:12:46 - [INFO] IMPORTANT: Protegrity Decimal UDF objects installation must be handled manually. Refer to product documentation.
    

Last modified : May 08, 2026