Changing DBC and DATAMOVER Passwords on the Data Mover Server - Teradata Data Mover

Teradata Data Mover Installation, Configuration, and Upgrade Guide for Customers

Product
Teradata Data Mover
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
wcu1482331938115.ditamap
dita:ditavalPath
4102_ICUCustomer_dm_1610.ditaval
dita:id
B035-4102
Product Category
Analytical Ecosystem
Data Mover versions 15.11.04 and later include the script changepassword.sh that allows the root user to change the DBC and DATAMOVER passwords from the Data Mover server. When executed, the script logs into the internal TD repository and changes the repository passwords. The script is part of the tdm-linux bundle and its location is determined by where the tdm-linux bundle is located. For example:

/var/opt/teradata/packages/DataMover/16.10.00.00/changepassword.sh

If you previously used dm.job.production.password in the daemon.properties file to change the DATAMOVER password, remove it from daemon.properties before running the changepassword.sh script.
We recommend that you run the script before installing or upgrading Data Mover. If you run it after Data Mover has been installed or upgraded, you must restart the daemon to ensure Data Mover runs properly.
  1. Do one of the following:
    Script Option Description
    Interactive
    1. Run the script without arguments:

      # changepassword.sh

    2. When prompted, enter the old and new passwords.
    Non-Interactive
    1. Run the script with the arguments -o, -p, -m, and -d. For example:

      # changepassword.sh -o old dbc password -p new dbc password -m old datamover password -d new datamover password, where:

      • old dbc password is the existing password for the DBC user
      • new dbc password is the new password for the DBC user
      • old datamover password is the existing password for the DATAMOVER user
      • new datamover password is the new password for the DATAMOVER user
  2. If you ran the changepassword.sh script after Data Mover was installed or upgraded, restart the daemon as follows:
    1. # /etc/init.d/dmdaemon stop
    2. # /etc/init.d/dmdaemon start
  3. Verify the Data Mover components are ready to use by issuing the following commands:
    • datamove list_jobs
    • datamove list_agents

Script Example

location:/var/opt/teradata/packages/DataMover160000 # ./changepassword.sh
Do you want to change the DBC password of the Teradata internal repository?(yes/no/y/n)?
yes
----------------------------------------------------------------
            Change DBC Default Password
----------------------------------------------------------------
Old Password:
Retype Old Password:
New Password:
Retype New Password:
Do you want to change the DATAMOVER password of the Teradata internal repository?(yes/no/y/n)?
y
----------------------------------------------------------------------
            Change DATAMOVER Default Password
----------------------------------------------------------------------
Old Password:
Retype Old Password:
New Password:
Retype New Password:
04/19/16 16:01:15 JDBC driver loaded.

04/19/16 16:01:15 Attempting to connect to Teradata via the JDBC driver...
04/19/16 16:01:16 User dbc is connected.
04/19/16 16:01:16 Connection to Teradata established.

04/19/16 16:01:16 Modify user dbc as password=*********
**********************************************************************************************
DBC default Password changed successfully
**********************************************************************************************
04/19/16 16:01:17 JDBC driver loaded.

04/19/16 16:01:17 Attempting to connect to Teradata via the JDBC driver...
04/19/16 16:01:18 User dbc is connected.
04/19/16 16:01:18 Connection to Teradata established.

04/19/16 16:01:18 Modify user datamover as password=*********
**********************************************************************************************
DATAMOVER default Password changed successfully
**********************************************************************************************
**********************************************************************************************
DBC and DATAMOVER passwords are encrypted and stored in /etc/opt/teradata/datamover/password.txt file
Granting permission to dmuser to access password.txt