-bash: dbscontrol: command not found in Teradata

Problem:

# dbscontrol

-bash: dbscontrol: command not found

Cause:

/usr/tdbms/bin path is missing in environment variable PATH

You case check it by following command. If it exists it will show you the output like below:

# env|grep PATH|grep /usr/tdbms/bin

PATH=/opt/teradata/client/16.20/bin:/opt/teradata/crash/bin:/sbin:/usr/sbin:/usr/local/sbin:/root/bin:/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/opt/teradata/bynet/bin:/usr/openv/netbackup/bin:/usr/openv/netbackup/bin/admincmd:/usr/lib/mit/bin:/usr/lib/mit/sbin:.:/opt/teradata/sm3g/bin:/opt/teradata/disk-migration/bin:/opt/teradata/dswap/sbin:/usr/tdbms/bin:/opt/teradata/gsctools/bin:/opt/teradata/osutils/bin:/usr/pde/bin:/opt/teradata/vmf/bin:/opt/teradata/bin

Solution:

# export PATH=$PATH:/usr/tdbms/bin

# dbscontrol

_______

| | |

| ___ __ ____ | ____ __|__ ____

| / |/ \ ____| ____| ____| | ____|

| --- | / | / | / | | / |

| \___ | \____| \____| \____| |__ \____|

Release 15.10.00.06 Version 15.10.00.07

DBSControl Utility (Dec 99)

The current DBS Control GDO has been read.

Enter a command, HELP, or QUIT:

You can permanently add the path in environment variable, so you don’t need to set the path every time.