Maintaining Data Classes (DB2 UDB for UNIX and Windows) 

Use

Using the data class list on the Configuration: Data Classes screen, you can maintain data classes as follows:

·        Change data classes

·        Add new data classes

·        Delete data classes

Procedure

Changing Data Classes

...

       1.      On the Configuration: Data Classes screen, choose  Edit.

The Change Data Class dialog box appears.

       2.      If required, change the description.

       3.      Change the tablespace assignment.

       4.      To confirm your changes, choose  Save.

Changing the related tablespaces does not affect already existing tables. It will only influence new tables. 

Adding Data Classes

...

       1.      On the Configuration: Data Classes screen, choose  Add.

The Add Data Class dialog box appears.

       2.      Specify a name for the data class using the naming conventions for customer-defined data classes. If you do not follow these naming conventions, you might get an error message.

Keep in mind that not defining data classes according to the naming conventions has an impact on future upgrades of your system.

Such entries will not be recognized as customer entries and will be lost during the upgrade.

You cannot enter a value in the Category field. It always has the value USR.

       3.      Enter a meaningful description.

       4.      Select a data and index tablespace from the list box.

       5.      To confirm your entries, choose  Add.

Deleting Data Classes

...

       1.      On the Configuration: Data Classes screen, choose  Delete.

The Delete Data Class dialog box appears.

       2.      To confirm your entries, chooseDelete.

A data class cannot be deleted if it is used by any table.