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 .. 11 12 13 14 15 16 < 17 > 18 19 20 21 22 23 .. 218 >> Next


Logging Overhead.....................................................................................................14-16

Examples of Logging Results...................................................................................14-17

Example of OBJECT Data for One Query..............................................................14-18

Example of STEP Data for One Query...................................................................14-18

Reviewing or Ending Current Rules.........................................................................14-19

Dynamically Enable/Disable Logging...................................................................14-19

Logging Implementation and Validation.................................................................14-21

Implementing Query Logging.................................................................................14-21

Rules Validation.........................................................................................................14-21

Logging Scenarios........................................................................................................14-23

Query Data Storage and Protection...........................................................................14-27

Protection for a Committed Row............................................................................14-27

Maintaining The Logs...............................................................................................14-28

Chapter 15:

Tools for Managing Resources

Managing I/O with Cylinder Read.............................................................................15-2

The Teradata File Segment (FSG) Functions...........................................................15-2

Memory Slots in FSG Cache.......................................................................................15-3

The Cylinder Read Process........................................................................................15-3

Changing the Cylinder Read Defaults.....................................................................15-5

Viewing the Cylinder Slot Configuration................................................................15-6

Calculating FSG Cache Size Requirements..............................................................15-7

Tracking Cylinder Read Resource Usage.................................................................15-7

Managing Resources with Priority Scheduler............................................................15-9

Implementation Utilities and Tools..........................................................................15-9

Priority Scheduler Administrator (PSA)................................................................15-11

Scheduling Workloads with Teradata Dynamic Query Manager (TDQM)........15-12

TDQM Rules...............................................................................................................15-12

Implementing TDQM...............................................................................................15-13

xxviii

Teradata RDBMS Database Administration Contents

Appendix A:

Teradata RDBMS Configuration, Global Defaults, and Client Connections

Using Data Dictionary Views and Macros.................................................................A-2

Types of System Views...............................................................................................A-2

Ad-Hoc Installation of System Views.......................................................................A-3

Viewing the Software Release and Version................................................................A-4

Reviewing or Changing Global Parameters...............................................................A-5

Viewing and Changing International Character Set Settings and Defaults..........A-7

Default Server Character Sets for User DBC...........................................................A-7

Default Server Character Set for Other Users.........................................................A-7

International Language Support Modes..................................................................A-7

Determining the Language Support Mode..............................................................A-8

Client Character Sets...................................................................................................A-9

Viewing the Status of Client Character Sets............................................................A-9

Changing Character Set Defaults............................................................................A-10

Changing Collation Defaults...................................................................................A-11

Cultural Format Defaults............................................................................................A-12

Viewing or Modifying the Teradata RDBMS Configuration.................................A-13
Previous << 1 .. 11 12 13 14 15 16 < 17 > 18 19 20 21 22 23 .. 218 >> Next