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 .. 177 178 179 180 181 182 < 183 > 184 185 186 187 188 189 .. 218 >> Next


Add new storage hardware (disk or disk array) When replacing old nodes, MOVE enables you to:

Logically move the data rows from an AMP or group of AMPs (with contiguous numbers) on the old node, to an AMP or group of AMPs with higher contiguous numbers on the new node.

Logically move a PE or group of PEs (with contiguous numbers) on the old node, to a PE or group of PEs with lower contiguous numbers on the new node (as long as any channel-connect restrictions are not violated).

Teradata RDBMS Database Administration

A - 13 Appendix A: Teradata RDBMS Configuration, Global Defaults, and Client Connections

Viewing or Modifying the Teradata RDBMS Configuration

When adding new storage hardware (disk array), you can move the AMPs and data rows to:

New storage connected to the same node

New storage connected to a different node

Typical Reconfiguration Procedures

IF you want to

THEN first

For instructions, see

view the current and any newly defined logical and physical configuration

use the:

LIST command of the Configuration utility, on any Teradata RDBMS

HARDWARE command of the:

ctl utility on Windows 2000

xctl utility on UNIX MP-RAS

(to display the PDE hardware configuration)

Teradata Manager configuration displays

DBS console window configuration displays

Teradata RDBMS Utilities

Teradata Manager User Guide

Teradata RDBMS Database Window

obtain an estimate of the elapsed time needed for reconfiguration

use the Reconfig Estimator utility.

Basing calculations upon the number and size of the data tables on your current system and your response to prompts about planned changes, the Estimator calculates the time needed for:

Reconfig redistribution phase

Reconfig deletion phase

change the TPA configuration in any way

the system must be configured and currently in the stopped state:

Step

Action

Run the Vproc Manager utility to:

Disable logons

Check the status of each AMP and PE

Prepare the PDE and hardware by making sure the PDE and all nodes are in the NULL state.

To verify the PDE state, enter: pdestate

The correct stopped status display is:

On Windows 2000:

PDE state is DOWN/HARDSTOP

On UNIX:

Parallel Database Extension state is NULL/STOPPED

Contact the TSC if you have questions on estimated time or other parts of this procedure.

To prepare the hardware, Teradata RDBMS

Installation/Upgrade/ Migration.

In Teradata RDBMS Utilities:

- "Reconfig Estimator"

- "Vproc Manager"

1

A - 16

Teradata RDBMS Database Administration A - 13 Appendix A: Teradata RDBMS Configuration, Global Defaults, and Client Connections

Viewing or Modifying the Teradata RDBMS Configuration

IF you want to .

THEN first .

For instructions, see .

add, replace, or delete a node and/or disk storage units

stop the system and all AMPs, PEs, logons, PDE, and nodes. When everything is quiet, perform the following:

Step

Action

Physically add the new node and/or storage to the hardware platform.

Run one of the following to create vprocs on the new node and/or vdisks on the new storage:

PUT, using the CONFIGURE TERADATA operation

Pdeconfig utility

Run the Configuration utility. The operation depends on the function being performed.

Note: It is possible to combine the ADD and MOVE operations to perform both at the same time.

IF you are ... THEN use the .
adding (not replacing) a new node or disk ADD AMP and ADD PE commands to add the item created in Step 2 with pdeconfig.
replacing a node or disk MOVE or ADD/MOVE PE and/or AMP commands to swap identifiers between the old and new PEs and/or old and new AMPs.

Immediately before performing a reconfiguration, run the CheckTable utility at LEVEL PENDINGOP to make sure that no tables are in the pending xxx state.

Step Action
a Run the CheckTable utility for all tables using the following options: LEVEL PENDING SKIPLOCKS PRIORITY=H; Caution: Make sure logons are disabled. A hang will occur if you run IN PARALLEL with PENDINGOP while users are logged on.
b Visually audit the CheckTable output to identify any skipped tables.
c Run CheckTable again for each table that was skipped because of lock contention.

first, contact the TSC;

then:

Teradata RDBMS Utilities for:

- "Configuration Utility"

- "CheckTable Utility"

- "Reconfiguration Utility"

For pdeconfig command-line operation (from a PDN console window only) on UNIX, see Teradata RDBMS Utilities

For pdeconfig GUI operation:

- Parallel Upgrade Tool (PUT) for MP/RAS UNIX

- Parallel Upgrade Tool (PUT) for Windows 2000 User Guide

1

2

3

4

Teradata RDBMS Database Administration

A - 13 Appendix A: Teradata RDBMS Configuration, Global Defaults, and Client Connections

Viewing or Modifying the Teradata RDBMS Configuration

IF you want to

THEN first

For instructions, see

add, replace, or delete a node and/or disk storage units (continued)
Previous << 1 .. 177 178 179 180 181 182 < 183 > 184 185 186 187 188 189 .. 218 >> Next