15.10 - Functionality - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K

The following table describes the interfaces of the Teradata Dynamic Workload Management that are used to return WDs, delayed query lists, summary data, and statistics; and update the components stored in the Teradata Dynamic Workload Management database.

Note: The updates in the TDWMRuleControl and TDWMSetLimits procedures must be committed before the TDWMApply procedure can be called. If the same transaction is used to call the external stored procedures that update the TDWM database and the TDWMApply external stored procedure, a self-deadlock occurs as shown in the example below.

Bt;
Call TDWMRuleControl()  

The updates are not committed because the TDWMRuleControl procedure is in a transaction (that is, the rows are locked for write).

Call TDWMApply(200, 'Y','N','N','N'); 

The TDWM database waits on the locked tables.

 

If you want to ...

Use the following
SQL interface ...

Or the following CLIv2 or Teradata JDBC Driver request ...

abort a request or utility session on the Teradata dynamic workload management software delay queue

“TDWMAbortDelayedRequest” on page 389

“TDWM DELAY REQUEST CHANGE” on page 347

apply changes to the rules in one or more the Teradata dynamic workload management software categories

“TDWMApply” on page 391

change the workload a session or request is assigned to

“TDWMAssignWD” on page 393

“TDWM WD ASSIGNMENT” on page 381

activate or deactivate a user-defined event

“TDWMEventControl” on page 395

“USER EVENT CONTROL” on page 385

list all objects that make up the system state

“TDWMEventMapping” on page 397

“EVENT STATUS” on page 333

return the currently defined events

“TDWMEventStatus” on page 399

“EVENT STATUS” on page 333

return the collection rate (that is, the first record of the Teradata dynamic workload management software Exception PM/API request) or return Teradata dynamic workload management software exception data from Teradata Database

“TDWMExceptionRate” on page 403

“TDWM EXCEPTIONS”

collect the Teradata dynamic workload management software exception data from the Teradata Database

“TDWMExceptions” on page 404

“TDWM EXCEPTIONS” on page 350

report if each category is active or not

“TDWMInquire” on page 414

return the delayed query data fields and delay information

“TDWMGetDelayedQueries” on page 408

“TDWM STATISTICS” on page 360

return the utility delay queue

“TDWMGetDelayedUtilities” on page 412

“TDWM STATISTICS” on page 360

return a list of the WDs

“TDWMListWDs” on page 415

“TDWM LIST WD” on page 356

return the statistics on the load utilities that are available in the system

“TDWMLoadUtilStatistics” on page 417

“TDWM STATISTICS” on page 360

release a request or utility session on the Teradata dynamic workload management software delay queue

“TDWMReleaseDelayedRequest” on page 419

“TDWM DELAY REQUEST CHANGE” on page 347

return the Teradata dynamic workload management software WD summary data fields

“TDWMSummary” on page 423

“TDWM SUMMARY” on page 374

return the collection rate

“TDWMSummaryRate” on page 427

“TDWM SUMMARY” on page 374

return statistics for throttled database objects or throttled workloads

“TDWMThrottleStatistics” on page 428

“TDWM STATISTICS” on page 360