Previous Topic: Define DB2 LUW Domain PropertiesNext Topic: Define Hive Domains


Define DB2 z/OS Domain Properties

In a model based on a DB2 for z/OS target server, you use the DB2 for z/OS tab in the Domain Editor to manage the data type, null option, and other properties for the selected domain.

Note: The options described here are the basic options available for most physical data types. There can be more options available depending on the physical data type you assign to the domain. We recommend that you refer to your DB2 for z/OS documentation for more information about using these properties.

To specify DB2 for z/OS domain properties

  1. Click Domains on the Model menu.

    The Domain Editor opens.

  2. Select the domain in the Navigation Grid that you want to define.

    Note: Click New New icon in property editors to create a new object on the toolbar to create a new domain. Use the Enter filter text box to filter a very large list of domains to quickly locate the one that you want to define.

  3. Click the DB2 for z/OS tab and work with the following options:
    Physical Data type

    Lets you select a data type from the drop-down list to apply to the selected domain. If the selected data type requires a value for precision, scale, or both, enter the value inside the data type parentheses. For example, you can select the DECIMAL() data type and specify a precision of 2 and a scale of 10 inside the parentheses to assign the data type DECIMAL(2,10) to the selected domain.

    Character Type

    Lets you specify the data subtype for character columns. Select a value from the drop-down list.

    Note: This option is only available if you select either the CHAR, CHAR(), CHARACTER, CHARACTER(), VARCHAR(), or LONG VARCHAR() data type.

    CCSId

    Lets you specify the CCSID for the columns.

    Null Option

    Lets you specify a null option.

    Average Width

    Lets you enter an estimated average width for columns if variable width is allowed based on the data type you assigned. If it is not allowed, an error is displayed in the Details section at the bottom of the editor. You can later use the Volumetrics dialog to calculate table and database size estimates based on these and other values.

    Percent Null

    Lets you enter the estimated percentage of nulls used for columns if the option is available. Use whole numbers. You can later use the Volumetrics dialog to calculate table and database size estimates based on these and other values.

    Label

    Lets you enter the name of a label that appears opposite the column value in DB2 for z/OS applications.

    Security Label

    Specifies that the columns are used for security. Select the check box to enable this option.

    Is Implicitly Hidden

    Specifies the IMPLICITLY HIDDEN column specification. Select the check box to enable this option. When this option is enabled, the column is not visible in SQL statement results unless it is explicitly referred to by name.

    Generated

    Lets you specify how DB2 for z/OS generates values for columns. Select a value from the drop-down list.

  4. Click Close.

    Domain properties are defined and the Domain Editor closes.