Implicit table space selection when creating a table

Db2 will automatically choose a table space on table creation when no table space is explicitly specified.

In these cases, Db2 chooses a table space (from the set of existing table spaces in the database) with the smallest sufficient page size and where the row size is within the row size limit of the page size on which the authorization ID of the statement has USE privilege. If more than one table space qualifies, Db2 chooses the table space in the following order of preference, depending how the authorization ID of the statement was granted USE privilege on the table space (and if more than one table space still qualifies, the final choice is made by Db2).

This algorithm has been extended to include remote table spaces. The new automatic table space selection algorithm will give remote table spaces lower precedence than non-remote table spaces and will only match a remote table space if no other non-remote table space has been identified as per the documented rules above. Alternatively, use the explicit table space selection using the “IN <table space>” clause.