15.10 - GetPSFVersion - Teradata Database

Teradata Database Application Programming Reference

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

Returns the current type of Priority Scheduler.

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

On SLES 10 or earlier systems, the Priority Scheduler assigns requests to performance groups.

On SLES 11 or later systems, 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.

 

Value

Description

PERFGROUPS

Current Priority Scheduler uses performance groups.

WORKLOADS

Current Priority Scheduler uses workload definitions.

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