TENANT_LIMIT_SPACE configuration parameter

The TENANT_LIMIT_SPACE configuration parameter specifies the maximum amount of storage space available to a tenant database. Storage space includes all permanent dbspaces, BLOB spaces, and sbspaces.

onconfig.std value
0 (off)
if not present
0 (off)
values
1048576 - 1717986918400
units
KB
takes effect
After you edit your onconfig file and restart the database server.

Usage

The TENANT_LIMIT_SPACE configuration parameter limits the amount of permanent storage space available to a tenant database, and can conserve system resources within a tenant-database environment. When the limit is reached, subsequent operations that require additional disk space are rejected. The value ranges from 1 GB to 200 TB, but must be specified as an integer that represents the number of KB.

The tenant_limit_space tenant database property set through the tenant create or tenant update SQL administration API command takes precedent over the TENANT_LIMIT_SPACE configuration parameter setting.


Copyright© 2019 HCL Technologies Limited