To monitor an Database Engine 20, Teradata Viewpoint requires a Teradata system user account with specific permissions. You can use SQL commands to create a user account and grant permissions, or the user can be an existing user with specific permission.
The Teradata Viewpoint user account must have sufficient spool space to allow Teradata Viewpoint to issue monitoring queries. Also, permanent (perm) space is required by the Lock Info collector that is used by the Lock Viewer portlet.
- Determine the amount of perm space and spool space to allocate to the Teradata user.
These values vary based on several factors, including the size of the Database Engine 20, the level of activity on the Database Engine 20, and the amount of data retained in the data dictionary tables queried by Teradata Viewpoint. For Teradata systems of 50 nodes or fewer, the suggested allocations are 2 GB of perm space and 500 GB of spool space. For Teradata systems larger than 50 nodes, additional perm and spool space might be required.
- Type the following command, where perm space and spool space are the perm space and spool space to allocate to the user:create user username as perm=perm space, spool=spool space, password=user password;
For example, to create a user with default settings, run this command:
CREATE USER viewpoint AS PERM=2E6, spool=200E6, password = viewpoint
- If the console user does not exist on the target Database Engine 20, run the following command to create the user:create user console as perm=50000, spool=50000, account='$H-remote-console-user', password=console, fallback;