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 |
What are the frequently used data types in teradata?
During the Display time, how is the sequence generated by Teradata?
Hash collision?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Difference between multiload and tpump?
What is the difference between teradata and oracle?
which join mostly use in realtime?
i have a table like sales....the field are Prodid Jan(jam month sales)Feb March apr may jun july 1 20 76 50 74 94 93 83 2 30 94 40 94 93 93 02 3 40 90 30 49 94 92 56 4 70 20 30 93 46 35 78 5 23 40 40 39 84 46 57 6 85 30 55 93 46 46 46 7 84 20 65 83 56 57 57 8 10 93 40 93 68 57 36 9 57 30 30 83 67 57 79 10 38 83 40 83 55 68 47 11 35 39 90 94 57 78 47 12 83 89 50 93 79 69 69 i wat ti find the max sales of every product which i want to load into target table
What is the use of having index's on table?
What are tpump utility limitations?
What is the purpose of joins in teradata?
how to load or extract the error table data ?