17.10 - JavaHybridThreads - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
xha1591998860283.ditamap
dita:ditavalPath
xha1591998860283.ditaval
dita:id
vkz1472241255652

Specifies the maximum number of threads that can be run simultaneously by the Java hybrid server.

Valid Range

0 through the setting for SecureServerAMPs or SecureServerPEs, whichever is smaller.

Default

20

Usage Notes

Each node can have one hybrid server that provides multiple threaded execution of protected mode Java UDFs to all AMPs and PEs on the node. (Protected mode Java UDFs are those that do not include the EXTERNAL SECURITY clause in their UDF SQL definitions.)

When this field is set to zero, Java UDFs cannot be run by the hybrid server, so must be run by Java secure servers, which are single threaded.

If JavaHybridThreads and JavaServerTasks are both set to zero, neither Java UDFs nor Java external stored procedures can be run.

Related Information

For more information on Java external stored procedures and Java user-defined functions, see Teradata Vantage™ - SQL External Routine Programming, B035-1147.