Create dbspaces and sbspaces for storage
For optimal performance and to take advantage of the data management facilities of a DBMS, such as transaction rollback, store your text search table and associated indexes in dbspaces and sbspaces that you allocate specifically for this purpose.
If you are using a CLOB, BLOB, or IfxMRData data type, you must store your data in an sbspace. Synonym and stopword lists are also stored in sbspaces. And since etx indexes are also stored in sbspaces, they are always detached, because the table that contains the indexed column is stored in a dbspace.
onspaces -c -d dbsp1 -p /Dbspace/dbsp1 -o 0 -s 10000
onspaces -c -S sbsp1 -g 2 -p /SBspace/sbsp1 -o 0 -s 100000 -Df "LOGGING=ON"
onspaces -c -S sbsp2 -g 2 -p /SBspace/sbsp2 -o 0 -s 100000 -Df "LOGGING=ON"