Cloudscape Properties
Page 34 of 47

cloudscape.storage.minimumRecordSize

Indicates the minimum user row size in bytes for on-disk database pages for tables when you are creating a table. This property ensures that there is enough room for a row to grow on a page when updated without having to overflow. This is generally most useful for VARCHAR and BIT VARYING data types and for tables that are updated a lot, in which the rows start small and grow due to updates. Reserving the space at the time of insertion minimizes row overflow due to updates, but it can result in wasted space.

See also cloudscape.storage.pageReservedSpace.

Valid Conglomerates

Tables only.

Default

12 bytes.

Minimum

12 bytes.

Maximum

cloudscape.storage.pageSize * (1 - cloudscape.storage.pageReservedSpace/100) - 100.

If you set this property to a value outside the legal range, Cloudscape uses the default value.

Examples

-- changing the default for the system
cloudscape.storage.minimumRecordSize=128

-- changing the default for the database
CALL PropertyInfo.setDatabaseProperty(
    'cloudscape.storage.minimumRecordSize',
    '128')

-- changing the default for target databases
CREATE PUBLICATION APub
ADD TARGET DATABASE PROPERTY cloudscape.storage.minimumRecordSize=
    '128'

-- overriding the defaults for a single table
CREATE TABLE A(textcol LONG VARCHAR)
PROPERTIES cloudscape.storage.minimumRecordSize=128

Scope

system-wide

database-wide (publishable)

conglomerate-specific

Dynamic or Static

This property is dynamic; if you change it while Cloudscape is running, the change takes effect immediately. For information about dynamic changes to properties, see Dynamic or Static Changes to Properties.