Tablespaces

Prior to production, you should plan the overall storage strategy.

Since there are strong preferences, the DDLs to create temporary tablespaces and data tablespaces are left to the discretion of the customer.

We instead provide the following recommendations for your consideration:

Tables

After creating the tablespaces, you can create a set of DDL scripts using the dbverify.sh script and the -applyddl parameter set to false, as follows:

   dbverify.sh (or .cmd) -applyddl false

This creates all the necessary CREATE TABLE and CREATE INDEX statements. You may then edit these scripts to map to your tablespaces. To prevent dbverify from generating "IndexAdds" SQLs for dropped indexes, ensure that the dropped indexes are listed in the <INSTALL_DIR>/extensions/schemagenerator/indexes_not_created.txt file. Or, if the INDEXES_NOT_CREATED property in the <INSTALL_DIR>/properties/sandbox.cfg file is configured, add the list of dropped indexes to the file referenced by the property.