Physical Data Storage Management

A Lawson database space is the storage area for your database files. After you define one or more database spaces using the Lawson dbdef utility, assign them to the product line, data area, system code, or table. Before using the database spaces, do the following:

  • Estimate disk usage.

  • Create database spaces.

  • Assign portions of the database to a database space.

  • Implement the dictionary changes.

You can assign database spaces at any time. Doing so, however, requires making it possible to stop the database prior to reorganizing the database. When reorganizing the database, do the following:

  • Determine where to store data and how much space you need.

    Note: 

    A helpful tool in estimating the table and index space used by a data area is the Disk Usage utility (ibmdu).

  • Create the database space(s) you want with dbdef.

  • Assign product lines, system codes, or files to the database space(s) you created.

  • Build the data dictionary using blddbdict.

  • Reorganize the database using dbreorg, which implements the changes.