| # Convert Table and Index Repository (ttdba0540m000) Use this session to view the RDBMSs for which you can optimize the table and index storage. This session converts the [RDBMS]_storage file to the runtime data dictionary. During the conversion process the [RDBMS]_storage file is split up into two separate files: The storage parameter file, [RDBMS]_storage_param The database driver parameter file, [RDBMS]_driver_param You can maintain these two files in the Storage Parameters Optimization (ttdba0132m000) session and the Driver Parameters Optimization (ttdba0137m000) session. Splitting up the [RDBMS]_storage file improves the interaction between Tools and the database. For example, the time required to run a query is reduced. WARNING The information in the Table and Index repository affects the data transfer to the database. Ensure not to corrupt the data transfer by storing incorrect information in the repository. Select a RDBMS in the grid and then, on the appropriate menu, select Convert Repository to start the conversion process. Note The [RDBMS]_storage file is not deleted but will not be used anymore when the [RDBMS]_storage_param file and the [RDBMS]_driver_param are created. Related topics The Database Administrator (DBA) module Creating a link between the LN user and the database user Database The code of the database. Note Create the database in the Database Definitions (ttaad4510m000) session. Database Type The database type. You can use several databases of different types in Tools. System Name The remote system's name where the database is located. Use this field if the database is located on a remote system. You need the remote system's name to convert the data to the tabledef6.x file. Note This field is empty if: The database is located on a local database. The system is not part of a remote system. BSE Path The specified host system's BSE path. Note This field is empty if: The database is located on a local database. The system is not part of a remote system. |