Specifies the database where you are setting the create limit.
table-name
Specifies the table where you are setting the create limit.
create-limit
Specifies the new create limit. The create limit is the amount of free space that must remain in a block when you are adding a record to the block.
tenant tenant-name
Specifies that the table create limit is to be set on the table partition that is associated with tenant-name. If tenant-name is not valid, is part of a group, or is not associated with a partition of the table, SETTABLECREATELIMIT exits with an error. Specifying tenant is only allowed on databases enabled for multi-tenancy.
group group-name
Specifies that the table create limit is to be set on the table partition that is associated with group-name. If group-name is not valid or is not associated with a partition of the table, SETTABLECREATELIMIT exits with an error. Specifying group is only allowed on databases enabled for multi-tenancy.
partition partition-name
Specifies that the table create limit is to be set on the table partition partition-name. If partition-name is not valid or is not associated with the specified table, SETABLECREATELIMIT exits with an error. Specifying partition is only allowed on databases enabled for table partitioning.
composite initial
Specifies that the table create limit is to be set on the composite initial partition of the specified table. If table-name is not a partitioned table, SETTABLECREATELIMIT exits with an error. Specifying composite initial is only allowed on databases enabled for table partitioning.
Notes
For a Type II area, SETTABLECREATELIMIT sets the table create limit for the specified table. For a Type I area, SETTABLECREATELIMIT issues a warning that all tables and LOBs in an area must have the same create limit, and prompts you to confirm setting the create limit for all tables and LOBs in the area containing the specified table.
The create limit value must be equal to or greater than 32, and less than the block size minus 128 bytes.
For databases with a 1K block size, the default create limit is 75. For all other database block sizes, the default create limit is 150.
For databases enabled for table partitioning, if the specified table-name is a partitioned table, but partition or composite initial is not specified, then the create limit is set for all partitions of the table.
For a Type II area, SETTABLECREATELIMIT sets the table create limit for the specified table. For a Type I area, SETTABLECREATELIMIT issues a warning that all tables and LOBs in an area must have the same create limit, and prompts you to confirm setting the create limit for all tables and LOBs in the area containing the specified table.