DB2 Version 10.1 for Linux, UNIX, and Windows

Some parameters of the CREATE DATABASE command have been deprecated

The AUTOMATIC STORAGE parameter, the MANAGED BY SYSTEM clause in the USER TABLESPACE parameter, and values for COLLATE USING parameter of the CREATE DATABASE command have been deprecated.


The AUTOMATIC STORAGE parameter, which indicates whether a database is enabled for automatic storage, is now deprecated. By default, all databases are enabled for automatic storage. DB2® pureScale® only supports databases with automatic storage enabled. The IBMSTOGROUP storage group is automatically created as the default storage group in the SYSSTOGROUPS catalog table. Use the ALTER STOGROUP statement to change the default storage group or manage storage groups.

When you create a database, you can specify the table spaces and they type of table space that you want to create for that database by using the MANAGED BY parameter. The system managed spaces (SMS) table space type is now deprecated for permanent table spaces. The database managed spaces (DMS) is deprecated for permanent table spaces since Version 10.1 Fix Pack 1. The recommended table space type for user table spaces is automatic storage.

The UCA400_NO, UCA400_LSK, and UCA400_LTH keywords for the COLLATE USING parameter of the CREATE DATABASE command have been deprecated. The supported locale-sensitive UCA-based collations provide the same functionality and better performance.


Stop using the AUTOMATIC STORAGE parameter with the CREATE DATABASE command before it becomes discontinued. Also, remove this parameter from any scripts or applications.

Use automatic storage table space type to create new user table spaces by using the MANAGED BY AUTOMATIC STORAGE parameter. For existing SMS or DMS user table spaces, start converting them to automatic storage table spaces before SMS and DMS user table spaces become discontinued.

Use any of the supported locale-sensitive UCA-based collations to create new Unicode databases. For existing databases, you can convert to a supported locale-sensitive UCA-based collation by recreating your database.