Linux-UNIX: Teradata-specific guardctl parameters
Use these guardctl parameters when configuring A-TAP for a Teradata database.
Examples of commands
Store A-TAP configuration:
/usr/local/guardium/guard_stap/guardctl --dbinstance=teradata --tdc_gtwgateway=/usr/tgtw/bin/gtwgateway --db-type=teradata --db-home=/opt/teradata/tdat/pde/15h.00.00.07 --dbuser=teradata store-conf
Activate A-TAP:
/usr/local/guardium/guard_stap/guardctl –db instance=teradata activate
Start Teradata
instance:
# /etc/init.d/tpa start Teradata Database Initiator service is starting... Teradata Database Initiator service started successfully. # /etc/init.d/tgtw start tgtw Startup complete
Teradata required parameters
Note: Hyphen and underscore are interchangeable in the guardctl parameters.
| Required Parameter | Value | How to determine |
|---|---|---|
| db_instance | typically teradata | Teradata Server instance name |
| db_home |
Points to where the DB version is installed, one of:
|
Determine the path to pdemain. Typically, the path is: /usr/pde/bin/pdemain. # ls -l /proc/4608/exe lrwxrwxrwx 1 root tdtrusted 0 2015-01-03 01:20 /proc/4608root 20620 20063 0 12:40 pts/0 00:00:00 grep pdemain/exe -> /opt/teradata/tdat/pde/15h.00.00.07/bin/pdemain Check the inodes for this file and /usr/pde/bin/pdemain to find out if they
are the same:
# ls -li /opt/teradata/tdat/pde/15h.00.00.07/bin/pdemain 1638875 -r-xr-xr-x 1 teradata tdtrusted 1294666 2014-01-22 01:40 # ls -li /usr/pde/bin/pdemain 1638875 -r-xr-xr-x 1 teradata tdtrusted 1294666 2014-01-22 01:40 Since the inodes are the same and the default value for --dbhome=/usr/pde,
the parameter in this case does not need to be set. Otherwise, it can be set one of :
|
| db_type | teradata | |
| db_user | teradata |
Determine the user running gtwgateway and path, for
example:
# ps -ef | grep gtwgateway teradata 5000 4608 0 Jan03 ? 00:00:05 /usr/tgtw/bin/gtwgateway gtwgateway runs as user teradata. |
| tdc_gtwgateway | /usr/tgtw/bin/gtwgateway |
Default path to gtwgateway is /usr/tgtw/bin/gtwgateway, otherwise the tdc_gtwgateway parameter should be configured: --tdc_gtwgateway=/usr/tgtw/bin/gtwgateway |
Teradata optional parameters
| Optional Parameter | Value | How to determine | When is it required |
|---|---|---|---|
| db_base | Home directory of db_user | DB instance user home directory. Value for db_base must match the correct path DB instance user home directory. It cannot be ~DB_USER. | Where db_base is not same as db_home |
| db_bits | 32 or 64 | DB instance architecture (32 for 32-bit, 64 for 64-bit) |