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


Transient Journal (TJ) and DBC Space.......................................................................7-30

Determining Maximum TJ Size................................................................................7-30

AMP Clustering and Fallback......................................................................................7-32

Failure Handling.........................................................................................................7-33

Activating Fallback Protection..................................................................................7-34

Down-AMP Recovery Journal..................................................................................7-34

Determining Cluster Size..........................................................................................7-35

Changing Cluster Assignments................................................................................7-35

Spanning Clusters Across Cliques...........................................................................7-36

Spanning Clusters Across Arrays............................................................................7-37

Archiving by Cluster..................................................................................................7-37

Permanent Journal (PJ) Protection..............................................................................7-38

PJ Options....................................................................................................................7-38

Journaling of Fallback Tables....................................................................................7-39

xxviii

Teradata RDBMS Database Administration Contents

Fallback Versus PJ......................................................................................................7-39

Space Allocation.........................................................................................................7-39

Deleting a PJ................................................................................................................7-40

Guidelines for Choosing Data Protection..................................................................7-41

Crashdumps and Fallback Protection........................................................................7-42

Accessing Dump Data...............................................................................................7-42

Dump Handling With No Fallback.........................................................................7-42

Chapter 8:

Archiving, Restoring and Recovering Data

Archiving Overview.......................................................................................................8-2

Archive/Recovery (ARC) Utility..................................................................................8-3

Common Uses for ARC...............................................................................................8-3

ARC-Specific Terminology.........................................................................................8-3

How ARC Works..........................................................................................................8-4

Invoking ARC...............................................................................................................8-4

Archiving with NetVault.............................................................................................8-4

Common NetVault Configurations...........................................................................8-6

Phase Processing..............................................................................................................8-7

Phase 1 - Dictionary Phase..........................................................................................8-7

Phase 2 - Data Phase.....................................................................................................8-7

Using ARC With Modified PIs or Partitioning...........................................................8-8

ARC Recovery versus FastLoad....................................................................................8-9

FastLoad Steps to Restore a Table..............................................................................8-9

Recovery Steps............................................................................................................8-10

Scripts..............................................................................................................................8-11

Script Management....................................................................................................8-11

Teradata Logon...........................................................................................................8-11

Creating a Script.........................................................................................................8-11
Previous << 1 .. 6 7 8 9 10 11 < 12 > 13 14 15 16 17 18 .. 218 >> Next