In DB2, it seems there is a strong separation between what a database is and what a tablespace is. Where as in MySQL and MS SQL Server tablespace and database seemed to be used synonymously.
What are the differences, if any?
1
In DB2 and Oracle, tablespace is roughly the child ‘containers’ within a database. You can, for example, organize your huge tables to be created on a specific tablespace, for managing the disk storage.
In MS SQL server there is no concept of tablespaces AFAIK. It uses file groups for the purpose of organizing storage and there is no one-to-one correlation with the tablespace concept.