Numeric values
The current value that you specify and the actual value of the attribute must match exactly for numeric values of most attributes.
You can specify the current value exactly or as a range of values for the following table space and index attributes that have numeric values:
- DSSIZE
- FREEPAGE
- PCTFREE
- PRIQTY
- SECQTY
- SEGSIZE
To specify a range of values, use a less than (<) or greater than (>) symbol with the current value of the preceding numeric attributes. For example, you can change all primary quantity values for table spaces that have a current value of less than 400 to a new value of 500. See the following figure:
************************************** TOP ************************************
C TS PRIQTY <400 500
************************************* BOTTOM **********************************
If you want to change all of the values for one of the preceding numeric attributes, specify the maximum valid value plus one with a less than symbol. For example, specify <100 to include all values less than and equal to the maximum valid value for the PCTFREE attribute. The maximum valid value for PCTFREE is 99. Because you cannot use wildcard characters with numeric values, this type of range specification is equivalent to using a wildcard character. The following figure shows an example:
************************************** TOP ************************************
C TS PCTFREE <100 10
************************************* BOTTOM **********************************
For STOGROUP-defined objects, you can specify -1 for the current or new attribute values for the PRIQTY and SECQTY attributes. (If you specify -1, Db2 uses a default value for allocating the primary space.) The products consider -1 to be a special value. As such, you cannot combine the value with greater than (>) or less than (<) symbols, <DEFLT> or <CURRENT> keywords, or arithmetic operators (+, -, *, /). In addition, when you specify -1 for the current value, you cannot include the <CURRENT> keyword or an arithmetic operator for the new value. The new value must be numeric.
Related topic