This parameter can be used to define the default values in percentage for a possible tablespace extension.
Default value:
30 (for all tablespaces)Possible values:
<tablespace name> <n><n>
- Number that defines a suggested size (in %) for a new data file when the named tablespace ( <tablespace name> ) is extended. The tablespace is extended by <n>% of its original size (sum of the size of all the data files of the tablespace) when the default value is accepted.Example:
PSAPBTABD 100When an extension is performed, the system will suggest adding a file to tablespace PSAPBTABD that is equal to the present size of that tablespace - that is, extend the tablespace by 100%.
Enter a value for every tablespace for which you want to set a default value (it is not possible to specify a list of tablespaces after parameter
tspadd_tspname ). For all tablespaces that are not contained in tspadd_tspname entries, SAPDBA assumes a default value of 30%.