Introduction › Adding an Index Entry to an Open Table

Adding an Index Entry to an Open Table

New index entries (key definitions) can be added (cataloged by CA Datacom Datadictionary) to a CA Datacom/DB table while that table and the database in which it resides remain open. Index entries can also be deleted while a table is open. Adding and deleting index entries while a table is open supports 24X7 operations.

A table being open means that the table is open to any number of user applications. The executing applications are unaffected by the index addition until:

• after the addition is complete, and
• the new index entry is available to either in-progress applications or to new applications that then start.

A CA Datacom Datadictionary key addition catalog function adds keys to tables in a 24x7 environment. The 24X7 key addition catalog exists in addition to a full database catalog. You are generally allowed to add a new key to a table while the table is open to user applications.

For details about adding index entries to open tables, see the CA Datacom/DB Database and System Administration Guide.