Give some points about Teradata Viewpoint ?
Answers were Sorted based on User's Feedback
Answer / tdguy
TD viewpoint is a framework where applications are
displayed. This web based framework can be used to manage
and monitor the teradata systems using a browser.
| Is This Answer Correct ? | 18 Yes | 1 No |
Answer / uli
ViewPoint is a separate Server, which collects usage/performance data and presents it via a collection of apps for a general overview, down to a single process.
QueryMonitor, one application in ViewPoint, shows System resource usage like CPU/Spool space/.. -usage, Blocks and blocking process, explain plan ...
QueryMonitor has Rewind capability, to show not only current processes, but is able to go back in time for whatever period the server is configured to hold the data.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / reddy
Teradata viewpoint shows the session ID, user ID,runtime,
expected row count,spool space occupied, approximate
completion time of the query.
Viewpoint shows the details of active sessions only.
| Is This Answer Correct ? | 5 Yes | 8 No |
IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.
What is meant by MATCHTAG in multiload utility?
What are the available join types in teradata?
Explain the meaning of Amp?
How a Referential integrity is handled in Teradata?
How do you do backup and recovery in teradata?
IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CONSTRAINS.IF YES HOW?PLZ GIVE ME A EXAMPLE.
Highlight the advantages of PPI(Partition Primary Index).
what is single value and Multivalue ?
Why Fload doesn’t support multiset table?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What is difference between user and database in teradata?