RDBMS table and index repository procedure

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 is improved. For example, the time required to run a query reduces.

Warning: The information in the Table and Index repository affects the data transfer to the database. Ensure to store the correct information in the repository to ensure that you do not corrupt the data transfer.

To optimize the table and index repository:

  1. Convert the table and index repository.
    1. Start the Convert Table and Index Repository (ttdba0540m000) session.
    2. 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.

  2. Optimize the storage parameters.
    1. Start the Storage Parameters Optimization (ttdba0132m000) session.
    2. Use this session to maintain the [RDBMS]_storage_param file, which is a part of the [RDBMS]_storage file.
  3. Optimize the driver parameters.
    1. Start the Driver Parameters Optimization (ttdba0137m000) session.
    2. Use this session to maintain the [RDBMS]_driver_param file, which is a part of the [RDBMS]_storage file.