5 6 1 Why Does it Have to Be Reorganized

5.6.1 Why Does it Have to Be Reorganized?

Like all IBM i database files, those in the LANSA 'internal' database should be regularly reorganized. There are two good reasons for doing this:

• To free up disk space
  by removing deleted record space from the files. When records are deleted from IBM i database files the disk space they occupy is not freed or re-used until the file is Reorganized.

• To improve the performance of both LANSA and client applications
  by re-arranging the data in the file so that it is in the same order as the most commonly used access path. Performing this function speeds up applications that access the file.