Creating Models › Target Servers for Physical Models › Database Property Editors › DB2 LUW Property Editors › Define DB2 LUW Global Temporary Table

Define DB2 LUW Global Temporary Table

Use the DB2 for LUW Table Editor to create a global temporary table, or work with the properties of an existing DB2 LUW global temporary table.

To define a DB2 LUW global temporary table

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

   The DB2 for LUW Table Editor opens.

2. Select a table and work with the following options:

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

   Physical Name

   Specifies the physical name for the table.

   Schema

   Specifies the schema associated with the selected table. Create or select a schema from the drop-down list.

   DB2/LUW Type

   Specifies the table type. Select Global Temporary from the drop-down list. The Organize By, Partitions, Table Options, Validation, and Volumetrics tabs are disabled based on this value.

   Use Replace Syntax

   Specifies whether or not to use the CREATE or REPLACE command instead of the CREATE command during Forward Engineering.

   Note: This field applies to DB2 for LUW version 9.7 only.

   Physical Only

   In a Logical/Physical model, specifies that the table does not appear on the logical side as an entity.

   Generate

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

3. Click the Dimensional tab and work with the following options:

   Dimensional Notation Rule Type

   Specifies the role assigned to the table for dimensional modeling. Select from the drop-down list; valid values are Fact, Dimension, and Outrigger.

   Dimensional Notation Update Type

   Specifies the type of update you want to use to update dimensional notations. Select from the drop-down list; valid values are Fixed, Type 1, Type 2, and Type 3.

4. Click the Data Movement Rule tab and work with the following options:

   Refresh Rule

   Append Rule

   Backup Rule

   Recovery Rule

   Archive Rule

   Purge Rule

5. Click the General tab and work with the following options:

   Commit Type

   Specifies the action that you want to take on a global temporary table when a COMMIT operation is performed. Select from the drop-down list; valid values are Delete Rows and Preserve Rows.

   Is Logging Enabled

   Specifies whether or not you want to log the operations performed on a global temporary table.

   Rollback Type

   Specifies the action that you want to take when a ROLLBACK operation is performed on a global temporary table that is not logged. Select from the drop-down list; valid values are Delete Rows and Preserve Rows.

6. Click the Tablespace tab and work with the following options:

   Name

   Specifies the tablespace name where the global temporary table will be instantiated.

7. Click the Distribution tab and work with the following options:

   Distribute By

   Specifies the default distribution method across database partitions.

   Distribution Key Columns

   Specifies the columns on which you want to use hash as the default distribution method.

8. Click the Alias tab and work with the following options:

   Name

   Specifies the alias for the global temporary table.

   Schema

   Specifies the schema for the alias. Create or select from the drop-down list.

9. Work with the other tabs in the editor to access additional design features, for example:
   • Associate permissions with the selected table on the Permission tab.
   • Enter any comments you want to associate with the table on the Comments tab.
   • Specify a theme for the table on the Style tab.
   • Select an icon for the current table on the Icon tab.
   • Change the object creation order on the Object Creation Order tab.
   • View where the table is used on the Where Used tab.
   • Select user-defined properties for the table on the UDP tab.
   • View history information and view or edit user notes on the Notes tab.
10. Click Close.

    The DB2 for LUW Table Editor closes.