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


Association View........................................................................................................8-44

Events View.................................................................................................................8-45

Events_Configuration[x] View.................................................................................8-46

Events_Media View....................................................................................................8-46

Chapter 9:

Stopping and Restarting the System

Stopping the Teradata RDBMS......................................................................................9-2

Restarts of the Teradata RDBMS...................................................................................9-3

Automatic Restarts.......................................................................................................9-3

Forced Restarts..............................................................................................................9-5

Restarting in UNIX.......................................................................................................9-6

Restarting in Windows 2000.......................................................................................9-7

Startup and Recovery......................................................................................................9-8

xxviii

Teradata RDBMS Database Administration Contents

Database Startup and Recovery.................................................................................9-8

Transaction Recovery...................................................................................................9-9

Using System Recovery Journals.............................................................................9-10

Performing Online and Offline Catch-up...............................................................9-10

Restarting the DB Window (UNIX Only)...............................................................9-10

Startup Event and Status Logs.................................................................................9-11

Restarting Jobs with Identity Columns...................................................................9-11

Chapter 10:

Handling Teradata Crashdumps

Dump Types...................................................................................................................10-2

System Dumps............................................................................................................10-2

PDE Crashdumps.......................................................................................................10-2

DBS Dumps.................................................................................................................10-2

PDE Crashdumps versus System Dumps..................................................................10-4

PDE Crashdumps Processes........................................................................................10-5

Finding PDE Crashdump Data...................................................................................10-6

PDE Crashdumps Location.......................................................................................10-6

Checking the Dump Device on UNIX.....................................................................10-7

Checking the Dump Directory on Windows 2000.................................................10-8

Checking DBC.Crashdumps with the SQL HELP Statement..............................10-8

Viewing PDE Crashdump Messages.......................................................................10-9

Finding Vproc to Node Mappings with csppeek..................................................10-9

About System User DBC.Crashdumps....................................................................10-11

Dump Data Access and Protection Considerations............................................10-11

Dump Data Without FALLBACK Protection.......................................................10-12

Ad-Hoc Creation with DIPCRASH.......................................................................10-12

Calculating DBC.Crashdumps Space Requirements..........................................10-13

Modifying DBC.Crashdumps Space......................................................................10-13

Administering PDE Crashdumps.............................................................................10-17

Automatic PDE Crashdumps.................................................................................10-17

Forcing a PDE Crashdump.....................................................................................10-18

Crashloop Control....................................................................................................10-19

Handling PDE Crashdumps on UNIX

MP-RAS.....................................................................................................................10-20
Previous << 1 .. 8 9 10 11 12 13 < 14 > 15 16 17 18 19 20 .. 218 >> Next