I am pleased to announce that Mr.Claybourne Barrineau who is my friend and colleague at Coca-Cola Enterprises Inc. has kindly agreed to share his Teradata knowledge in this forum.

Claybourne Barrineau (or Clay as he is known to his friends), has been working with Teradata technologies since 1998. Clay is very well known in Teradata circles. He is a member of the Teradata Product Advisory Council (PAC) which  is an advisory group that provides input to the Teradata corporation regarding the product direction for Teradata RDBMS along with related products and platforms. Look out for his contributions in the coming days.

Claybourne Barrineau works as a Senior Application DBA with Coca-Cola Enterprises, Inc., where he is responsible for architecting and maintaining a world class Teradata information warehouse.

- Ramakrishna Nemani

Diagnostic commands are undocumented features of Teradata. These commands come in handy to DBAs when dignosing performance problems. I use a couple of the Diagnostic commands regularly in troubleshooting  performance issues.

Continue reading Teradata Dignostics commands »

Teradata is a relational database management system. A Teradata system has many components (hardware and software). A Teradata system contains one or more nodes. A node is a term for a general-purpose processing unit under the control of a single operating system. The basic building block for a Teradata system, the node is where the processing occurs for the database.

A node contains a large number of hardware and software components as explained below…

Continue reading An Introduction to Teradata components »

Continue reading RMAN Disaster Recovery script (rman_dr.ksh) »

Continue reading RMAN tape backup script »

Continue reading RMAN configuration script »

Continue reading RMAN archive logs backup script »

Continue reading RMAN complete database backup script »

Continue reading SQL Tutorial for the beginners »