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 .. 72 73 74 75 76 77 < 78 > 79 80 81 82 83 84 .. 218 >> Next


The rules and facilities for changing the performance group and/or account of the requests of an active session are as follows:

5 - 40 Teradata RDBMS Database Administration

Chapter 5: Setting Up Users, Profiles, Accounts and Accounting

System Accounting Functions

You can change .

At this level . With this tool .
Session Teradata SQL statement
Request
Session Static:
Teradata SQL
Dynamic:
Performance
Monitor program
(Teradata Manager
or Windows 2000
Start menu)
PM/API
Caution: PM/API
keeps group names in
volatile memory, not in
DBC.SessTontbl, so a
restart could void a SET
SESSION ACCOUNT
request. To be sure your
change completes, use
SET CRASH to specify
NOWAIT_TELL, or
verify the result.
Request PM/API

Using .

your own account or priority, if the account has been defined for you, and the priority does not exceed the level defined in your latest CREATE or MODIFY USER or PROFILE definition. (For example, if you are defined as M, you can lower the job to L, then raise it to M, but you cannot raise it to H.)

Static:

CREATE/MODIFY USER CREATE/MODIFY PROFILE Dynamic (interactive or embedded): SET SESSION ACCOUNT = 'priority/ account' FOR SESSION sessionID

Affects the remainder of your session until you submit another change. SET SESSION ACCOUNT = 'priority/ account' FOR REQUEST requestID

Affects only the subsequent request.

another user's account, if you have at least these administrator privileges:

CREATE USER

ABORTSESSION

Static:

MODIFY USER

Dynamic:

"Modify a user account/priority string" operation

Note: This operation lets you change to any level, regardless of profile definitions.

SET SESSION ACCOUNT sessionID [hostID] 'priority/account' [Y/N]

where Y or N defines how you want the change to be applied, as follows:

IF you specify . THEN the change .
Y or y applies to all current and future requests of this session. If no steps are executing, affects the next request and DBC.SessionInfo shows the new priority and/or account for this session ID.
NULL or blank, or N or n applies only to the current request for the specified session. If no steps are executing, the next request for the specified session has the old account/priority.

SET SESSION ACCOUNT requestID sessionID [hostID] 'priority/account' [Y/N]

5 - 40

Teradata RDBMS Database Administration Chapter 5: Setting Up Users, Profiles, Accounts and Accounting

System Accounting Functions

Nicing (Lowering the Priority of) a Query

Typically, you nice a query to lower its priority (and thus be nice to other users).

For instance, you can nice a long-running job to a lower priority to free more

resources for business-critical jobs.

Self-nicing refers to lowering the priority of your own request or session. To self-nice, you can lower the performance group of the next query you run, or all your queries for the remainder of the session. You can specify any level that does not exceed your user or profile definitions (or the default of M if none is specified). For example, if you are running under M, you can lower the job to L, then raise it again to M, but you cannot raise it to H.

Asynchronous nicing refers to a user with administrative privileges (at least | CREATE USER, CREATE PROFILE, and SESSION ABORT) manipulating

the priority of another user. Using the PM/API and Teradata Manager tools, you can change the priority of any session or query to any higher or lower level, including R, regardless of user or profile definitions.

Using the Priority Scheduler

The Priority Scheduler is an important resource management tool. To learn

more about it:

IF you want to . THEN use . For further information, see .
implement Priority Scheduling an administrative overview of Priority Scheduler capabilities and tools. "Managing Resources with Priority Scheduler" on page 15-9 Priority Scheduler" in Teradata RDBMS Utilities
establish or modify Resource Partitions, Performance Groups, Performance Periods, and other scheduler parameters schmon command-line utility xschmon utility (UNIX) Priority Scheduler Administrator tool in Teradata Manager Teradata RDBMS Utilities Teradata Manager User Guide Teradata Manager online help for Priority Scheduler Administrator
nice your next query Teradata SQL SET SESSION ACCOUNT ... FOR REQUEST PM/API SET SESSION ACCOUNT "Changing the Performance Group of a Running Job" on page 5-23 "Changing the Priority of a Current Account" in Teradata RDBMS Performance Optimization "SET SESSION" in Teradata RDBMS SQL Reference, Volume 4 Teradata Preprocessor2 Programmer Guide "SET SESSION ACCOUNT Request" in Teradata PM/API Reference

5 - 40 Teradata RDBMS Database Administration

Chapter 5: Setting Up Users, Profiles, Accounts and Accounting

System Accounting Functions

IF you want to . THEN use . For further information, see .
nice all your queries for the remainder of the current session Teradata SQL SET SESSION ACCOUNT ... FOR SESSION PM/API SET SESSION ACCOUNT "SET SESSION ACCOUNT Request" in Teradata Performance Monitor API Reference Teradata Manager User Guide Teradata Manager online help for Performance Monitor
Previous << 1 .. 72 73 74 75 76 77 < 78 > 79 80 81 82 83 84 .. 218 >> Next