16.20 - GetSystemTCore - 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

GetSystemTCore returns the current TCore setting of the system.

Syntax



Syntax Elements

SYSLIB

Name of the database where the function is located.

ANSI Compliance

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

Usage Notes

The EXECUTE privilege on GetSystemTCore is required in order to run it.

Example

SELECT * FROM TABLE(SYSLIB.getSystemTcore()) AS t;

*** Query completed. One row found. 7 columns returned.

*** Total elasped time was 1 second.

StatusFlag 1
ErrorMsg Success for get systemtcore
BaselineTcore 75
CurrentTcore 100
MinTcore 0
MaxTCore 102