Books
in black and white
Main menu
Share a book About us Home
Books
Biology Business Chemistry Computers Culture Economics Fiction Games Guide History Management Mathematical Medicine Mental Fitnes Physics Psychology Scince Sport Technics
Ads

Teradata RDBMS Database Administration - NCR

NCR Teradata RDBMS Database Administration - NCR , 2004. - 616 p.
Download (direct link): teradatadatabaseadmin2004.pdf
Previous << 1 .. 115 116 117 118 119 120 < 121 > 122 123 124 125 126 127 .. 218 >> Next


Caution: You can only restore a DBC archive to an initialized (empty) Teradata RDBMS.

Statements that change the size and/or content of your Data Dictionary include:

ALTER

BEGIN/END LOGGING BEGIN/END QUERY LOGGING COLLECT STATISTICS (SQL form) CREATE DELETE DROP GIVE

GRANT/REVOKE privilege GRANT/REVOKE LOGON MODIFY RENAME REPLACE

Teradata RDBMS Database Administration

8 - 19 Chapter 8: Archiving, Restoring and Recovering Data

Archive Routines (Recommended)

The system tables pre-defined for a DBC archive include:

Data Dictionary (System) Table Contents
DBC.AccessRights Records all granted privileges.
DBC.AccLogRuleTbl Logs access logging rules generated by executing BEGIN/END LOGGING statements.
DBC.Accounts Records all authorized account numbers.
DBC.CollationTbl Defines MULTINATIONAL collation.
DBC.DBase Records each database and user.
DBC.Hosts Records information about user-defined character sets assigned as defaults to clients (hosts) or host groups.
DBC.IdCol Records information about all identity columns and their parameter settings. (A SELECT on DBC.IdCol is a restricted right. DBC will have to explicitly grant this right to other users if they require it.)
DBC.LogonRuleTbl Logs information about logon rules generated by a GRANT LOGON statement.
DBCMedia Records all removable devices used in archive activities.
DBC.Next Generates table and database identifiers (internal table).
DBC.Owners Records all databases owned by another.
DBC.Parents Records all parent/child relationships between databases.
DBC.Profiles Records all profiles.
DBC.RCEvent Records all archive and recovery activities.
DBC.RCConfiguration Records the configuration for RCEvent rows.
DBC.Roles Records all roles.
DBC.RoleGrants Records the users and/ or other roles to which each role has been granted.
DBC.Translation Holds hexadecimal codes that form translation tables for non-English character sets.

8 - 24

Teradata RDBMS Database Administration 8 - 19 Chapter 8: Archiving, Restoring and Recovering Data

Restore-Related Statements

Restart Log

The size of DBCLOG can grow with the number of objects you specify in the statement and is indirectly involved with the ALL keyword for descendent databases.

Archive/recovery's first action is to write the script to restart the log file. The log file contains:

Current statement

Object list

Checkpoint positioning information

Checkpoint configuration information

Teradata RDBMS Database Administration

8 - 25 Chapter 8: Archiving, Restoring and Recovering Data

Archive Routines (Recommended)

Archive Routines (Recommended)

It is recommended that you perform the following on a daily and weekly basis.

Daily Archive Routine

It is recommended that you perform the following procedure on a daily basis:

Step Action
1 Submit a CHECKPOINT WITH SAVE statement for each journal table. This appends any changes stored in the active journal subtable to the saved journal table, and initiates a new active journal subtable.
2 Archive each current journal.
3 Delete the saved journal subtable from the saved journal.

Weekly Archive Routine

It is recommended that you perform submit an all-AMPs DUMP of all data tables on a weekly basis. Note that this statement is set up so that only table is dumped each day; by the end of the week, each table is dumped once.

8 - 26

Teradata RDBMS Database Administration 8 - 19 Chapter 8: Archiving, Restoring and Recovering Data

Restore-Related Statements

Restore Overview

A restore operation transfers database information from archive files backed up on portable storage media to all AMPs, clusters of AMPs, or specified AMPs.

You can restore archived data tables to the RDBMS if the data dictionary contains a definition of the entity you want to restore.

For example, if the entity is a database, that database must be defined in the dictionary. Or, if the entity is a table, that table must be defined in the dictionary. You cannot restore entities not defined in the data dictionary.

A dictionary table archive contains all table, view, and macro definitions in the database. A restore of a dictionary archive restores the definitions of all data tables, views and macros. However, it does not restore any data.

Teradata RDBMS Database Administration

8 - 25 Chapter 8: Archiving, Restoring and Recovering Data

Restore-Related Statements

Restore-Related Statements

The ARC utility provides several recovery control statements you use during restore-related operations. Each command is described in the table below.

You can invoke the ARC utility from a channel-attached MVS or VM client, a Windows 2000 client, or the main NetVault GUI (usually on the MASTER Teradata plugin machine).

Restore-Related Statement Function
ANALYZE Reads an archive tape to display information about its contents.
BUILD Builds indexes for fallback and non-fallback tables. It also builds fallback rows for fallback tables, and can build journal tables by sorting the change images. (This statement causes rehashing of V1 data restored to a V2 system.)
Previous << 1 .. 115 116 117 118 119 120 < 121 > 122 123 124 125 126 127 .. 218 >> Next