DB2 10.5 for Linux, UNIX, and Windows

numsegs - Default number of SMS containers configuration parameter

This parameter has been deprecated since Version 9.5, but is still being used by pre-Version 9.5 data servers and clients. Any value specified for this configuration parameter will be ignored by the database manager in DB2® Version 9.5 or later releases.

Note: The following information applies only to pre-Version 9.5 data servers and clients.

Configuration type: Database
Parameter type: Informational
Unit of measure: Counter

This parameter indicates the number of containers that will be created within the default table spaces. It also shows the information used when you created your database, whether it was specified explicitly or implicitly on the CREATE DATABASE command.

This parameter only applies to SMS table spaces; the CREATE TABLESPACE statement does not use it in any way.