User Datatypes (DB2 LUW)

From DBArtisan
Jump to: navigation, search

Go Up to IBM DB2 for Linux, Unix, and Windows Object Wizards

User defined datatypes allow column definitions to be consistent across a database. They let you associate frequently used datatype information to be associated with a specified function and take advantage of performance features available to built-in datatypes including indexing and parallel database queries.

To create a new user datatype using a wizard:

  1. Open a creation wizard for a user datatype. For details, see Opening an Object Wizard.
  2. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
  3. Finally, use the Execute button to create the object.

User Datatypes (DB2 LUW) - Properties

When creating or editing a user datatype, this tab/panel lets you work with the following settings:

Setting Description


Select the owner of the user datatype.


Provide a name for the datatype.


Select the base datatype.


Provide the size of the datatype.

Allow Bit Data

The option is only available for certain datatypes. A check means you want to store the data in a bit format.