Cloudscape Properties
Page 37 of 47

cloudscape.storage.pageSize

Function

Defines the page size, in bytes, for on-disk database pages for tables or indexes used during table or index creation. Page size should be a power of 2.

Valid Conglomerates

Tables and indexes, including the indexes created to enforce constraints.

Default

4096 bytes.

Minimum Value

The minimum size is 1024 bytes. If you specify a value lower than the minimum, Cloudscape uses the default value 4096.

Maximum Value

None.

Example

-- changing the default for the system
cloudscape.storage.pageSize=8192

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

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

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

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.