Teradata tools

Query Submitting Tools

BTEQ

• Basic Teradata Query utility
• SQL front-end
  
• Report writer features
  
• Interactive and batch queries
  
• Import/Export across all platforms
  
• The default number of sessions, upon login, is 1.

Teradata Query Manager

• SQL front-end for ODBC databases
  
• Historical record of queries including:
  – Timings
  – Status
  – Row counts
  
• Random sampling feature
• Limit amount of data returned
• Import/Export between database and PC
• Export to EXCEL or ACCESS
  

Application Utilities

FastLoad

• •Data loading utility
• •Loads empty tables
• •Block transfers with multi-session parallelism MultiLoad
• •Table loading/maintaining utility
• •Runs against multiple tables
• •Block transfers with multi-session parallelism
• •Multiple input source files

FastExport

• •Data extraction utility
• •Exports tables to client files
• •Block transfers with multi-session parallelism

TPump

• •Teradata Parallel Data Pump
• •Maintains up to 60 tables at a time
• •Uses standard DML—not block transfers
• •User may adjust throttle to change apply rate
• •Same restartability, portability and scalability as MultiLoad

Administrative Tools

Teradata Manager

Database Query Manager (DBQM)

• Query workload management tool
• Runs, suspends, schedules later or rejects query based on current workload
• Restricts queries based on analysis control:
• Restricts queries based on object control:
• Logs workload performance for analysis
• Restricts based on environmental factors:
  – CPU
  – Disk utilization
  – Network activity
  – Number of users