LANSA stores a great deal of information about fields, files and processes. This information is kept in a set of approximately 80 IBM i database files that reside in the LANSA 'data' library. This is normally called DC@DTALIB, but may be different at your installation. These files begin with the prefix 'DC@F', 'DC@W'or 'DC@X' which identify them as 'internal' LANSA files.

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.

The steps involved in Reorganizing the LANSA internal database are as follows:

                                      __________
     1. Select the option to submit  |          |
        the job to Reorganize the    | HOUSE-   |
        LANSA internal database      | KEEPING  |
        on the housekeeping menu.    |  MENU    |
                                     |__________|
                                          |     
                                          | 
                                          | 
                                      ____|_____
     2. Specify job details and      |          |
        submit the batch job.        |  SUBMIT  |
                                     |REORGANIZE|
                                     |   JOB    |
                                     |__________|

                                     
Also see

5.6.1 When Should It Be Reorganized?

5.6.2 Submit Job to Reorganize the Database

5.6.3 Remotely Invoke the Reorganization Facility