Day-to-Day DBA Task

Database
Enthusiast

Day-to-Day DBA Task

Can anyone help me to specify the day-to-day DBA task.

many thanks if you help me.

Thanks a Lot
5 REPLIES
Teradata Employee

Re: Day-to-Day DBA Task

Hi,

Though unlike other RDBMSs you won't find many of them .... but some can be space management across databases/users, DBQL tables periodic truncation (if enabled offcourse), refreshing statistics, etc.

Regards,

MAC
Enthusiast

Re: Day-to-Day DBA Task

tengkyu bro ,, nice reply
Teradata Employee

Re: Day-to-Day DBA Task

How's that different for any other RDBMS?
Enthusiast

Re: Day-to-Day DBA Task

Alex those tasks are common across database platforms. However, Teradata DBA's generally do not have to concern themselves with operating system level tasks, file segments, index (de)fragmentation, and file system administration. Some of these tasks are the result of Teradata not currently running on commodity hardware. Should Teradata become more prevalent in SMP environments running as a virtual appliance on VMWare some of these things may become more important and require additional DBAs or a broaden technical background to support such systems.
Enthusiast

Re: Day-to-Day DBA Task

Please see the below link for a concise list of DBA functions in Teradata:

http://teradatatricks.com/interview-tips/what-are-the-functions-of-a-teradata-dba/