16.20 - SetSystemTCore - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1145-162K
Language
English (United States)

Purpose

SetSystemTCore sets the TCore value of the system.

Syntax



Syntax Elements

SYSLIB

Name of the database where the function is located.

SystemTCoreToSet

An integer representing the amount of TCore to give the system. To see the range of valid values, run the GetSystemTCore function.

ANSI Compliance

This is a Teradata extension to the ANSI SQL:2011 standard.

Usage Notes

When using SetSystemTCore, keep the following in mind:
  • Teradata monitors use of Elastic TCore. Customers that use more TCore than they have purchased to date may incur additional charges as a result.
  • The EXECUTE privilege on SetSystemTCore is required in order to run it.
  • It is supported only on Intelliflex 2.1 and above systems.
  • It is used only in the FROM clause of a SELECT request.
  • It can be invoked only with constant expression input arguments.

Example

SELECT * FROM TABLE(SYSLIB.SetSystemTcore(75)) AS t;