Teradata Administration
Pin It

Teradata Administration:

Overview:

Teradata Teradata Administration
teradata administration

Concepts:

Teradata DBA (25HOURS)

Module 1: (TERADATA Architecture)

Ø Parsing Engine(PE)

Ø Request and Response Parcel

Ø Access Module Processors (AMPs)

Ø Bynet

Ø Data access Handling

Ø TD Config Utilities

Ø Config and Reconfig

Module 2: (TERADATA Database Space)

Ø Permanent Space

Ø Spool Space

Ø Temp Space

Ø Indexes

Module 3: (DBC Dictionary Tables)

Ø Data dictionary

Ø Parsing Engine

Ø System Views

Ø Database Views

Ø DBC Users View

Ø Indices View

Ø All Temp Tables View

Ø Using DBC AMP Usage

Ø Using DBC Table Size

Ø Logon and Logoff Tracking.

Module4: (Access Rights, Roles, Profiles)

Ø Access rights (Auto,implicit,Explicit Rights)

Ø Roles and Profiles

Ø Creating Roles and Profiles

Ø DBC.RoleInfo and DBC.ProfileInfo

Module 5: (Query analysis and Tools)

Ø Database Query Log (DBQL)

Ø DBQL Tables and Views

Ø Access Logging

Module 6: (System Access Control Levels)

Ø TD Password Encryption

Ø Password Security Features

Ø Host Logon Processing

Ø GRANT/REVOKE LOGON

Ø Session Related Views

Ø DBC.sessionInfo Info View

Ø Data Access Info Views

Ø Access LogRules Views

Ø Access Log Views

Module 7: (TD Manager)

Ø TD Manager Apps

Ø TD Dashboard

Ø TD Manager Service

Ø Starting TD Manager

Module 8: (Monitoring tools)

Ø Performance Monitor

Ø PMON Main window

Ø PMON sessions Screen

Ø TD Administrator

Ø Locking Logger

Module 9: (TD Remote Console Utilities)

Ø Starting DB Window

Ø SHOWLOCKS

Ø SHOWSPACE

Ø SHOWBLOCKS

Ø PACKDISK

Ø SCANDISK

Module 10: (Archiving Data)

Ø Archive and Recovery Statements

Ø Recovery vs. FastLoad

Ø Invoking Archive

Ø Restart Log

Ø Archive

Ø Database DBC Archive

Ø Indexes option

Ø Database DBC Archive

Ø Archive and Recovery (ARC) Examples

Module 11 (Restoring data)

Ø Restore

Ø COPY

Ø Copying Tables

Ø BUILD