TABLE_SIZE session environment option

The TABLE_SIZE session environment option controls the default size of newly created permanent tables for a session.

The SET ENVIRONMENT TABLE_SIZE statement of SQL supports the following syntax:
Read syntax diagramSkip visual syntax diagram SET ENVIRONMENT TABLE_SIZE 'SMALL''LARGE'

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 native mode (Infrastructure 1 is enabled) newly created tables are large by default. That default can be changed for a session by setting TABLE_SIZE to 'SMALL'.

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

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

"TBLspace uses large rowids"