Superfluous physical tables

In LN, superfluous physical tables can exist in different forms. These tables can cause issues during application upgrades.

Examples of superfluous physical tables include:

  • Tables without a company record. These physical tables still exist after the corresponding company has been removed.
  • Superfluous expired tables. These physical tables still exist after the corresponding table definition has expired.

Example

Previously, a physical table was shared, which made the physical table logical. However, the physical table was not deleted from the database.

If you later unshare the table and change it back from logical to physical, the old physical table may cause problems.

If the table definition was changed while the table was logical, this can lead to a 512 error, because the reconfiguration process skips logical tables when processing the changed table definition.

To prevent this issue, the superfluous logical table must be removed.

Retrieving and removing superfluous physical tables

Use the Check and Delete Superfluous Physical Tables (ttaad4234m000) session to retrieve and remove superfluous physical tables.

  1. Specify the company, package, and table ranges.
  2. Select the databases to check for, or delete, superfluous tables.
  3. Under Checks, select the types of superfluous tables to find.
  4. Clear the Delete found Superfluous Tables check box.
  5. Click Print/Delete.

    A report is printed with the found tables.

  6. Review the tables in the report and decide whether to delete them.
  7. To delete the reported tables, run the session again with the Delete found Superfluous Tables check box selected.
Note: Use the Delete found Superfluous Tables with care. First print a report and review the reported superfluous tables. Delete the tables only after you have verified the report.