Driver Parameters Optimization (ttdba0137m000)
Use this session to maintain the database driver parameters for a specific database. With this session you can optimize the database driver parameters to improve the performance between LN and the database.
The driver parameters provide a way to specify specific driver behavior per database table. For example, you can specify that you want to use two columns, or that you want to generate statistics at creation of the table.
Use the command on the appropriate menu to store the optimized
parameters in the [RDBMS]_driver_param file. This file can now be accessed by the database drivers at runtime.
Use the command on the appropriate menu to import
the data from the [RDBMS]_driver_param file into this session.
Example
The [RDBMS]_driver_param file contains this line:
indented-estimatedTfgld402:312:T:group:034:4 *:*:*:group:0214:4
In this Oracle example, the database driver handles the table tfgld402 in company 312 slightly different than the other tables because of the index optimization. For more information, see the Technical Reference Manuals of the database drivers.
Field Information
- Database
-
The database for which you want to maintain the parameters.
- Sequence Number
-
The line number. The lines are written in ascending order of the sequence number.
- Table Code
-
A table name or a package or module name. An asterisk (*) indicates all tables.
This table shows some examples:
ttadv000 A specific table ttadv All tables in the adv module in package tt tt All tables in package tt * All tables - Company
-
A company number. An asterisk (*) indicates all company numbers.
- Table/Index
-
This field indicates whether the settings in the row apply to a table or an index.
Allowed values
Table
Index
- Index Number
-
If Index is selected in the Table/Index field, this field contains the number of the index to which the settings in the row apply.
- Optimization Value (Octal)
-
The optimization value.
See the Technical Reference Manuals of the database drivers.