Creating Models › Target Servers for Physical Models › Database Property Editors › DB2 LUW Property Editors › Support for Workload Features in DB2 LUW › Set Properties for a DB2 LUW Histogram Template

Set Properties for a DB2 LUW Histogram Template

Use the DB2 for LUW Histogram Template Editor to set properties for a histogram template. You create histogram templates to specify the uppermost bound for the range of data that the corresponding histogram captures.

Note: This topic applies to DB2 for LUW versions 9.5 and 9.7 only.

To set properties for a DB2 histogram template

1. Right-click a Histogram Template in the Model Explorer and select Properties.

   The Histogram Template Editor opens.

2. Select a histogram template and work with the following options:

   Note: Click New on the toolbar to create a histogram template. Use the Enter filter text text box to filter a large list of names to locate the one you want to work with.

   Name

   Specifies the name of the histogram template.

   Top Value

   Specifies the top value of the second to last bin (the last bin has an unbounded top value).

   Generate

   Specifies whether or not to generate DDL for this object during Forward Engineering.

3. Click the Comment tab and enter any comments you want to associate with the histogram template.
4. Click the UDP tab to work with user-defined properties for the histogram template.
5. Click Close.

   The DB2 for LUW Histogram Template Editor closes.

More Information:

Add a Comment in a Property Editor

Add a UDP in a Physical Property Editor