Previous Topic: Define Hive Table PropertiesNext Topic: Define Informix Table Physical Storage Properties


Define DB2 for i Table Properties

Use the DB2 for i Table Editor to define table properties. This procedure assumes you are working in a physical model, with DB2 for i defined as the target server.

To define properties for a DB2 for i table

  1. Click Tables on the Model menu.

    The DB2 for i Table Editor opens.

  2. Select the table in the Navigation Grid that you want to define and work with the following options:

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

    Physical Name

    Specifies the physical name of the table. Change the physical name of the table in this field.

    DB Owner

    Specifies the owner of the database to which the table belongs. Change the owner name of the table in this field.

    Physical Only

    Specifies whether the table is suppressed from a logical model and appears in a physical model only.

    Generate

    Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

  3. Click the General tab and enter a name that identifies the table in the Label field.
  4. Click the Volumetrics tab and work with the following options:
    Initial Row Count

    Defines row count for the table. Enter a value in the field.

    Max Rows

    Defines row sizing for the table. Enter a value in the field.

    Growth By Month

    Defines growth increments for the table. Enter a value in the field.

  5. Work with the other tabs in the editor to access additional design features, for example:
  6. (Optional) Click the Comment tab and enter any comments that you want to associate with the object.
  7. (Optional) Click the Where Used tab to view where the object is used within the model.
  8. (Optional) Click the UDP tab to work with user-defined properties for the object.
  9. (Optional) Click the History tab to view the history information for the object.
  10. (Optional) Click the Notes tab to view and edit user notes.
  11. Click Close.

    The table is defined and the DB2 for i Table Editor closes.