Creating Models › Creating a Physical Model › Tables › Table Editor › Define Informix Table Physical Storage Properties

Define Informix Table Physical Storage Properties

Use the General tab in the Informix Table Editor to define table physical storage properties and to assign a table generated to a database and tablespace. This procedure assumes you are working in a physical model, with Informix defined as the target server.

To define physical storage properties for an Informix table

1. Click Tables on the Model menu.

   The Informix Table Editor opens.

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

   Note: Click New 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.

3. Click the General tab.
4. Select the Storage Option drop-down arrow and select one of the following storage options:

   DB Space

   Specifies to assign the current table to an existing dbspace or blobspace. Assign values to the following fields:

   EXTENT_SIZE

   Lets you enter a number to assign to the extent size, in kilobytes.

   NEXT_SIZE

   Lets you enter a number to assign to the next (incremental) size, in kilobytes.

   LOCKMODE

   Lets you specify to use either a Row lock or a Page lock.

   IN_DBSPACE

   Lets you assign a dbspace to the table. Click New to add a new dbspace or click the button to open the Informix DBSpace Editor to work with an existing dbspace.

   Path Name

   Specifies to use a UNIX or DOS pathname to determine the storage location of the current table. Enter the pathname in the PATHNAME_IN field.

   Round Robin

   Specifies to fragment by Round Robin. Assign values to the following fields:

   EXTENT_SIZE

   Lets you enter a number to assign to the extent size, in kilobytes.

   NEXT_SIZE

   Lets you enter a number to assign to the next (incremental) size, in kilobytes.

   LOCKMODE

   Lets you specify to use either a Row lock or a Page lock.

   WITH_ROWIDS

   Specifies to create a row ID column when creating a partitioned table. Select the check box to enable this option.

   Expression

   Specifies to fragment by Expression. Assign values to the following fields:

   EXTENT_SIZE

   Lets you enter a number to assign to the extent size, in kilobytes.

   NEXT_SIZE

   Lets you enter a number to assign to the next (incremental) size, in kilobytes.

   LOCKMODE

   Lets you specify to use either a Row lock or a Page lock.

   WITH_ROWIDS

   Specifies to create a row ID column when creating a partitioned table. Select the check box to enable this option.

   REMAINDER_IN

   Lets you select the dbspace in which to store the rows that are not selected by any expression.

5. Click Close.

   The table physical storage properties are assigned and the Informix Table Editor closes.