| RDBMS table and index repository procedure |  |
| Introduction With this procedure, you can convert the [RDBMS]_storage file from the run time 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, then the performance between ERP LN and the database will be improved. For example, this reduces the time required to run a query. To optimize the table and index repository, you must do the following: Convert the table and index repository Optimize the storage parameters Optimize the driver parameters Result As a result of this procedure, the interaction between ERP LN and the database in improved. This results in an improved performance of ERP 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. The following figure illustrates the steps in the procedure you must take to optimize the table and index repository: This procedure is divided into the following three sub-procedures: Use the Convert Table and Index Repository (ttdba0540m000) session to split up the [RDBMS]_storage file. Optimize the [RDBMS]_storage_param file. Optimize the [RDBMS]_driver_param file. Note Splitting up the [RDBMS]_storage file in to two separate files is a one time only action. After you split up the [RDBMS]_storage file, the file still exists, however, because the file has expired, the file no longer used. The other two steps are for maintenance purposes of the [RDBMS]_storage_param file and the [RDBMS]_driver_param file. To convert the table and index repository You can use this procedure to split up the [RDBMS]_storage file for improved interaction between ERP LN and the database. Procedure summary The following list shows the procedure steps and the corresponding sessions. Convert the table and index repository with the following session: Convert Table and Index Repository (ttdba0540m000). To optimize the storage parameters for the specific database You can use this process to maintain the [RDBMS]_storage_param file, which is a part of the [RDBMS]_storage file. Procedure summary The following list shows the procedure steps and the corresponding sessions. Optimize the storage with the following sessions: Storage Parameters Optimization (ttdba0530m000) Storage Parameters Optimization (ttdba0130s000) To optimize the driver parameters for the specific database You can use this process to maintain the [RDBMS]_driver_param file, which is a part of the [RDBMS]_storage file. Procedure summary Optimize the database drivers with the following sessions: Driver Parameters Optimization (ttdba0535m000) Driver Parameter Optimization (ttdba0135s000) |