Skip to Content

CREATE DATABASE statement

The CREATE DATABASE statement creates a new database.

GUID-FFA16A5D-5255-439A-AB3C-99D77618B0B5-low.png

CREATE DATABASE databaseName

This option specifies the name of the new database.

OWNER authorizationID

This option specifies the owner of the database.

STOGROUP

This option specifies the default storage group for the database. If the STOGROUP parameter is not specified, the default Db2 SYSDEFLT storage group is used.

STOGROUP parameter values

Value

Description

storageGroupName

Specifies the name of the storage group.

<DEFLT>

Specifies a default value.

<DEFLT> is a reserved keyword.

BUFFERPOOL

This option specifies the new default buffer pool for the database for the creation of the table space. If the BUFFERPOOL parameter is not specified, the Db2 default value is used.

BUFFERPOOL parameter values

Value

Description

bufferPoolName

Specifies the name of the buffer pool.

<DEFLT>

Specifies a default value.

<DEFLT> is a reserved keyword.

CCSID

This option specifies the encoding scheme of the database.

CCSID parameter values

Value

Description

ASCII

Specifies ASCII encoding.

EBCDIC

Specifies EBCDIC encoding.

UNICODE

Specifies Unicode encoding.

<DEFLT>

Specifies a default value.

The default encoding scheme is determined in the installation options module with the CCSID keyword.

INDEXBP

This option specifies the default buffer pool for the database for the creation of the index. If the INDEXBP parameter is not specified, the Db2 default value is used.

INDEXBP parameter values

Value

Description

bufferPoolName

Specifies the name of the buffer pool.

<DEFLT>

Specifies a default value.

<DEFLT> is a reserved keyword.

Related topic

CDL-statements

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

ALTER and BMC AMI Change Manager for Db2 13.1