How Is a Database Space Saved Using the Empty Database Type?

You might have empty Lawson tables at your site. For example, you may not use a Lawson application that populates a particular table. If a table is not being used at your site, use the dbdef utility to change the table to type Empty. This frees up disk space that had been allocated for the table.

Before you perform this procedure for any table, be sure that the table is actually empty at all times. The Payroll application, for example, includes tables that contain records only at certain times in a payroll cycle. The application automatically deletes the records when they are no longer needed. A table of this kind should not be set to an empty database space.

If you are not sure whether a table is being used, use the count utility to determine whether it has records. Run the count utility over a period of time before setting a table to empty.

If a table that has been set to Empty is actually being used, you receive the message "Empty DB Space does not allow Stores."

Note: It is theoretically possible that you might have an entire system code that is not used. If you are certain that none of the tables in a particular system code contains records, use the procedure referred to above to assign the system code to an empty DB space.

See Assigning a Table to an Empty Database Space.