15.00 - JavaServerTasks - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

JavaServerTasks

Purpose  

Specifies the number of Java secure servers that can be run simultaneously per vproc, subject to the limitations imposed by the ParallelUserServerAMPs and ParallelUserServerPEs settings.

Valid Range

0 to 20

Default

2

Usage Notes  

Java secure servers can be used by Java external stored procedures and secure-mode Java UDFs. (Secure-mode Java UDFs are those that include the EXTERNAL SECURITY clause in their UDF SQL definitions.)

Java secure servers are single threaded. This is in contrast to Java hybrid servers, which can execute multiple Java UDFs, each one in its own thread. The number of threads that can be run by a Java hybrid server is controlled by the JavaHybridThreads field.

If the JavaServerTasks field is zero, you cannot run any Java external stored procedures, and Java UDFs must run by a Java hybrid server.

JavaServerTasks is analogous to the UDFServerTasks field used for native based UDFs, external stored procedures, or UDMs.

Related Topics

For more information on Java external stored procedures and Java user defined functions, see SQL External Routine Programming.