Tablespace name |
Key |
---|---|
Default |
DB2_9_TBLCONF_STDTABLE / DB2_10_TBLCONF_STDTABLE |
Binary data |
DB2_9_TBLCONF_STDBLOB / DB2_10_TBLCONF_STDBLOB |
For DB2, the locations where the table indices are saved must be specified when creating the table. The tablespace is specified by the following syntax:
Key = IN <Tablespace name> INDEX IN <Index tablespace name>
The keyword DB2_<vVersion>_TBLCONF_STDINDEX of the configuration file Database_settings.properties is not supported for DB2.
Example
File extract Database_settings.properties
DB2_9_TBLCONF_STDTABLE=IN PPMDATA INDEX IN PPMINDX
DB2_9_TBLCONF_STDBLOB=IN PPMBLOB INDEX IN PPMINDX LONG IN PPMLOB
The mandatory extension LONG IN <tablespace name> determines the tablespace in which the binary database objects will be saved, all others are saved in the tablespace identified with the keyword IN.