| # RDBMS table and index repository procedure Introduction With this procedure, you can convert the `[RDBMS]_storage` file from the runtime data dictionary to the RDBMS Administration module. During the conversion process, the `[RDBMS]_storage` file is split up into two separate files: The database storage parameter file, `[RDBMS]_storage_param` The database driver parameter file, `[RDBMS]_driver_param` If you split up the `[RDBMS]_storage` file, the interaction between LN and the database will be improved. For example, this reduces the time required to run a query. Procedure To optimize the table and index repository: Step 1. Convert the table and index repository. Complete these steps: Start the Convert Table and Index Repository (ttdba0540m000) session. Convert the table and index repository. During the conversion process the `[RDBMS]_storage` file is split up into the `[RDBMS]_storage_param` file and the `[RDBMS]_driver_param` file. Splitting up the `[RDBMS]_storage` file into two separate files is a once-only action. After you split up the `[RDBMS]_storage` file, the file still exists, but has expired; therefore the file is no longer used. The next two steps are for maintenance purposes of the `[RDBMS]_storage_param` file and the `[RDBMS]_driver_param` file. Step 2. Optimize the storage parameters. Complete these steps: Start the Storage Parameters Optimization (ttdba0132m000) session. Use this session to maintain the `[RDBMS]_storage_param` file, which is a part of the `[RDBMS]_storage` file. Step 3. Optimize the driver parameters. Complete these steps: Start the Driver Parameters Optimization (ttdba0137m000) session. Use this session to maintain the `[RDBMS]_driver_param` file, which is a part of the `[RDBMS]_storage` file. Result As a result of this procedure, the interaction between LN and the database is improved. This results in an improved performance of LN. Warning The information in the Table and Index repository affects the data transfer to the database. Be sure to store the correct information in the repository to ensure that you do not corrupt the data transfer. |