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


Diagnosing SSO Logon Errors (Windows 2000 only).............................................12-14

Mismatch of DBS and Gateway GDOs...................................................................12-14

Non-Unique Usernames...........................................................................................12-14

Preventing Slowdown or Hang Events.....................................................................12-16

Monitoring Lock Contentions with Locking Logger...........................................12-16

Controlling Session Elements..................................................................................12-17

Ensuring Node Parallel Efficiency..........................................................................12-19

Using the Resource Check Tools.............................................................................12-21

Troubleshooting a Slow or Hung Job........................................................................12-23

Determining the Cause of a Slowdown or Hang..................................................12-23

Solving Lock, Partition Evaluation, or Resource Problems.................................12-25

Solving PPI and RI Validation Errors........................................................................12-27

Solving Bottlenecks by Expanding Your Teradata RDBMS Configuration.........12-28

Determining Resource Needs..................................................................................12-28

Adding Disk Arrays.................................................................................................12-29

Adding Vprocs...........................................................................................................12-29

Adding Memory........................................................................................................12-30

Adding Nodes............................................................................................................12-31

Reconfiguring Your Teradata RDBMS...................................................................12-31

Scaling Your Applications........................................................................................12-32

Chapter 13: Database Analysis

Target Level Emulation (TLE)......................................................................................13-3

Query Capture Facility (QCF) .....................................................................................13-4

Teradata SQL Statements for Query Analysis........................................................13-6

Teradata Index Wizard................................................................................................13-10

Teradata Visual Explain Utility..................................................................................13-12

Building Baseline Transaction Profiles......................................................................13-13

Types of Performance Metrics.................................................................................13-13

Guidelines for Profile Building................................................................................13-14

Chapter 14:

Tracking Processing Behavior with the Database Query Log (DBQL)

Introducing DBQL..........................................................................................................14-2

Populating the Log Tables..........................................................................................14-2

The BEGIN/END QUERY LOGGING Statements.................................................14-3

The Statement Options...............................................................................................14-3

The DBQL Components................................................................................................14-5

The DBQL Logging Fields and Values........................................................................14-7

xxviii Teradata RDBMS Database Administration Contents

DBQLogTbl...................................................................................................................14-7

DBQLObjTbl...............................................................................................................14-10

DBQLSQLTbl.............................................................................................................14-11

DBQLStepTbl.............................................................................................................14-11

DBQLSummaryTbl....................................................................................................14-12

Defining the Rules........................................................................................................14-15

Applying the Logged Data.......................................................................................14-15

Logging Volume per User and/or Account..........................................................14-16
Previous << 1 .. 10 11 12 13 14 15 < 16 > 17 18 19 20 21 22 .. 218 >> Next