Creating and configuring SMS table spaces
SMS is managed by the operating system, which means each table and/or index defined in this type of table space is implemented by at least one operating system file, depending on the number of containers for this table space. The space is limited by the amount of free space in the filesystem.
Getting ready
Make sure that the instance owner has write access to create a directory for the containers used in that table space. This will usually be under the same directory as specified in the storage path used to create the database.
Define all the containers you need for this table space type, since you cannot change this later. Containers should all have the same amount of available space.
Decide if you want to use a buffer pool or use filesystem caching. We recommend you use buffer pools with an AUTOMATIC size.
How to do it...
Use a script or, from the command center, execute the commands listed as follows:
Confirm write permissions in the storage path:
In...
