TABLE_SIZE configuration parameter

Use the TABLE_SIZE configuration parameter to set the default size (SMALL or LARGE) of newly created permanent tables.

onconfig.std value
TABLE_SIZE LARGE
values
LARGE or SMALL. Default value is LARGE in native mode (Infrastructure 1 is enabled). In compatibility mode (Infrastructure 0 is enabled), default value is SMALL.
takes effect
After you edit your onconfig file and restart the database server.
When you reset the value dynamically in your onconfig file by running the onmode -wf command.
When you reset the value in memory by running the onmode -wm command.

Usage

Small tables are limited to 16.7 million pages of any supported size. Large tables make use of 8-byte row identifiers and support 140 trillion pages. Whether a table is created small or large affects its maximum size, but does not affect its initial size.

When a version 15.0 instance is in compatibility mode (Infrastructure 0 is enabled) all migrated or newly created tables are small. Large tables may not be created.

When a Version 15.0 instance is in native mode (Infrastructure 1 is enabled) newly created tables are large by default. That default can be changed across the instance by setting the TABLE_SIZE configuration parameter to SMALL.

Explicitly setting the TABLE_SIZE session environment variable overrides the TABLE_SIZE configuration parameter setting.

Explicit use of either the 'LARGE' or 'SMALL' keyword in the CREATE TABLE statement overrides the TABLE_SIZE session environment option as well as the TABLE_SIZE configuration parameter.

The following message in an oncheck -pt output indicates that a table is large:

"TBLspace uses large rowids"