Parameter file field descriptions

table/module specification
Description This field consists of a list of comma-separated table names or a module name to which the entry applies. An asterisk (*) indicates all tables.
Example ttadv000,ttadv999 Two specific tables
ttadv All tables in module tt and package adv
tt All tables in module tt
* All tables
company number
Description This field consists of a list of company numbers to which the entry applies. An asterisk (*) indicates all company numbers.
Example 000,999 Companies 000 and 999
* All companies
object type
Description This field consists of a list of object (table or index) identifications to which the entry applies. You can specify the following options:
T Table only
I All indexes
I <index number> Only specified index
* Both table and indexes

Fall back rules in the database drivers

If no specific index line ( I<index number> ) is defined, the value for the generic index line is used.

If no generic index line is defined, the driver uses the value for the table line.

Example I1,I2 Only index 1 and 2
T Only for table
Compress specification
Description When this field is present the table or index is compressed.
Example COMPRESS=1; Table compression is used for the selected table(s) or index(es).
Group
Description This field identifies the owner of the table. You must specify Group.
Note Previous porting sets also supported the Private option. This option is obsolete.
table/index optimization
Description Specific flags related to indexes and tables can be specified. If specified on a “T” object entry, the flag defines the default for all indexes.

You can use octal values to set the flags for a specific index or table.

  • 00: Use default initial technique (filter)
  • 03: Initial technique is nested
  • 04: Initial technique is iterative
  • 05: Initial technique is filter

You can OR these flags to this value:

  • 0010: Generate statistics at creation of the table
Example 014 – Recommended value.
Refresh time
Description Ignored by the oracle driver
Storage parameters
Description The specific database driver implementation defines these parameters, and often defines map-to-table and index creation options available in the host RDBMS.

Several driver configuration options specific to the Oracle driver allow the user to customize table and index attributes at create time. These storage options are used to affect specified tables.

For a complete description of the parameters you can add to the CREATE TABLE and CREATE INDEX commands, refer to the Oracle SQL Language Reference Manual.

Example TABLESPACE DATA PCTFREE 5 INITRANS 3