To monitor a Teradata Database system, Teradata Viewpoint requires a Teradata Database 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 Teradata Database system, the level of activity on the Teradata Database system, 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 Database 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;
- If the console user does not exist on the target Teradata Database system, run the following command to create the user: create user console as perm=50000, spool=50000, account='$H-remote-console-user', password=console, fallback;