PrioritizePreparedCollect - Teradata Database - Teradata Vantage NewSQL Engine

Application Programming Reference

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-02
dita:mapPath
vwf1492987142269.ditamap
dita:ditavalPath
changebar_rev_16_20_exclude_audience_ie.ditaval
dita:id
B035-1090
lifecycle
previous
Product Category
Teradata Vantage™

Changes the submission order of an individual collection within a prepared commands list.

Definition

REPLACE PROCEDURE TDSTATS.PrioritizePreparedCollect
  (IN RequestID    BIGINT,
   IN Priority     INTEGER,
   OUT NumUpdated  INTEGER)
           .
           .
           .
;

Input Parameters

Parameter Description
RequestID TDSTATS database unique ID for an individual prepared collection.
This input parameter cannot be NULL.
Priority Changed priority of the specified collection expressed as a relative rank among other collections in the commands list containing RequestID.
This input parameter cannot be NULL.

Usage Notes

You can call the SelectPreparedCollects external stored procedure to determine the priority of other collections in the same commands list.

The modified priority is only relevant to the commands list containing the specified collection as identified by RequestID. Future invocations of PrepCollect will not incorporate the modified priority.

If two or more collections have the same priority within a commands list, the submission order among them is undefined.

Output Parameter

Parameter Description
NumUpdated Possible values:
  • 1 means the operation was successful.
  • 0 means the operation failed.

Example: Using PrioritizePreparedCollect

The following example shows how to change the priority of pending collection number from 12 to 1 (that is, one being the highest priority).

CALL TDSTATS.PrioritizePreparedCollect(12, 1, NumUpdated);
*** Procedure has been executed.
*** Total elapsed time was 1 second.
 NumUpdated
-----------
          1

Related Topics

For more information on ... See ...
the priority of other collections in the commands list SelectPreparedCollects.
preparing a prioritize list of COLLECT STATISITICS statements PrepCollect.