The database user is not shown correctly in Guardium reports when you monitor Teradata

If Guardium reports do not show the database user correctly when you monitor Teradata, configure the Teradata Database.

Symptoms

When you view records from the monitored Teradata Database in Guardium reports, the database user name field does not show up as expected. The user name is truncated or missing.

Causes

The Teradata Database is not enabled to return the full user name.

Environment

Any Guardium collector that captures data from the Teradata database is affected.

Resolving the problem

Use the following command to enable the Teradata Database to return the full user name, in the correct character set, to the monitoring application. Other applications are not affected.

gtwcontrol -u yes -d

The -d command displays the updated GDO settings.

Note: This setup returns the user name in unencrypted form. If encryption is enabled, the system returns an error message.