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 .. 122 123 124 125 126 127 < 128 > 129 130 131 132 133 134 .. 218 >> Next


8 - 10

Teradata RDBMS Database Administration Events View

Chapter 8: Archiving, Restoring and Recovering Data

Arc Recovery versus FastLoad

This query returns event rows similar to the following:

Object Source Event

Payroll Prod. DEPARTMENT PAYROLL_ _TEST. . department 00014
Payroll Prod. DEPT PAYROLL_ _TEST. dept 00014
Payroll Prod. EMP PAYROLL_ _TEST. . emp 00014
Payroll Prod. EMPLOYEE PAYROLL_ _TEST. . employee 00014
Payroll Prod. NEWHIRE PAYROLL_ _TEST. .newhire 00014

The Events view tracks ARC activity. ARC inserts a new row in the Events system table each time another ARC activity begins. The Events view returns a row for each activity tracked.

The event depends on the type of object on which the activity was performed, as follows:

A row for this event type ... Is created for each .
Checkpoint Event Row journal checkpointed
Delete Event Row journal deleted
Dump Event Row database or table dumped
Restore Event Row database or table restored
Rollback Event Row database or table rolled back
Rollforward Event Row database or table rolled forward

The SQL statement in the following example requests a list of all ARC activity that took place March 28th.

SELECT EventNum ,UserName (CHAR (12)) ,EventType (CHAR (12)) ,DatabaseName (CHAR (15)) FROM DBC.Events WHERE CreateDate=9 9 03 2 8 ORDER BY EventNum ;

EventNum UserName EventType DatabaseName

180 BRM Dump Payroll_Test

181 RPK Restore Personnel Test

8 - 10 Teradata RDBMS Database Administration

Chapter 8: Archiving, Restoring and Recovering Data

Arc Recovery versus FastLoad

Events_Configuration[x] View

The Events_Configuration view contains rows for each archive activity that does not affect all AMPs in the database configuration. If the ARC command specifies all AMPs and there are one or more vprocs offline, a row is inserted in the system table for each off-line vproc. If the statement is for specific AMPs, a row is inserted for each specified and online vproc.

The following example submits an SQL statement to find out which user did not release the utility locks on processor 2. Query results show three different users: AMT, ALK, and JLR.

Who left the utility locks on processor 2?

SELECT CreateTime ,EventNum

,EventType (CHAR (12)) ,UserName (CHAR (12)) ,vproc

FROM DBC.Events_Configuration WHERE vproc= '2' ORDER BY 2 ;

CreateTime EventNum EventType UserName Vproc

14:06:22 1,153 Dump AMT 2

16:06:39 1,159 Dump ALK 2

18:12:09 1,164 Restore JLR 2

Events_Media View

The Events_Media view provides information about ARC activities that used removable storage media. This information includes the volume serial numbers assigned to portable devices.

The following example requests the volume serial number of a restore tape. The query results show two restore operations, each with their own serial number and dataset name.

SELECT EventNum ,EventType (CHAR (12)) ,UserName (CHAR (12)) ,VolSerialID ,DataSetName (CHAR (12)) FROM DBC.Events_Media ORDER BY EventNum ;

EventNum EventType UserName VolSerialID DataSetName

179 Restore PJ MPC001 LDR.DMP1.JNL

18 0 Restore PJ MPC0 02 RAN.DMP2.JNL

8 - 10

Teradata RDBMS Database Administration Chapter 9:

Stopping and Restarting the System

This chapter provides information on stopping the TPA and automatic and forced Teradata RDBMS restarts.

Teradata RDBMS Database Administration

10 - 1 Chapter 9: Stopping and Restarting the System

Restarts of the Teradata RDBMS

Stopping the Teradata RDBMS

To manually stop the Teradata RDBMS, perform the following steps:

Step Action
1 Log onto the system with administrator privileges.
2 Warn any active users that the Teradata RDBMS is going to shut down. Wait until all active sessions have logged off and the system is quiescent.
3 Open a Teradata Command Prompt window.
4 Enter the command: tpareset -x comment You must enter a comment text string. This string appears in the Event Log. For example: tpareset -x stopping teradata for upgrade
5 When the program prompts you: Start reset? (for Windows 2000) or: Do you wish to continue? (for UNIX) Enter Y. The system stops the Teradata RDBMS in an orderly sequence.
6 To verify that the Teradata RDBMS has stopped, enter: pdestate On Windows 2000, the correct stopped status response is: PDE state is DOWN/HARDSTOP On UNIX, the correct stopped status response is: Parallel Database Extension state is NULL/STOPPED

9 - 2

Teradata RDBMS Database Administration Chapter 9: Stopping and Restarting the System

Restarts of the Teradata RDBMS

Restarts of the Teradata RDBMS

When a restart occurs, the Teradata RDBMS performs the following:

Generates an information message to each active system console.

Terminates all tasks and returns an informative message to the session

Frees all associated resources

Initiates startup processing

Performs transaction recovery processing

Note: If a restart occurs when Reconfiguration processing is in the middle of the Hash Map calculation phase (a rare occurrence), the operation might not be able to restart because of unexpected tables on the new AMPs. For instructions on how to recover, see "Reconfiguration Utility" in Teradata RDBMS Utilities.
Previous << 1 .. 122 123 124 125 126 127 < 128 > 129 130 131 132 133 134 .. 218 >> Next