To reconfigure tables

This topic describes the procedure to reconfigure tables.

Important!

The sections below describe the sessions that you must use to complete the procedure. However, they do not describe all details of these sessions. For detailed session information, refer to the Web Help.

Procedure aim

When you change the table definitions, or the corresponding domains, for tables that already exist in the database, you must reconfigure the tables according to the new table and domain definitions.

A table configuration process will perform these actions:

  • Unload data that is in the existing table, for all companies in the package combination
  • Drop the existing table, for all companies in the package combination
  • Create the table according to the new table and domain definitions
  • Re-load the data into the table

This is a process that you will want to control when and who performs the reconfiguration activity. You can separate the convert process and the reconfigure process.

Procedure result and prerequisites
Result

The structure of the tables in the database matches the new table and domain definitions.

Prerequisites

A table reconfiguration requires exclusive access to the table, because the system will drop the table.

Procedure summary

To execute the convert and reconfigure process as 2 separate steps:

  1. Convert the data dictionary information to runtime - Convert to Runtime Data Dictionary (ttadv5215m000)
  2. Reconfigure the tables in conjunction with the DBA or system administrator - Convert to Runtime Data Dictionary (ttadv5215m000)
Note

You must log off and log on again to use the new tables.

Procedure details
Step 1. Convert the data dictionary information to runtime

Run the Convert to Runtime Data Dictionary (ttadv5215m000) session with the following selection settings:

Check BoxSelected
DomainsYes
TablesYes
Reconfigure TablesNo

 

Step 2. Reconfigure the tables

To reconfigure the tables in conjunction with the DBA or system administrator, run the Convert to Runtime Data Dictionary (ttadv5215m000) session with the following selection settings:

Check BoxSelected
DomainsNo
TablesNo
Reconfigure TablesYes