| # 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 Convert to Runtime 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 Read Data From File 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:
    Tfgld402: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. Related topics Infor Enterprise Server - Technical Reference Guide for Informix Database Driver (U8781 US) Infor Enterprise Server - Technical Reference Guide for Microsoft SQL Server Database Driver (U8173 US) Infor Enterprise Server - Technical Reference Guide for DB2 Database Driver (U7829 US) Infor Enterprise Server - Technical Reference Guide for Oracle Database Driver (U7076 US) Infor Enterprise Server - Technical Reference Guide for MySQL Database Driver (U8924 US) 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. Convert to Runtime Stores the data specified in this session in the `[RDBMS]_driver_param` file. Read Data From File Imports the data from the `[RDBMS]_driver_param` file into this session. |