Simple table spaces (deprecated)

Start of change A simple table space is neither partitioned nor segmented. The creation of new simple table spaces is not supported in DB2® 10. However, DB2 can still use existing simple table spaces. End of change

Recommendation: If you have any simple table spaces in your database, alter them to a preferred type of table space with the ALTER TABLESPACE statement. If a simple table space contains only one table, alter it to a universal table space.

You cannot create simple table spaces, but you can alter data, update data, or retrieve data from simple table spaces. If you implicitly create a table space or explicitly create a table space without specifying the SEGSIZE, NUMPARTS, or MAXPARTITIONS options, DB2 creates a segmented table space instead of a simple table space. By default, the segmented table space has a SEGSIZE value of 4 and a LOCKSIZE value of ROW.