16.20 - GetPSFVersion - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Application Programming Reference

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Programming Reference
featnum
B035-1090-162K

Purpose

Returns the current type of Priority Scheduler.

Definition

REPLACE FUNCTION TD_SYSFNLIB.GetPSFVersion()
RETURNS VARCHAR (10) CHARACTER SET LATIN,
...
;

Usage Notes

Priority Scheduler is managed by TASM, and is configured using the Teradata Viewpoint workload management portlets. For more information on those portlets, see Teradata Viewpoint User Guide.

Return Values

Value Description
WORKLOADS Current Priority Scheduler uses workload definitions.

Example: Using GetPSFVersion

This example shows the current Priority Scheduler is using workload definitions.

SELECT TD_SYSFNLIB.GetPSFVersion();
 *** Query completed. One row found. One column returned.
 *** Total elapsed time was 1 second.
getpsfversion()  WORKLOADS