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 .. 7 8 9 10 11 12 < 13 > 14 15 16 17 18 19 .. 218 >> Next


Archiving a Script.......................................................................................................8-12

Optional Archive Parameters...................................................................................8-12

Syntax Checker...........................................................................................................8-13

Session Control..............................................................................................................8-14

LOGON/LOGOFF statements.................................................................................8-14

Multiple Sessions........................................................................................................8-14

Archive Commands......................................................................................................8-16

ARCHIVE Command ................................................................................................ 8-16

Archive Types.............................................................................................................8-16

Archive Objects...........................................................................................................8-17

Archive Levels............................................................................................................8-18

Cluster Archives.........................................................................................................8-18

Archiving with a Down AMP...................................................................................8-18

xxviii Teradata RDBMS Database Administration Contents

Archive Options.............................................................................................................8-19

Indexes Option............................................................................................................8-19

Group Read Lock Option..........................................................................................8-20

Types of Archives.......................................................................................................8-21

Archiving the Data Dictionary....................................................................................8-23

Restart Log......................................................................................................................8-25

Archive Routines (Recommended).............................................................................8-26

Daily Archive Routine...............................................................................................8-26

Weekly Archive Routine............................................................................................8-26

Restore Overview..........................................................................................................8-27

Restore-Related Statements..........................................................................................8-28

ANALYZE Statement.................................................................................................8-28

RESTORE Statement..................................................................................................8-29

COPY Statement.........................................................................................................8-31

BUILD Statement........................................................................................................8-32

Changing the State of RI Tables with REVALIDATE REFERENCES FOR........8-32

RELEASE LOCK Statement......................................................................................8-33

Restoring After a Down AMP.....................................................................................8-34

Restoring Dual Before- and After-Image Protected Tables..................................8-35

Restoring Single Before- and After-Image Protected Tables................................8-35

Recovery Overview.......................................................................................................8-37

Data Recovery Using Roll Operations.....................................................................8-37

CHECKPOINT Statement.........................................................................................8-38

ROLLBACK Statement..............................................................................................8-39

ROLLFORWARD Statement.....................................................................................8-41

ROLLFORWARD Restrictions..................................................................................8-42

DELETE JOURNAL Statement.................................................................................8-43

Recovery Control Views...............................................................................................8-44
Previous << 1 .. 7 8 9 10 11 12 < 13 > 14 15 16 17 18 19 .. 218 >> Next