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:

indented-estimatedTfgld402: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.

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.

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.