Chapter 3. Configuration for performance and manageability 41
The decisions for selection of the tablespace format are generally not affected by ESS.
However, you might want to pay a little more attention to container layout for SMS
tablespaces, particularly if those tablespaces are not spread across multiple containers on
separate arrays.
The general considerations are as follows:
DMS raw tablespaces generally provide the best performance for several reasons. First,
the layers of file management are removed from the I/O path. Secondly, data generally
maps fairly simply to underlying storage. Data that appears to DB2 as sequential access
also appears to ESS as sequential access, making best use of caching algorithms.
However, DMS is not as ...