| # Storage Parameters Optimization (ttdba0132m000) Use this session to maintain the storage parameters for database tables and indexes in a specific database. With this session you can optimize the storage driver parameters for a specific database to improve the performance between LN and the database. The storage parameters provide a way to specify the distribution of the table and index data in different tablespaces. Storage parameters are used by the database driver when a Dynamic Link Library statement, such as a create table or create index statement, is executed. Use the Convert to Runtime command on the appropriate menu to store the optimized parameters in the `[RDBMS]_storage_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]_storage_param` file into this session. Example The `ora_storage_param` file contains this line:
    Tfgld402:312:T:TABLESPACE baan INITIAL 500M NEXT 200M *:*:*: TABLE SPACE baan
In this Oracle example, the database driver adds the `TABLESPACE baan` clause to the create statement during the creation of the table or index. As a result the tfgld402 table in company 312 is created with a different size than the other tables in the database. The database storage parameters are defined by the database driver implementation and often map to the table and index creation options, which are available in the database. There are several driver configuration options that allow the user to customize the table and index attributes. These storage options effect the specified tables in the database. 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. Compress If this check box is selected, the database table(s) will be compressed. If this check box is cleared, the database table(s) will not be compressed. Parameters The parameters that belong to the specified table(s) or index. Convert to Runtime Stores the data specified in this session in the `[RDBMS]_storage_param` file. Read Data From File Imports the data from the `[RDBMS]_storage_param` file into this session. |