SYSUDTLIB Database | Distinct UDTs | Teradata Vantage - SYSUDTLIB Database - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
jpx1556733107962.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1184
lifecycle
previous
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.