SYSUDTLIB Database | Distinct UDTs | Teradata Vantage - SYSUDTLIB Database - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-12-13
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
jbg1472252759029
lifecycle
latest
Product Category
Teradata Vantage™

SYSUDTLIB is a system database that contain all UDTs, their methods, cast routines, ordering routines, transform routines, and any UDFs that are used as cast routines, ordering routines, or transform routines. Because SYSUDTLIB is a system database, it is created by a DIP script. SYSUDTLIB is created as a database, not a user, so you cannot log on as user SYSUDTLIB.

When the system resolves SQL requests that involve UDTs, it only searches SYSUDTLIB for UDTs and UDT-related database objects. Because of this, you need not explicitly specify a database name for UDTs. If you do specify a database name, however, it must be SYSUDTLIB.

You should not place non-UDT-related objects in SYSUDTLIB. The database requires space for every UDT you define as well as for every method or UDT-related UDF created within it. SYSUDTLIB space usage is dependent primarily on the space required to store the code files implementing the UDM or UDF, or the space required to contain internally generated source code that is used to acquire an instance of a UDT.

The initial space allocation for SYSUDTLIB is 0. The DBA must modify the definition for SYSUDTLIB to assign enough space that UDTs, UDMs, and UDT-related UDFs can be created within it. If you attempt to create a UDT-related object in SYSUDTLIB when there is insufficient space to do so, the system returns an error to the requestor. As time passes, you might need to increase the storage associated with SYSUDTLIB to accommodate the growing number of UDTs, UDMs, and UDT-related UDFs.

For details on modifying the definition for SYSUDTLIB, see MODIFY DATABASE.