Tuesday 12 February 2013

23. Teradata Admin tools

Administrative Tools

Teradata Manager
Teradata Manager is a production and performance monitoring system
that simplifies the tasks of monitoring, controlling, and administering one
or more Teradata Databases.
With Teradata Manager you can use a variety of specially designed tools
and applications to gather, manipulate, and analyze information about
each Teradata system you need to administer.
It provides performance monitoring and database utilization statistics that
are collected, analyzed, and displayed. Teradata Manager can produce
its reports either in standard report format or in graphical format. Its
structure can be customized to configure it to address a wide variety of
issues that suit the needs of individuals or groups within your organization.
Teradata Manager runs on a PC that is network-connected to the
Teradata Database platform(s). It supports Windows 98, NT, 2000, and
XP.

Teradata Dynamic Query Manager (TDQM)
TDQM allows the Database Administrator to provide operational control of
and to effectively manage and regulate access to the Teradata Database.
The database administrator can use the following capabilities of TDQM to
manage work submitted to the database in order to maximize system
resource utilization:

·
Query Management

·
Scheduled Requests

With Query Management, database query requests are intercepted within
the Teradata database, their components are compared against criteria
that are defined by the administrator, and those requests that fail to meet
the criteria are rejected.

With Scheduled Requests, MS Windows clients can submit SQL requests
to be executed off-line at scheduled off-peak times.

No comments:

Post a Comment