Chapter 6. Database administration 151
In the SET commands above, the table space IDs 0, 1, 2, 3, and 4 are used to
specify the table space that will be assigned to the new container path. All five
table spaces are System Managed Spaces (SMS) with the containers
pointing to the C:\Databases\sms table spaces directory. Note, you only need
to create the C:\tablespaces\sms directory. The execution of the SET
command will create the directories SYSCAT, TEMP16K, USER, TEMP4K, and
TEMP32K.
The Database Managed Spaces (DMS) table spaces have a slightly different
syntax. The table space IDs 5, 6, 7, 8, 9, and 10 are DMS table spaces with
the containers pointing to C:\Databases\dms.
In case you want to determine what other table spaces reside in the ...